Database: hg19    Primary Table: netPanTro2    Row Count: 438,952
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	10917	int(10) unsigned	range	Start on target
tEnd	30027	int(10) unsigned	range	End on target
strand	-	char(1)	values	Orientation of query. + or -
qName	chr15	varchar(255)	values	Query chromosome
qStart	100030911	int(10) unsigned	range	Start on query
qEnd	100049816	int(10) unsigned	range	End on query
chainId	1404	int(10) unsigned	range	Associated chain Id with alignment details
ali	17978	int(10) unsigned	range	Bases in gap-free alignments
score	1313058	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	18905	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	336	int(11)	range	Unsequenced bases on query. -1 for undefined
tR	3975	int(11)	range	RepeatMasker bases on target. -1 for undefined
qR	3529	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	476	int(11)	range	Bases of tandem repeats on target. -1 for undefined
qTrf	658	int(11)	range	Bases of tandem repeats on query. -1 for undefined

      hg19.chainPanTro2.id (via netPanTro2.chainId)
      hg19.chainPanTro2Link.chainId (via netPanTro2.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	10917	30027	-	chr15	100030911	100049816	1404	17978	1313058	-1	-1	18905	top	0	336	3975	3529	-1	-1	-1	-1	476	658
585	2	chr1	11386	11448	-	chr15	100049361	100049361	0	0	0	-1	-1	-1	gap	0	0	61	0	-1	-1	-1	-1	62	0
585	3	chr1	11386	11448	+	chr9_random	4665776	4665838	5299	62	5304	-1	-1	62	nonSyn	0	0	61	62	-1	-1	-1	-1	62	62
585	2	chr1	20447	21463	-	chr15	100039465	100039465	0	0	0	-1	-1	-1	gap	0	0	149	0	-1	-1	-1	-1	35	0
585	3	chr1	20447	21463	+	chr9_random	4675776	4677499	5299	700	59888	-1	-1	700	nonSyn	0	10	149	611	-1	-1	-1	-1	35	0
585	4	chr1	20818	21134	+	chr9_random	4676147	4677170	0	0	0	-1	-1	-1	gap	0	10	0	331	-1	-1	-1	-1	35	0
585	5	chr1	20907	21106	-	chr12	57677593	57677812	58956	194	6609	-1	-1	219	nonSyn	0	0	0	0	-1	-1	-1	-1	0	0
585	1	chr1	30027	33925	-	chrUn	1507331	1512602	5143	3858	216261	-1	-1	5271	top	0	10	2302	2839	-1	-1	-1	-1	97	966
585	2	chr1	30872	30895	-	chrUn	1511757	1511757	0	0	0	-1	-1	-1	gap	0	0	23	0	-1	-1	-1	-1	23	0
585	3	chr1	30872	30895	-	chr15_random	1091183	1091206	10300	23	2042	-1	-1	23	nonSyn	0	0	23	23	-1	-1	-1	-1	23	23

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