Schema for foldUtr5
  Database: hg19    Primary Table: foldUtr5    Row Count: 92,213   Data last updated: 2024-08-23
Format description: Info about folding of RNA into secondary structure
On download server: MariaDB table dump directory
fieldexampleSQL type info description
name ENST00000000233.10_4varchar(255) values mRNA accession
seq cugcugcugcugcgccccauccccccg...longblob   mRNA sequence (U's instead of T's)
fold ..((((..((((.(((....((........longblob   Parenthesis and .'s that describe folding
energy -30.6float range Estimated free energy of folding (negative)

Connected Tables and Joining Fields
        hg19.bioCycPathway.kgID (via foldUtr5.name)
      hg19.ceBlastTab.query (via foldUtr5.name)
      hg19.dmBlastTab.query (via foldUtr5.name)
      hg19.drBlastTab.query (via foldUtr5.name)
      hg19.foldUtr3.name (via foldUtr5.name)
      hg19.gnfAtlas2Distance.query (via foldUtr5.name)
      hg19.gnfAtlas2Distance.target (via foldUtr5.name)
      hg19.gnfU95Distance.query (via foldUtr5.name)
      hg19.gnfU95Distance.target (via foldUtr5.name)
      hg19.humanHprdP2P.query (via foldUtr5.name)
      hg19.humanHprdP2P.target (via foldUtr5.name)
      hg19.humanVidalP2P.query (via foldUtr5.name)
      hg19.humanVidalP2P.target (via foldUtr5.name)
      hg19.humanWankerP2P.query (via foldUtr5.name)
      hg19.humanWankerP2P.target (via foldUtr5.name)
      hg19.keggPathway.kgID (via foldUtr5.name)
      hg19.kgAlias.kgID (via foldUtr5.name)
      hg19.kgColor.kgID (via foldUtr5.name)
      hg19.kgProtAlias.kgID (via foldUtr5.name)
      hg19.kgProtMap2.qName (via foldUtr5.name)
      hg19.kgSpAlias.kgID (via foldUtr5.name)
      hg19.kgTargetAli.qName (via foldUtr5.name)
      hg19.kgTxInfo.name (via foldUtr5.name)
      hg19.kgXref.kgID (via foldUtr5.name)
      hg19.knownAttrs.kgID (via foldUtr5.name)
      hg19.knownBlastTab.query (via foldUtr5.name)
      hg19.knownBlastTab.target (via foldUtr5.name)
      hg19.knownCanonToDecipher.name (via foldUtr5.name)
      hg19.knownCanonical.transcript (via foldUtr5.name)
      hg19.knownCds.name (via foldUtr5.name)
      hg19.knownGene.name (via foldUtr5.name)
      hg19.knownGeneMrna.name (via foldUtr5.name)
      hg19.knownGenePep.name (via foldUtr5.name)
      hg19.knownGeneTxMrna.name (via foldUtr5.name)
      hg19.knownGeneTxPep.name (via foldUtr5.name)
      hg19.knownIsoforms.transcript (via foldUtr5.name)
      hg19.knownToAllenBrain.name (via foldUtr5.name)
      hg19.knownToDecipher.name (via foldUtr5.name)
      hg19.knownToEnsembl.name (via foldUtr5.name)
      hg19.knownToGnfAtlas2.name (via foldUtr5.name)
      hg19.knownToHInv.name (via foldUtr5.name)
      hg19.knownToHprd.name (via foldUtr5.name)
      hg19.knownToKeggEntrez.name (via foldUtr5.name)
      hg19.knownToLocusLink.name (via foldUtr5.name)
      hg19.knownToLynx.name (via foldUtr5.name)
      hg19.knownToMrna.name (via foldUtr5.name)
      hg19.knownToMrnaSingle.name (via foldUtr5.name)
      hg19.knownToMupit.name (via foldUtr5.name)
      hg19.knownToNextProt.name (via foldUtr5.name)
      hg19.knownToPfam.name (via foldUtr5.name)
      hg19.knownToRefSeq.name (via foldUtr5.name)
      hg19.knownToSuper.gene (via foldUtr5.name)
      hg19.knownToTag.name (via foldUtr5.name)
      hg19.knownToTreefam.name (via foldUtr5.name)
      hg19.knownToU133.name (via foldUtr5.name)
      hg19.knownToU133Plus2.name (via foldUtr5.name)
      hg19.knownToU95.name (via foldUtr5.name)
      hg19.knownToVisiGene.name (via foldUtr5.name)
      hg19.knownToWikipedia.name (via foldUtr5.name)
      hg19.mmBlastTab.query (via foldUtr5.name)
      hg19.rnBlastTab.query (via foldUtr5.name)
      hg19.scBlastTab.query (via foldUtr5.name)
      hg19.ucscScop.ucscId (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
 
nameseqfoldenergy
ENST00000000233.10_4cugcugcugcugcgccccauccccccgcggccggccaguuccagcccgcaccccgcgucggugcccgcgccccuccccgggccccgcc..((((..((((.(((....((......))..)))))))..)))).(((.....))).(((.(((((.(......).))))).)))..-30.6
ENST00000000412.3ccgggagcggucaggcgcgugaccccgcgugaccggggugcgcgagccgagaggcccuggaagcgggacucugggaccccauugaaagaaaggcaaccagaaaaggcgaaacgacaaccucgauagug ...(((((.((.....(((.((((((((((......)))))).)))).))).....)))))))..(.((((.(((((((((((.(((.......(((..((((.....((....(((.....)))...)). ...-201
ENST00000000442.11_8gucagcuggaggaagcggaguaggaagcggccgcgauguccuuuuguguccuacaagcagccggcggcgccgccgagugaggggacgcggcgcgguggggcggcgcggcccgaggaggcggcggagga ...((((.((((.((...(((....(((((.(((......))))))))(((((((.....((..(((((....)))))..))..)))))))((((((((.((((((((((((((..((((..(.((((((( ...-125.5
ENST00000001008.6_4ccuaccccagcucucgcgccgcgugcagaggugcucaagccuccucgcgguccgcagucagugccgccgcgcccggccucccgcacgccccgcagguagcgcccccgcccgcggcccagagugcgcuc .............(((.(((((.((((((.(((((......)))))..(((((..((((.((.(.(((((.(((...(((((((.((.......)).)).)).)))..)))..))))).).)).)))).)) ...-74.2
ENST00000001146.7_7acagccaaucccccgagcggccgccaac...(((..((....))..))).......-4.5
ENST00000002125.9_4gucuaagccccagcuccuggcggagcgagcuagccugcgaauuucagc.....(((....(((((....)))))..))).....((........))-11
ENST00000002165.11_7gcggcauacucagcggcagagacggaagaacagcgcucccgaggccgcgggagccugcagagaggacagccggccugcgccgggac((.((.......)).)).............(((.(((((((......))))))))))............(((((....)))))...-32.3
ENST00000002501.11_6gcugccccgaugcgcugcgcccggagccggggccgagucgcugccgcagcuguuggggcgcccgggccaggcgacgccgccgucgcccgugccccucccagaccgcaccggccgc(((((((((..((.(((....))).))))))))..))).((.((((..((.((((((((((..((((..((((....))))...))))))))))).....))).))..)))).))-56.9
ENST00000002596.6_7cucugcgcccuggcagccaggagucgccgccacgacagccgggucucagugggugccugcgccuucuccccgcccgccugccccgggccauccagaaacuugcucuacccgccgcgggugcucggcag .......(((((((((...))))).).)))(((((((.....(((((((((((..(.(((.(((((((...((.(((((((.((((((((((((.(((..(((.(((.((((((...))))))...))))) ...-129.6
ENST00000002829.8_6gagcgccccugagccuucccauggcccgggcuggggcccgggcccucggcugcugacgcgcccgaagcccgcggaaccgguuaagccgcggccgcggcgccgaucccggcugaggcgcagcggcgaga ......((((.(((.(((((.....(((((((((....))))))))).((((.(((....))).)))).(((.((((...((((...))))...)))))))((((....)))).))))).))).)))).(( ...-173.4

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