Schema for drBlastTab

Database: hg38 Primary Table: drBlastTab Row Count: 13,798 Data last updated: 2025-09-26
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`query`	ENST00000943175.1	`varchar(255)`	values	Name of sequence in this assembly (query)
`target`	ENSDART00000172822.2	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	96.04	`float`	range	Percent identity
`aliLength`	429	`int(10) unsigned`	range	Length of alignment
`mismatch`	17	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	0	`int(10) unsigned`	range	Number of gap openings
`qStart`	22	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	451	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	15	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	444	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	0	`double`	range	Expectation value
`bitScore`	833	`double`	range	Bit score

Connected Tables and Joining Fields


	hg38.bioCycPathway.kgID (via drBlastTab.query) hg38.ccdsKgMap.geneId (via drBlastTab.query) hg38.ceBlastTab.query (via drBlastTab.query) hg38.dmBlastTab.query (via drBlastTab.query) hg38.foldUtr3.name (via drBlastTab.query) hg38.foldUtr5.name (via drBlastTab.query) hg38.gnfAtlas2Distance.query (via drBlastTab.query) hg38.gnfAtlas2Distance.target (via drBlastTab.query) hg38.gnfU95Distance.query (via drBlastTab.query) hg38.gnfU95Distance.target (via drBlastTab.query) hg38.humanHprdP2P.query (via drBlastTab.query) hg38.humanHprdP2P.target (via drBlastTab.query) hg38.humanVidalP2P.query (via drBlastTab.query) hg38.humanVidalP2P.target (via drBlastTab.query) hg38.humanWankerP2P.query (via drBlastTab.query) hg38.humanWankerP2P.target (via drBlastTab.query) hg38.keggPathway.kgID (via drBlastTab.query) hg38.kgAlias.kgID (via drBlastTab.query) hg38.kgColor.kgID (via drBlastTab.query) hg38.kgProtAlias.kgID (via drBlastTab.query) hg38.kgSpAlias.kgID (via drBlastTab.query) hg38.kgTargetAli.qName (via drBlastTab.query) hg38.kgXref.kgID (via drBlastTab.query) hg38.knownAttrs.kgID (via drBlastTab.query) hg38.knownBlastTab.query (via drBlastTab.query) hg38.knownBlastTab.target (via drBlastTab.query) hg38.knownCanonical.transcript (via drBlastTab.query) hg38.knownCds.name (via drBlastTab.query) hg38.knownGene.name (via drBlastTab.query) hg38.knownGeneMrna.name (via drBlastTab.query) hg38.knownGenePep.name (via drBlastTab.query) hg38.knownIsoforms.transcript (via drBlastTab.query) hg38.knownToEnsembl.name (via drBlastTab.query) hg38.knownToGnfAtlas2.name (via drBlastTab.query) hg38.knownToHprd.name (via drBlastTab.query) hg38.knownToKeggEntrez.name (via drBlastTab.query) hg38.knownToLocusLink.name (via drBlastTab.query) hg38.knownToLynx.name (via drBlastTab.query) hg38.knownToMrna.name (via drBlastTab.query) hg38.knownToMrnaSingle.name (via drBlastTab.query) hg38.knownToMupit.name (via drBlastTab.query) hg38.knownToNextProt.name (via drBlastTab.query) hg38.knownToPfam.name (via drBlastTab.query) hg38.knownToRefSeq.name (via drBlastTab.query) hg38.knownToSuper.gene (via drBlastTab.query) hg38.knownToTag.name (via drBlastTab.query) hg38.knownToU133.name (via drBlastTab.query) hg38.knownToU95.name (via drBlastTab.query) hg38.knownToVisiGene.name (via drBlastTab.query) hg38.knownToWikipedia.name (via drBlastTab.query) hg38.mmBlastTab.query (via drBlastTab.query) hg38.rnBlastTab.query (via drBlastTab.query) hg38.scBlastTab.query (via drBlastTab.query) hg38.ucscScop.ucscId (via drBlastTab.query) knownGeneV39.bioCycPathway.kgID (via drBlastTab.query) knownGeneV39.ceBlastTab.query (via drBlastTab.query) knownGeneV39.dmBlastTab.query (via drBlastTab.query) knownGeneV39.drBlastTab.query (via drBlastTab.query) knownGeneV39.foldUtr3.name (via drBlastTab.query) knownGeneV39.foldUtr5.name (via drBlastTab.query) knownGeneV39.gnfAtlas2Distance.query (via drBlastTab.query) knownGeneV39.gnfAtlas2Distance.target (via drBlastTab.query) knownGeneV39.kgAlias.kgID (via drBlastTab.query) knownGeneV39.kgColor.kgID (via drBlastTab.query) knownGeneV39.kgProtAlias.kgID (via drBlastTab.query) knownGeneV39.kgSpAlias.kgID (via drBlastTab.query) knownGeneV39.kgTargetAli.qName (via drBlastTab.query) knownGeneV39.kgXref.kgID (via drBlastTab.query) knownGeneV39.knownAttrs.kgID (via drBlastTab.query) knownGeneV39.knownBlastTab.query (via drBlastTab.query) knownGeneV39.knownBlastTab.target (via drBlastTab.query) knownGeneV39.knownCanonical.protein (via drBlastTab.query) knownGeneV39.knownCanonical.transcript (via drBlastTab.query) knownGeneV39.knownCds.name (via drBlastTab.query) knownGeneV39.knownGene.name (via drBlastTab.query) knownGeneV39.knownGeneMrna.name (via drBlastTab.query) knownGeneV39.knownGenePep.name (via drBlastTab.query) knownGeneV39.knownIsoforms.transcript (via drBlastTab.query) knownGeneV39.knownToEnsembl.name (via drBlastTab.query) knownGeneV39.knownToGnfAtlas2.name (via drBlastTab.query) knownGeneV39.knownToHprd.name (via drBlastTab.query) knownGeneV39.knownToLocusLink.name (via drBlastTab.query) knownGeneV39.knownToMrna.name (via drBlastTab.query) knownGeneV39.knownToMrnaSingle.name (via drBlastTab.query) knownGeneV39.knownToMupit.name (via drBlastTab.query) knownGeneV39.knownToPfam.name (via drBlastTab.query) knownGeneV39.knownToRefSeq.name (via drBlastTab.query) knownGeneV39.knownToSuper.gene (via drBlastTab.query) knownGeneV39.knownToTag.name (via drBlastTab.query) knownGeneV39.knownToU133.name (via drBlastTab.query) knownGeneV39.knownToU95.name (via drBlastTab.query) knownGeneV39.knownToVisiGene.name (via drBlastTab.query) knownGeneV39.knownToWikipedia.name (via drBlastTab.query) knownGeneV39.mmBlastTab.query (via drBlastTab.query) knownGeneV39.rnBlastTab.query (via drBlastTab.query) knownGeneV39.scBlastTab.query (via drBlastTab.query) knownGeneV39.ucscScop.ucscId (via drBlastTab.query)

Sample Rows

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
ENST00000943175.1	ENSDART00000172822.2	96.04	429	17	0	22	451	15	444	0	833
ENST00000370447.3	ENSDART00000192225.1	45.12	328	156	7	76	393	118	433	2e-56	218
ENST00000409123.5	ENSDART00000192353.1	50	106	42	3	32	130	17	120	2e-18	91.3
ENST00000389231.9	ENSDART00000148666.3	69.08	828	244	9	11	833	10	832	0	1145
ENST00000380338.9	ENSDART00000021502.9	55.58	565	212	8	32	568	0	555	7e-105	379
ENST00000626639.1	ENSDART00000157450.2	74.51	612	152	3	12	622	9	619	0	881
ENST00000261637.5	ENSDART00000166591.2	56.83	2810	1168	11	0	2784	2	2793	0	3006
ENST00000371436.10	ENSDART00000105394.3	79.33	508	55	7	0	499	0	467	0	677
ENST00000333407.11	ENSDART00000103592.6	47.56	307	152	2	0	307	0	298	2e-79	294
ENST00000888219.1	ENSDART00000193365.1	77.97	236	50	2	0	236	0	234	4e-98	354

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