Database: hg19    Primary Table: netPonAbe2    Row Count: 795,774
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	11462	int(10) unsigned	Start on target
tEnd	11610	int(10) unsigned	End on target
strand	+	char(1)	Orientation of query. + or -
qName	chr12_random	varchar(255)	Query chromosome
qStart	8391153	int(10) unsigned	Start on query
qEnd	8391300	int(10) unsigned	End on query
chainId	71766	int(10) unsigned	Associated chain Id with alignment details
ali	147	int(10) unsigned	Bases in gap-free alignments
score	10678	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	147	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	0	int(11)	Unsequenced bases on query. -1 for undefined
tR	107	int(11)	RepeatMasker bases on target. -1 for undefined
qR	106	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	0	int(11)	Bases of tandem repeats on target. -1 for undefined
qTrf	0	int(11)	Bases of tandem repeats on query. -1 for undefined

      hg19.chainPonAbe2.id (via netPonAbe2.chainId)
      hg19.chainPonAbe2Link.chainId (via netPonAbe2.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	11462	11610	+	chr12_random	8391153	8391300	71766	147	10678	-1	-1	147	top	0	0	107	106	-1	-1	-1	-1	0	0
585	1	chr1	11625	40733	+	chr2b	21132250	21169657	1668	28758	2279211	-1	-1	29168	top	0	387	9635	13467	-1	-1	-1	-1	270	159
585	2	chr1	12167	12194	+	chr2b	21132791	21134626	0	0	0	-1	-1	-1	gap	0	10	0	0	-1	-1	-1	-1	0	0
585	2	chr1	19349	19419	+	chr2b	21141854	21141854	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	70	0
585	2	chr1	20123	20141	+	chr2b	21142560	21142560	0	0	0	-1	-1	-1	gap	0	0	18	0	-1	-1	-1	-1	0	0
585	2	chr1	20818	20869	+	chr2b	21143236	21145314	0	0	0	-1	-1	-1	gap	0	0	0	603	-1	-1	-1	-1	35	47
585	2	chr1	22244	22258	+	chr2b	21146698	21146698	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	25080	25090	+	chr2b	21149531	21149531	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	30907	30964	+	chr2b	21156036	21156813	0	0	0	-1	-1	-1	gap	0	367	57	1	-1	-1	-1	-1	52	1
585	1	chr1	40733	47723	-	chrUn	4476861	4484030	22924	5826	472384	-1	-1	5876	top	0	1245	4388	3637	-1	-1	-1	-1	41	26

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