Database: hg19    Primary Table: netFr2    Row Count: 247,738
Format description: Database representation of a net of alignments.

field	example	SQL type	info	description
bin	585	smallint(5) unsigned	range	Indexing field to speed chromosome range queries.
level	1	int(10) unsigned	range	Level of alignment
tName	chr1	varchar(255)	values	Target chromosome
tStart	12178	int(10) unsigned	range	Start on target
tEnd	24867	int(10) unsigned	range	End on target
strand	+	char(1)	values	Orientation of query. + or -
qName	chrUn	varchar(255)	values	Query chromosome
qStart	81157031	int(10) unsigned	range	Start on query
qEnd	81162051	int(10) unsigned	range	End on query
chainId	8888	int(10) unsigned	range	Associated chain Id with alignment details
ali	2294	int(10) unsigned	range	Bases in gap-free alignments
score	67978	double	range	Score - a number proportional to 100x matching bases
qOver	-1	int(11)	range	Overlap with parent gap on query side. -1 for undefined
qFar	-1	int(11)	range	Distance from parent gap on query side. -1 for undefined
qDup	2397	int(11)	range	Bases with two or more copies in query. -1 for undefined
type	top	varchar(255)	values	Syntenic type: gap/top/syn/nonsyn/inv
tN	0	int(11)	range	Unsequenced bases on target. -1 for undefined
qN	0	int(11)	range	Unsequenced bases on query. -1 for undefined
tR	1848	int(11)	range	RepeatMasker bases on target. -1 for undefined
qR	639	int(11)	range	RepeatMasker bases on query. -1 for undefined
tNewR	-1	int(11)	range	Lineage specific repeats on target. -1 for undefined
qNewR	-1	int(11)	range	Lineage specific repeats on query. -1 for undefined
tOldR	-1	int(11)	range	Bases of ancient repeats on target. -1 for undefined
qOldR	-1	int(11)	range	Bases of ancient repeats on query. -1 for undefined
tTrf	173	int(11)	range	Bases of tandem repeats on target. -1 for undefined
qTrf	33	int(11)	range	Bases of tandem repeats on query. -1 for undefined

      hg19.chainFr2.id (via netFr2.chainId)
      hg19.chainFr2Link.chainId (via netFr2.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	12178	24867	+	chrUn	81157031	81162051	8888	2294	67978	-1	-1	2397	top	0	0	1848	639	-1	-1	-1	-1	173	33
585	2	chr1	12243	12877	+	chrUn	81157096	81157137	0	0	0	-1	-1	-1	gap	0	0	0	13	-1	-1	-1	-1	0	0
585	2	chr1	13056	13073	+	chrUn	81157334	81157334	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	13087	13110	+	chrUn	81157348	81157348	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	13155	13168	+	chrUn	81157387	81157387	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	13379	14697	+	chrUn	81157584	81158259	0	0	0	-1	-1	-1	gap	0	0	0	84	-1	-1	-1	-1	0	0
585	2	chr1	14901	14916	+	chrUn	81158459	81158459	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	14930	14963	+	chrUn	81158473	81158473	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	15062	15751	+	chrUn	81158568	81158826	0	0	0	-1	-1	-1	gap	0	0	91	19	-1	-1	-1	-1	0	0
585	2	chr1	15951	16640	+	chrUn	81159025	81159145	0	0	0	-1	-1	-1	gap	0	0	0	20	-1	-1	-1	-1	0	0

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