Database: hg19    Primary Table: netLoxAfr3    Row Count: 4,020,362
Format description: Database representation of a net of alignments.

field	example	SQL type	description
bin	585	smallint(5) unsigned	Indexing field to speed chromosome range queries.
level	1	int(10) unsigned	Level of alignment
tName	chr1	varchar(255)	Target chromosome
tStart	11857	int(10) unsigned	Start on target
tEnd	36992	int(10) unsigned	End on target
strand	-	char(1)	Orientation of query. + or -
qName	scaffold_15	varchar(255)	Query chromosome
qStart	46840380	int(10) unsigned	Start on query
qEnd	46878227	int(10) unsigned	End on query
chainId	1095	int(10) unsigned	Associated chain Id with alignment details
ali	18594	int(10) unsigned	Bases in gap-free alignments
score	694827	double	Score - a number proportional to 100x matching bases
qOver	-1	int(11)	Overlap with parent gap on query side. -1 for undefined
qFar	-1	int(11)	Distance from parent gap on query side. -1 for undefined
qDup	31349	int(11)	Bases with two or more copies in query. -1 for undefined
type	top	varchar(255)	Syntenic type: gap/top/syn/nonsyn/inv
tN	0	int(11)	Unsequenced bases on target. -1 for undefined
qN	1723	int(11)	Unsequenced bases on query. -1 for undefined
tR	6399	int(11)	RepeatMasker bases on target. -1 for undefined
qR	13857	int(11)	RepeatMasker bases on query. -1 for undefined
tNewR	-1	int(11)	Lineage specific repeats on target. -1 for undefined
qNewR	-1	int(11)	Lineage specific repeats on query. -1 for undefined
tOldR	-1	int(11)	Bases of ancient repeats on target. -1 for undefined
qOldR	-1	int(11)	Bases of ancient repeats on query. -1 for undefined
tTrf	270	int(11)	Bases of tandem repeats on target. -1 for undefined
qTrf	80	int(11)	Bases of tandem repeats on query. -1 for undefined

      hg19.chainLoxAfr3.id (via netLoxAfr3.chainId)
      hg19.chainLoxAfr3Link.chainId (via netLoxAfr3.chainId)

bin	level	tName	tStart	tEnd	strand	qName	qStart	qEnd	chainId	ali	score	qOver	qFar	qDup	type	tN	qN	tR	qR	tNewR	qNewR	tOldR	qOldR	tTrf	qTrf
585	1	chr1	11857	36992	-	scaffold_15	46840380	46878227	1095	18594	694827	-1	-1	31349	top	0	1723	6399	13857	-1	-1	-1	-1	270	80
585	2	chr1	12110	12176	-	scaffold_15	46876167	46877946	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12254	12275	-	scaffold_15	46876098	46876098	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12421	12437	-	scaffold_15	46875956	46875956	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	13925	13937	-	scaffold_15	46874365	46874365	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	14649	14671	-	scaffold_15	46873456	46873456	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	15489	15504	-	scaffold_15	46872519	46872519	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	16179	16191	-	scaffold_15	46871768	46871768	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	18123	18134	-	scaffold_15	46869691	46869691	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	18767	18781	-	scaffold_15	46868977	46868977	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0

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