Schema for dmBlastTab

Database: hg38 Primary Table: dmBlastTab Row Count: 6,055 Data last updated: 2025-09-26
Format description: Blast alignments of Drosophila 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`	FBtr0083048	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	50.51	`float`	range	Percent identity
`aliLength`	588	`int(10) unsigned`	range	Length of alignment
`mismatch`	279	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	6	`int(10) unsigned`	range	Number of gap openings
`qStart`	22	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	604	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	13	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	595	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	4e-161	`double`	range	Expectation value
`bitScore`	565	`double`	range	Bit score

Connected Tables and Joining Fields


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

Sample Rows

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
ENST00000943175.1	FBtr0083048	50.51	588	279	6	22	604	13	595	4e-161	565
ENST00000389231.9	FBtr0445725	50.6	840	373	14	12	832	7	825	0	816
ENST00000261637.5	FBtr0071833	25.83	2156	1391	48	669	2717	607	2663	1e-163	576
ENST00000330877.7	FBtr0083991	60.66	427	163	3	30	456	23	446	2e-148	523
ENST00000947568.1	FBtr0070709	57.44	383	152	5	3	376	0	382	5e-126	448
ENST00000374839.8	FBtr0074417	47.45	137	70	2	1	136	8	145	9e-25	110
ENST00000314163.12	FBtr0087404	56.92	448	188	3	0	446	0	445	3e-141	499
ENST00000537611.3	FBtr0307180	22.91	502	278	18	39	466	40	508	2e-18	91.3
ENST00000918000.1	FBtr0071860	34.09	132	85	1	80	210	49	181	0.0000000000007	71.6
ENST00000355151.9	FBtr0088942	41.3	92	53	1	25	116	31	123	0.00000000003	63.9

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