Schema for foldUtr5

Database: hg17 Primary Table: foldUtr5 Row Count: 33,765 Data last updated: 2005-06-06
Format description: Info about folding of RNA into secondary structure
On download server: MariaDB table dump directory

field	example	SQL type	info	description
`name`	AB000409	`varchar(255)`	values	mRNA accession
`seq`	GCGAUCUGCAGGUAGGGGUGCGCGCGA...	`longblob`		mRNA sequence (U's instead of T's)
`fold`	(((((((.(((...((((.(((........	`longblob`		Parenthesis and .'s that describe folding
`energy`	-53.5	`float`	range	Estimated free energy of folding (negative)

Connected Tables and Joining Fields


	hg17.bioCycPathway.kgID (via foldUtr5.name) hg17.ccdsKgMap.geneId (via foldUtr5.name) hg17.ceBlastTab.query (via foldUtr5.name) hg17.dmBlastTab.query (via foldUtr5.name) hg17.drBlastTab.query (via foldUtr5.name) hg17.dupSpMrna.mrnaID (via foldUtr5.name) hg17.foldUtr3.name (via foldUtr5.name) hg17.gladHumESDistance.query (via foldUtr5.name) hg17.gladHumESDistance.target (via foldUtr5.name) hg17.gnfAtlas2Distance.query (via foldUtr5.name) hg17.gnfAtlas2Distance.target (via foldUtr5.name) hg17.gnfU95Distance.query (via foldUtr5.name) hg17.gnfU95Distance.target (via foldUtr5.name) hg17.humanHprdP2P.query (via foldUtr5.name) hg17.humanHprdP2P.target (via foldUtr5.name) hg17.humanVidalP2P.query (via foldUtr5.name) hg17.humanVidalP2P.target (via foldUtr5.name) hg17.humanWankerP2P.query (via foldUtr5.name) hg17.humanWankerP2P.target (via foldUtr5.name) hg17.keggPathway.kgID (via foldUtr5.name) hg17.kgAlias.kgID (via foldUtr5.name) hg17.kgProtAlias.kgID (via foldUtr5.name) hg17.kgSpAlias.kgID (via foldUtr5.name) hg17.kgTargetAli.qName (via foldUtr5.name) hg17.kgXref.kgID (via foldUtr5.name) hg17.knownBlastTab.query (via foldUtr5.name) hg17.knownBlastTab.target (via foldUtr5.name) hg17.knownCanonical.transcript (via foldUtr5.name) hg17.knownExpDistance.query (via foldUtr5.name) hg17.knownExpDistance.target (via foldUtr5.name) hg17.knownGene.name (via foldUtr5.name) hg17.knownGeneLink.name (via foldUtr5.name) hg17.knownGeneMrna.name (via foldUtr5.name) hg17.knownGenePep.name (via foldUtr5.name) hg17.knownIsoforms.transcript (via foldUtr5.name) hg17.knownToAllenBrain.name (via foldUtr5.name) hg17.knownToEnsembl.name (via foldUtr5.name) hg17.knownToGnf1h.name (via foldUtr5.name) hg17.knownToGnfAtlas2.name (via foldUtr5.name) hg17.knownToHInv.name (via foldUtr5.name) hg17.knownToHprd.name (via foldUtr5.name) hg17.knownToKeggEntrez.name (via foldUtr5.name) hg17.knownToLocusLink.name (via foldUtr5.name) hg17.knownToPfam.name (via foldUtr5.name) hg17.knownToRefSeq.name (via foldUtr5.name) hg17.knownToSuper.gene (via foldUtr5.name) hg17.knownToU133.name (via foldUtr5.name) hg17.knownToU133Plus2.name (via foldUtr5.name) hg17.knownToU95.name (via foldUtr5.name) hg17.knownToVisiGene.name (via foldUtr5.name) hg17.mmBlastTab.query (via foldUtr5.name) hg17.rankProp.query (via foldUtr5.name) hg17.rankProp.target (via foldUtr5.name) hg17.rnBlastTab.query (via foldUtr5.name) hg17.scBlastTab.query (via foldUtr5.name) knownGeneV39.bioCycPathway.kgID (via foldUtr5.name) knownGeneV39.ceBlastTab.query (via foldUtr5.name) knownGeneV39.dmBlastTab.query (via foldUtr5.name) knownGeneV39.drBlastTab.query (via foldUtr5.name) knownGeneV39.foldUtr3.name (via foldUtr5.name) knownGeneV39.foldUtr5.name (via foldUtr5.name) knownGeneV39.gnfAtlas2Distance.query (via foldUtr5.name) knownGeneV39.gnfAtlas2Distance.target (via foldUtr5.name) knownGeneV39.kgAlias.kgID (via foldUtr5.name) knownGeneV39.kgColor.kgID (via foldUtr5.name) knownGeneV39.kgProtAlias.kgID (via foldUtr5.name) knownGeneV39.kgSpAlias.kgID (via foldUtr5.name) knownGeneV39.kgTargetAli.qName (via foldUtr5.name) knownGeneV39.kgXref.kgID (via foldUtr5.name) knownGeneV39.knownAttrs.kgID (via foldUtr5.name) knownGeneV39.knownBlastTab.query (via foldUtr5.name) knownGeneV39.knownBlastTab.target (via foldUtr5.name) knownGeneV39.knownCanonical.protein (via foldUtr5.name) knownGeneV39.knownCanonical.transcript (via foldUtr5.name) knownGeneV39.knownCds.name (via foldUtr5.name) knownGeneV39.knownGene.name (via foldUtr5.name) knownGeneV39.knownGeneMrna.name (via foldUtr5.name) knownGeneV39.knownGenePep.name (via foldUtr5.name) knownGeneV39.knownIsoforms.transcript (via foldUtr5.name) knownGeneV39.knownToEnsembl.name (via foldUtr5.name) knownGeneV39.knownToGnfAtlas2.name (via foldUtr5.name) knownGeneV39.knownToHprd.name (via foldUtr5.name) knownGeneV39.knownToLocusLink.name (via foldUtr5.name) knownGeneV39.knownToMrna.name (via foldUtr5.name) knownGeneV39.knownToMrnaSingle.name (via foldUtr5.name) knownGeneV39.knownToMupit.name (via foldUtr5.name) knownGeneV39.knownToPfam.name (via foldUtr5.name) knownGeneV39.knownToRefSeq.name (via foldUtr5.name) knownGeneV39.knownToSuper.gene (via foldUtr5.name) knownGeneV39.knownToTag.name (via foldUtr5.name) knownGeneV39.knownToU133.name (via foldUtr5.name) knownGeneV39.knownToU95.name (via foldUtr5.name) knownGeneV39.knownToVisiGene.name (via foldUtr5.name) knownGeneV39.knownToWikipedia.name (via foldUtr5.name) knownGeneV39.mmBlastTab.query (via foldUtr5.name) knownGeneV39.rnBlastTab.query (via foldUtr5.name) knownGeneV39.scBlastTab.query (via foldUtr5.name) knownGeneV39.ucscScop.ucscId (via foldUtr5.name)

Sample Rows

name	seq	fold	energy
AB000409	GCGAUCUGCAGGUAGGGGUGCGCGCGACCGCUCCCCGGCGGGAGCCAGCGAAGGUUUCCAUGUCAGAGGCCAAUGGAGAACUGAAGAUUGCCACCUACGCACAAAGGCCAUUGAGACACUUCGUGUAG ...	(((((((.(((...((((.(((......))).))))(((....)))......((((((.......)))))).........))).)))))))..(((........)))(((.(((((...(((.(((.. ...	-53.5
AB000460	CACAAUGACAUGCAGACCUGCAUAUUGGAGCUGGACGGAGAAACUGGGCUAAUGUGACAGACAGCAACAAGAGUAAGGCAGUUGCUUCGCUAUUGAGAGAAAGAACCAUAUGAAGAAAUUUCGGCAGA ...	.................(((((((((((..(..(.........)..).)))))))).))).((((..(((.((..((((....))))..)).)))...........(((((.......(((((((... ...	-119.31
AB000461	CACAAUGACAUGCAGACCUGCAUAUUGGAGCUGGACGGAGAAACUGGGCUAAUGUGACAGACAGCAACAAGAGUAAGGCAGUUGCUUCGCUAUUGAGAGAAAGAACCAUAUGAAGAAAUUUCGGCAGA ...	.................(((((((((((..(..(.........)..).)))))))).))).((((..(((.((..((((....))))..)).)))...........(((((.......(((((((... ...	-119.31
AB000463	CAGCCGGGUGACCCAGGCCGAGGCCGGCAGAAGACAGCCUGAUGCCUUGAAGACUUCCUCUUGCACUUUUGUUGGAGGGUGCUGGUUUGCUAAAAGCAGAGAGUAUUUUUCUUUUUAUUUAUUUUGUU ...	.(((..((((.(((.((..(((((.(((........))).((.(((..((.((((((((((.(((....))).)))))).(((((...(((((((..(((((((........................ ...	-81.59
AB000781	AGAACGUGUCUCUGGCUGACAUCCUCUCCCUGCGGGACCGCGGCCUCAGCGAGCAGGAAGCCUGGGCCGUGUGCCUGGAGUGCAGCCUGUCC	.............(((((.((....((((....(((..(((((((.(((...((.....))))))))))))..)))))))))))))).....	-35
AB000815	CUGGAUCUGGGGUGUAAGAACUGUGACUUCAGAUCAUCCAAUGGCAGACCAGAGAAUGGACAUUUCUUCAACCAUCAGUGAUUUCAUGUCCCCGGGCCCCACCGACCUGCUUUCCAGCUCUCUUGGUA ...	...((((((((((............)))))))))).(((...((((...........((((((....(((........)))....))))))...((((((((((...((((..((((.((.((((... ...	-75.8
AB001025	GCAGCAGCAGUCAGCGCACGCCGAGCGGCUGCCGGGGGAAGCAGAGGCGCCGGAGGCUGGGGCACCGCCGACGCCUCGGGAGCC	(((((.((..((.((....)).)))).))))).............(((.((.(((((...(((...)))...))))).)).)))	-35.2
AB001328	CAGUCACCGGUAAGUUACUGAAUCUGCGUUGGCUGCCUUUCAUGCCACUGGUGCUCCUUUGUGGCUAUGGACCAGUGGGGGGUGUAUUUCAAUCCUGUGCUUGUUUCUUUUUUGUCAGAGUUUCUUUG ...	......(((...(((....((((((.(((((((..(..((((((((((.((....))...))))).)))))...((((((((((....((((......((((....(......)...))))....))) ...	-48.1
AB001535	UGUGCAGAAUUGUACAGUUGCGAAACCAUGUCGCUGGCAGCUGGUGCUGGCGGUGGAGACUUCCCUGUGCGGUGCUCAGUGCAGCUGCACCCGUGGGGGAGGGAGCUCUUUCUCUGGCCCUGCAGUCA ...	(((((......)))))...............((((((((((....))))...((((.((((((((((((((((((((....(((((((......(..((((....))))..)..(((((((.(.(((( ...	-456.9
AB002292	GGGGUCGCGGGGGACGCGGGGGACGCGGGGGACGGCGGGGAACGGCGGGGGACGGCGGGGAACAGCGGGGGACGGCGGGGAACAGCGGGGGACGGCGGGGAACAGCAGGGGACUGCGGGUCGCGUCCU ...	.((((((((((((((.((((((((((.(....).)))(((...(((.((((..((((((...(((((((((..((((((...((((((((.((((.(((.....((((....)))).((((.(.(((( ...	-325.7

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