Schema for FlyBase 6.06 Genes - FlyBase 6.06 Protein-Coding Genes

JavaScript is disabled in your web browser

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

Schema for FlyBase 6.06 Genes - FlyBase 6.06 Protein-Coding Genes

Database: dm6 Primary Table: fb606genes Row Count: 30,440

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`name`	CG11023-RC	`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`	9276	`int(10) unsigned`	range
`exonCount`	3	`int(10) unsigned`	range
`exonStarts`	7528,8192,8667,	`longblob`
`exonEnds`	8116,8589,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,0,	`longblob`

Sample Rows

bin	name	chrom	strand	txStart	txEnd	cdsStart	cdsEnd	exonCount	exonStarts	exonEnds	score	name2	cdsStartStat	cdsEndStat	exonFrames
585	CG11023-RC	chr2L	+	7528	9484	7679	9276	3	7528,8192,8667,	8116,8589,9484,	0	CG11023	cmpl	cmpl	0,2,0,
585	CG11023-RB	chr2L	+	7528	9484	7679	8610	2	7528,8192,	8116,9484,	0	CG11023	cmpl	cmpl	0,2,
585	CG11023-RD	chr2L	+	7528	9484	7679	8610	2	7528,8228,	8116,9484,	0	CG11023	cmpl	cmpl	0,2,
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-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-RK	chr2L	-	9838	21376	11309	17136	9	9838,11778,12285,13519,13682,14932,17052,19879,21065,	11344,12221,12928,13625,14874,15711,17212,20020,21376,	0	l(2)gl	cmpl	cmpl	1,2,1,0,2,0,0,-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,
585	l(2)gl-RH	chr2L	-	9838	21376	11214	17136	9	9838,11409,11778,12285,13519,13682,14932,17052,21135,	11344,11518,12221,12928,13625,14874,15711,17212,21376,	0	l(2)gl	cmpl	cmpl	2,1,2,1,0,2,0,0,-1,

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

FlyBase 6.06 Genes (fb606genes) 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.06. Credits Thanks to FlyBase for providing these annotations. References St Pierre SE, Ponting L, Stefancsik R, McQuilton P; FlyBase Consortium. FlyBase 102 — advanced approaches to interrogating FlyBase. Nucleic Acids Res. 2014 Jan;42(Database issue):D780-8