Schema for chainSelfLink
  Database: hg38    Primary Table: chainSelfLink    Row Count: 266,419,480   Data last updated: 2020-02-11
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 10000int(10) unsigned Alignment start position in target
tEnd 10108int(10) unsigned Alignment end position in target
qStart 10435int(10) unsigned start in query
chainId 23989int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        hg38.chainSelf.id (via chainSelfLink.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
585chr110000101081043523989
585chr110108101311059023989
585chr110131101561061423989
585chr110156101771064023989
585chr110177102281066423989
585chr110228102531075123989
585chr110256102911077623989
585chr110291103531083223989
585chr110353103971093123989
585chr110397104211098523989

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