Schema for Medaka Chain - Medaka (Oct. 2005 (NIG/UT MEDAKA1/oryLat2)) Chained Alignments

Database: hg19 Primary Table: chainOryLat2 Row Count: 614,837
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`	61857	`double`	score of chain
`tName`	chr1	`varchar(255)`	Target sequence name
`tSize`	249250621	`int(10) unsigned`	Target sequence size
`tStart`	12176	`int(10) unsigned`	Alignment start position in target
`tEnd`	18413	`int(10) unsigned`	Alignment end position in target
`qName`	chr6	`varchar(255)`	Query sequence name
`qSize`	26576615	`int(10) unsigned`	Query sequence size
`qStrand`	-	`char(1)`	Query strand
`qStart`	12382409	`int(10) unsigned`	Alignment start position in query
`qEnd`	12388246	`int(10) unsigned`	Alignment end position in query
`id`	10168	`int(10) unsigned`	chain id

bin	score	tName	tSize	tStart	tEnd	qName	qSize	qStrand	qStart	qEnd	id
585	61857	chr1	249250621	12176	18413	chr6	26576615	-	12382409	12388246	10168
585	11819	chr1	249250621	61385	63396	scaffold3092	10540	+	817	2453	228060
585	25182	chr1	249250621	62623	69988	chr21	31883787	+	1515000	1521884	46681
585	11415	chr1	249250621	62652	63489	scaffold4018	6917	-	2885	3743	242157
585	10856	chr1	249250621	62745	63833	chr13	33409148	-	25231973	25233026	263307
585	8926	chr1	249250621	62818	63462	chr21	31883787	-	30447057	30447694	352597
585	22942	chr1	249250621	62905	70246	chr21	31883787	-	30436252	30448314	57410
585	23773	chr1	249250621	62927	70320	chr13	33409148	-	25219088	25229157	52921
585	8800	chr1	249250621	62958	63396	scaffold3092	10540	+	319	784	359522
585	15777	chr1	249250621	62958	69950	chr21	31883787	-	30665132	30675942	130470

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