Schema for drBlastTab

Database: hg19 Primary Table: drBlastTab Row Count: 11,235
Format description: Tab-delimited blast output file

field	example	SQL type	info	description
`query`	uc010ggu.2	`varchar(255)`	values	Name of sequence in this assembly (query)
`target`	ENSDART00000082821	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	84.44	`float`	range	Percent identity
`aliLength`	270	`int(10) unsigned`	range	Length of alignment
`mismatch`	39	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	2	`int(10) unsigned`	range	Number of gap openings
`qStart`	0	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	270	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	0	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	267	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	1e-126	`double`	range	Expectation value
`bitScore`	449.5	`double`	range	Bit score

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

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
uc010ggu.2	ENSDART00000082821	84.44	270	39	2	0	270	0	267	1e-126	449.5
uc003syx.2	ENSDART00000102925	49.2	311	117	4	1	312	2	276	4.3e-76	281.6
uc003szn.2	ENSDART00000079343	70.37	243	24	0	0	243	0	243	2.8e-98	354.8
uc003trd.2	ENSDART00000076320	73.88	134	29	4	0	129	0	133	8.4e-48	185.3
uc003uid.2	ENSDART00000047309	74.52	883	186	8	8	879	4	884	0	1330.9
uc010fpr.2	ENSDART00000104928	36.49	285	145	9	189	466	0	258	6.1e-43	172.9
uc003szl.2	ENSDART00000040727	49.7	827	340	14	8	788	0	810	0	766.1
uc003uhl.2	ENSDART00000092421	47.63	695	343	7	34	723	23	703	0	732.6
uc010fpq.2	ENSDART00000042413	38.59	1472	775	29	227	1673	17	1394	0	956.1
uc010ezh.1	ENSDART00000010362	63.96	419	111	5	0	412	0	414	4e-145	511.5

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