Schema for dmBlastTab

Database: mm39 Primary Table: dmBlastTab Row Count: 6,074 Data last updated: 2026-07-12
Format description: Blast alignments of Drosophila genes
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`query`	ENSMUST00000466664.1	`varchar(255)`	values	Name of sequence in this assembly (query)
`target`	FBtr0089488	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	69.55	`float`	range	Percent identity
`aliLength`	936	`int(10) unsigned`	range	Length of alignment
`mismatch`	283	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	2	`int(10) unsigned`	range	Number of gap openings
`qStart`	5	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	939	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	4	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	940	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	0	`double`	range	Expectation value
`bitScore`	1336	`double`	range	Bit score

Connected Tables and Joining Fields


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

Sample Rows

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
ENSMUST00000466664.1	FBtr0089488	69.55	936	283	2	5	939	4	940	0	1336
ENSMUST00000190686.8	FBtr0072807	49.1	167	78	4	0	164	0	163	5e-27	122
ENSMUST00000531518.1	FBtr0080330	46.28	739	353	14	4	725	10	723	4e-177	619
ENSMUST00000007790.12	FBtr0085116	36.11	216	125	2	108	324	45	248	5e-31	132
ENSMUST00000037023.9	FBtr0334681	78.57	56	12	0	0	56	0	56	6e-21	95.9
ENSMUST00000073076.13	FBtr0073658	51.11	632	298	3	71	692	68	700	1e-173	607
ENSMUST00000481949.1	FBtr0345675	86.32	95	13	0	206	301	475	570	4e-49	192
ENSMUST00000432600.1	FBtr0333730	50.36	137	58	2	18	145	24	161	4e-33	137
ENSMUST00000180792.9	FBtr0080435	28.86	201	134	2	0	193	21	221	4e-24	110
ENSMUST00000496336.1	FBtr0084737	32.63	668	402	14	0	651	101	738	2e-82	304

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