Schema for drBlastTab

Database: mm39 Primary Table: drBlastTab Row Count: 13,770 Data last updated: 2026-07-12
Format description: Blast alignments of Zebrafish genes
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`query`	ENSMUST00000065163.16	`varchar(255)`	values	Name of sequence in this assembly (query)
`target`	ENSDART00000160545.2	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	68.75	`float`	range	Percent identity
`aliLength`	192	`int(10) unsigned`	range	Length of alignment
`mismatch`	55	`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`	191	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	0	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	188	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	5e-65	`double`	range	Expectation value
`bitScore`	244	`double`	range	Bit score

Connected Tables and Joining Fields


	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) mm39.bioCycPathway.kgID (via drBlastTab.query) mm39.ceBlastTab.query (via drBlastTab.query) mm39.dmBlastTab.query (via drBlastTab.query) mm39.foldUtr3.name (via drBlastTab.query) mm39.foldUtr5.name (via drBlastTab.query) mm39.hgBlastTab.query (via drBlastTab.query) mm39.kgAlias.kgID (via drBlastTab.query) mm39.kgColor.kgID (via drBlastTab.query) mm39.kgProtAlias.kgID (via drBlastTab.query) mm39.kgSpAlias.kgID (via drBlastTab.query) mm39.kgTargetAli.qName (via drBlastTab.query) mm39.kgXref.kgID (via drBlastTab.query) mm39.knownAttrs.kgID (via drBlastTab.query) mm39.knownBlastTab.query (via drBlastTab.query) mm39.knownBlastTab.target (via drBlastTab.query) mm39.knownCanonical.transcript (via drBlastTab.query) mm39.knownCds.name (via drBlastTab.query) mm39.knownGene.name (via drBlastTab.query) mm39.knownGeneMrna.name (via drBlastTab.query) mm39.knownIsoforms.transcript (via drBlastTab.query) mm39.knownToEnsembl.name (via drBlastTab.query) mm39.knownToLocusLink.name (via drBlastTab.query) mm39.knownToMrna.name (via drBlastTab.query) mm39.knownToMrnaSingle.name (via drBlastTab.query) mm39.knownToMupit.name (via drBlastTab.query) mm39.knownToNextProt.name (via drBlastTab.query) mm39.knownToPfam.name (via drBlastTab.query) mm39.knownToRefSeq.name (via drBlastTab.query) mm39.knownToSuper.gene (via drBlastTab.query) mm39.knownToTag.name (via drBlastTab.query) mm39.knownToVisiGene.name (via drBlastTab.query) mm39.knownToWikipedia.name (via drBlastTab.query) mm39.rnBlastTab.query (via drBlastTab.query) mm39.scBlastTab.query (via drBlastTab.query) mm39.ucscScop.ucscId (via drBlastTab.query)

Sample Rows

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
ENSMUST00000065163.16	ENSDART00000160545.2	68.75	192	55	2	0	191	0	188	5e-65	244
ENSMUST00000131446.9	ENSDART00000182967.1	75.58	344	81	1	0	341	0	344	2e-143	506
ENSMUST00000056708.4	ENSDART00000136239.2	66.74	451	140	4	99	549	76	518	3e-161	566
ENSMUST00000034058.15	ENSDART00000149735.2	64.68	235	82	1	0	234	0	235	1e-79	293
ENSMUST00000190686.8	ENSDART00000129339.4	58.06	155	59	3	0	153	0	151	4e-31	136
ENSMUST00000531518.1	ENSDART00000172618.2	89.27	727	77	1	0	727	0	726	0	1335
ENSMUST00000565580.1	ENSDART00000159954.3	71.86	629	139	11	307	920	295	902	0	814
ENSMUST00000037023.9	ENSDART00000060444.6	96.43	56	2	0	0	56	0	56	3e-27	117
ENSMUST00000073076.13	ENSDART00000079202.6	66.12	605	197	2	93	692	105	708	0	768
ENSMUST00000481949.1	ENSDART00000104317.5	65.36	306	90	6	0	301	0	295	5e-89	325

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