Schema for FlyBase 6.06 Proteins - FlyBase 6.06 Protein-Coding Regions

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 Proteins - FlyBase 6.06 Protein-Coding Regions

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

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`chrom`	chr2L	`varchar(255)`	values
`chromStart`	7679	`int(10) unsigned`	range
`chromEnd`	8610	`int(10) unsigned`	range
`name`	CG11023-PB	`varchar(255)`	values
`score`	0	`int(10) unsigned`	range
`strand`	+	`char(1)`	values
`thickStart`	7679	`int(10) unsigned`	range
`thickEnd`	8610	`int(10) unsigned`	range
`reserved`	0	`int(10) unsigned`	range
`blockCount`	2	`int(10) unsigned`	range
`blockSizes`	437,418,	`longblob`
`chromStarts`	0,513,	`longblob`

Sample Rows

bin	chrom	chromStart	chromEnd	name	score	strand	thickStart	thickEnd	reserved	blockCount	blockSizes	chromStarts
585	chr2L	7679	8610	CG11023-PB	0	+	7679	8610	0	2	437,418,	0,513,
585	chr2L	7679	9276	CG11023-PC	0	+	7679	9276	0	3	437,397,609,	0,513,988,
585	chr2L	7679	8610	CG11023-PD	0	+	7679	8610	0	2	437,382,	0,549,
585	chr2L	11214	19944	l(2)gl-PB	0	-	11214	19944	0	8	130,109,443,643,106,1192,779,60,	0,195,564,1071,2305,2468,3718,8670,
585	chr2L	11214	15648	l(2)gl-PD	0	-	11214	15648	0	7	130,109,443,643,106,1192,716,	0,195,564,1071,2305,2468,3718,
585	chr2L	11214	15648	l(2)gl-PE	0	-	11214	15648	0	7	130,109,443,643,106,1192,716,	0,195,564,1071,2305,2468,3718,
585	chr2L	11214	15648	l(2)gl-PF	0	-	11214	15648	0	7	130,109,443,643,106,1192,716,	0,195,564,1071,2305,2468,3718,
585	chr2L	11214	17136	l(2)gl-PG	0	-	11214	17136	0	8	130,109,443,643,106,1192,779,84,	0,195,564,1071,2305,2468,3718,5838,
585	chr2L	11214	17136	l(2)gl-PH	0	-	11214	17136	0	8	130,109,443,643,106,1192,779,84,	0,195,564,1071,2305,2468,3718,5838,
585	chr2L	11214	17136	l(2)gl-PI	0	-	11214	17136	0	8	130,109,443,643,106,1192,779,84,	0,195,564,1071,2305,2468,3718,5838,

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

FlyBase 6.06 Proteins (fb606proteins) Track Description


	Description This track shows the protein-coding regions of D. melanogaster 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