Schema for ceBlastTab

Database: mm39 Primary Table: ceBlastTab Row Count: 4,443 Data last updated: 2026-07-12
Format description: Blast alignments of C. elegans genes
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`query`	ENSMUST00000521626.1	`varchar(255)`	values	Name of sequence in this assembly (query)
`target`	Y47D3A.15	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	45.02	`float`	range	Percent identity
`aliLength`	211	`int(10) unsigned`	range	Length of alignment
`mismatch`	98	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	4	`int(10) unsigned`	range	Number of gap openings
`qStart`	52	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	245	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	49	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	260	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	3e-42	`double`	range	Expectation value
`bitScore`	168	`double`	range	Bit score

Connected Tables and Joining Fields


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

Sample Rows

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
ENSMUST00000521626.1	Y47D3A.15	45.02	211	98	4	52	245	49	260	3e-42	168
ENSMUST00000037023.9	B0412.4	73.21	56	15	0	0	56	0	56	3e-19	89.4
ENSMUST00000073076.13	Y48G8AL.11a	52.06	582	275	2	118	696	86	668	2e-168	589
ENSMUST00000551301.1	C39E9.13	53.47	346	156	3	0	341	0	346	4e-106	381
ENSMUST00000516228.1	Y113G7B.16	39.2	500	269	8	6	495	4	480	2e-83	306
ENSMUST00000179802.3	F28H1.4a	29.68	155	104	2	43	195	112	265	0.0000003	51.6
ENSMUST00000205179.4	C47B2.7b	31.76	529	272	18	12	525	18	474	2e-55	213
ENSMUST00000096261.6	Y54E10BR.6	76.74	172	40	0	0	172	23	195	1e-72	268
ENSMUST00000165512.5	F33D11.4	68.33	60	19	0	238	298	107	167	2e-19	93.2
ENSMUST00000472154.1	Y37H9A.3	31.88	345	214	4	479	803	447	792	4e-44	176

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