Schema for Pig Chain - Pig (Nov. 2009 (SGSC Sscrofa9.2/susScr2)) Chained Alignments
Database: hg19    Primary Table: chainSusScr2    Row Count: 5,579,263
Format description: Summary info about a chain of alignments
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
score 551182double score of chain
tName chr1varchar(255) Target sequence name
tSize 249250621int(10) unsigned Target sequence size
tStart 11707int(10) unsigned Alignment start position in target
tEnd 36884int(10) unsigned Alignment end position in target
qName chr5varchar(255) Query sequence name
qSize 100516970int(10) unsigned Query sequence size
qStrand +char(1) Query strand
qStart 63220996int(10) unsigned Alignment start position in query
qEnd 63248923int(10) unsigned Alignment end position in query
id 7774int(10) unsigned chain id
Connected Tables and Joining Fields
      hg19.chainSusScr2Link.chainId (via chainSusScr2.id)
      hg19.netSusScr2.chainId (via chainSusScr2.id)
Sample Rows
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
585551182chr12492506211170736884chr5100516970+63220996632489237774
58515380chr12492506211444315884chr14148510138+10904380109051951333630
58538911chr12492506212757428603chr1179814395-2036291320364075141648
5854718chr12492506213412834252chr1295529705-1943562701943563944600679
585734204chr12492506214073577642chr7136409062-50613878506529496026
585829802chr12492506214211977642chr7136409062+86018277860561785338
585112692chr12492506214729151497chr7136409062+13459796813460080526639
58510899chr12492506214748948019chr7136409062+86042168860427482378237
58511335chr12492506214748948019chr7136409062-183283318334132259605
5853679chr12492506214761347682chr7136409062-50639047506391165208563

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