Schema for Finishing Projects - GEP Sequence Improvement Projects

Database: DtakGB2 Primary Table: finishing_projects Row Count: 44 Data last updated: 2022-10-20

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`chrom`	AFFI02007110	`varchar(255)`	values
`chromStart`	0	`int(10) unsigned`	range
`chromEnd`	87902	`int(10) unsigned`	range
`name`	DTAK7110001	`varchar(255)`	values
`score`	0	`int(10) unsigned`	range
`strand`	+	`char(1)`	values

Sample Rows

bin	chrom	chromStart	chromEnd	name	strand
585	AFFI02007110	0	87902	DTAK7110001	+
585	KB460245	0	76460	DTAK0245001	+
585	KB460776	0	100000	DTAK0776001	+
73	KB460776	90000	171904	DTAK0776002	+
585	KB461079	0	100000	DTAK1079001	+
73	KB461079	90000	190000	DTAK1079002	+
73	KB461079	180000	280000	DTAK1079003	+
587	KB461079	270000	370000	DTAK1079004	+
73	KB461079	360000	460000	DTAK1079005	+
73	KB461079	450000	550000	DTAK1079006	+

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

Finishing Projects (finishing_projects) Track Description


	Description This track shows the location of the GEP finishing projects relative to the D. takahashii DtakGB2 assembly.