Schema for FlyBase R5.50 - FlyBase Protein-Coding Genes Release 5.50

JavaScript is disabled in your web browser

You must have JavaScript enabled in your web browser to use the Genome Browser

Schema for FlyBase R5.50 - FlyBase Protein-Coding Genes Release 5.50

Database: dm3 Primary Table: flybase_genes Row Count: 28,538

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`name`	CG11023-RB	`varchar(255)`	values
`chrom`	chr2L	`varchar(255)`	values
`strand`	+	`char(1)`	values
`txStart`	7528	`int(10) unsigned`	range
`txEnd`	9484	`int(10) unsigned`	range
`cdsStart`	7679	`int(10) unsigned`	range
`cdsEnd`	8610	`int(10) unsigned`	range
`exonCount`	2	`int(10) unsigned`	range
`exonStarts`	7528,8192,	`longblob`
`exonEnds`	8116,9484,	`longblob`
`score`	0	`int(11)`	range
`name2`	CG11023	`varchar(255)`	values
`cdsStartStat`	cmpl	`enum('none', 'unk', 'incmpl', 'cmpl')`	values
`cdsEndStat`	cmpl	`enum('none', 'unk', 'incmpl', 'cmpl')`	values
`exonFrames`	0,2,	`longblob`

Sample Rows

bin	name	chrom	strand	txStart	txEnd	cdsStart	cdsEnd	exonCount	exonStarts	exonEnds	score	name2	cdsStartStat	cdsEndStat	exonFrames
585	CG11023-RB	chr2L	+	7528	9484	7679	8610	2	7528,8192,	8116,9484,	0	CG11023	cmpl	cmpl	0,2,
585	CG11023-RC	chr2L	+	7528	9484	7679	9276	3	7528,8192,8667,	8116,8589,9484,	0	CG11023	cmpl	cmpl	0,2,0,
585	CG11023-RD	chr2L	+	7528	9484	7679	8610	2	7528,8228,	8116,9484,	0	CG11023	cmpl	cmpl	0,2,
585	l(2)gl-RA	chr2L	-	9838	18570	11214	17136	10	9838,11409,11778,12285,13519,13682,14932,17052,18025,18260,	11344,11518,12221,12928,13625,14874,15711,17212,18168,18570,	0	l(2)gl	cmpl	cmpl	2,1,2,1,0,2,0,0,-1,-1,
585	l(2)gl-RB	chr2L	-	9838	21376	11214	19944	9	9838,11409,11778,12285,13519,13682,14932,19884,21135,	11344,11518,12221,12928,13625,14874,15711,20020,21376,	0	l(2)gl	cmpl	cmpl	2,1,2,1,0,2,0,0,-1,
585	l(2)gl-RC	chr2L	-	9838	18570	11214	17136	9	9838,11409,11778,12285,13519,13682,14932,17052,18260,	11344,11518,12221,12928,13625,14874,15711,17212,18570,	0	l(2)gl	cmpl	cmpl	2,1,2,1,0,2,0,0,-1,
585	l(2)gl-RD	chr2L	-	9838	21376	11214	15648	9	9838,11409,11778,12285,13519,13682,14932,19879,21065,	11344,11518,12221,12928,13625,14874,15711,20020,21376,	0	l(2)gl	cmpl	cmpl	2,1,2,1,0,2,0,-1,-1,
585	l(2)gl-RE	chr2L	-	9838	21376	11214	15648	9	9838,11409,11778,12285,13519,13682,14932,19879,21065,	11344,11518,12221,12928,13625,14874,15711,20015,21376,	0	l(2)gl	cmpl	cmpl	2,1,2,1,0,2,0,-1,-1,
585	l(2)gl-RF	chr2L	-	9838	21376	11214	15648	10	9838,11409,11778,12285,13519,13682,14932,19879,21065,21348,	11344,11518,12221,12928,13625,14874,15711,20020,21200,21376,	0	l(2)gl	cmpl	cmpl	2,1,2,1,0,2,0,-1,-1,-1,
585	l(2)gl-RG	chr2L	-	9838	21376	11214	17136	10	9838,11409,11778,12285,13519,13682,14932,17052,19879,21135,	11344,11518,12221,12928,13625,14874,15711,17212,20015,21376,	0	l(2)gl	cmpl	cmpl	2,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 R5.50 (flybase_genes) Track Description


	Description This track shows protein-coding genes annotated by FlyBase and the Drosophila Heterochromatin Genome Project (DHGP). Annotations on both heterochromatin and euchromatic sequences were downloaded from FlyBase D. melanogaster release 5.50. Credits Thanks to FlyBase and DHGP for providing these annotations. References Crosby MA, Goodman JL, Strelets VB, Zhang P, Gelbart WM; FlyBase Consortium. FlyBase: genomes by the dozen. Nucleic Acids Res. 2007 Jan;35(Database issue):D486-91. Smith CD, Shu S, Mungall CJ, Karpen GH. The Release 5.1 Annotation of Drosophila melanogaster Heterochromatin. Science. 2007 Jun 15;316(5831):1586-91. PubMed abstract