Schema for chainEchTel2Link
  Database: mm10    Primary Table: chainEchTel2Link    Row Count: 41,574,059   Data last updated: 2013-06-13
Format description: alignment block in chain
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 608smallint(5) unsigned Indexing field to speed chromosome range queries.
tName chr1varchar(255) Target sequence name
tStart 3094694int(10) unsigned Alignment start position in target
tEnd 3094728int(10) unsigned Alignment end position in target
qStart 7112447int(10) unsigned start in query
chainId 385710int(10) unsigned chain id in chain table

Connected Tables and Joining Fields
        mm10.chainEchTel2.id (via chainEchTel2Link.chainId)
      mm10.netEchTel2.chainId (via chainEchTel2Link.chainId)

Sample Rows
 
bintNametStarttEndqStartchainId
608chr1309469430947287112447385710
608chr1309472930947647112481385710
608chr1309476630948167112516385710
608chr1309481930948547112566385710
608chr1309485830948997112601385710
608chr1309489930949927112643385710
608chr1309499230950067112737385710
608chr1309500630950527112752385710
608chr1309505230951087112799385710
608chr1309510830951497112856385710

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