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

Connected Tables and Joining Fields
        mm10.chainFr3.id (via netFr3.chainId)
      mm10.chainFr3Link.chainId (via netFr3.chainId)

Sample Rows
 
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
6091chr132160223217177+chr224988455498998912301112253121-1-10top0000-1-1-1-100
6092chr132169923217004+chr2249898144989814000-1-1-1gap0000-1-1-1-100
6092chr132170223217033+chr2249898334989833000-1-1-1gap0000-1-1-1-100
6101chr133268253327207-chr1310507326105077301311303429785-1-10top005062-1-1-1-15062
6102chr133269473326961-chr131050761610507616000-1-1-1gap0000-1-1-1-100
6102chr133269783326992-chr131050759910507599000-1-1-1gap0000-1-1-1-100
6111chr134216863421927+chr22499039249906338334724013687-1-10top0000-1-1-1-100
6111chr135317923532739-chr18173393117362061680894042971-1-11648top000196-1-1-1-100
6131chr136703173670518-chr836336903634771581291692969-1-10top000149-1-1-1-10110
6132chr136704773670498-chr836337073634603000-1-1-1gap000149-1-1-1-10110

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