Schema for chainMelGal1Link
  Database: hg19    Primary Table: chainMelGal1Link    Row Count: 3,138,050   Data last updated: 2011-03-28
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 12178int(10) unsigned Alignment start position in target
tEnd 12232int(10) unsigned Alignment end position in target
qStart 61236552int(10) unsigned start in query
chainId 3150int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        hg19.chainMelGal1.id (via chainMelGal1Link.chainId)
      hg19.netMelGal1.chainId (via chainMelGal1Link.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
585chr11217812232612365523150
585chr11259612610612370003150
585chr11261012674612370183150
585chr11267812689612370823150
585chr11296412983612376943150
585chr11298312992612377143150
585chr11299513069612377233150
585chr11306913083612378003150
585chr11308313135612378223150
585chr11314513179612378743150

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