Schema for Primate RBest Chain/Net - Primate Reciprocal Best Chain and Net Alignments
  Database: hg38    Primary Table: chainRBestRhiRox1    Row Count: 44,148   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 167double range score of chain
tName chr1varchar(255) values Target sequence name
tSize 248956422int(10) unsigned range Target sequence size
tStart 28416int(10) unsigned range Alignment start position in target
tEnd 28419int(10) unsigned range Alignment end position in target
qName KN294453v1varchar(255) values Query sequence name
qSize 428752int(10) unsigned range Query sequence size
qStrand -char(1) values Query strand
qStart 33517int(10) unsigned range Alignment start position in query
qEnd 33520int(10) unsigned range Alignment end position in query
id 5715int(10) unsigned range chain id

Connected Tables and Joining Fields
        hg38.chainRBestRhiRox1Link.chainId (via chainRBestRhiRox1.id)
      hg38.netRBestRhiRox1.chainId (via chainRBestRhiRox1.id)

Sample Rows
 
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
585167chr12489564222841628419KN294453v1428752-33517335205715
5851140chr12489564225224385046KN299224v1220090-28820687494629
585326chr12489564228728187286KN297143v1270830+5895590028075
58572chr12489564229558895589KN299427v12342998+1094831094849547
587144chr1248956422280189280191KN299427v12342998+1183331183359567
5875930chr1248956422360495377597KN297143v1270830+12899295646983
588533chr1248956422420656453910KN299224v1220090-710081052794530
588469chr1248956422472433473517KN297506v12405796-227694522780328366
58912156chr1248956422595599605589KN297143v1270830+21015293637898
589354085chr1248956422629080634925JABR01027729v114414-67371263325985

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