Schema for Horse Chain - Horse (Sep. 2007 (Broad/equCab2)) Chained Alignments
Database: hg19    Primary Table: chainEquCab2    Row Count: 12,212,011
Format description: Summary info about a chain of alignments
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
score 848721double score of chain
tName chr1varchar(255) Target sequence name
tSize 249250621int(10) unsigned Target sequence size
tStart 11489int(10) unsigned Alignment start position in target
tEnd 37673int(10) unsigned Alignment end position in target
qName chr6varchar(255) Query sequence name
qSize 84719076int(10) unsigned Query sequence size
qStrand -char(1) Query strand
qStart 54105327int(10) unsigned Alignment start position in query
qEnd 54134388int(10) unsigned Alignment end position in query
id 1381int(10) unsigned chain id
Connected Tables and Joining Fields
      hg19.chainEquCab2Link.chainId (via chainEquCab2.id)
      hg19.netEquCab2.chainId (via chainEquCab2.id)
Sample Rows
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
585848721chr12492506211148937673chr684719076-54105327541343881381
58520627chr12492506211441415884chr2120857687+55568582555691811737679
58544967chr12492506212756728637chr1780757907-2058339020585731173799
5855219chr12492506212762027756chr2355726280-37543095375432299224116
585209553chr12492506214073550818chr1185838109+1551330571551566128663
585434062chr12492506214073557658chr1185838109+1556563331556788563319
58512704chr12492506214115342063chr983561422+53906893539078384084251
5856573chr12492506214116241356chr599680356-29237025292372567876741
5853677chr12492506214121041283chr2157723302+384696673846974011227173
585879558chr12492506214664968083chr1185838109+1555058471555257381322

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