Schema for chainRn6Link
  Database: hg38    Primary Table: chainRn6Link    Row Count: 123,218,384   Data last updated: 2015-02-14
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 11677int(10) unsigned Alignment start position in target
tEnd 11697int(10) unsigned Alignment end position in target
qStart 30123320int(10) unsigned start in query
chainId 4883int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        hg38.chainRn6.id (via chainRn6Link.chainId)
      hg38.netRn6.chainId (via chainRn6Link.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
585chr11167711697301233204883
585chr11169711712301233414883
585chr11171211733301233574883
585chr11173311782301233794883
585chr11178211802301234294883
585chr11181611857301234494883
585chr11185711891301236944883
585chr11190611911301237284883
585chr11191211943301237334883
585chr11194811961301237644883

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