Database: hg19    Primary Table: netCalJac3    Row Count: 2,319,713
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	11498	int(10) unsigned	Start on target
tEnd	39621	int(10) unsigned	End on target
strand	-	char(1)	Orientation of query. + or -
qName	chr9	varchar(255)	Query chromosome
qStart	11731402	int(10) unsigned	Start on query
qEnd	11784214	int(10) unsigned	End on query
chainId	1131	int(10) unsigned	Associated chain Id with alignment details
ali	24702	int(10) unsigned	Bases in gap-free alignments
score	1197579	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	48864	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	3142	int(11)	Unsequenced bases on query. -1 for undefined
tR	8689	int(11)	RepeatMasker bases on target. -1 for undefined
qR	11948	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	270	int(11)	Bases of tandem repeats on target. -1 for undefined
qTrf	355	int(11)	Bases of tandem repeats on query. -1 for undefined

      hg19.chainCalJac3.id (via netCalJac3.chainId)
      hg19.chainCalJac3Link.chainId (via netCalJac3.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	11498	39621	-	chr9	11731402	11784214	1131	24702	1197579	-1	-1	48864	top	0	3142	8689	11948	-1	-1	-1	-1	270	355
585	2	chr1	11894	11906	-	chr9	11783816	11783816	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12148	12179	-	chr9	11781573	11783573	0	0	0	-1	-1	-1	gap	0	0	0	313	-1	-1	-1	-1	0	34
585	2	chr1	14667	14700	-	chr9	11779043	11779043	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	18185	18195	-	chr9	11775521	11775521	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	18206	18222	-	chr9	11775510	11775510	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	19291	19354	-	chr9	11774425	11774425	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	49	0
585	2	chr1	19362	19375	-	chr9	11774417	11774417	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	13	0
585	2	chr1	19619	19634	-	chr9	11774175	11774175	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	20816	20869	-	chr9	11770938	11772998	0	0	0	-1	-1	-1	gap	0	0	0	724	-1	-1	-1	-1	35	0

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