Schema for Primate RBest Chain/Net - Primate Reciprocal Best Chain and Net Alignments
  Database: hg38    Primary Table: chainRBestPanTro5    Row Count: 11,442   Data last updated: 2017-10-26
Format description: Summary info about a chain of alignments
On download server: MariaDB table dump directory
fieldexampleSQL type info description
bin 73smallint(5) unsigned range Indexing field to speed chromosome range queries.
score 64897double range score of chain
tName chr1varchar(255) values Target sequence name
tSize 248956422int(10) unsigned range Target sequence size
tStart 17729int(10) unsigned range Alignment start position in target
tEnd 452498int(10) unsigned range Alignment end position in target
qName chr15varchar(255) values Query sequence name
qSize 83230942int(10) unsigned range Query sequence size
qStrand -char(1) values Query strand
qStart 1176int(10) unsigned range Alignment start position in query
qEnd 264531int(10) unsigned range Alignment end position in query
id 1827int(10) unsigned range chain id

Connected Tables and Joining Fields
        hg38.chainRBestPanTro5Link.chainId (via chainRBestPanTro5.id)
      hg38.netRBestPanTro5.chainId (via chainRBestPanTro5.id)

Sample Rows
 
binscoretNametSizetStarttEndqNameqSizeqStrandqStartqEndid
7364897chr124895642217729452498chr1583230942-11762645311827
739789chr124895642287275260315chr1961309027+780751561482837
58534419chr12489564229157592387chrUn_NW_015976062v125332-166441744422940
586139chr1248956422136467136957chr1228573443+2016020492016098332780
5862005chr1248956422136545136569chr4194502333+1222537121222537362739
58622chr1248956422180154180155chr18_NW_015974278v1_random16555+7228722933999
58646205chr1248956422180177180766chr11135753878+3827938847149727
5861613chr1248956422193519196580chr1583230942-5566870714206
5878599chr1248956422357531377597chr1783181570+83125635831499785966
7313100chr1248956422383697528467chr1228573443+2222318542223345251114

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