Schema for D. bip. v2 Chain - D. bipectinata (Mar. 2013 (WGS / Dbip

Schema for D. bip. v2 Chain - D. bipectinata (Mar. 2013 (WGS / Dbip_2.0)) Chained Alignments

Database: DanaWGS Primary Table: chainDbipWGS2 Row Count: 48,172 Data last updated: 2023-08-05

field	example	SQL type	info
`bin`	585	`smallint(5) unsigned`	range
`score`	25596	`double`	range
`tName`	scaffold_0	`varchar(255)`	values
`tSize`	1069	`int(10) unsigned`	range
`tStart`	0	`int(10) unsigned`	range
`tEnd`	344	`int(10) unsigned`	range
`qName`	scf7180000396691	`varchar(255)`	values
`qSize`	3151712	`int(10) unsigned`	range
`qStrand`	+	`char(1)`	values
`qStart`	1338082	`int(10) unsigned`	range
`qEnd`	1338428	`int(10) unsigned`	range
`id`	63230	`int(10) unsigned`	range

Sample Rows

bin	score	tName	tSize	tStart	tEnd	qName	qSize	qStrand	qStart	qEnd	id
585	25596	scaffold_0	1069	0	344	scf7180000396691	3151712	+	1338082	1338428	63230
585	29920	scaffold_10005	1601	955	1307	scf7180000391778	43438	-	28861	29222	48625
585	28610	scaffold_10005	1601	957	1307	scf7180000394883	69880	+	3437	3777	51986
585	30619	scaffold_10005	1601	957	1307	scf7180000395119	23417	-	14926	15285	46975
585	24293	scaffold_10005	1601	957	1307	scf7180000393586	27007	-	643	959	70351
585	30152	scaffold_10005	1601	957	1307	scf7180000395483	5831	-	1041	1400	48064
585	25682	scaffold_10005	1601	958	1307	scf7180000395597	51669	-	14445	14752	62784
585	30046	scaffold_10005	1601	963	1307	scf7180000396721	999819	-	993109	993462	48328
585	30186	scaffold_10005	1601	963	1307	scf7180000394510	17608	-	1	354	47997
585	23252	scaffold_10005	1601	1003	1307	scf7180000396349	6042	-	1760	2028	75864

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