Schema for Rat Chain - Rat (Nov. 2004 (Baylor 3.4/rn4)) Chained Alignments
Database: hg19    Primary Table: chainRn4    Row Count: 2,563,762
Format description: Summary info about a chain of alignments
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
score 132776double score of chain
tName chr1varchar(255) Target sequence name
tSize 249250621int(10) unsigned Target sequence size
tStart 11678int(10) unsigned Alignment start position in target
tEnd 28604int(10) unsigned Alignment end position in target
qName chr4varchar(255) Query sequence name
qSize 187126005int(10) unsigned Query sequence size
qStrand -char(1) Query strand
qStart 29160230int(10) unsigned Alignment start position in query
qEnd 29188771int(10) unsigned Alignment end position in query
id 4219int(10) unsigned chain id
Connected Tables and Joining Fields
      hg19.chainRn4Link.chainId (via chainRn4.id)
      hg19.netRn4.chainId (via chainRn4.id)
Sample Rows
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
585132776chr12492506211167828604chr4187126005-29160230291887714219
58529698chr12492506211179613467chr9113440463+105026173105029435229529
58566064chr12492506211299517313chr9113440463+10520633610521026434368
585124447chr12492506211299528574chr9113440463-854284285542775022
58562333chr12492506211466917460chr9113440463+10527844410528108441332
58512031chr12492506211715817597chr9113440463-844115684415811196758
58516798chr12492506212462828084chr9113440463-84531978454270632234
5853571chr12492506213230832417chr4187126005-29188777291888842495396
58521460chr12492506213597736830chr4187126005-2919816529199026416736
58515090chr12492506215231753311chr3171063335+9730223997303247776593

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