Schema for scBlastTab

Database: mm39 Primary Table: scBlastTab Row Count: 2,360 Data last updated: 2026-07-12
Format description: Blast alignments of S. cerevisiae 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`	YGL208W	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	31.85	`float`	range	Percent identity
`aliLength`	248	`int(10) unsigned`	range	Length of alignment
`mismatch`	116	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	7	`int(10) unsigned`	range	Number of gap openings
`qStart`	64	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	259	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	164	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	412	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	4e-17	`double`	range	Expectation value
`bitScore`	83.2	`double`	range	Bit score

Connected Tables and Joining Fields


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

Sample Rows

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
ENSMUST00000521626.1	YGL208W	31.85	248	116	7	64	259	164	412	4e-17	83.2
ENSMUST00000402925.1	YOL103W	33.95	324	200	6	86	401	125	444	3e-48	187
ENSMUST00000096261.6	YDR404C	42.77	173	95	2	0	171	0	171	2e-34	139
ENSMUST00000511730.1	YBR111W-A	32.56	86	56	2	4	88	5	91	0.0000002	48.5
ENSMUST00000397416.1	YDR402C	25.34	371	231	17	124	480	107	447	1e-18	89.7
ENSMUST00000072079.9	YOR294W	39.69	194	94	7	23	196	10	202	2e-21	97.8
ENSMUST00000170895.5	YDR454C	51.89	185	87	2	13	197	2	186	3e-50	192
ENSMUST00000060226.12	YGL200C	33.33	189	116	4	18	201	18	203	3e-23	103
ENSMUST00000422690.1	YGR260W	22.93	205	146	5	163	358	182	385	0.00001	46.2
ENSMUST00000535900.1	YHL031C	27.53	178	125	3	70	247	48	223	6e-16	79.3

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