Schema for GEP Genes - GEP Gene Annotations

JavaScript is disabled in your web browser

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

Schema for GEP Genes - GEP Gene Annotations

Database: DmojImproved Primary Table: gep_genes Row Count: 460

field	example	SQL type	info
`bin`	74	`smallint(5) unsigned`	range
`chrom`	improved_6498	`varchar(255)`	values
`chromStart`	1348733	`int(10) unsigned`	range
`chromEnd`	1505757	`int(10) unsigned`	range
`name`	CG31999-RA	`varchar(255)`	values
`score`	1000	`int(10) unsigned`	range
`strand`	-	`char(1)`	values
`thickStart`	1348733	`int(10) unsigned`	range
`thickEnd`	1505757	`int(10) unsigned`	range
`reserved`	0	`int(10) unsigned`	range
`blockCount`	14	`int(10) unsigned`	range
`blockSizes`	163,231,89,133,478,138,306,...	`longblob`
`chromStarts`	0,274,64826,65077,66133,917...	`longblob`

Sample Rows

bin	chrom	chromStart	chromEnd	name	score	strand	thickStart	thickEnd	reserved	blockCount	blockSizes	chromStarts
74	improved_6498	1348733	1505757	CG31999-RA	1000	-	1348733	1505757	0	14	163,231,89,133,478,138,306,58,83,273,330,243,273,70,	0,274,64826,65077,66133,91726,95189,123998,124124,124295,149174,149676,149985,156954,
596	improved_6498	1509010	1511174	CG5262-RA	1000	-	1509010	1511174	0	4	764,239,458,54,	0,831,1470,2110,
596	improved_6498	1509010	1511174	CG5262-RB	1000	-	1509010	1511174	0	4	764,239,458,54,	0,831,1470,2110,
596	improved_6498	1514536	1520763	PRY-RA	1000	-	1514536	1520763	0	5	2478,629,211,152,610,	0,4453,5143,5407,5617,
596	improved_6498	1526330	1566605	Or13a-RA	1000	+	1526330	1566605	0	6	368,453,100,111,162,60,	0,27444,38852,39054,39998,40215,
74	improved_6498	1571647	1586896	rho-5-RA	1000	+	1571647	1586896	0	6	3192,342,255,258,300,294,	0,3256,9324,12596,12931,14955,
597	improved_6498	1587134	1587913	CG4038-RA	1000	-	1587134	1587913	0	3	107,477,37,	0,167,742,
597	improved_6498	1590775	1613380	Ank-RB	1000	-	1590775	1613380	0	11	242,123,1748,225,94,331,948,104,1114,108,156,	0,338,521,2337,2918,3616,16117,19637,19798,21443,22449,
597	improved_6498	1590775	1613380	Ank-RC	1000	-	1590775	1613380	0	11	242,123,1748,225,94,331,948,104,1114,108,156,	0,338,521,2337,2918,3616,16117,19637,19798,21443,22449,
597	improved_6498	1590775	1613380	Ank-RD	1000	-	1590775	1613380	0	11	242,123,1748,225,94,331,948,104,1114,108,156,	0,338,521,2337,2918,3616,16117,19637,19798,21443,22449,

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

GEP Genes (gep_genes) Track Description

Description

This track shows the manual gene annotations constructed by students participating in the Genomics Education Partnership (GEP). The comparative gene annotations are based on FlyBase D. melanogaster release 5.50.