Schema for Rhesus Net - Rhesus (Jan. 2006 (MGSC Merged 1.0/rheMac2)) Alignment Net
Database: hg19    Primary Table: netRheMac2    Row Count: 1,215,988
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 11591int(10) unsigned Start on target
tEnd 12954int(10) unsigned End on target
strand +char(1) Orientation of query. + or -
qName chr11varchar(255) Query chromosome
qStart 9624673int(10) unsigned Start on query
qEnd 9627756int(10) unsigned End on query
chainId 11579int(10) unsigned Associated chain Id with alignment details
ali 1285int(10) unsigned Bases in gap-free alignments
score 38247double 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 3083int(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 187int(11) RepeatMasker bases on target. -1 for undefined
qR 190int(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
      hg19.chainRheMac2.id (via netRheMac2.chainId)
      hg19.chainRheMac2Link.chainId (via netRheMac2.chainId)
Sample Rows
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
5851chr11159112954+chr119624673962775611579128538247-1-13083top00187190-1-1-1-100
5852chr11210412178+chr1196251909626937000-1-1-1gap0000-1-1-1-100
5851chr11295420818-chr1311370001811370802141767553512885-1-17760top00877970-1-1-1-1138420
5852chr11439214530-chr13113706553113706558000-1-1-1gap0000-1-1-1-100
5853chr11439214530+chr1196292229629373115791213601-1-1151nonSyn0000-1-1-1-100
5854chr11445514472+chr1196292869629315000-1-1-1gap0000-1-1-1-100
5852chr11610116132-chr13113704748113704986000-1-1-1gap0000-1-1-1-10236
5852chr11619916222-chr13113704682113704682000-1-1-1gap0000-1-1-1-100
5852chr11880318817-chr13113701957113701957000-1-1-1gap0000-1-1-1-100
5852chr11935419424-chr13113701414113701414000-1-1-1gap0000-1-1-1-1700

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