Schema for chainXenTro2Link
Database: hg19    Primary Table: chainXenTro2Link    Row Count: 54,532,832
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 12598int(10) unsigned Alignment start position in target
tEnd 12608int(10) unsigned Alignment end position in target
qStart 54176int(10) unsigned start in query
chainId 111982int(10) unsigned chain id in chain table
Connected Tables and Joining Fields
      hg19.chainXenTro2.id (via chainXenTro2Link.chainId)
      hg19.netXenTro2.chainId (via chainXenTro2Link.chainId)
Sample Rows
bintNametStarttEndqStartchainId
585chr1125981260854176111982
585chr1126081267954189111982
585chr1126791274254283111982
585chr1149661506062131111982
585chr1157881589663994111982
585chr1158961596064103111982
585chr1168221687465644111982
585chr1168741690965699111982
585chr1169091705765737111982
585chr1170871709465885111982

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