Schema for X. tropicalis Chain - X. tropicalis (Aug. 2005 (JGI 4.1/xenTro2)) Chained Alignments

Database: hg19 Primary Table: chainXenTro2 Row Count: 6,020,142
Format description: Summary info about a chain of alignments

field	example	SQL type	description
`bin`	585	`smallint(5) unsigned`	Indexing field to speed chromosome range queries.
`score`	39518	`double`	score of chain
`tName`	chr1	`varchar(255)`	Target sequence name
`tSize`	249250621	`int(10) unsigned`	Target sequence size
`tStart`	12598	`int(10) unsigned`	Alignment start position in target
`tEnd`	17745	`int(10) unsigned`	Alignment end position in target
`qName`	scaffold_876	`varchar(255)`	Query sequence name
`qSize`	331011	`int(10) unsigned`	Query sequence size
`qStrand`	+	`char(1)`	Query strand
`qStart`	54176	`int(10) unsigned`	Alignment start position in query
`qEnd`	66525	`int(10) unsigned`	Alignment end position in query
`id`	111982	`int(10) unsigned`	chain id

bin	score	tName	tSize	tStart	tEnd	qName	qSize	qStrand	qStart	qEnd	id
585	39518	chr1	249250621	12598	17745	scaffold_876	331011	+	54176	66525	111982
585	12662	chr1	249250621	42878	53349	scaffold_942	286514	+	194586	197994	2088510
585	42590	chr1	249250621	45580	70093	scaffold_24	4875303	-	3995240	4025182	90638
585	23036	chr1	249250621	45695	71739	scaffold_24	4875303	-	3973562	4003716	532754
585	33951	chr1	249250621	47191	70070	scaffold_657	607664	+	93023	118977	174133
585	30509	chr1	249250621	47480	70000	scaffold_24	4875303	+	46003	84321	241162
585	20679	chr1	249250621	49798	69965	scaffold_24	4875303	-	3626269	3690878	702933
585	24033	chr1	249250621	52116	69979	scaffold_942	286514	-	47101	60600	476551
585	16995	chr1	249250621	52124	53305	scaffold_539	791252	-	512433	513644	1153815
585	35850	chr1	249250621	52283	69947	scaffold_672	601088	-	583903	597551	148065

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