Schema for Primate RBest Chain/Net - Primate Reciprocal Best Chain and Net Alignments
  Database: hg38    Primary Table: chainRBestMicMur3    Row Count: 26,845   Data last updated: 2017-10-27
Format description: Summary info about a chain of alignments
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 585smallint(5) unsigned range Indexing field to speed chromosome range queries.
score 34double range score of chain
tName chr1varchar(255) values Target sequence name
tSize 248956422int(10) unsigned range Target sequence size
tStart 56260int(10) unsigned range Alignment start position in target
tEnd 66858int(10) unsigned range Alignment end position in target
qName chr3varchar(255) values Query sequence name
qSize 119751181int(10) unsigned range Query sequence size
qStrand -char(1) values Query strand
qStart 42648772int(10) unsigned range Alignment start position in query
qEnd 42658752int(10) unsigned range Alignment end position in query
id 1007int(10) unsigned range chain id

Connected Tables and Joining Fields
        hg38.chainRBestMicMur3Link.chainId (via chainRBestMicMur3.id)
      hg38.netRBestMicMur3.chainId (via chainRBestMicMur3.id)

Sample Rows
 
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
58534chr12489564225626066858chr3119751181-42648772426587521007
5852160chr124895642295400100568chr1760697988-17692820176972864010
58524158chr1248956422106591124559chr1493316391-51416253514267625427
586470chr1248956422186964187073chr7108171978+509099335091004296221
5892chr1248956422588945588946chr1665901067-6576867065768671148887
59085chr1248956422687702687707chr3119751181-42699489426994941600
5919707chr1248956422911248912211chr2141296404-8633749386338235174155
94602907chr12489564229166693873385chr2141296404-8634236988796314261
59572chr124895642213789171379053chr1857149010-3664093836641094162572
59684chr124895642214621011462114chr2141296404-867936168679362957503

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