Schema for foldUtr3
  Database: hg18    Primary Table: foldUtr3    Row Count: 48,446   Data last updated: 2009-03-05
Format description: Info about folding of RNA into secondary structure
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name uc001aav.2varchar(255) values mRNA accession
seq CUCUCGCCUCACUGCGGCCUCCCCAGU...longblob   mRNA sequence (U's instead of T's)
fold .....((((..(((.(((((..........longblob   Parenthesis and .'s that describe folding
energy -67.7float range Estimated free energy of folding (negative)

Connected Tables and Joining Fields
        hg18.bioCycPathway.kgID (via foldUtr3.name)
      hg18.ccdsKgMap.geneId (via foldUtr3.name)
      hg18.ceBlastTab.query (via foldUtr3.name)
      hg18.dmBlastTab.query (via foldUtr3.name)
      hg18.drBlastTab.query (via foldUtr3.name)
      hg18.foldUtr5.name (via foldUtr3.name)
      hg18.gnfAtlas2Distance.query (via foldUtr3.name)
      hg18.gnfAtlas2Distance.target (via foldUtr3.name)
      hg18.gnfU95Distance.query (via foldUtr3.name)
      hg18.gnfU95Distance.target (via foldUtr3.name)
      hg18.humanHprdP2P.query (via foldUtr3.name)
      hg18.humanHprdP2P.target (via foldUtr3.name)
      hg18.humanVidalP2P.query (via foldUtr3.name)
      hg18.humanVidalP2P.target (via foldUtr3.name)
      hg18.humanWankerP2P.query (via foldUtr3.name)
      hg18.humanWankerP2P.target (via foldUtr3.name)
      hg18.keggPathway.kgID (via foldUtr3.name)
      hg18.kgAlias.kgID (via foldUtr3.name)
      hg18.kgColor.kgID (via foldUtr3.name)
      hg18.kgProtAlias.kgID (via foldUtr3.name)
      hg18.kgProtMap2.qName (via foldUtr3.name)
      hg18.kgSpAlias.kgID (via foldUtr3.name)
      hg18.kgTargetAli.qName (via foldUtr3.name)
      hg18.kgTxInfo.name (via foldUtr3.name)
      hg18.kgXref.kgID (via foldUtr3.name)
      hg18.knownBlastTab.query (via foldUtr3.name)
      hg18.knownBlastTab.target (via foldUtr3.name)
      hg18.knownCanonToDecipher.name (via foldUtr3.name)
      hg18.knownCanonical.protein (via foldUtr3.name)
      hg18.knownCanonical.transcript (via foldUtr3.name)
      hg18.knownGene.name (via foldUtr3.name)
      hg18.knownGeneMrna.name (via foldUtr3.name)
      hg18.knownGenePep.name (via foldUtr3.name)
      hg18.knownIsoforms.transcript (via foldUtr3.name)
      hg18.knownToAllenBrain.name (via foldUtr3.name)
      hg18.knownToDecipher.name (via foldUtr3.name)
      hg18.knownToEnsembl.name (via foldUtr3.name)
      hg18.knownToGnf1h.name (via foldUtr3.name)
      hg18.knownToGnfAtlas2.name (via foldUtr3.name)
      hg18.knownToHInv.name (via foldUtr3.name)
      hg18.knownToHprd.name (via foldUtr3.name)
      hg18.knownToKeggEntrez.name (via foldUtr3.name)
      hg18.knownToLocusLink.name (via foldUtr3.name)
      hg18.knownToMupit.name (via foldUtr3.name)
      hg18.knownToPfam.name (via foldUtr3.name)
      hg18.knownToRefSeq.name (via foldUtr3.name)
      hg18.knownToSuper.gene (via foldUtr3.name)
      hg18.knownToTreefam.name (via foldUtr3.name)
      hg18.knownToU133.name (via foldUtr3.name)
      hg18.knownToU133Plus2.name (via foldUtr3.name)
      hg18.knownToU95.name (via foldUtr3.name)
      hg18.knownToVisiGene.name (via foldUtr3.name)
      hg18.mmBlastTab.query (via foldUtr3.name)
      hg18.rnBlastTab.query (via foldUtr3.name)
      hg18.scBlastTab.query (via foldUtr3.name)
      hg18.ucscScop.ucscId (via foldUtr3.name)
      knownGeneV39.bioCycPathway.kgID (via foldUtr3.name)
      knownGeneV39.ceBlastTab.query (via foldUtr3.name)
      knownGeneV39.dmBlastTab.query (via foldUtr3.name)
      knownGeneV39.drBlastTab.query (via foldUtr3.name)
      knownGeneV39.foldUtr3.name (via foldUtr3.name)
      knownGeneV39.foldUtr5.name (via foldUtr3.name)
      knownGeneV39.gnfAtlas2Distance.query (via foldUtr3.name)
      knownGeneV39.gnfAtlas2Distance.target (via foldUtr3.name)
      knownGeneV39.kgAlias.kgID (via foldUtr3.name)
      knownGeneV39.kgColor.kgID (via foldUtr3.name)
      knownGeneV39.kgProtAlias.kgID (via foldUtr3.name)
      knownGeneV39.kgSpAlias.kgID (via foldUtr3.name)
      knownGeneV39.kgTargetAli.qName (via foldUtr3.name)
      knownGeneV39.kgXref.kgID (via foldUtr3.name)
      knownGeneV39.knownAttrs.kgID (via foldUtr3.name)
      knownGeneV39.knownBlastTab.query (via foldUtr3.name)
      knownGeneV39.knownBlastTab.target (via foldUtr3.name)
      knownGeneV39.knownCanonical.protein (via foldUtr3.name)
      knownGeneV39.knownCanonical.transcript (via foldUtr3.name)
      knownGeneV39.knownCds.name (via foldUtr3.name)
      knownGeneV39.knownGene.name (via foldUtr3.name)
      knownGeneV39.knownGeneMrna.name (via foldUtr3.name)
      knownGeneV39.knownGenePep.name (via foldUtr3.name)
      knownGeneV39.knownIsoforms.transcript (via foldUtr3.name)
      knownGeneV39.knownToEnsembl.name (via foldUtr3.name)
      knownGeneV39.knownToGnfAtlas2.name (via foldUtr3.name)
      knownGeneV39.knownToHprd.name (via foldUtr3.name)
      knownGeneV39.knownToLocusLink.name (via foldUtr3.name)
      knownGeneV39.knownToMrna.name (via foldUtr3.name)
      knownGeneV39.knownToMrnaSingle.name (via foldUtr3.name)
      knownGeneV39.knownToMupit.name (via foldUtr3.name)
      knownGeneV39.knownToPfam.name (via foldUtr3.name)
      knownGeneV39.knownToRefSeq.name (via foldUtr3.name)
      knownGeneV39.knownToSuper.gene (via foldUtr3.name)
      knownGeneV39.knownToTag.name (via foldUtr3.name)
      knownGeneV39.knownToU133.name (via foldUtr3.name)
      knownGeneV39.knownToU95.name (via foldUtr3.name)
      knownGeneV39.knownToVisiGene.name (via foldUtr3.name)
      knownGeneV39.knownToWikipedia.name (via foldUtr3.name)
      knownGeneV39.mmBlastTab.query (via foldUtr3.name)
      knownGeneV39.rnBlastTab.query (via foldUtr3.name)
      knownGeneV39.scBlastTab.query (via foldUtr3.name)
      knownGeneV39.ucscScop.ucscId (via foldUtr3.name)

Sample Rows
 
nameseqfoldenergy
uc001aav.2CUCUCGCCUCACUGCGGCCUCCCCAGUCCAAAGCUCCUGCCUUUCGGCCACUUCGGCAGGUCCAGCUCCUGCCUGCCAGUGGCCUCUUUAGGCCCAGCUCAUUCCUCACGUCGGCCAUUCCAGGCCCC ........((((..(((.(((((............((....)).....(((((((..(((((((.........)))))))))))))).....))))))))...............(((((....((((.(( ...-67.7
uc001abe.2CUGUGAGUCCAUUUCCAGGCCUAGUGCCUGCCUCGUGGCUGACUCUUGAAGCCCAAAACUUCCUCAAAUCAGGCUUUUGCCCAACUUCUGUCUACUGUCGGACUCUACAGGUCAGCCUCUGCCUCACA ...(((((((........(((((.....)))))....(.(((((....((((((..(((((............((((...............(((((((((.((.(.....(((....)))..)))..))) ...-298.15
uc001abw.1GGUUGCCGGGGGUAGGGGUGGGGCCACACAAAUCUCCAGGAGCCACCACUCAACACAAUGGCCCUGCCUCCCACCGCUUUAUUUCUUUCGGUUUCGGAUGCAAAACAAAAAAUUUUAAAAGAAAAUGU ...((((..(((((((.(((.((((............((((((.(((.(((((..........((((((((..((....(((((((((((..(((((....((.....)).............(((((((( ...-172
uc001abx.1GGUUGCCGGGGGUAGGGGUGGGGCCACACAAAUCUCCAGGAGCCACCACUCAACACAAUGGCCCUGCCUCCCACCGCUUUAUUUCUUUCGGUUUCGGAUGCAAAACAAAAAAUUUUAAAAGAAAAUGU ...((((..(((((((.(((.((((............((((((.(((.(((((..........((((((((..((....(((((((((((..(((((....((.....)).............(((((((( ...-172
uc001aby.2GGCAGCCCAUCUGGGGGGCCUGUAGGGGCUGCCGGGCUGGUGGCCAGUGUUUCCACCUCCCUGGCAGUCAGGCCUAGAGGCUGGCGUCUGUGCAGUUGGGGGAGGCAGUAGACACGGGACAGGCUUUA ....(((((((...((((((((((.((((((((((((((..(((((.........)))))..))))))))))...)))).)))).(((((((((((((.((((.(((((.((((((...(((..(((.... ...-216.3
uc001abz.2GGCAGCCCAUCUGGGGGGCCUGUAGGGGCUGCCGGGCUGGUGGCCAGUGUUUCCACCUCCCUGGCAGUCAGGCCUAGAGGCUGGCGUCUGUGCAGUUGGGGGAGGCAGUAGACACGGGACAGGCUUUA ....(((((((...((((((((((.((((((((((((((..(((((.........)))))..))))))))))...)))).)))).(((((((((((((.((((.(((((.((((((...(((..(((.... ...-216.3
uc001aca.1CCCACCUACCACCAGAGGCCUGCAGCCUCCCACAUGCCUUAAGGGGACCGUGGCCCCCACCAGGGACGUCCUGCGCCAUCCGUUCACGUCUCUGCAUCCAUUCCUUCAUGUCUUUAUUUAGUUGUUUA ................(((((((((..(((((((((..((((...(((.(((((((((.((..(((((((((...(((.....)))..)))))))))....((((((((.(((.........(((...((( ...-213.97
uc001acb.1CCCUCCCUCCUAGGCAUCUUCAGGGCUCCCUGGGUCCACAGGACCCUCCCCAGAUCUCAGGUCUGAGGACCCCCACUCCCAGGUUCUGGAACUGGUCUCUAGCGACAGCCUGAACGUGCCUUCAGAGG ....(((((.((((((((((.((((((.((....((((((...))))))...((((.(((..(..(((.(((.......))))))..)..))).))))...........)))))))).))))))....))) ...-80.3
uc001acd.1UGGCCGCGGUGAGGUGGGUUCUCAGGACCACCCUCGCCAAGCUCCAGGGUACCUGCCCCUCUAACCCACUUCAAAUUACAAGUCAGGGUCUGAACCCAGUGUGAUGGGGGGAGUCUCUGGGGCCCUGA ......(((.(((((((..((((.....))))..)))))))...((((.((((((((..(((((...(((((((((...(((....(((((.((...((((......))))...)).))))).(((((((. ...-240.1
uc001ace.1UGGCCGCGGUGAGGUGGGUUCUCAGGACCACCCUCGCCAAGCUCCAGGGUACCUGCCCCUCUAACCCACUUCAAAUUACAAGUCAGGGUCUGAACCCAGUGUGAUGGGGGGAGUCUCUGGGGCCCUGA ......(((.(((((((..((((.....))))..)))))))...((((.((((((((..(((((...(((((((((...(((....(((((.((...((((......))))...)).))))).(((((((. ...-240.1

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