Database: hg19    Primary Table: rnBlastTab    Row Count: 25,071
Format description: Tab-delimited blast output file

field	example	SQL type	info	description
query	uc001aby.3	varchar(255)	values	Name of sequence in this assembly (query)
target	NM_001033897	varchar(255)	values	Name of sequence in other assembly (target)
identity	74.07	float	range	Percent identity
aliLength	509	int(10) unsigned	range	Length of alignment
mismatch	121	int(10) unsigned	range	Number of mismatches
gapOpen	1	int(10) unsigned	range	Number of gap openings
qStart	29	int(10) unsigned	range	Start in query (0 based)
qEnd	538	int(10) unsigned	range	End in query (non-inclusive)
tStart	129	int(10) unsigned	range	Start in target (0 based)
tEnd	631	int(10) unsigned	range	End in target (non-inclusive)
eValue	0	double	range	Expectation value
bitScore	763.1	double	range	Bit score

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

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
uc001aby.3	NM_001033897	74.07	509	121	1	29	538	129	631	0	763.1
uc001abz.3	NM_001033897	75.42	602	137	2	135	736	31	631	0	910.2
uc009vjq.2	NM_001033897	74.79	607	141	2	135	741	31	631	0	910.2
uc001aca.1	NM_145671	92.98	627	26	1	0	627	0	625	0	1160.2
uc001acb.1	NM_145671	99.12	114	1	0	0	114	122	236	5.3e-61	228.4
uc010nya.1	NM_145671	99.12	114	1	0	0	114	122	236	5.3e-61	228.4
uc010nyb.1	NM_145671	100	71	0	0	0	71	275	346	3.2e-37	149.1
uc001aci.2	NM_024360	68	150	40	0	0	150	0	150	6.3e-54	205.3
uc010nyc.1	NM_024360	57.95	176	40	1	0	176	0	150	1.5e-49	191
uc001ack.1	NM_175754	74.65	1913	346	5	155	2045	50	1959	0	2986.8

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