Database: hg19    Primary Table: ceBlastTab    Row Count: 4,968
Format description: Tab-delimited blast output file

field	example	SQL type	info	description
query	uc003trd.2	varchar(255)	values	Name of sequence in this assembly (query)
target	C05D11.10	varchar(255)	values	Name of sequence in other assembly (target)
identity	30.7	float	range	Percent identity
aliLength	114	int(10) unsigned	range	Length of alignment
mismatch	70	int(10) unsigned	range	Number of mismatches
gapOpen	3	int(10) unsigned	range	Number of gap openings
qStart	1	int(10) unsigned	range	Start in query (0 based)
qEnd	107	int(10) unsigned	range	End in query (non-inclusive)
tStart	4	int(10) unsigned	range	Start in target (0 based)
tEnd	117	int(10) unsigned	range	End in target (non-inclusive)
eValue	0.000000062	double	range	Expectation value
bitScore	52.37	double	range	Bit score

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

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
uc003trd.2	C05D11.10	30.7	114	70	3	1	107	4	117	0.000000062	52.37
uc003uid.2	ZC506.4b	39.56	867	443	16	30	834	33	890	3e-178	622.5
uc010fpr.2	Y57G11A.3	25	224	130	7	22	236	52	248	0.000000000025	67.4
uc010fox.2	R10E4.2a	57.54	179	66	2	58	235	77	253	5e-48	188
uc003tqg.2	F32D8.6	64.18	67	9	0	0	67	0	67	2.1e-18	86.66
uc003szf.2	B0250.5	54.58	295	132	2	42	335	4	299	6.1e-86	313.9
uc010fot.1	W04E12.8	26.62	308	179	13	215	487	19	316	2.8e-23	107.1
uc003syn.1	C07H6.7	65.12	86	26	2	175	260	147	230	3e-26	115.2
uc003szd.1	M142.4	73.68	76	19	1	181	256	66	142	5.9e-25	111.7
uc003sxu.2	K08H2.6	32.12	137	81	2	35	172	42	170	0.000000000000014	75.48

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