Schema for netMm9
Database: hg19    Primary Table: netMm9    Row Count: 5,191,136
Format description: Database representation of a net of alignments.
fieldexampleSQL type description
bin 585smallint(5) unsigned Indexing field to speed chromosome range queries.
level 1int(10) unsigned Level of alignment
tName chr1varchar(255) Target chromosome
tStart 11679int(10) unsigned Start on target
tEnd 38741int(10) unsigned End on target
strand -char(1) Orientation of query. + or -
qName chr6varchar(255) Query chromosome
qStart 121445958int(10) unsigned Start on query
qEnd 121480456int(10) unsigned End on query
chainId 2086int(10) unsigned Associated chain Id with alignment details
ali 11490int(10) unsigned Bases in gap-free alignments
score 178391double 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 14249int(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 7635int(11) RepeatMasker bases on target. -1 for undefined
qR 10592int(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 270int(11) Bases of tandem repeats on target. -1 for undefined
qTrf 1326int(11) Bases of tandem repeats on query. -1 for undefined
Connected Tables and Joining Fields
      hg19.chainMm9.id (via netMm9.chainId)
      hg19.chainMm9Link.chainId (via netMm9.chainId)
Sample Rows
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
5851chr11167938741-chr6121445958121480456208611490178391-1-114249top00763510592-1-1-1-12701326
5852chr11180911822-chr6121480323121480323000-1-1-1gap0000-1-1-1-100
5852chr11198912009-chr6121479971121479971000-1-1-1gap0000-1-1-1-100
5852chr11203412049-chr6121479946121479946000-1-1-1gap0000-1-1-1-100
5852chr11213912487-chr6121476566121479856000-1-1-1gap000705-1-1-1-10899
5853chr11217612259+chr176649860266498678374739762081-1-176nonSyn0000-1-1-1-100
5852chr11273412774-chr6121475705121476307000-1-1-1gap000543-1-1-1-100
5852chr11330313325-chr6121475164121475164000-1-1-1gap0000-1-1-1-100
5852chr11344013474-chr6121475045121475045000-1-1-1gap0000-1-1-1-100
5852chr11355713648-chr6121474900121474967000-1-1-1gap0000-1-1-1-100

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