April 2013 - Microbe - mailman3.cels.anl.gov

Re: [Microbe] [Kbase-devel] How do we enable KBase to support publication of genome and phenotype data
by Folker Meyer 17 Apr '13

17 Apr '13

Hi Chris, we have had a solution for this in MG-RAST for a couple of years now, actually there are two parts to the solutions: - publishing/sharing of data (with required metadata) AND - projects combining data sets together The publishing mechanism we currently have probably needs to be extended to cover reviewer access (so that owners can generate an anonymous reviewer token for their manuscripts), we have not had sufficient engineering time. Most data in MG-RAST (>95%, over 60,000 data sets) is actually organized in projects now. The feature (as well as the pre-publication sharing) is quite popular with users, we have actually had requests from sociologists and network analysis people for the interaction graphs, with many thousand users sharing many thousand data sets. The emerging properties are quite interesting ==> science is very clique-ish. here are some technical details that we have learned: - The project notion is important as it generates one identifier for multiple data objects - Authorization needs to be inherited from the project (otherwise there will be users missing rights to some data sets for pre-pub sharing) - projects probably need to support multiple data types (the current MG-RAST implementation is a bit metagenome centric) - everything we share or publish requires permanent IDs and indeed permanent "objects", we cannot use any temporary structures - data provenance and metadata is very important (provenance= how was it computed, metadata= where is it from, where was it sampled) - we have used a specific permanent link (data set: http://permanent.url/linkin.cgi?id=XYZ or project: http://permanent.url/linkin.cgi?project=123) - we allow users to share with arbitrary email addresses, requiring recipients to create accounts ... - versioning, will we maintain the original published analysis for data or will we update the data once the pipeline(s) change? SHOCK can allow us to maintain the original analysis results, however what happens if the API / UI changes dramatically? One option might be an archive of the web pages in addition to the data. The pipeline(s) we can archive via archiving the VMs (to some extent). We currently have an encoding for metadata for genomes and metagenomes and some CV standards. The CVs (controlled vocabularies) are fortunately maintained by external parties. For provenance, this will be somewhat harder: how was it computed? how can I recompute the same information.) Best, Folker On Apr 17, 2013, at 7:04 AM, Christopher Henry <chrisshenry(a)gmail.com> wrote: > Hi all, > > I started this thread with some KBase leads, and Adam raised some good points, but I'd like to bring this discussion project wide to the devel list. > > I want to publish a manuscript where we sequenced 124 environmental isolates, resulting in a total of 166 new genomes. > > We sequenced the genomes, assembled them in KBase, annotated them, modeled them. We have 124 biolog arrays for all sample. I want KBase to be my supplementary material. I want to send people to KBase to get all this data and analysis, rather than pointlessly dumping them into NCBI where they won't be connected to any of the analysis we did (plus I don't really want to jump through the hoops that NCBI would probably make me jump through). > > So how do we support this? > > To get things started, here's a few things I think we need: > > 1.) Persistent KBase-wide IDs for the genomes and phenotype sets that will never change > I'm suggesting "kb|g.###" for genomes, and "kb|g.###.phenos.###" for phenotype sets. Comments? > > 2.) A place people can go to look at the data, download data, access data > Initially I'm suggesting I put the genomes and all derived data in one or more workspaces, and put links to the workspace in the workspace browser in the publication, then we make sure the workspace offers good mechanisms for viewing and searching all these phenotypes. Comments? > > 3.) We need to decide on what metadata we want to support for the release of genomes, models, and Biolog array data in KBase > I don't have a strong proposal here. I'm hoping some of the metadata experts speak up. > > 4.) What are the things about KBase that we find to be the most embarrassing… that we would absolutely want to correct before any manuscript like the one I'm proposing gets published and starts driving people enmasse to KBase. > I'm thinking documentation at the moment… and I'm the number one offender here. We have shining spots in the documentation, but we've got some real sore spots too. > > This is something I think we want to address in short order. If we shift to campaigns, I think we should have a campaign specifically to address these issues. Because if a user of KBase cannot easily publish the work they do in KBase right now, then we're going to have trouble attracting users. The best possible advertisement is a good manuscript that people read and get excited about all the powerful things they can do in KBase. Then they click on our supplementary material and come to KBase and see the tools in action. > > Chris > _______________________________________________ > Kbase-devel mailing list > Kbase-devel(a)lists.kbase.us > https://lists.kbase.us/mailman/listinfo/kbase-devel

1 0

How do we enable KBase to support publication of genome and phenotype data
by Christopher Henry 17 Apr '13

17 Apr '13

Hi all, I started this thread with some KBase leads, and Adam raised some good points, but I'd like to bring this discussion project wide to the devel list. I want to publish a manuscript where we sequenced 124 environmental isolates, resulting in a total of 166 new genomes. We sequenced the genomes, assembled them in KBase, annotated them, modeled them. We have 124 biolog arrays for all sample. I want KBase to be my supplementary material. I want to send people to KBase to get all this data and analysis, rather than pointlessly dumping them into NCBI where they won't be connected to any of the analysis we did (plus I don't really want to jump through the hoops that NCBI would probably make me jump through). So how do we support this? To get things started, here's a few things I think we need: 1.) Persistent KBase-wide IDs for the genomes and phenotype sets that will never change I'm suggesting "kb|g.###" for genomes, and "kb|g.###.phenos.###" for phenotype sets. Comments? 2.) A place people can go to look at the data, download data, access data Initially I'm suggesting I put the genomes and all derived data in one or more workspaces, and put links to the workspace in the workspace browser in the publication, then we make sure the workspace offers good mechanisms for viewing and searching all these phenotypes. Comments? 3.) We need to decide on what metadata we want to support for the release of genomes, models, and Biolog array data in KBase I don't have a strong proposal here. I'm hoping some of the metadata experts speak up. 4.) What are the things about KBase that we find to be the most embarrassing… that we would absolutely want to correct before any manuscript like the one I'm proposing gets published and starts driving people enmasse to KBase. I'm thinking documentation at the moment… and I'm the number one offender here. We have shining spots in the documentation, but we've got some real sore spots too. This is something I think we want to address in short order. If we shift to campaigns, I think we should have a campaign specifically to address these issues. Because if a user of KBase cannot easily publish the work they do in KBase right now, then we're going to have trouble attracting users. The best possible advertisement is a good manuscript that people read and get excited about all the powerful things they can do in KBase. Then they click on our supplementary material and come to KBase and see the tools in action. Chris

1 0

no call today
by Paramvir Dehal 15 Apr '13

15 Apr '13

No call today, but continue to prioritize our 3m and 18m lists, I expect Adam and Rick to send out guidance for writing the Spec.0 for our campaigns soon. Paramvir

1 0

Re: [Microbe] reminder! update the google doc
by Gavin Price 11 Apr '13

11 Apr '13

Stackoverflow is already there; we should just use it. -g Sent from my Cray XT30 On Apr 11, 2013 1:26 PM, "Paramvir Dehal" <psdehal(a)lbl.gov> wrote: > I also think something like StackOverflow would be great. I'll include it > in our documentation goals for the next 3months. > > > On Thu, Apr 11, 2013 at 1:15 PM, Terry Disz <disz(a)mcs.anl.gov> wrote: > >> Ben, >> >> Glad it helped. I like the idea of a StackOverflow-like Question and >> Answer service and maybe the web people can make some proposals for such a >> service, but we're trying to get ahead of that a little. We have a >> developed a set of common queries in english and for each one we show the >> command query sequence to satisfy the question, i.e. >> >> What features in kb|g.123 implement role 'SSU ribosomal protein S16p'? >> >> is implemented by >> >> echo 'kb|g.123' | get_relationship_IsOwnerOf -to id,function | grep 'SSU >> ribosomal protein S16p' | cut -f2,3 >> >> >> We'll be working on publishing this set of questions and it should go a >> long way towards helping people understand the ERDB query model. >> >> Ross is writing up an explanation of the answer I gave you, how we >> arrived at it, and alternative paths to the answer. We should get that to >> you very soon. >> >> >> Terry >> >> >> >> On Apr 10, 2013, at 3:02 PM, Ben Bowen <ben.bowen(a)gmail.com> wrote: >> >> Thanks Terry! That is exactly what I wanted, and it ran perfectly in >> IRIS! I'll work on wrapping my mind around how to teach people how to >> create queries like that themselves. The simplest thing that comes to mind >> is something like StackOverflow where people post little questions (like >> mine) and experts put in how to do it correctly. >> >> Ben >> >> -------------- >> Email: BPBowen(a)lbl.gov >> Phone: (510) 214-6683 >> MS 977-221, Lawrence Berkeley Lab >> Web: ms.lbl.gov >> >> >> On Wed, Apr 10, 2013 at 12:47 PM, Terry Disz <disz(a)mcs.anl.gov> wrote: >> >>> Ben, >>> >>> Ross and I took this up and we produced this example - I think it does >>> what you want. >>> We went to the ERDB browser and followed the path from >>> Compound->ParticipatesAs->LocalizedCompund->IsInvolvedIn >>> >>> >>> >>> all_entities_Compound -a | grep -i valine | >>> get_relationship_ParticipatesAs -c 1 -to id | get_relationship_IsInvolvedIn >>> -to id,name >>> >>> This produces information for all compounds with valine in the name. >>> >>> Here are the first couple lines of output >>> >>> disz@ash:~$ all_entities_Compound -a | grep -i valine | >>> get_relationship_ParticipatesAs -c 1 -to id | get_relationship_IsInvolvedIn >>> -to id,name >>> kb|cpd.153 L-Valine val-L cpd00156 0 1340988351 117 C5H11NO2 0 -86.49 >>> 0.43806 kb|loc.0.c.1376 kb|rxn.99 L-valine transport in via proton >>> symport >>> kb|cpd.153 L-Valine val-L cpd00156 0 1340988351 117 C5H11NO2 0 -86.49 >>> 0.43806 kb|loc.0.c.1376 kb|rxn.485 Branched chain amino acid:H+ >>> symporter (Valine) >>> >>> Is this what you were looking for? >>> >>> Terry >>> >>> >>> >>> On Apr 10, 2013, at 2:17 PM, Ben Bowen <ben.bowen(a)gmail.com> wrote: >>> >>> I just made a small update to the doc, but probably didn't make it >>> clear. The thought I'm trying to convey is that we are missing out on a >>> huge opportunity by not having the API commands that perform ER-queries >>> easier to use. To me, the ER-queries make the KBase platform very distinct >>> (and more powerful) from other systems. I just can never seem to get them >>> to work... maybe its just me, but somehow I doubt it. Today, I was trying >>> to get a list of reactions that Valine was involved in and I gave up after >>> 30 minutes. Actually, what I was trying to do was this: >>> 1) get all the relationships that connect "Compounds" >>> 2) for Valine, get all the results of those relationships (ie: Media >>> IDs, Biomass terms, Reactions, etc). >>> What a powerful query! and what a success it would be to somehow make it >>> easier. I don't know what this would take, but I'm happy to talk with >>> whoever wants to try and figure out what it would take. >>> >>> Ben >>> >>> >>> -------------- >>> Email: BPBowen(a)lbl.gov >>> Phone: (510) 214-6683 >>> MS 977-221, Lawrence Berkeley Lab >>> Web: ms.lbl.gov >>> >>> >>> On Tue, Apr 9, 2013 at 12:18 PM, Paramvir Dehal <psdehal(a)lbl.gov> wrote: >>> >>>> Adam want's our Platform updates by Thursday, please update the google >>>> doc: >>>> >>>> >>>> https://docs.google.com/a/lbl.gov/document/d/1Nz2Tjl6Vdj9XWnEWEVHjWkJRew0jE… >>>> >>>> Let's populate this as much as we can before trying to prioritize. >>>> >>>> _______________________________________________ >>>> Microbe mailing list >>>> Microbe(a)lists.kbase.us >>>> https://lists.kbase.us/mailman/listinfo/microbe >>>> >>>> >>> _______________________________________________ >>> Microbe mailing list >>> Microbe(a)lists.kbase.us >>> https://lists.kbase.us/mailman/listinfo/microbe >>> >>> >>> >> >> > > _______________________________________________ > Microbe mailing list > Microbe(a)lists.kbase.us > https://lists.kbase.us/mailman/listinfo/microbe > >

1 0

Re: [Microbe] reminder! update the google doc
by Paramvir Dehal 11 Apr '13

11 Apr '13

I also think something like StackOverflow would be great. I'll include it in our documentation goals for the next 3months. On Thu, Apr 11, 2013 at 1:15 PM, Terry Disz <disz(a)mcs.anl.gov> wrote: > Ben, > > Glad it helped. I like the idea of a StackOverflow-like Question and > Answer service and maybe the web people can make some proposals for such a > service, but we're trying to get ahead of that a little. We have a > developed a set of common queries in english and for each one we show the > command query sequence to satisfy the question, i.e. > > What features in kb|g.123 implement role 'SSU ribosomal protein S16p'? > > is implemented by > > echo 'kb|g.123' | get_relationship_IsOwnerOf -to id,function | grep 'SSU > ribosomal protein S16p' | cut -f2,3 > > > We'll be working on publishing this set of questions and it should go a > long way towards helping people understand the ERDB query model. > > Ross is writing up an explanation of the answer I gave you, how we arrived > at it, and alternative paths to the answer. We should get that to you very > soon. > > > Terry > > > > On Apr 10, 2013, at 3:02 PM, Ben Bowen <ben.bowen(a)gmail.com> wrote: > > Thanks Terry! That is exactly what I wanted, and it ran perfectly in IRIS! > I'll work on wrapping my mind around how to teach people how to create > queries like that themselves. The simplest thing that comes to mind is > something like StackOverflow where people post little questions (like mine) > and experts put in how to do it correctly. > > Ben > > -------------- > Email: BPBowen(a)lbl.gov > Phone: (510) 214-6683 > MS 977-221, Lawrence Berkeley Lab > Web: ms.lbl.gov > > > On Wed, Apr 10, 2013 at 12:47 PM, Terry Disz <disz(a)mcs.anl.gov> wrote: > >> Ben, >> >> Ross and I took this up and we produced this example - I think it does >> what you want. >> We went to the ERDB browser and followed the path from >> Compound->ParticipatesAs->LocalizedCompund->IsInvolvedIn >> >> >> >> all_entities_Compound -a | grep -i valine | >> get_relationship_ParticipatesAs -c 1 -to id | get_relationship_IsInvolvedIn >> -to id,name >> >> This produces information for all compounds with valine in the name. >> >> Here are the first couple lines of output >> >> disz@ash:~$ all_entities_Compound -a | grep -i valine | >> get_relationship_ParticipatesAs -c 1 -to id | get_relationship_IsInvolvedIn >> -to id,name >> kb|cpd.153 L-Valine val-L cpd00156 0 1340988351 117 C5H11NO2 0 -86.49 >> 0.43806 kb|loc.0.c.1376 kb|rxn.99 L-valine transport in via proton >> symport >> kb|cpd.153 L-Valine val-L cpd00156 0 1340988351 117 C5H11NO2 0 -86.49 >> 0.43806 kb|loc.0.c.1376 kb|rxn.485 Branched chain amino acid:H+ >> symporter (Valine) >> >> Is this what you were looking for? >> >> Terry >> >> >> >> On Apr 10, 2013, at 2:17 PM, Ben Bowen <ben.bowen(a)gmail.com> wrote: >> >> I just made a small update to the doc, but probably didn't make it clear. >> The thought I'm trying to convey is that we are missing out on a huge >> opportunity by not having the API commands that perform ER-queries easier >> to use. To me, the ER-queries make the KBase platform very distinct (and >> more powerful) from other systems. I just can never seem to get them to >> work... maybe its just me, but somehow I doubt it. Today, I was trying to >> get a list of reactions that Valine was involved in and I gave up after 30 >> minutes. Actually, what I was trying to do was this: >> 1) get all the relationships that connect "Compounds" >> 2) for Valine, get all the results of those relationships (ie: Media IDs, >> Biomass terms, Reactions, etc). >> What a powerful query! and what a success it would be to somehow make it >> easier. I don't know what this would take, but I'm happy to talk with >> whoever wants to try and figure out what it would take. >> >> Ben >> >> >> -------------- >> Email: BPBowen(a)lbl.gov >> Phone: (510) 214-6683 >> MS 977-221, Lawrence Berkeley Lab >> Web: ms.lbl.gov >> >> >> On Tue, Apr 9, 2013 at 12:18 PM, Paramvir Dehal <psdehal(a)lbl.gov> wrote: >> >>> Adam want's our Platform updates by Thursday, please update the google >>> doc: >>> >>> >>> https://docs.google.com/a/lbl.gov/document/d/1Nz2Tjl6Vdj9XWnEWEVHjWkJRew0jE… >>> >>> Let's populate this as much as we can before trying to prioritize. >>> >>> _______________________________________________ >>> Microbe mailing list >>> Microbe(a)lists.kbase.us >>> https://lists.kbase.us/mailman/listinfo/microbe >>> >>> >> _______________________________________________ >> Microbe mailing list >> Microbe(a)lists.kbase.us >> https://lists.kbase.us/mailman/listinfo/microbe >> >> >> > >

1 0

Re: [Microbe] reminder! update the google doc
by Terry Disz 11 Apr '13

11 Apr '13

Ben, Glad it helped. I like the idea of a StackOverflow-like Question and Answer service and maybe the web people can make some proposals for such a service, but we're trying to get ahead of that a little. We have a developed a set of common queries in english and for each one we show the command query sequence to satisfy the question, i.e. What features in kb|g.123 implement role 'SSU ribosomal protein S16p'? is implemented by echo 'kb|g.123' | get_relationship_IsOwnerOf -to id,function | grep 'SSU ribosomal protein S16p' | cut -f2,3 We'll be working on publishing this set of questions and it should go a long way towards helping people understand the ERDB query model. Ross is writing up an explanation of the answer I gave you, how we arrived at it, and alternative paths to the answer. We should get that to you very soon. Terry On Apr 10, 2013, at 3:02 PM, Ben Bowen <ben.bowen(a)gmail.com> wrote: > Thanks Terry! That is exactly what I wanted, and it ran perfectly in IRIS! I'll work on wrapping my mind around how to teach people how to create queries like that themselves. The simplest thing that comes to mind is something like StackOverflow where people post little questions (like mine) and experts put in how to do it correctly. > > Ben > > -------------- > Email: BPBowen(a)lbl.gov > Phone: (510) 214-6683 > MS 977-221, Lawrence Berkeley Lab > Web: ms.lbl.gov > > > On Wed, Apr 10, 2013 at 12:47 PM, Terry Disz <disz(a)mcs.anl.gov> wrote: > Ben, > > Ross and I took this up and we produced this example - I think it does what you want. > We went to the ERDB browser and followed the path from Compound->ParticipatesAs->LocalizedCompund->IsInvolvedIn > > > > all_entities_Compound -a | grep -i valine | get_relationship_ParticipatesAs -c 1 -to id | get_relationship_IsInvolvedIn -to id,name > > This produces information for all compounds with valine in the name. > > Here are the first couple lines of output > > disz@ash:~$ all_entities_Compound -a | grep -i valine | get_relationship_ParticipatesAs -c 1 -to id | get_relationship_IsInvolvedIn -to id,name > kb|cpd.153 L-Valine val-L cpd00156 0 1340988351 117 C5H11NO2 0 -86.49 0.43806 kb|loc.0.c.1376 kb|rxn.99 L-valine transport in via proton symport > kb|cpd.153 L-Valine val-L cpd00156 0 1340988351 117 C5H11NO2 0 -86.49 0.43806 kb|loc.0.c.1376 kb|rxn.485 Branched chain amino acid:H+ symporter (Valine) > > Is this what you were looking for? > > Terry > > > > On Apr 10, 2013, at 2:17 PM, Ben Bowen <ben.bowen(a)gmail.com> wrote: > >> I just made a small update to the doc, but probably didn't make it clear. The thought I'm trying to convey is that we are missing out on a huge opportunity by not having the API commands that perform ER-queries easier to use. To me, the ER-queries make the KBase platform very distinct (and more powerful) from other systems. I just can never seem to get them to work... maybe its just me, but somehow I doubt it. Today, I was trying to get a list of reactions that Valine was involved in and I gave up after 30 minutes. Actually, what I was trying to do was this: >> 1) get all the relationships that connect "Compounds" >> 2) for Valine, get all the results of those relationships (ie: Media IDs, Biomass terms, Reactions, etc). >> What a powerful query! and what a success it would be to somehow make it easier. I don't know what this would take, but I'm happy to talk with whoever wants to try and figure out what it would take. >> >> Ben >> >> >> -------------- >> Email: BPBowen(a)lbl.gov >> Phone: (510) 214-6683 >> MS 977-221, Lawrence Berkeley Lab >> Web: ms.lbl.gov >> >> >> On Tue, Apr 9, 2013 at 12:18 PM, Paramvir Dehal <psdehal(a)lbl.gov> wrote: >> Adam want's our Platform updates by Thursday, please update the google doc: >> >> https://docs.google.com/a/lbl.gov/document/d/1Nz2Tjl6Vdj9XWnEWEVHjWkJRew0jE… >> >> Let's populate this as much as we can before trying to prioritize. >> >> _______________________________________________ >> Microbe mailing list >> Microbe(a)lists.kbase.us >> https://lists.kbase.us/mailman/listinfo/microbe >> >> >> _______________________________________________ >> Microbe mailing list >> Microbe(a)lists.kbase.us >> https://lists.kbase.us/mailman/listinfo/microbe > >

1 0

Re: [Microbe] campaigns for Adam
by Marcin Joachimiak 11 Apr '13

11 Apr '13

Hey Paramvir, One higher level theme is regulation. At the moment it looks like the plant and microbe regulatory network efforts will take parallel paths. But there are some common threads, at the very least the plant and microbe regulation could be cast into a common data model. The elements of the regulatory network are also common (regulator, target, type of interaction), though things like network and regulon size may be operationally different. Biclusters are operationally the same (again with size and overlap differences). Motifs may be qualitatively different. So there are some nuances, but fundamentally it seems that the methods to reconstruct the networks can be common. Also the 'plant-microbes' interaction theme suggests that at some point we may consider combined regulatory models. There are also higher level themes in annotation. Currently the Networks team is starting to explore network based annotation and this will have both a plants and microbe direction. Same for functional ortholog prediction. Just wanted to throw this out there for consideration ... marcin On Thu, Apr 11, 2013 at 10:47 AM, Paramvir Dehal <psdehal(a)lbl.gov> wrote: > So it looks like we're making pretty good head way on our 3 month Platform > campaigns doc. Chris and I will prioritize them before we send them to Adam > and Rick. > > > https://docs.google.com/a/lbl.gov/document/d/1Nz2Tjl6Vdj9XWnEWEVHjWkJRew0jE… > > > Also take a look at our science campaigns, we don't have these broken down > into sprints, but I think it's okay to keep them at an intermediate level: > > > https://docs.google.com/a/lbl.gov/document/d/1AsdNq-umcYFBnijFSm3RzBXtKW-M9… > > _______________________________________________ > Microbe mailing list > Microbe(a)lists.kbase.us > https://lists.kbase.us/mailman/listinfo/microbe > >

1 0

campaigns for Adam
by Paramvir Dehal 11 Apr '13

11 Apr '13

So it looks like we're making pretty good head way on our 3 month Platform campaigns doc. Chris and I will prioritize them before we send them to Adam and Rick. https://docs.google.com/a/lbl.gov/document/d/1Nz2Tjl6Vdj9XWnEWEVHjWkJRew0jE… Also take a look at our science campaigns, we don't have these broken down into sprints, but I think it's okay to keep them at an intermediate level: https://docs.google.com/a/lbl.gov/document/d/1AsdNq-umcYFBnijFSm3RzBXtKW-M9…

1 0

Re: [Microbe] reminder! update the google doc
by Gavin Price 10 Apr '13

10 Apr '13

We should just get a sysbiokbase tag going on SO. -g On 4/10/2013 1:02 PM, Ben Bowen wrote: > Thanks Terry! That is exactly what I wanted, and it ran perfectly in > IRIS! I'll work on wrapping my mind around how to teach people how to > create queries like that themselves. The simplest thing that comes to > mind is something like StackOverflow where people post little > questions (like mine) and experts put in how to do it correctly. > > Ben > > -------------- > Email: BPBowen(a)lbl.gov <mailto:[email protected]> > Phone: (510) 214-6683 > MS 977-221, Lawrence Berkeley Lab > Web: ms.lbl.gov <http://ms.lbl.gov> > > > On Wed, Apr 10, 2013 at 12:47 PM, Terry Disz <disz(a)mcs.anl.gov > <mailto:[email protected]>> wrote: > > Ben, > > Ross and I took this up and we produced this example - I think it > does what you want. > We went to the ERDB browser and followed the path from > Compound->ParticipatesAs->LocalizedCompund->IsInvolvedIn > > > > all_entities_Compound -a | grep -i valine | > get_relationship_ParticipatesAs -c 1 -to id | > get_relationship_IsInvolvedIn -to id,name > > This produces information for all compounds with valine in the name. > > Here are the first couple lines of output > > disz@ash:~$ all_entities_Compound -a | grep -i valine | > get_relationship_ParticipatesAs -c 1 -to id | > get_relationship_IsInvolvedIn -to id,name > kb|cpd.153L-Valineval-Lcpd0015601340988351117C5H11NO20-86.490.43806kb|loc.0.c.1376kb|rxn.99L-valine > transport in via proton symport > kb|cpd.153L-Valineval-Lcpd0015601340988351117C5H11NO20-86.490.43806kb|loc.0.c.1376kb|rxn.485Branched > chain amino acid:H+ symporter (Valine) > > Is this what you were looking for? > > Terry > > > > On Apr 10, 2013, at 2:17 PM, Ben Bowen <ben.bowen(a)gmail.com > <mailto:[email protected]>> wrote: > >> I just made a small update to the doc, but probably didn't make >> it clear. The thought I'm trying to convey is that we are >> missing out on a huge opportunity by not having the API commands >> that perform ER-queries easier to use. To me, the ER-queries >> make the KBase platform very distinct (and more powerful) from >> other systems. I just can never seem to get them to work... >> maybe its just me, but somehow I doubt it. Today, I was trying >> to get a list of reactions that Valine was involved in and I gave >> up after 30 minutes. Actually, what I was trying to do was this: >> 1) get all the relationships that connect "Compounds" >> 2) for Valine, get all the results of those relationships (ie: >> Media IDs, Biomass terms, Reactions, etc). >> What a powerful query! and what a success it would be to somehow >> make it easier. I don't know what this would take, but I'm happy >> to talk with whoever wants to try and figure out what it would take. >> >> Ben >> >> >> -------------- >> Email: BPBowen(a)lbl.gov <mailto:[email protected]> >> Phone: (510) 214-6683 <tel:%28510%29%20214-6683> >> MS 977-221, Lawrence Berkeley Lab >> Web: ms.lbl.gov <http://ms.lbl.gov/> >> >> >> On Tue, Apr 9, 2013 at 12:18 PM, Paramvir Dehal <psdehal(a)lbl.gov >> <mailto:[email protected]>> wrote: >> >> Adam want's our Platform updates by Thursday, please update >> the google doc: >> >> https://docs.google.com/a/lbl.gov/document/d/1Nz2Tjl6Vdj9XWnEWEVHjWkJRew0jE… >> >> Let's populate this as much as we can before trying to >> prioritize. >> >> _______________________________________________ >> Microbe mailing list >> Microbe(a)lists.kbase.us <mailto:[email protected]> >> https://lists.kbase.us/mailman/listinfo/microbe >> >> >> _______________________________________________ >> Microbe mailing list >> Microbe(a)lists.kbase.us <mailto:[email protected]> >> https://lists.kbase.us/mailman/listinfo/microbe > > > > > _______________________________________________ > Microbe mailing list > Microbe(a)lists.kbase.us > https://lists.kbase.us/mailman/listinfo/microbe

1 0

Re: [Microbe] reminder! update the google doc
by Ben Bowen 10 Apr '13

10 Apr '13

Thanks Terry! That is exactly what I wanted, and it ran perfectly in IRIS! I'll work on wrapping my mind around how to teach people how to create queries like that themselves. The simplest thing that comes to mind is something like StackOverflow where people post little questions (like mine) and experts put in how to do it correctly. Ben -------------- Email: BPBowen(a)lbl.gov Phone: (510) 214-6683 MS 977-221, Lawrence Berkeley Lab Web: ms.lbl.gov On Wed, Apr 10, 2013 at 12:47 PM, Terry Disz <disz(a)mcs.anl.gov> wrote: > Ben, > > Ross and I took this up and we produced this example - I think it does > what you want. > We went to the ERDB browser and followed the path from > Compound->ParticipatesAs->LocalizedCompund->IsInvolvedIn > > > > all_entities_Compound -a | grep -i valine | > get_relationship_ParticipatesAs -c 1 -to id | get_relationship_IsInvolvedIn > -to id,name > > This produces information for all compounds with valine in the name. > > Here are the first couple lines of output > > disz@ash:~$ all_entities_Compound -a | grep -i valine | > get_relationship_ParticipatesAs -c 1 -to id | get_relationship_IsInvolvedIn > -to id,name > kb|cpd.153 L-Valine val-L cpd00156 0 1340988351 117 C5H11NO2 0 -86.49 > 0.43806 kb|loc.0.c.1376 kb|rxn.99 L-valine transport in via proton symport > kb|cpd.153 L-Valine val-L cpd00156 0 1340988351 117 C5H11NO2 0 -86.49 > 0.43806 kb|loc.0.c.1376 kb|rxn.485 Branched chain amino acid:H+ symporter > (Valine) > > Is this what you were looking for? > > Terry > > > > On Apr 10, 2013, at 2:17 PM, Ben Bowen <ben.bowen(a)gmail.com> wrote: > > I just made a small update to the doc, but probably didn't make it clear. > The thought I'm trying to convey is that we are missing out on a huge > opportunity by not having the API commands that perform ER-queries easier > to use. To me, the ER-queries make the KBase platform very distinct (and > more powerful) from other systems. I just can never seem to get them to > work... maybe its just me, but somehow I doubt it. Today, I was trying to > get a list of reactions that Valine was involved in and I gave up after 30 > minutes. Actually, what I was trying to do was this: > 1) get all the relationships that connect "Compounds" > 2) for Valine, get all the results of those relationships (ie: Media IDs, > Biomass terms, Reactions, etc). > What a powerful query! and what a success it would be to somehow make it > easier. I don't know what this would take, but I'm happy to talk with > whoever wants to try and figure out what it would take. > > Ben > > > -------------- > Email: BPBowen(a)lbl.gov > Phone: (510) 214-6683 > MS 977-221, Lawrence Berkeley Lab > Web: ms.lbl.gov > > > On Tue, Apr 9, 2013 at 12:18 PM, Paramvir Dehal <psdehal(a)lbl.gov> wrote: > >> Adam want's our Platform updates by Thursday, please update the google >> doc: >> >> >> https://docs.google.com/a/lbl.gov/document/d/1Nz2Tjl6Vdj9XWnEWEVHjWkJRew0jE… >> >> Let's populate this as much as we can before trying to prioritize. >> >> _______________________________________________ >> Microbe mailing list >> Microbe(a)lists.kbase.us >> https://lists.kbase.us/mailman/listinfo/microbe >> >> > _______________________________________________ > Microbe mailing list > Microbe(a)lists.kbase.us > https://lists.kbase.us/mailman/listinfo/microbe > > >

1 0