CBS Genome Atlas Database: a dynamic storage for bioinformatic results and sequence data

Area of Science:

• Bioinformatics
• Genomics
• Database Management

Background:

• Increasing volume of bacterial genome sequence data necessitates efficient storage and analysis solutions.
• Limited availability of comparative genomics data for taxonomically similar organisms hinders biological research.
• Complex analyses and evolving methodologies require a dynamic database structure.

Purpose of the Study:

• To develop a flexible and maintainable database structure for storing bacterial genome sequence data and bioinformatic analysis results.
• To provide biologists with easy access to comparative genomics data for over 150 sequenced bacterial genomes.
• To present a dynamic web interface for accessing detailed genomic information and analysis results.

Main Methods:

• Utilized GNU Make, csh, Perl, and MySQL to create a dynamic database environment.
• Developed a Perl program package for database content synchronization and updates.
• Integrated a MySQL database with a CBS web-server via PHP4 for dynamic web content delivery.

Main Results:

• Successfully created a database storing over 220 pieces of information for complete microbial genomes.
• Implemented a flexible system capable of handling complex calculations, changing methods, and new model additions.
• Established a dynamic web interface (www.cbs.dtu.dk/services/GenomeAtlas/) for user access to genomic data and analysis.

Conclusions:

• The developed database solution provides a flexible and maintainable structure for managing extensive bacterial genome data.
• The system facilitates detailed comparative genomics by offering a wide range of analyses beyond basic genomic features.
• This approach can serve as a template for other research groups facing similar database challenges in genomics.