Database: hg19    Primary Table: kgTargetAli    Row Count: 77,614
Format description: Summary info about a patSpace alignment

field	example	SQL type	info	description
bin	585	smallint(5) unsigned	range	Indexing field to speed chromosome range queries.
matches	1488	int(10) unsigned	range	Number of bases that match that aren't repeats
misMatches	0	int(10) unsigned	range	Number of bases that don't match
repMatches	0	int(10) unsigned	range	Number of bases that match but are part of repeats
nCount	0	int(10) unsigned	range	Number of 'N' bases
qNumInsert	0	int(10) unsigned	range	Number of inserts in query
qBaseInsert	0	int(10) unsigned	range	Number of bases inserted in query
tNumInsert	2	int(10) unsigned	range	Number of inserts in target
tBaseInsert	1048	int(10) unsigned	range	Number of bases inserted in target
strand	+	char(2)	values	+ or - for strand. First character query, second target (optional)
qName	uc010nxq.1	varchar(255)	values	Query sequence name
qSize	1488	int(10) unsigned	range	Query sequence size
qStart	0	int(10) unsigned	range	Alignment start position in query
qEnd	1488	int(10) unsigned	range	Alignment end position in query
tName	chr1	varchar(255)	values	Target sequence name
tSize	249250621	int(10) unsigned	range	Target sequence size
tStart	11873	int(10) unsigned	range	Alignment start position in target
tEnd	14409	int(10) unsigned	range	Alignment end position in target
blockCount	3	int(10) unsigned	range	Number of blocks in alignment
blockSizes	354,127,1007,	longblob		Size of each block
qStarts	0,354,481,	longblob		Start of each block in query.
tStarts	11873,12594,13402,	longblob		Start of each block in target.

      hg19.bioCycPathway.kgID (via kgTargetAli.qName)
      hg19.ccdsKgMap.geneId (via kgTargetAli.qName)
      hg19.ceBlastTab.query (via kgTargetAli.qName)
      hg19.dmBlastTab.query (via kgTargetAli.qName)
      hg19.drBlastTab.query (via kgTargetAli.qName)
      hg19.foldUtr3.name (via kgTargetAli.qName)
      hg19.foldUtr5.name (via kgTargetAli.qName)
      hg19.gnfAtlas2Distance.query (via kgTargetAli.qName)
      hg19.gnfAtlas2Distance.target (via kgTargetAli.qName)
      hg19.humanHprdP2P.query (via kgTargetAli.qName)
      hg19.humanHprdP2P.target (via kgTargetAli.qName)
      hg19.humanVidalP2P.query (via kgTargetAli.qName)
      hg19.humanVidalP2P.target (via kgTargetAli.qName)
      hg19.humanWankerP2P.query (via kgTargetAli.qName)
      hg19.humanWankerP2P.target (via kgTargetAli.qName)
      hg19.keggPathway.kgID (via kgTargetAli.qName)
      hg19.kg4ToKg5.newId (via kgTargetAli.qName)
      hg19.kgAlias.kgID (via kgTargetAli.qName)
      hg19.kgColor.kgID (via kgTargetAli.qName)
      hg19.kgProtAlias.kgID (via kgTargetAli.qName)
      hg19.kgProtMap2.qName (via kgTargetAli.qName)
      hg19.kgSpAlias.kgID (via kgTargetAli.qName)
      hg19.kgTxInfo.name (via kgTargetAli.qName)
      hg19.kgXref.kgID (via kgTargetAli.qName)
      hg19.knownBlastTab.query (via kgTargetAli.qName)
      hg19.knownBlastTab.target (via kgTargetAli.qName)
      hg19.knownCanonical.protein (via kgTargetAli.qName)
      hg19.knownCanonical.transcript (via kgTargetAli.qName)
      hg19.knownGene.name (via kgTargetAli.qName)
      hg19.knownGeneMrna.name (via kgTargetAli.qName)
      hg19.knownGenePep.name (via kgTargetAli.qName)
      hg19.knownIsoforms.transcript (via kgTargetAli.qName)
      hg19.knownToAllenBrain.name (via kgTargetAli.qName)
      hg19.knownToEnsembl.name (via kgTargetAli.qName)
      hg19.knownToGnfAtlas2.name (via kgTargetAli.qName)
      hg19.knownToHprd.name (via kgTargetAli.qName)
      hg19.knownToLocusLink.name (via kgTargetAli.qName)
      hg19.knownToPfam.name (via kgTargetAli.qName)
      hg19.knownToRefSeq.name (via kgTargetAli.qName)
      hg19.knownToSuper.gene (via kgTargetAli.qName)
      hg19.knownToTreefam.name (via kgTargetAli.qName)
      hg19.knownToU133.name (via kgTargetAli.qName)
      hg19.knownToVisiGene.name (via kgTargetAli.qName)
      hg19.mmBlastTab.query (via kgTargetAli.qName)
      hg19.rnBlastTab.query (via kgTargetAli.qName)
      hg19.scBlastTab.query (via kgTargetAli.qName)

bin	matches	misMatches	repMatches	nCount	qNumInsert	qBaseInsert	tNumInsert	tBaseInsert	strand	qName	qSize	qStart	qEnd	tName	tSize	tStart	tEnd	blockCount	blockSizes	qStarts	tStarts
585	1488	0	0	0	0	0	2	1048	+	uc010nxq.1	1488	0	1488	chr1	249250621	11873	14409	3	354,127,1007,	0,354,481,	11873,12594,13402,
585	1595	0	0	0	0	0	2	941	+	uc010nxr.1	1595	0	1595	chr1	249250621	11873	14409	3	354,52,1189,	0,354,406,	11873,12645,13220,
585	1652	0	0	0	0	0	2	884	+	uc001aaa.3	1652	0	1652	chr1	249250621	11873	14409	3	354,109,1189,	0,354,463,	11873,12612,13220,
585	1636	0	0	0	0	0	6	13372	-	uc009viq.2	1636	0	1636	chr1	249250621	14362	29370	7	467,152,159,198,456,154,50,	0,467,619,778,976,1432,1586,	14362,15795,16606,16857,17605,24737,29320,
585	1745	0	0	0	0	0	10	13263	-	uc001aac.3	1745	0	1745	chr1	249250621	14362	29370	11	467,69,152,159,198,110,137,147,102,154,50,	0,467,536,688,847,1045,1155,1292,1439,1541,1695,	14362,14969,15795,16606,16857,17258,17605,17914,18267,24737,29320,
585	1745	0	0	0	0	0	9	8794	-	uc001aab.3	1745	0	1745	chr1	249250621	14362	24901	10	467,69,152,159,202,136,137,147,112,164,	0,467,536,688,847,1049,1185,1322,1469,1581,	14362,14969,15795,16606,16853,17232,17605,17914,18267,24737,
585	1768	0	0	0	0	0	10	13240	-	uc001aah.3	1768	0	1768	chr1	249250621	14362	29370	11	467,69,152,159,198,136,137,147,99,154,50,	0,467,536,688,847,1045,1181,1318,1465,1564,1718,	14362,14969,15795,16606,16857,17232,17605,17914,18267,24737,29320,
585	2005	0	0	0	0	0	9	13003	-	uc009vir.2	2005	0	2005	chr1	249250621	14362	29370	10	467,69,152,159,198,510,147,99,154,50,	0,467,536,688,847,1045,1555,1702,1801,1955,	14362,14969,15795,16606,16857,17232,17914,18267,24737,29320,
585	2411	0	0	0	0	0	9	2986	-	uc001aae.3	2411	0	2411	chr1	249250621	14362	19759	10	467,69,152,159,198,136,137,147,99,847,	0,467,536,688,847,1045,1181,1318,1465,1564,	14362,14969,15795,16606,16857,17232,17605,17914,18267,18912,
585	2648	0	0	0	0	0	8	2749	-	uc009vit.2	2648	0	2648	chr1	249250621	14362	19759	9	467,69,152,159,198,510,147,99,847,	0,467,536,688,847,1045,1555,1702,1801,	14362,14969,15795,16606,16857,17232,17914,18267,18912,

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