Schema for netDm3
  Database: dm6    Primary Table: netDm3    Row Count: 11,538
fieldexampleSQL type info
bin 1smallint(5) unsigned range
level 1int(10) unsigned range
tName chr2Lvarchar(255) values
tStart 0int(10) unsigned range
tEnd 23105354int(10) unsigned range
strand +char(1) values
qName chr2Lvarchar(255) values
qStart 0int(10) unsigned range
qEnd 22998087int(10) unsigned range
chainId 3int(10) unsigned range
ali 22997865int(10) unsigned range
score 2179189922double range
qOver -1int(11) range
qFar -1int(11) range
qDup 193097int(11) range
type topvarchar(255) values
tN 200int(11) range
qN 200int(11) range
tR 1913770int(11) range
qR 1953225int(11) range
tNewR -1int(11) range
qNewR -1int(11) range
tOldR -1int(11) range
qOldR -1int(11) range
tTrf 306674int(11) range
qTrf 216596int(11) range

This table points to a file in BigWig format.

Connected Tables and Joining Fields
        dm6.chainDm3.id (via netDm3.chainId)
      dm6.chainDm3Link.chainId (via netDm3.chainId)

Sample Rows
 
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
11chr2L023105354+chr2L0229980873229978652179189922-1-1193097top20020019137701953225-1-1-1-1306674216596
7482chr2L2148553821485638+chr2L2148553821485638000-1-1-1gap10010000-1-1-1-100
7562chr2L2242024122527609+chr2L2242024122420341000-1-1-1gap100100732240-1-1-1-1536860
7563chr2L2246289022468047+chr3L24235607242407647285156198295-1-15157nonSyn0051455156-1-1-1-1334271
7563chr2L2247945522480152+chrUextra8360878367846790669766061-1-10nonSyn00265265-1-1-1-16260
7563chr2L2248017422527609+chrU223638228499467417050759007-1-1346730nonSyn017013941391353910-1-1-1-1141865155
7564chr2L2248127722481313+chrU22374842237484000-1-1-1gap00360-1-1-1-100
7564chr2L2248699722490549+chrU22441352314782000-1-1-1gap019658222439700-1-1-1-1020271
7565chr2L2248699722487691+chrUextra169057316912677292969439159-1-10nonSyn00420336-1-1-1-100
7565chr2L2249005322490538+chrUextra207826820787539542648545867-1-10nonSyn0000-1-1-1-100

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