Schema for Panda Chain - Panda (Dec. 2009 (BGI-Shenzhen 1.0/ailMel1)) Chained Alignments

Database: hg19 Primary Table: chainAilMel1 Row Count: 552,467
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`	708002	`double`	score of chain
`tName`	chr1	`varchar(255)`	Target sequence name
`tSize`	249250621	`int(10) unsigned`	Target sequence size
`tStart`	11507	`int(10) unsigned`	Alignment start position in target
`tEnd`	38258	`int(10) unsigned`	Alignment end position in target
`qName`	GL192379.1	`varchar(255)`	Query sequence name
`qSize`	3779386	`int(10) unsigned`	Query sequence size
`qStrand`	-	`char(1)`	Query strand
`qStart`	917196	`int(10) unsigned`	Alignment start position in query
`qEnd`	947028	`int(10) unsigned`	Alignment end position in query
`id`	3662	`int(10) unsigned`	chain id

bin	score	tName	tSize	tStart	tEnd	qName	qSize	qStrand	qStart	qEnd	id
585	708002	chr1	249250621	11507	38258	GL192379.1	3779386	-	917196	947028	3662
585	39612	chr1	249250621	27567	28627	GL194103.1	348582	+	174952	176449	72926
585	91902	chr1	249250621	40850	43125	GL196693.1	4878	-	5	2424	14411
585	72095	chr1	249250621	41111	42923	GL197751.1	1791	-	1	1791	23562
585	7812	chr1	249250621	41296	41456	GL241933.1	160	-	3	160	470020
585	29137	chr1	249250621	46643	47559	GL200330.1	1014	+	51	967	120545
585	12461	chr1	249250621	47580	47821	GL227711.1	256	+	18	248	332039
585	19192	chr1	249250621	47870	48335	GL212758.1	489	-	0	488	208297
585	9039	chr1	249250621	49678	49848	GL230441.1	231	-	2	172	428891
585	159991	chr1	249250621	50587	54734	GL196520.1	6330	+	59	4196	7067

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