Schema for Guinea pig Chain - Guinea pig (Feb. 2008 (Broad/cavPor3)) Chained Alignments

Database: hg19 Primary Table: chainCavPor3 Row Count: 27,186,468
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`	25992	`double`	score of chain
`tName`	chr1	`varchar(255)`	Target sequence name
`tSize`	249250621	`int(10) unsigned`	Target sequence size
`tStart`	11488	`int(10) unsigned`	Alignment start position in target
`tEnd`	13283	`int(10) unsigned`	Alignment end position in target
`qName`	scaffold_201	`varchar(255)`	Query sequence name
`qSize`	1005036	`int(10) unsigned`	Query sequence size
`qStrand`	+	`char(1)`	Query strand
`qStart`	948131	`int(10) unsigned`	Alignment start position in query
`qEnd`	951216	`int(10) unsigned`	Alignment end position in query
`id`	1862387	`int(10) unsigned`	chain id

bin	score	tName	tSize	tStart	tEnd	qName	qSize	qStrand	qStart	qEnd	id
585	25992	chr1	249250621	11488	13283	scaffold_201	1005036	+	948131	951216	1862387
585	35799	chr1	249250621	11683	15996	scaffold_44	15920349	-	3619899	3623840	529260
585	148204	chr1	249250621	11683	29457	scaffold_44	15920349	+	14973739	14984257	6696
585	114394	chr1	249250621	11721	26790	scaffold_168	1901849	+	1108461	1114244	11135
585	182421	chr1	249250621	11721	30534	scaffold_42	15951348	-	746241	757374	4849
585	122338	chr1	249250621	12087	30534	scaffold_18	39996202	+	109208	118875	9530
585	8179	chr1	249250621	12176	12690	scaffold_32	25641242	-	19231717	19232074	13321544
585	84139	chr1	249250621	12176	18591	scaffold_242	697331	-	87668	92549	20499
585	76835	chr1	249250621	12483	28076	scaffold_5	61868410	-	3088322	3097596	24646
585	152032	chr1	249250621	13271	20712	scaffold_64	10140339	+	10132193	10138972	6414

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