Schema for Fosmid Projects - GEP Sequence Improvement Fosmid Projects

JavaScript is disabled in your web browser

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

Schema for Fosmid Projects - GEP Sequence Improvement Fosmid Projects

Database: DanaWGS Primary Table: gep_fosmids Row Count: 114

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`chrom`	scaffold_13010	`varchar(255)`	values
`chromStart`	39194	`int(10) unsigned`	range
`chromEnd`	79058	`int(10) unsigned`	range
`name`	2595J23	`varchar(255)`	values
`score`	1000	`int(10) unsigned`	range
`strand`	+	`char(1)`	values
`thickStart`	39194	`int(10) unsigned`	range
`thickEnd`	79058	`int(10) unsigned`	range
`itemRgb`	13107200	`int(10) unsigned`	range

Sample Rows

bin	chrom	chromStart	chromEnd	name	score	strand	thickStart	thickEnd	itemRgb
585	scaffold_13010	39194	79058	2595J23	1000	+	39194	79058	200,0,0
585	scaffold_13010	58573	91711	1498A17	1000	+	58573	91711	200,0,0
73	scaffold_13010	102237	139889	1499F11	1000	+	102237	139889	184,134,11
586	scaffold_13010	136894	175017	1767K22	1000	+	136894	175017	200,0,0
586	scaffold_13010	173124	214109	2595C06	1000	+	173124	214109	200,0,0
586	scaffold_13010	204295	243527	1476E05	1000	+	204295	243527	0,100,0
73	scaffold_13010	233643	269724	8055G12	1000	+	233643	269724	0,100,0
73	scaffold_13010	245987	283384	1475E11	1000	+	245987	283384	0,100,0
587	scaffold_13010	280494	322110	2749L02	1000	+	280494	322110	200,0,0
587	scaffold_13010	312947	351216	1131J07	1000	+	312947	351216	200,0,0

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