Comments (3)
@DeniseSl22, didn't we write a SPARQL query for this at some point in time? Or was that just on my long wish-/todo list?
from rwikipathways.
The pathway WP5424
is not in the RDF yet, but the following SPARQL should give you some idea how to do this:
SELECT ?wpid ?catalyst ?source ?target WHERE {
?pathway a wp:Pathway ;
dc:identifier / dcterms:identifier ?wpid .
?catalysis a wp:Catalysis ;
dcterms:isPartOf ?pathway ;
wp:source / rdfs:label ?catalyst ;
wp:participants ?reaction .
?reaction a wp:Interaction .
OPTIONAL { ?reaction wp:source ?source }
OPTIONAL { ?reaction wp:target ?target }
} ORDER BY ASC(?catalysis)
from rwikipathways.
@avelar-ageing , thanks for your question!
I've modified the query of @egonw slightly, see below.
I believe that the reactions without a clear source and/or target are not relevant in this case (and require some curation on our side). There are also a bunch of interactions between two metabolites which have not been drawn with the MIM-Catalysis interaction type, but with a regular arrow. I've reworked that line in the SPARQL query (see below), so you can comment it out to see the difference in response (# is used for comments in SPARQL).
When only including interactions of type MIM:Catalysis, you would receive 5296 results; if commenting out this line, you get 6189 results (so ~900 more). I've also added a way to unify to one database type (Wikidata, others are possible, e.g. HMDB, ChEBI, PubChem) for the metabolite annotations, in case you would want to merge the data at a later stage. Unifying the enzyme annotations can be done in a similar matter (to HGNC, Ensembl, UniProt, etc.)
Also note that this is for all pathway (WikiPathways and Reactome) and all species.
Hope the above helps, if not ask another question here.
SELECT DISTINCT ?wpid ?catalyst ?source ?sourceDb ?target ?targetDb WHERE {
?pathway a wp:Pathway ;
dc:identifier / dcterms:identifier ?wpid .
# ?catalysis a wp:Catalysis .
?catalysis dcterms:isPartOf ?pathway ;
wp:source / rdfs:label ?catalyst ;
wp:participants ?reaction .
?reaction a wp:Interaction .
?reaction wp:source ?source .
?source a wp:Metabolite .
OPTIONAL{?source wp:bdbWikidata ?sourceDb .}
?reaction wp:target ?target .
?target a wp:Metabolite .
OPTIONAL{?target wp:bdbWikidata ?targetDb .}
} ORDER BY ASC(?source)
from rwikipathways.
Related Issues (20)
- How to extract edges from GPML file ? HOT 2
- Procedure to remove getColoredPathway function HOT 2
- loading of BridgeDbR does not happen authomatically when using getXrefList() HOT 1
- commit 2ba575e338706e1c6ffa7707e7d10ff78839e71a undid earlier fixes HOT 2
- GMT parsing is missing HOT 3
- proper acknowledgement HOT 2
- Add emap section to PathwayAnalysis vignette HOT 1
- Link to BridgeDb datasource list in documentation is wrong HOT 2
- downloadPathwaysArchive doesn't work with redirects
- downloadPathwayArchive() not working HOT 3
- igraph compatible? HOT 1
- Error in function (type, msg, asError = TRUE) : SSL certificate problem: certificate has expired HOT 4
- https for downloadPathwayArchive
- update pathway analysis vignette
- how to metabolite enrichment analysis HOT 1
- getXrefList(...) method is broken HOT 14
- get push rights in the BioC repo HOT 3
- 404 error when trying to use clusterProfiler::enrichWP HOT 2
- latest article needs to be added
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from rwikipathways.