Schema for netDasNov3
  Database: mm10    Primary Table: netDasNov3    Row Count: 2,384,124   Data last updated: 2012-04-14
Format description: Database representation of a net of alignments.
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 608smallint(5) unsigned Indexing field to speed chromosome range queries.
level 1int(10) unsigned Level of alignment
tName chr1varchar(255) Target chromosome
tStart 3044216int(10) unsigned Start on target
tEnd 3044323int(10) unsigned End on target
strand -char(1) Orientation of query. + or -
qName JH563518varchar(255) Query chromosome
qStart 1788321int(10) unsigned Start on query
qEnd 1788429int(10) unsigned End on query
chainId 5519774int(10) unsigned Associated chain Id with alignment details
ali 107int(10) unsigned Bases in gap-free alignments
score 3160double Score - a number proportional to 100x matching bases
qOver -1int(11) Overlap with parent gap on query side. -1 for undefined
qFar -1int(11) Distance from parent gap on query side. -1 for undefined
qDup 0int(11) Bases with two or more copies in query. -1 for undefined
type topvarchar(255) Syntenic type: gap/top/syn/nonsyn/inv
tN 0int(11) Unsequenced bases on target. -1 for undefined
qN 0int(11) Unsequenced bases on query. -1 for undefined
tR 0int(11) RepeatMasker bases on target. -1 for undefined
qR 0int(11) RepeatMasker bases on query. -1 for undefined
tNewR -1int(11) Lineage specific repeats on target. -1 for undefined
qNewR -1int(11) Lineage specific repeats on query. -1 for undefined
tOldR -1int(11) Bases of ancient repeats on target. -1 for undefined
qOldR -1int(11) Bases of ancient repeats on query. -1 for undefined
tTrf 0int(11) Bases of tandem repeats on target. -1 for undefined
qTrf 0int(11) Bases of tandem repeats on query. -1 for undefined

Connected Tables and Joining Fields
        mm10.chainDasNov3.id (via netDasNov3.chainId)
      mm10.chainDasNov3Link.chainId (via netDasNov3.chainId)

Sample Rows
 
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
6081chr130442163044323-JH5635181788321178842955197741073160-1-10top0000-1-1-1-100
6081chr130493453049521-JH5635181783580178374748186831655204-1-10top005770-1-1-1-100
6082chr130494583049469-JH56351817836331783633000-1-1-1gap0050-1-1-1-100
6081chr130607463062650-JH563518177976817812511024540134317304-1-10top00418251-1-1-1-1450
6082chr130609233061189-JH56351817810651781073000-1-1-1gap002400-1-1-1-100
6082chr130615703061584-JH56351817806321780632000-1-1-1gap0000-1-1-1-100
6082chr130617793061822-JH56351817804421780442000-1-1-1gap0000-1-1-1-100
6082chr130620093062025-JH56351817802231780223000-1-1-1gap0000-1-1-1-100
6082chr130620913062103-JH56351817801581780158000-1-1-1gap0000-1-1-1-100
6082chr130621273062156-JH56351817801351780135000-1-1-1gap00290-1-1-1-1290

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