Schema for Rat Net - Rat (Nov. 2004 (Baylor 3.4/rn4)) Alignment Net
Database: hg19    Primary Table: netRn4    Row Count: 4,951,018
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 11678int(10) unsigned Start on target
tEnd 28604int(10) unsigned End on target
strand -char(1) Orientation of query. + or -
qName chr4varchar(255) Query chromosome
qStart 157937234int(10) unsigned Start on query
qEnd 157965775int(10) unsigned End on query
chainId 4219int(10) unsigned Associated chain Id with alignment details
ali 8789int(10) unsigned Bases in gap-free alignments
score 132776double 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 11395int(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 5106int(11) Unsequenced bases on query. -1 for undefined
tR 3146int(11) RepeatMasker bases on target. -1 for undefined
qR 7145int(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 173int(11) Bases of tandem repeats on target. -1 for undefined
qTrf 579int(11) Bases of tandem repeats on query. -1 for undefined
Connected Tables and Joining Fields
      hg19.chainRn4.id (via netRn4.chainId)
      hg19.chainRn4Link.chainId (via netRn4.chainId)
Sample Rows
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
5851chr11167828604-chr415793723415796577542198789132776-1-111395top0510631467145-1-1-1-1173579
5852chr11180211816-chr4157965647157965647000-1-1-1gap0000-1-1-1-100
5852chr11189111906-chr4157965368157965368000-1-1-1gap0000-1-1-1-100
5852chr11198911999-chr4157965293157965293000-1-1-1gap0000-1-1-1-100
5852chr11203912049-chr4157965250157965250000-1-1-1gap0000-1-1-1-100
5852chr11213912177-chr4157963637157965161000-1-1-1gap00071-1-1-1-100
5852chr11224012487-chr4157958173157963576000-1-1-1gap0486500-1-1-1-10378
5852chr11254112551-chr4157958122157958122000-1-1-1gap0000-1-1-1-100
5852chr11267512686-chr4157957979157957979000-1-1-1gap0000-1-1-1-100
5852chr11273412800-chr4157957316157957928000-1-1-1gap000552-1-1-1-100

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