Portal:Semantic Web/SPARQL

From WikiPathways

(Difference between revisions)
Jump to: navigation, search
Current revision (12:03, 8 January 2020) (view source)
 
(3 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:
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"). 
}
Personal tools