Database: hg19    Primary Table: netPetMar1    Row Count: 150,080
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	17242	int(10) unsigned	range	Start on target
tEnd	17767	int(10) unsigned	range	End on target
strand	+	char(1)	values	Orientation of query. + or -
qName	Contig25515	varchar(255)	values	Query chromosome
qStart	3357	int(10) unsigned	range	Start on query
qEnd	7045	int(10) unsigned	range	End on query
chainId	294790	int(10) unsigned	range	Associated chain Id with alignment details
ali	318	int(10) unsigned	range	Bases in gap-free alignments
score	10494	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	328	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	0	int(11)	range	RepeatMasker bases on target. -1 for undefined
qR	1869	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	0	int(11)	range	Bases of tandem repeats on target. -1 for undefined
qTrf	84	int(11)	range	Bases of tandem repeats on query. -1 for undefined

      hg19.chainPetMar1.id (via netPetMar1.chainId)
      hg19.chainPetMar1Link.chainId (via netPetMar1.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	17242	17767	+	Contig25515	3357	7045	294790	318	10494	-1	-1	328	top	0	0	0	1869	-1	-1	-1	-1	0	84
585	2	chr1	17388	17595	+	Contig25515	3504	6864	0	0	0	-1	-1	-1	gap	0	0	0	1864	-1	-1	-1	-1	0	84
585	1	chr1	17901	18073	+	Contig41731	299	474	534307	172	6935	-1	-1	175	top	0	0	0	0	-1	-1	-1	-1	0	0
585	1	chr1	68965	69964	+	Contig1546	24150	25163	351179	974	9455	-1	-1	1013	top	0	0	0	26	-1	-1	-1	-1	0	0
586	1	chr1	131161	131849	-	Contig23930	257	9080	194370	510	12895	-1	-1	520	top	0	1310	0	3456	-1	-1	-1	-1	0	52
586	2	chr1	131355	131368	-	Contig23930	8892	8892	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
586	2	chr1	131493	131640	-	Contig23930	463	8766	0	0	0	-1	-1	-1	gap	0	1310	0	3450	-1	-1	-1	-1	0	52
586	1	chr1	138819	139522	-	Contig76645	68	666	309264	553	10217	-1	-1	598	top	0	0	0	21	-1	-1	-1	-1	80	563
586	2	chr1	138948	139074	-	Contig76645	548	548	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
586	1	chr1	139526	139715	+	Contig19873	14156	14336	429142	164	3327	-1	-1	180	top	0	0	8	0	-1	-1	-1	-1	0	180

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