Schema for chainMm39Link
  Database: gorGor6    Primary Table: chainMm39Link    Row Count: 59,977,746   Data last updated: 2020-11-24
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 1749int(10) unsigned Alignment start position in target
tEnd 1782int(10) unsigned Alignment end position in target
qStart 951673int(10) unsigned start in query
chainId 919int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        gorGor6.chainMm39.id (via chainMm39Link.chainId)
      gorGor6.netMm39.chainId (via chainMm39Link.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
585chr117491782951673919
585chr117821807951707919
585chr118071830951758919
585chr118301836951803919
585chr118361875951833919
585chr118751881951875919
585chr118861898951881919
585chr119051911951893919
585chr119131922951899919
585chr119341952951908919

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