Rapid storage and retrieval of genomic intervals from a relational database system using nested containment lists
Laura K Wiley1, R Michael Sivley, William S Bush
1Department of Biomedical Informatics, Center for Human Genetics Research, Vanderbilt University, 2215 Garland Ave, Nashville, TN 37232, USA.
Summary
MyNCList efficiently stores and retrieves genomic annotations using a MySQL database. This approach speeds up whole-genome annotation tasks, overcoming limitations of traditional database indexing for next-generation sequencing data.
Area of Science:
- Bioinformatics
- Genomics
- Database Management
Background:
- Next-generation sequencing generates vast amounts of genomic data requiring efficient storage and retrieval.
- Traditional relational database indexing strategies are often inadequate for genomic annotation tasks.
- Existing solutions rely on standalone applications and flat-file libraries, limiting integration.
Purpose of the Study:
- To implement the NCList data structure within a MySQL database, creating MyNCList.
- To enable efficient storage, updating, and rapid retrieval of genomic annotations.
- To provide a solution that leverages the convenience of relational database systems for genomic data.
Main Methods:
- Implementation of the NCList data structure within a MySQL relational database.
- Development of MyNCList for managing genomic annotations.
- Testing retrieval speeds for range-based annotations.
Main Results:
- MyNCList successfully integrates the NCList data structure into a MySQL database.
- The system allows for efficient storage, updating, and retrieval of genomic annotations.
- Retrieval of annotations for 1 million variants was achieved in under one minute.
Conclusions:
- MyNCList offers a feasible approach for whole-genome annotation tasks.
- This method overcomes the limitations of traditional database indexing for genomic data.
- It provides a convenient and rapid solution for managing large-scale genomic annotations within a familiar database environment.
Related Concept Videos
02:51Multi-species Conserved Sequences
Next-generation sequencing technologies have created large genomic databases of a variety of animals and plants. Ever since the human genome project was completed, scientists studied the genome of primates, mammals, and other phylogenetically distant living beings. Such large-scale studies have provided new insights into the evolutionary relationship between organisms.
Although the genome of each species varies greatly from each other, a few sequences are highly conserved. Such conserved DNA...
Although the genome of each species varies greatly from each other, a few sequences are highly conserved. Such conserved DNA...
00:58Genomic DNA in Eukaryotes
Eukaryotes have large genomes compared to prokaryotes. To fit their genomes into a cell, eukaryotic DNA is packaged extraordinarily tightly inside the nucleus. To achieve this, DNA is tightly wound around proteins called histones, which are packaged into nucleosomes that are joined by linker DNA and coil into chromatin fibers. Additional fibrous proteins further compact the chromatin, which is recognizable as chromosomes during certain phases of cell division.
03:21RNA-seq
RNA sequencing, or RNA-Seq, is a high-throughput sequencing technology used to study the transcriptome of a cell. Transcriptomics helps to interpret the functional elements of a genome and identify the molecular constituents of an organism. Additionally, it also helps in understanding the development of an organism and the occurrence of diseases.
Before the discovery of RNA-seq, microarray-based methods and Sanger sequencing were used for transcriptome analysis. However, while microarray-based...
Before the discovery of RNA-seq, microarray-based methods and Sanger sequencing were used for transcriptome analysis. However, while microarray-based...
02:37Gene Duplication and Divergence
The seminal work of Ohno in 1970 popularized the idea of gene duplication and divergence. DNA sequence comparison studies reveal that a large portion of the genes in bacteria, archaebacteria, and eukaryotes was generated by gene duplication and divergence, indicating its critical role in evolution.
The duplicated copies of the gene are called Paralogs. Paralogs with similar sequences and functions form a gene family. Across several species, a large number of gene families are characterized.
The duplicated copies of the gene are called Paralogs. Paralogs with similar sequences and functions form a gene family. Across several species, a large number of gene families are characterized.
00:46Genomic DNA in Prokaryotes
The genome of most prokaryotic organisms consists of double-stranded DNA organized into one circular chromosome in a region of cytoplasm called the nucleoid. The chromosome is tightly wound, or supercoiled, for efficient storage. Prokaryotes also contain other circular pieces of DNA called plasmids. These plasmids are smaller than the chromosome and often carry genes that confer adaptive functions, such as antibiotic resistance.
Genomic Diversity in Bacteria
Although bacterial genomes are much...
Genomic Diversity in Bacteria
Although bacterial genomes are much...
02:53Conservative Site-specific Recombination and Phase Variation
Because the DNA segments are cut and reorganized in a direction-specific manner, site-specific recombination has emerged as an efficient genetic engineering technique. Flippase and Cyclization recombinases or Flp and Cre, respectively, are two members of the tyrosine recombinase family derived from bacteriophages, that are used to mediate site-specific DNA insertions, deletions, and targeted expression of proteins in mammalian cell lines.
The recognition sites for Cre recombinase called LoxP...
The recognition sites for Cre recombinase called LoxP...