Schema for chainTurTru2
  Database: mm39    Primary Table: chainTurTru2    Row Count: 981,907   Data last updated: 2020-11-24
Format description: Summary info about a chain of alignments
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 608smallint(5) unsigned Indexing field to speed chromosome range queries.
score 4798double score of chain
tName chr1varchar(255) Target sequence name
tSize 195154279int(10) unsigned Target sequence size
tStart 3050000int(10) unsigned Alignment start position in target
tEnd 3050220int(10) unsigned Alignment end position in target
qName JH499553varchar(255) Query sequence name
qSize 27213int(10) unsigned Query sequence size
qStrand +char(1) Query strand
qStart 20955int(10) unsigned Alignment start position in query
qEnd 21164int(10) unsigned Alignment end position in query
id 808729int(10) unsigned chain id

Connected Tables and Joining Fields
        mm39.chainTurTru2Link.chainId (via chainTurTru2.id)
      mm39.netTurTru2.chainId (via chainTurTru2.id)

Sample Rows
 
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
6084798chr119515427930500003050220JH49955327213+2095521164808729
6084869chr119515427930500003050127JH477252146995-114536114663800859
60810683chr119515427930500003050309JH47877967138+1446114768418953
60811833chr119515427930500003050308JH474935201582+161771162078370654
60810785chr119515427930500073050309JH474422200323-2984930146414396
6084276chr119515427930501993050271JH477252146995-117345117419869879
60821471chr119515427930528523053937JH474527255422-8913690276159561
60828449chr119515427930643043064856JH48566272992-5536855910104336
60813954chr119515427930643083064510JH473911207555-157676157882295423
60833029chr119515427930643133064987JH47892398097+324973316282782

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