Schema for netAilMel1
  Database: mm10    Primary Table: netAilMel1    Row Count: 2,721,571   Data last updated: 2012-03-20
Format description: Database representation of a net of alignments.
On download server: MariaDB table dump directory
fieldexampleSQL type description
bin 607smallint(5) unsigned Indexing field to speed chromosome range queries.
level 1int(10) unsigned Level of alignment
tName chr1varchar(255) Target chromosome
tStart 3007027int(10) unsigned Start on target
tEnd 3008111int(10) unsigned End on target
strand +char(1) Orientation of query. + or -
qName GL192389.1varchar(255) Query chromosome
qStart 2581439int(10) unsigned Start on query
qEnd 2582625int(10) unsigned End on query
chainId 337764int(10) unsigned Associated chain Id with alignment details
ali 995int(10) unsigned Bases in gap-free alignments
score 18085double 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 1180int(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 241int(11) RepeatMasker bases on target. -1 for undefined
qR 721int(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 30int(11) Bases of tandem repeats on query. -1 for undefined

Connected Tables and Joining Fields
        mm10.chainAilMel1.id (via netAilMel1.chainId)
      mm10.chainAilMel1Link.chainId (via netAilMel1.chainId)

Sample Rows
 
binleveltNametStarttEndstrandqNameqStartqEndchainIdaliscoreqOverqFarqDuptypetNqNtRqRtNewRqNewRtOldRqOldRtTrfqTrf
6071chr130070273008111+GL192389.12581439258262533776499518085-1-11180top00241721-1-1-1-1030
6072chr130076123007645+GL192389.125821752582175000-1-1-1gap0000-1-1-1-100
6072chr130079813007991+GL192389.125825082582508000-1-1-1gap0000-1-1-1-100
6071chr130126633013044-GL192547.130606930648111446843819783-1-10top0000-1-1-1-100
6081chr130740243074333+GL193103.1336217336540108929930610363-1-10top0000-1-1-1-100
91chr130944573921326+GL193103.133888096996812522157433643388-1-1607top013180447092242016-1-1-1-1202526123
6082chr130954373095450+GL193103.1339956339956000-1-1-1gap0000-1-1-1-100
6082chr130954573095476+GL193103.1339963339963000-1-1-1gap0000-1-1-1-1190
6082chr130958893097356+GL193103.1340423341038000-1-1-1gap00961296-1-1-1-11290
6082chr130974603097879+GL193103.1341142341142000-1-1-1gap004040-1-1-1-1490

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