viewing KEGG results

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

viewing KEGG results

Sofia Robb
Hi,

I figured out how to get each brite keg files, I tared them up and I was able to load them into the db. I had to alter a few of the regular expressions in the loading code because these files do not contain html like the original ones must have.

Now, I can see my KEGG results in my db but not on my feature pages. Is there something I need to enable? Do I need to sync features?

SELECT for kegg info for feature_id = 1858815

drupal=# select cv_id, name, definition, analysisfeatureprop_id, afp.analysisfeature_id, type_id, value  from cv c, analysisfeatureprop afp, analysisfeature af  where afp.analysisfeature_id = af.analysisfeature_id and feature_id = 1858815 and name LIKE 'KEGG%' and type_id = 64339;
 cv_id |      name      |                  definition                   | analysisfeatureprop_id | analysisfeature_id | type_id |                        value
-------+----------------+-----------------------------------------------+------------------------+--------------------+---------+------------------------------------------------------
    25 | KEGG_PATHWAY   | Holds terms from the KEGG PATHWAY database.   |                 707942 |            4441591 |   64339 | NR1D3; nuclear receptor subfamily 1 group D member 3
    26 | KEGG_BRITE     | Holds terms from the KEGG BRITE database.     |                 707942 |            4441591 |   64339 | NR1D3; nuclear receptor subfamily 1 group D member 3
    27 | KEGG_ORTHOLOGY | Holds terms from the KEGG ORTHOLOGY database. |                 707942 |            4441591 |   64339 | NR1D3; nuclear receptor subfamily 1 group D member 3
    28 | KEGG_MODULE    | Holds terms from the KEGG MODULE database.    |                 707942 |            4441591 |   64339 | NR1D3; nuclear receptor subfamily 1 group D member 3

feature page for 1858815

Inline image 1

------------------------------------------------------------------------------
Site24x7 APM Insight: Get Deep Visibility into Application Performance
APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
Monitor end-to-end web transactions and take corrective actions now
Troubleshoot faster and improve end-user experience. Signup Now!
http://pubads.g.doubleclick.net/gampad/clk?id=272487151&iu=/4140
_______________________________________________
Gmod-tripal mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/gmod-tripal