Portal:Semantic Web/SPARQL
From WikiPathways
(Difference between revisions)
Current revision (12:03, 8 January 2020) (view source) |
|||
| (3 intermediate revisions not shown.) | |||
| Line 1: | Line 1: | ||
| - | We provide [http://sparql.wikipathways.org/ | + | We provide [http://sparql.wikipathways.org/sparql a SPARQL endpoint] where data queries can be done. |
=== WikiPathways Example SPARQL Queries === | === WikiPathways Example SPARQL Queries === | ||
| - | We have a large collection of [http://www.wikipathways.org/index.php/Help:WikiPathways_SPARQL_queries example queries]. | + | We have a large collection of [http://www.wikipathways.org/index.php/Help:WikiPathways_SPARQL_queries general example queries] and |
| + | [https://www.wikipathways.org/index.php/Help:WikiPathways_Metabolomics metabolite related example queries]. | ||
For example, to list all pathways per instance of a particular gene or protein (wp:GeneProduct), you can use the following SPARQL: | For example, to list all pathways per instance of a particular gene or protein (wp:GeneProduct), you can use the following SPARQL: | ||
| Line 12: | Line 13: | ||
PREFIX dcterms: <http://purl.org/dc/terms/> | PREFIX dcterms: <http://purl.org/dc/terms/> | ||
| - | SELECT DISTINCT ?pathway str(?label) as ?geneProduct | + | SELECT DISTINCT |
| + | ?pathway | ||
| + | (str(?label) as ?geneProduct) | ||
WHERE { | WHERE { | ||
?geneProduct a wp:GeneProduct . | ?geneProduct a wp:GeneProduct . | ||
Current revision
We provide a SPARQL endpoint where data queries can be done.
WikiPathways Example SPARQL Queries
We have a large collection of general example queries and metabolite related example queries.
For example, to list all pathways per instance of a particular gene or protein (wp:GeneProduct), you can use the following SPARQL:
PREFIX wp: <http://vocabularies.wikipathways.org/wp#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dcterms: <http://purl.org/dc/terms/>
SELECT DISTINCT
?pathway
(str(?label) as ?geneProduct)
WHERE {
?geneProduct a wp:GeneProduct .
?geneProduct rdfs:label ?label .
?geneProduct dcterms:isPartOf ?pathway .
?pathway a wp:Pathway .
FILTER regex(str(?label), "CYP").
}
