Portal:Semantic Web/SPARQL

From WikiPathways

(Difference between revisions)
Jump to: navigation, search
(New page: We provide [http://sparql.wikipathways.org/ an (experimental) SPARQL endpoint] where data queries can be done. === WikiPathways Example SPARQL Queries === We have a large collection of ...)
Current revision (12:03, 8 January 2020) (view source)
 
(4 intermediate revisions not shown.)
Line 1: Line 1:
-
We provide [http://sparql.wikipathways.org/ an (experimental) SPARQL endpoint] where data queries can be done.  
+
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:
 +
 
 +
<PRE>
 +
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").
 +
}
 +
</PRE>

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"). 
}
Personal tools