Schema for chainHg38Link
  Database: rheMac10    Primary Table: chainHg38Link    Row Count: 22,554,934   Data last updated: 2019-07-04
Format description: alignment block in chain
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
tName chr1varchar(255) Target sequence name
tStart 0int(10) unsigned Alignment start position in target
tEnd 236int(10) unsigned Alignment end position in target
qStart 21180int(10) unsigned start in query
chainId 40435int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        rheMac10.chainHg38.id (via chainHg38Link.chainId)
      rheMac10.netHg38.chainId (via chainHg38Link.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
585chr102362118040435
585chr12364712141740435
585chr14715382165340435
585chr15455732172040435
585chr15735802174940435
585chr15806342175840435
585chr193210092181240435
585chr1210321202188940435
585chr1212021752190740435
585chr1217521932196340435

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