Schema for scBlastTab

Database: hg38 Primary Table: scBlastTab Row Count: 2,363 Data last updated: 2026-07-16
Format description: Blast alignments of S. cerevisiae genes
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`query`	ENST00000330877.7	`varchar(255)`	values	Name of sequence in this assembly (query)
`target`	YNL220W	`varchar(255)`	values	Name of sequence in other assembly (target)
`identity`	57.11	`float`	range	Percent identity
`aliLength`	429	`int(10) unsigned`	range	Length of alignment
`mismatch`	177	`int(10) unsigned`	range	Number of mismatches
`gapOpen`	3	`int(10) unsigned`	range	Number of gap openings
`qStart`	32	`int(10) unsigned`	range	Start in query (0 based)
`qEnd`	455	`int(10) unsigned`	range	End in query (non-inclusive)
`tStart`	1	`int(10) unsigned`	range	Start in target (0 based)
`tEnd`	429	`int(10) unsigned`	range	End in target (non-inclusive)
`eValue`	2e-132	`double`	range	Expectation value
`bitScore`	467	`double`	range	Bit score

Connected Tables and Joining Fields


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

Sample Rows

query	target	identity	aliLength	mismatch	gapOpen	qStart	qEnd	tStart	tEnd	eValue	bitScore
ENST00000330877.7	YNL220W	57.11	429	177	3	32	455	1	429	2e-132	467
ENST00000933281.2	YDR023W	47.24	489	201	13	1	473	0	449	2e-115	410
ENST00000389231.10	YBR058C	28.38	874	477	32	11	833	4	781	9e-73	270
ENST00000918001.2	YDR337W	30.25	119	77	2	24	140	115	231	0.00000006	52
ENST00001008108.1	YKL117W	28.24	131	80	5	0	117	0	131	0.000000001	58.2
ENST00000913493.2	YDR457W	52.02	421	197	4	3820	4240	2851	3268	9e-125	445
ENST00001082634.1	YJR093C	47.14	70	28	1	123	184	163	233	0.0000000000001	72.8
ENST00000893608.2	YIL155C	43.62	603	275	13	53	599	49	644	5e-120	426
ENST00000685872.2	YGL049C	36.77	291	145	12	913	1178	563	841	1e-34	144
ENST00000642017.2	YBR035C	38.05	226	123	6	38	261	16	228	4e-36	145

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