Schema for chainSelfLink
  Database: hg19    Primary Table: chainSelfLink    Row Count: 6,882,618   Data last updated: 2009-03-19
Format description: alignment block in chain
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 10032int(10) unsigned Alignment end position in target
qStart 133756271int(10) unsigned start in query
chainId 4031int(10) unsigned chain id in chain table

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

Sample Rows
 
bintNametStarttEndqStartchainId
585chr110000100321337562714031
585chr110033100541337563034031
585chr110054101081337563254031
585chr110108101491337563804031
585chr110150101791337564214031
585chr110179102001337564514031
585chr110200102491337564734031
585chr110250102551337565224031
585chr110257102861337565274031
585chr110287103211337565564031

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