Schema for netGadMor1
  Database: mm10    Primary Table: netGadMor1    Row Count: 231,980   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 3199684int(10) unsigned range Start on target
tEnd 3200138int(10) unsigned range End on target
strand -char(1) values Orientation of query. + or -
qName HE566665varchar(255) values Query chromosome
qStart 278744int(10) unsigned range Start on query
qEnd 279210int(10) unsigned range End on query
chainId 144794int(10) unsigned range Associated chain Id with alignment details
ali 393int(10) unsigned range Bases in gap-free alignments
score 10745double 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 45int(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.chainGadMor1.id (via netGadMor1.chainId)
      mm10.chainGadMor1Link.chainId (via netGadMor1.chainId)

Sample Rows
 
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
6091chr131996843200138-HE56666527874427921014479439310745-1-10top00450-1-1-1-100
6092chr131998723199884-HE566665279009279009000-1-1-1gap0000-1-1-1-100
6092chr131999503199968-HE566665278903278942000-1-1-1gap0000-1-1-1-100
6092chr132000043200016-HE566665278869278869000-1-1-1gap0000-1-1-1-100
6091chr132160203216262+HE57201820442762044521274852326600-1-1245top0000-1-1-1-100
6092chr132161063216116+HE57201820443752044375000-1-1-1gap0000-1-1-1-100
6091chr132162623216991-CAEA0103463011512001707872235802-1-10top00088-1-1-1-10100
6111chr134216893421904-HE56666526451526473013230921511329-1-10top00010-1-1-1-109
6111chr135318023532634+HE5715501916541934811904673333607-1-11141top00073-1-1-1-10212
6112chr135321973532290+HE571550192048192675000-1-1-1gap0000-1-1-1-100

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