Schema for Panda Net - Panda (Dec. 2009 (BGI-Shenzhen 1.0/ailMel1)) Alignment Net
Database: hg19    Primary Table: netAilMel1    Row Count: 3,713,193
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 11507int(10) unsigned Start on target
tEnd 38258int(10) unsigned End on target
strand -char(1) Orientation of query. + or -
qName GL192379.1varchar(255) Query chromosome
qStart 2832358int(10) unsigned Start on query
qEnd 2862190int(10) unsigned End on query
chainId 3662int(10) unsigned Associated chain Id with alignment details
ali 18754int(10) unsigned Bases in gap-free alignments
score 708002double 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 22178int(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 652int(11) Unsequenced bases on query. -1 for undefined
tR 7322int(11) RepeatMasker bases on target. -1 for undefined
qR 7439int(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 270int(11) Bases of tandem repeats on target. -1 for undefined
qTrf 93int(11) Bases of tandem repeats on query. -1 for undefined
Connected Tables and Joining Fields
      hg19.chainAilMel1.id (via netAilMel1.chainId)
      hg19.chainAilMel1Link.chainId (via netAilMel1.chainId)
Sample Rows
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
5851chr11150738258-GL192379.128323582862190366218754708002-1-122178top065273227439-1-1-1-127093
5852chr11156211574-GL192379.128621392862139000-1-1-1gap00120-1-1-1-100
5852chr11237112383-GL192379.128595572859557000-1-1-1gap0000-1-1-1-100
5852chr11312213132-GL192379.128587362858736000-1-1-1gap0000-1-1-1-100
5852chr11445414472-GL192379.128572722857272000-1-1-1gap0000-1-1-1-100
5852chr11448214497-GL192379.128572622857262000-1-1-1gap0000-1-1-1-100
5852chr11521715227-GL192379.128564582856458000-1-1-1gap0000-1-1-1-100
5852chr11539715408-GL192379.128562882856288000-1-1-1gap0000-1-1-1-100
5852chr11625216316-GL192379.128552832855326000-1-1-1gap0000-1-1-1-100
5852chr11655816569-GL192379.128550252855025000-1-1-1gap0000-1-1-1-100

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