Database: hg19    Primary Table: netSusScr2    Row Count: 3,822,588
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	11707	int(10) unsigned	Start on target
tEnd	36884	int(10) unsigned	End on target
strand	+	char(1)	Orientation of query. + or -
qName	chr5	varchar(255)	Query chromosome
qStart	63220996	int(10) unsigned	Start on query
qEnd	63248923	int(10) unsigned	End on query
chainId	7774	int(10) unsigned	Associated chain Id with alignment details
ali	17091	int(10) unsigned	Bases in gap-free alignments
score	551182	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	22360	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	200	int(11)	Unsequenced bases on query. -1 for undefined
tR	6472	int(11)	RepeatMasker bases on target. -1 for undefined
qR	8978	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	160	int(11)	Bases of tandem repeats on query. -1 for undefined

      hg19.chainSusScr2.id (via netSusScr2.chainId)
      hg19.chainSusScr2Link.chainId (via netSusScr2.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	11707	36884	+	chr5	63220996	63248923	7774	17091	551182	-1	-1	22360	top	0	200	6472	8978	-1	-1	-1	-1	270	160
585	2	chr1	12095	12178	+	chr5	63221387	63223088	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12286	12297	+	chr5	63223196	63223196	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12341	12353	+	chr5	63223240	63223240	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12497	12516	+	chr5	63223384	63223384	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12592	12602	+	chr5	63223452	63223452	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12736	12764	+	chr5	63223585	63223585	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	12838	12856	+	chr5	63223658	63223658	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	13684	13697	+	chr5	63224533	63224533	0	0	0	-1	-1	-1	gap	0	0	0	0	-1	-1	-1	-1	0	0
585	2	chr1	14273	14314	+	chr5	63225096	63225096	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.