Schema for chainOtoGar3Link
  Database: mm39    Primary Table: chainOtoGar3Link    Row Count: 48,393,955   Data last updated: 2020-11-24
Format description: alignment block in chain
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 608smallint(5) unsigned Indexing field to speed chromosome range queries.
tName chr1varchar(255) Target sequence name
tStart 3050001int(10) unsigned Alignment start position in target
tEnd 3050095int(10) unsigned Alignment end position in target
qStart 3924026int(10) unsigned start in query
chainId 1953156int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        mm39.chainOtoGar3.id (via chainOtoGar3Link.chainId)
      mm39.netOtoGar3.chainId (via chainOtoGar3Link.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
608chr13050001305009539240261953156
608chr13050095305012439241211953156
608chr13050124305013739241541953156
608chr13050137305015039241691953156
608chr13050150305016839241911953156
608chr13050178305019739271732097300
608chr13050197305022139271932097300
608chr13050221305027139272192097300
608chr13064312306456625275995469251
608chr13064566306458325276250469251

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