Schema for foldUtr3
Database: hg19    Primary Table: foldUtr3    Row Count: 58,055
Format description: Info about folding of RNA into secondary structure
fieldexampleSQL type info description
name uc001aau.2varchar(255) values mRNA accession
seq CUGUGAGGCCAUUUCCAGGCCUAGUGC...longblob   mRNA sequence (U's instead of T's)
fold ....(((((((((..(((((.....((...longblob   Parenthesis and .'s that describe folding
energy -1507.29float range Estimated free energy of folding (negative)
Connected Tables and Joining Fields
      hg19.bioCycPathway.kgID (via foldUtr3.name)
      hg19.ccdsKgMap.geneId (via foldUtr3.name)
      hg19.ceBlastTab.query (via foldUtr3.name)
      hg19.dmBlastTab.query (via foldUtr3.name)
      hg19.drBlastTab.query (via foldUtr3.name)
      hg19.foldUtr5.name (via foldUtr3.name)
      hg19.gnfAtlas2Distance.query (via foldUtr3.name)
      hg19.gnfAtlas2Distance.target (via foldUtr3.name)
      hg19.humanHprdP2P.query (via foldUtr3.name)
      hg19.humanHprdP2P.target (via foldUtr3.name)
      hg19.humanVidalP2P.query (via foldUtr3.name)
      hg19.humanVidalP2P.target (via foldUtr3.name)
      hg19.humanWankerP2P.query (via foldUtr3.name)
      hg19.humanWankerP2P.target (via foldUtr3.name)
      hg19.keggPathway.kgID (via foldUtr3.name)
      hg19.kg4ToKg5.newId (via foldUtr3.name)
      hg19.kgAlias.kgID (via foldUtr3.name)
      hg19.kgColor.kgID (via foldUtr3.name)
      hg19.kgProtAlias.kgID (via foldUtr3.name)
      hg19.kgProtMap2.qName (via foldUtr3.name)
      hg19.kgSpAlias.kgID (via foldUtr3.name)
      hg19.kgTargetAli.qName (via foldUtr3.name)
      hg19.kgTxInfo.name (via foldUtr3.name)
      hg19.kgXref.kgID (via foldUtr3.name)
      hg19.knownBlastTab.query (via foldUtr3.name)
      hg19.knownBlastTab.target (via foldUtr3.name)
      hg19.knownCanonical.protein (via foldUtr3.name)
      hg19.knownCanonical.transcript (via foldUtr3.name)
      hg19.knownGene.name (via foldUtr3.name)
      hg19.knownGeneMrna.name (via foldUtr3.name)
      hg19.knownGenePep.name (via foldUtr3.name)
      hg19.knownIsoforms.transcript (via foldUtr3.name)
      hg19.knownToAllenBrain.name (via foldUtr3.name)
      hg19.knownToEnsembl.name (via foldUtr3.name)
      hg19.knownToGnfAtlas2.name (via foldUtr3.name)
      hg19.knownToHprd.name (via foldUtr3.name)
      hg19.knownToLocusLink.name (via foldUtr3.name)
      hg19.knownToPfam.name (via foldUtr3.name)
      hg19.knownToRefSeq.name (via foldUtr3.name)
      hg19.knownToSuper.gene (via foldUtr3.name)
      hg19.knownToTreefam.name (via foldUtr3.name)
      hg19.knownToU133.name (via foldUtr3.name)
      hg19.knownToVisiGene.name (via foldUtr3.name)
      hg19.mmBlastTab.query (via foldUtr3.name)
      hg19.rnBlastTab.query (via foldUtr3.name)
      hg19.scBlastTab.query (via foldUtr3.name)
Sample Rows
nameseqfoldenergy
uc001aau.2CUGUGAGGCCAUUUCCAGGCCUAGUGCCUGCCUCGUGGCUGACUCUUGAAGCCCAAAACUUCCUCAAAUCAGGCUUUUGCCCAACUUCUGUCUACUGUCGGACUCUACAGGUCAGCCUCUGCCUCACA .......(((((((((..(((((.....(((((....(.(((((((((..(.(((((.(((((........(((((.....((((.....(((....((((((((.....((((..(((.((.(((((((( ...-1507.29
uc001abe.3UCCCAACUGCUGCCUCCUGGUGGCCUAUGAAGGCCCAAAAUCUCCUCAAGUUGACCUGUCCAGGCCCAGCUCCUGCCUCCUGUCAGCGUCUACAGGCCCAACCUCUGCCUCAUGGGGGCUUCUCCAGG ...........((((((....((.(((((..(((((((..............((.((((((..((((....((....))..)))).))).))).)).((((........(((...(((((((......((( ...-1624.47
uc001abw.1GGUUGCCGGGGGUAGGGGUGGGGCCACACAAAUCUCCAGGAGCCACCACUCAACACAAUGGCCCUGCCUCCCACCGCUUUAUUUCUUUCGGUUUCGGAUGCAAAACAAAAAAUUUUAAAAGAAAAUGU ...((((..(((((((.(((.((((............((((((.(((.(((((..........((((((((..((....(((((((((((..(((((....((.....)).............(((((((( ...-172
uc001abx.1GGUUGCCGGGGGUAGGGGUGGGGCCACACAAAUCUCCAGGAGCCACCACUCAACACAAUGGCCCUGCCUCCCACCGCUUUAUUUCUUUCGGUUUCGGAUGCAAAACAAAAAAUUUUAAAAGAAAAUGU ...((((..(((((((.(((.((((............((((((.(((.(((((..........((((((((..((....(((((((((((..(((((....((.....)).............(((((((( ...-172
uc001aby.3GGCAGCCCAUCUGGGGGGCCUGUAGGGGCUGCCGGGCUGGUGGCCAGUGUUUCCACCUCCCUGGCAGUCAGGCCUAGAGGCUGGCGUCUGUGCAGUUGGGGGAGGCAGUAGACACGGGACAGGCUUUA ....(((((((...((((((((((.((((((((((((((..(((((.........)))))..))))))))))...)))).)))).(((((((((((((.((((.(((((.((((((...(((..(((.... ...-216.3
uc001abz.3GGCAGCCCAUCUGGGGGGCCUGUAGGGGCUGCCGGGCUGGUGGCCAGUGUUUCCACCUCCCUGGCAGUCAGGCCUAGAGGCUGGCGUCUGUGCAGUUGGGGGAGGCAGUAGACACGGGACAGGCUUUA ....(((((((...((((((((((.((((((((((((((..(((((.........)))))..))))))))))...)))).)))).(((((((((((((.((((.(((((.((((((...(((..(((.... ...-216.3
uc001aca.1CCCACCUACCACCAGAGGCCUGCAGCCUCCCACAUGCCUUAAGGGGACCGUGGCCCCCACCAGGGACGUCCUGCGCCAUCCGUUCACGUCUCUGCAUCCAUUCCUUCAUGUCUUUAUUUAGUUGUUUA ................(((((((((..(((((((((..((((...(((.(((((((((.((..(((((((((...(((.....)))..)))))))))....((((((((.(((.........(((...((( ...-213.97
uc001acb.1CCCUCCCUCCUAGGCAUCUUCAGGGCUCCCUGGGUCCACAGGACCCUCCCCAGAUCUCAGGUCUGAGGACCCCCACUCCCAGGUUCUGGAACUGGUCUCUAGCGACAGCCUGAACGUGCCUUCAGAGG ....(((((.((((((((((.((((((.((....((((((...))))))...((((.(((..(..(((.(((.......))))))..)..))).))))...........)))))))).))))))....))) ...-80.3
uc001acd.2UGGCCGCGGUGAGGUGGGUUCUCAGGACCACCCUCGCCAAGCUCCAGGGUACCUGCCCCUCUAACCCACUUCAAAUUACAAGUCAGGGUCUGAACCCAGUGUGAUGGGGGGAGUCUCUGGGGCCCUGA ......(((.(((((((..((((.....))))..)))))))...((((.((((((((..(((((...(((((((((...(((....(((((.((...((((......))))...)).))))).(((((((. ...-240.1
uc001ace.2UGGCCGCGGUGAGGUGGGUUCUCAGGACCACCCUCGCCAAGCUCCAGGGUACCUGCCCCUCUAACCCACUUCAAAUUACAAGUCAGGGUCUGAACCCAGUGUGAUGGGGGGAGUCUCUGGGGCCCUGA ......(((.(((((((..((((.....))))..)))))))...((((.((((((((..(((((...(((((((((...(((....(((((.((...((((......))))...)).))))).(((((((. ...-240.1

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