Database: hg19    Primary Table: netOrnAna1    Row Count: 897,579
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	11871	int(10) unsigned	Start on target
tEnd	25924	int(10) unsigned	End on target
strand	+	char(1)	Orientation of query. + or -
qName	Contig4137	varchar(255)	Query chromosome
qStart	24545	int(10) unsigned	Start on query
qEnd	40207	int(10) unsigned	End on query
chainId	3927	int(10) unsigned	Associated chain Id with alignment details
ali	4644	int(10) unsigned	Bases in gap-free alignments
score	150469	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	7355	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	550	int(11)	Unsequenced bases on query. -1 for undefined
tR	1848	int(11)	RepeatMasker bases on target. -1 for undefined
qR	4865	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	173	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.chainOrnAna1.id (via netOrnAna1.chainId)
      hg19.chainOrnAna1Link.chainId (via netOrnAna1.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	11871	25924	+	Contig4137	24545	40207	3927	4644	150469	-1	-1	7355	top	0	550	1848	4865	-1	-1	-1	-1	173	0
585	2	chr1	11984	11997	+	Contig4137	24673	24673	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12085	12176	+	Contig4137	24761	26877	0	0	0	-1	-1	-1	gap	0	0	0	701	-1	-1	-1	-1	0	0
585	2	chr1	12329	12342	+	Contig4137	27016	27016	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12379	12589	+	Contig4137	27053	27096	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12700	12738	+	Contig4137	27209	27209	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12771	12790	+	Contig4137	27233	27233	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12819	12838	+	Contig4137	27259	27259	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12853	12864	+	Contig4137	27274	27274	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12872	12891	+	Contig4137	27282	27282	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.