Schema for Mouse Chain - Mouse (July 2007 (NCBI37/mm9)) Chained Alignments
Database: hg19    Primary Table: chainMm9    Row Count: 3,374,849
Format description: Summary info about a chain of alignments
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
score 178391double score of chain
tName chr1varchar(255) Target sequence name
tSize 249250621int(10) unsigned Target sequence size
tStart 11679int(10) unsigned Alignment start position in target
tEnd 38741int(10) unsigned Alignment end position in target
qName chr6varchar(255) Query sequence name
qSize 149517037int(10) unsigned Query sequence size
qStrand -char(1) Query strand
qStart 28036581int(10) unsigned Alignment start position in query
qEnd 28071079int(10) unsigned Alignment end position in query
id 2086int(10) unsigned chain id
Connected Tables and Joining Fields
      hg19.chainMm9Link.chainId (via chainMm9.id)
      hg19.netMm9.chainId (via chainMm9.id)
Sample Rows
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
585178391chr12492506211167938741chr6149517037-28036581280710792086
58524809chr12492506211217613467chr1795272651+6649860266500157374739
585127835chr12492506211281529547chr1795272651-28802358288118194065
58519262chr12492506215227353332chr14125194864+5074598550747158595428
58519591chr12492506215233353327chr14125194864-7442621974427217577501
58524745chr12492506215237253365chr2181748087+111339372111340390376634
58524960chr12492506215237253365chr2181748087+111367380111368398370375
58530439chr12492506215237553366chr2181748087-6999494769995941246021
58516862chr12492506215237953329chr2181748087-7057180170572756760447
58512706chr12492506215238053329chr2181748087-92332138923331021295486

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