Schema for Lizard Net - Lizard (Feb. 2007 (Broad/anoCar1)) Alignment Net
Database: hg19    Primary Table: netAnoCar1    Row Count: 445,032
Format description: Database representation of a net of alignments.
fieldexampleSQL type info description
bin 585smallint(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 12038int(10) unsigned range Start on target
tEnd 25894int(10) unsigned range End on target
strand -char(1) values Orientation of query. + or -
qName scaffold_49varchar(255) values Query chromosome
qStart 1478768int(10) unsigned range Start on query
qEnd 1530839int(10) unsigned range End on query
chainId 13484int(10) unsigned range Associated chain Id with alignment details
ali 2646int(10) unsigned range Bases in gap-free alignments
score 80861double 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 2983int(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 100int(11) range Unsequenced bases on query. -1 for undefined
tR 1848int(11) range RepeatMasker bases on target. -1 for undefined
qR 12650int(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 173int(11) range Bases of tandem repeats on target. -1 for undefined
qTrf 275int(11) range Bases of tandem repeats on query. -1 for undefined
Connected Tables and Joining Fields
      hg19.chainAnoCar1.id (via netAnoCar1.chainId)
      hg19.chainAnoCar1Link.chainId (via netAnoCar1.chainId)
Sample Rows
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
5851chr11203825894-scaffold_491478768153083913484264680861-1-12983top0100184812650-1-1-1-1173275
5852chr11226812597-scaffold_4915305491530584000-1-1-1gap00019-1-1-1-100
5852chr11271712946-scaffold_4915290841530429000-1-1-1gap00077-1-1-1-100
5852chr11308113196-scaffold_4915281601528957000-1-1-1gap0000-1-1-1-100
5852chr11338414685-scaffold_4915248401527976000-1-1-1gap000298-1-1-1-100
5852chr11493314966-scaffold_4915236611524578000-1-1-1gap000157-1-1-1-100
5852chr11505715793-scaffold_4915216531523576000-1-1-1gap00911523-1-1-1-1039
5852chr11601216851-scaffold_4915188831521431000-1-1-1gap0037741-1-1-1-100
5852chr11706617185-scaffold_4915175101518665000-1-1-1gap00085-1-1-1-100
5852chr11742417598-scaffold_4915156901517267000-1-1-1gap000287-1-1-1-100

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