Schema for FlyBase Genes - FlyBase Protein-Coding Genes
  Database: dm6    Primary Table: fbgenes    Row Count: 30,802   Data last updated: 2024-08-24
fieldexampleSQL type info
bin 585smallint(5) unsigned range
name l(2)gl-RBvarchar(255) values
chrom chr2Lvarchar(255) values
strand -char(1) values
txStart 9838int(10) unsigned range
txEnd 21376int(10) unsigned range
cdsStart 11214int(10) unsigned range
cdsEnd 19944int(10) unsigned range
exonCount 9int(10) unsigned range
exonStarts 9838,11409,11778,12285,1351...longblob  
exonEnds 11344,11518,12221,12928,136...longblob  
score 0int(11) range
name2 l(2)glvarchar(255) values
cdsStartStat cmplenum('none', 'unk', 'incmpl', 'cmpl') values
cdsEndStat cmplenum('none', 'unk', 'incmpl', 'cmpl') values
exonFrames 2,1,2,1,0,2,0,0,-1,longblob  

Sample Rows
 
binnamechromstrandtxStarttxEndcdsStartcdsEndexonCountexonStartsexonEndsscorename2cdsStartStatcdsEndStatexonFrames
585l(2)gl-RBchr2L-983821376112141994499838,11409,11778,12285,13519,13682,14932,19884,21135,11344,11518,12221,12928,13625,14874,15711,20020,21376,0l(2)glcmplcmpl2,1,2,1,0,2,0,0,-1,
585l(2)gl-RDchr2L-983821376112141564899838,11409,11778,12285,13519,13682,14932,19879,21065,11344,11518,12221,12928,13625,14874,15711,20020,21376,0l(2)glcmplcmpl2,1,2,1,0,2,0,-1,-1,
585l(2)gl-REchr2L-983821376112141564899838,11409,11778,12285,13519,13682,14932,19879,21065,11344,11518,12221,12928,13625,14874,15711,20015,21376,0l(2)glcmplcmpl2,1,2,1,0,2,0,-1,-1,
585l(2)gl-RFchr2L-9838213761121415648109838,11409,11778,12285,13519,13682,14932,19879,21065,21348,11344,11518,12221,12928,13625,14874,15711,20020,21200,21376,0l(2)glcmplcmpl2,1,2,1,0,2,0,-1,-1,-1,
585l(2)gl-RKchr2L-983821376113091713699838,11778,12285,13519,13682,14932,17052,19879,21065,11344,12221,12928,13625,14874,15711,17212,20020,21376,0l(2)glcmplcmpl1,2,1,0,2,0,0,-1,-1,
585l(2)gl-RGchr2L-9838213761121417136109838,11409,11778,12285,13519,13682,14932,17052,19879,21135,11344,11518,12221,12928,13625,14874,15711,17212,20015,21376,0l(2)glcmplcmpl2,1,2,1,0,2,0,0,-1,-1,
585l(2)gl-RHchr2L-983821376112141713699838,11409,11778,12285,13519,13682,14932,17052,21135,11344,11518,12221,12928,13625,14874,15711,17212,21376,0l(2)glcmplcmpl2,1,2,1,0,2,0,0,-1,
585l(2)gl-RIchr2L-9838213761121417136109838,11409,11778,12285,13519,13682,14932,17052,19879,21065,11344,11518,12221,12928,13625,14874,15711,17212,20020,21376,0l(2)glcmplcmpl2,1,2,1,0,2,0,0,-1,-1,
585l(2)gl-RJchr2L-9838213761121417136119838,11409,11778,12285,13519,13682,14932,17052,19879,20830,21065,11344,11518,12221,12928,13625,14874,15711,17212,20015,20973,21376,0l(2)glcmplcmpl2,1,2,1,0,2,0,0,-1,-1,-1,
585l(2)gl-RAchr2L-9838185701121417136109838,11409,11778,12285,13519,13682,14932,17052,18025,18260,11344,11518,12221,12928,13625,14874,15711,17212,18168,18570,0l(2)glcmplcmpl2,1,2,1,0,2,0,0,-1,-1,

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.

FlyBase Genes (fbgenes) Track Description
 

Description

This track shows the protein-coding genes that have been annotated by FlyBase. These gene annotations correspond to D. melanogaster release 6.58.

Credits

Thanks to FlyBase for providing these annotations.

References

Öztürk-Çolak A, Marygold SJ, Antonazzo G, Attrill H, Goutte-Gattat D, Jenkins VK, Matthews BB, Millburn G, Dos Santos G, Tabone CJ; FlyBase Consortium. FlyBase: updates to the Drosophila genes and genomes database. Genetics. 2024 May 7;227(1):iyad211. doi: 10.1093/genetics/iyad211. PMID: 38301657; PMCID: PMC11075543.