Schema for ceBlastTab

Database: hg38 Primary Table: ceBlastTab Row Count: 4,394 Data last updated: 2025-09-26
Format description: Blast alignments of C. elegans 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`	C09H6.3	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	21.98	`float`	range	Percent identity
`aliLength`	605	`int(10) unsigned`	range	Length of alignment
`mismatch`	413	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	16	`int(10) unsigned`	range	Number of gap openings
`qStart`	22	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	594	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	3	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	582	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	5e-24	`double`	range	Expectation value
`bitScore`	109	`double`	range	Bit score

Connected Tables and Joining Fields


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

Sample Rows

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
ENST00000943175.1	C09H6.3	21.98	605	413	16	22	594	3	582	5e-24	109
ENST00000389231.9	T27A3.2	34.93	833	463	22	18	834	18	789	6e-132	468
ENST00000543111.5	T23E7.2e	32.99	97	62	1	1539	1633	307	404	0.000008	51.2
ENST00000261637.5	F18C5.3	25.58	997	622	19	1764	2740	546	1444	8e-78	290
ENST00000947568.1	T05H10.6b	62.43	354	130	1	27	378	38	392	5e-133	470
ENST00000374839.8	ZK930.2	26.17	214	132	5	10	206	9	215	0.0000000003	61.6
ENST00000354619.10	Y105E8B.8d	44.1	424	202	10	51	460	49	453	1e-95	347
ENST00000314163.12	Y75B8A.16	56.42	452	185	5	5	448	10	459	1e-143	506
ENST00000285814.9	T04A8.6	35.42	144	88	2	45	185	32	175	6e-18	87.8
ENST00000918001.1	K07A12.7	29.03	124	79	3	30	147	98	220	0.000001	49.7

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