From WikiPathways

(Difference between revisions)

Revision as of 16:19, 7 January 2013

On http://sparql.wikipathways.org/ wikipathways content is replicated. Currently this SPARQL endpoint is being developed, with very irregular updates.

Resources

WikiPathways internal vocabularies: http://vocabularies.wikipathways.org
WikiPathways data as RDF: http://rdf.wikipathways.org
WikiPathways SPARQL endpoint http://sparql.wikipathways.org

Identifiers.org: http://identifiers.org
Sparqlbin http://sparqlbin.org
Searches prefixes: http://prefix.cc

Other sparql endpoints

Gene Wiki: http://genewiki.semwebinsi.de
ChEMBL: http://rdf.farmbio.uu.se/chembl/sparql/
[1]
ubo text mining

Submit ideas

Prefixes

Below are example queries. For readability we have omitted the prefixes. We use the following prefixes: (Not complete yet)

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc:      <http://purl.org/dc/elements/1.1/> 
PREFIX cas:     <http://identifiers.org/cas/> 
PREFIX wprdf:   <http://rdf.wikipathways.org/> 
PREFIX foaf:    <http://xmlns.com/foaf/0.1/> 
PREFIX pubmed:  <http://www.ncbi.nlm.nih.gov/pubmed/> 
PREFIX wp:      <http://vocabularies.wikipathways.org/wp#> 
PREFIX biopax:  <http://www.biopax.org/release/biopax-level3.owl#> 
PREFIX dcterms:  <http://purl.org/dc/terms/> 
PREFIX rdfs:    <http://www.w3.org/2000/01/rdf-schema#> 
PREFIX ncbigene:  <http://identifiers.org/ncbigene/> 
PREFIX xsd:     <http://www.w3.org/2001/XMLSchema#> 
PREFIX rdf:     <http://www.w3.org/1999/02/22-rdf-syntax-ns#> 
PREFIX gpml:    <http://vocabularies.wikipathways.org/gpml#> 
PREFIX skos:    <http://www.w3.org/2004/02/skos/core#>

Example queries

Queries with a * requires a bit more time for results.

Data curation oriented queries

Get the pathway with the erroneous data source "null"

SELECT DISTINCT  ?identifier ?pathway ?label
WHERE {
        ?concept dc:source "null"^^xsd:string .
        ?concept dc:identifier ?identifier .
        ?concept dcterms:isPartOf ?pathway .
        ?concept rdfs:label ?label
}

sparqlbin Execute

Get all geneproducts that lack either a DataSource or an Identifier

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 ?label where {?geneProduct a wp:GeneProduct . 
      ?geneProduct rdfs:label ?label .
      ?geneProduct dcterms:isPartOf ?pathway .
      
      FILTER regex(str(?geneProduct), "^node"). 
      FILTER regex(str(?pathway), "^http").
      }

sparqlbin Execute

Pathway oriented queries

Get the species currently in WikiPathways with their respective URI's

SELECT DISTINCT ?organism ?label
WHERE {
    ?concept wp:organism ?organism .
    ?organism rdfs:label ?label .
 }

Sparqlbin

List pathways and their species

SELECT DISTINCT ?title ?label 
WHERE {
    ?pathway dc:title ?title .
    ?pathway wp:organism ?organism .
    ?organism rdfs:label ?label .
 }

Sparqlbin

List the species captured in WikiPathways and the number of pathways per species

SELECT DISTINCT ?organism ?label count(?pathway) as ?noPathways
WHERE {
    ?pathway dc:title ?title .
    ?pathway wp:organism ?organism .
    ?organism rdfs:label ?label .
 }
ORDER BY DESC(?noPathways)

Sparqlbin

Count the pathways per pathway category

SELECT DISTINCT  ?category count(?category) as ?noCategories
WHERE {
        ?pathway wp:category ?category .
        ?pathway dc:title ?title .
} 
ORDER BY ?category

Sparqlbin execute

List all pathways of category Metabolic Process

SELECT DISTINCT  *
WHERE {
        ?pathway wp:category wp:MetabolicProcess .
        ?pathway dc:title ?title .
}

Sparqlbin execute

Get all pathways with CYP protein

   select distinct ?pathway ?label where {
     ?geneProduct a wp:GeneProduct . 
     ?geneProduct rdfs:label ?label .
     ?geneProduct dcterms:isPartOf ?pathway .
   
     FILTER regex(str(?label), "CYP"). 
     FILTER regex(str(?pathway), "^http"). 
   }

Count the number of Pathways per Pathway Ontology term

In WikiPathways pathways can be labeled according to terms from Pathway ontology, Cell Line ontology and the disease ontology. The following query get a pathway count for each ontological term being used in WikiPathways

 SELECT DISTINCT ?label as ?pwOntologyTerm count(?pathway) as ?pathwayCount
 WHERE {
	?pathwayRDF wp:pathwayOntology ?o .
        ?pathwayRDF foaf:page ?pathway .
        ?pathwayRDF dc:title ?title .
        ?o <http://www.w3.org/2000/01/rdf-schema#label> ?label .
        ?o rdfs:subClassOf ?superClass .
        ?superClass rdfs:label ?superClassLabel .
 }
 ORDER BY DESC(?pathwayCount)

Sparqlbin

Execute

Get a full dump of all pathways from the analytical set and they pathway ontological terms

PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX dc:  <http://purl.org/dc/elements/1.1/>
PREFIX foaf: <http://xmlns.com/foaf/0.1/>
PREFIX schema: <http://schema.org/>
PREFIX wp:      <http://vocabularies.wikipathways.org/wp#>
PREFIX dcterms:  <http://purl.org/dc/terms/>

SELECT DISTINCT ?depicts ?title ?speciesLabel ?identifier ?ontology ?label 
FROM <http://ops.wikipathways.org>
FROM <http://clontology.wikipathways.org>
FROM <http://doidontology.wikipathways.org>
FROM <http://pwontology.wikipathways.org>
WHERE {
	?pathway foaf:page ?depicts .
        ?pathway dc:title ?title .
        ?pathway wp:organism ?species .
        ?species rdfs:label ?speciesLabel .
        ?pathway dc:identifier ?identifier .
        OPTIONAL {?pathway wp:pathwayOntology ?ontology .
        ?ontology rdfs:label ?label .}
}

Execute

Datasource oriented queries

Get all datasources currently captured in WikiPathways

SELECT DISTINCT ?datasource 
WHERE {
         ?concept dc:source ?datasource
}

Execute

Get the number of entries per datasource in WikiPathways

SELECT DISTINCT ?datasource count(?datasource) as ?numberEntries 
WHERE {
        ?concept dc:source ?datasource
} 
ORDER BY DESC(?numberEntries)

Sparqlbin

Count the identifiers per data source

SELECT DISTINCT ?datasource ?identifier count(?identifier) AS ?numberEntries 
WHERE {
        ?concept dc:source ?datasource .
        ?concept dc:identifier ?identifier
}

Sparqlbin

Count the identifiers per data source and order them from high to low

SELECT DISTINCT ?datasource ?identifier count(?identifier) AS ?numberEntries 
WHERE {
        ?concept dc:source ?datasource .
        ?concept dc:identifier ?identifier
} 
ORDER BY DESC(?numberEntries)

Sparqlbin

Return all Chembl compounds in WikiPathways and the pathways they are in

SELECT DISTINCT ?identifier ?pathway
WHERE {
        ?concept dcterms:isPartOf ?pathway .
        ?concept dc:source "ChEMBL compound"^^xsd:string .
        ?concept dc:identifier ?identifier .
        
}

Sparqlbin

Curators oriented queries

Extract contributors

SELECT DISTINCT ?contributor  
WHERE {
       ?pathway dc:contributor ?contributor
}

Sparqlbin

Extract the amount of pathways edited per contributor

SELECT DISTINCT ?contributor, count(?pathway) as ?pathwaysEdited  
WHERE {
       ?pathway dc:contributor ?contributor
}
ORDER BY DESC(?pathwaysEdited)

Sparqlbin

find the pathways a user have edited so far.

SELECT DISTINCT ?pathway, ?pathwayLabel
WHERE {
       ?pathway dc:contributor wpuser:Andra .
       ?pathway dc:contributor ?contributor .
       ?pathway rdfs:label ?pathwayLabel .
}

Sparqlbin

Federated queries

WikiPathways with GeneWiki

SELECT DISTINCT ?wplabel ?identifier ?snp where {

                        ?s dc:identifier <http://identifiers.org/ncbigene/53975> .
                        ?s dc:identifier ?identifier .
                        ?s rdfs:label ?wplabel .
                        ?s dc:source ?source .
                    SERVICE <http://genewiki.semwebinsi.de/> {
                       ?gws dc:identifier ?identifier .
                       ?gws rdf:type ?gwtype .
                       ?gws <http://genewikiplus.org/wiki/Special:URIResolver/Property-3AHasSNP> ?snp . 
                    }

             }

prefix dc: <http://purl.org/dc/elements/1.1/>
prefix dcterms:  <http://purl.org/dc/terms/>

select distinct * where { 
            ?pwEntity dc:identifier ?identifier . 
            ?pwEntity dcterms:isPartOf ?pathway .
        SERVICE <http://genewiki.semwebinsi.de/> {
            ?concept dc:identifier <http://identifiers.org/ncbigene/12189> .
            ?concept dc:identifier ?identifier .
            ?concept <http://genewikiplus.org/wiki/Special:URIResolver/Property-3AIs_associated_with_disease> ?disease .
        }
}

WikiPathways with ChEMBL: ChEMBL compounds in WikiPathways (without BridgeDB)

SELECT *
  WHERE {{
        SELECT DISTINCT ?pathway ?concept iri(bif:concat("http://linkedchemistry.info/chembl/chemblid/", bif:regexp_substr('http://identifiers.org/chembl.compound/(.*)',?identifier, 1))) as ?ChEMBLId where {
                        ?concept dcterms:isPartOf ?pathway .
                        ?concept dc:source "ChEMBL compound"^^xsd:string .
                        ?concept dc:identifier ?identifier .     
                        FILTER regex(str(?identifier), "^http").      
        }
} SERVICE <http://rdf.farmbio.uu.se/chembl/sparql/>{
        ?ChEMBLId ?p ?o .
} }

Execute

WikiPathways with ChEMBL: all ChEMBL assays for pathways

SELECT ?pathway ?target ?assay WHERE {
{
  SELECT DISTINCT
    ?pathway ?uniprot
    iri(
      bif:concat("http://bio2rdf.org/uniprot:",
      bif:regexp_substr('http://identifiers.org/uniprot/(.*)',?uniprot, 1))
    ) as ?chembluniprot
  WHERE {
    ?s ?p ?uniprot .
    ?s dcterms:isPartOf ?pathway .
    FILTER regex(?uniprot, "uniprot")
  }
}
  SERVICE <http://rdf.farmbio.uu.se/chembl/sparql/> {
    ?target owl:sameAs ?chembluniprot .
    ?score chembl:forTarget ?target .
    ?assay chembl:hasTargetScore ?score .
}
}

Execute

WikiPathways with ChEMBL: all molecules targeting pathways

SELECT ?pathway ?target ?assay ?smiles WHERE {
{
  SELECT DISTINCT
    ?pathway ?uniprot
    iri(
      bif:concat("http://bio2rdf.org/uniprot:",
      bif:regexp_substr('http://identifiers.org/uniprot/(.*)',?uniprot, 1))
    ) as ?chembluniprot
  WHERE {
    ?s ?p ?uniprot .
    ?s dcterms:isPartOf ?pathway .
    FILTER regex(?uniprot, "uniprot")
  }
}
  SERVICE <http://rdf.farmbio.uu.se/chembl/sparql/> {
    ?target owl:sameAs ?chembluniprot .
    ?score chembl:forTarget ?target .
    ?assay chembl:hasTargetScore ?score .
    ?activity chembl:onAssay ?assay ;
      chembl:forMolecule ?molecule .
    ?molecule bo:smiles ?smiles .
    
}
}

Execute

WikiPathways with EBI Atlas RDF

PREFIX biopax3:<http://www.biopax.org/release/biopax-level3.owl#>
PREFIX rdf:<http://www.w3.org/1999/02/22-rdf-syntax-ns#>
PREFIX owl:<http://www.w3.org/2002/07/owl#>
PREFIX upc:<http://purl.uniprot.org/core/>
PREFIX gxa:<http://identifiers.org/gxa/>
PREFIX rdfs:<http://www.w3.org/2000/01/rdf-schema#>
PREFIX efo:<http://www.ebi.ac.uk/efo/>
PREFIX ro:<http://www.obofoundry.org/ro/ro.owl#>
PREFIX obo:<http://purl.obolibrary.org/obo/>
PREFIX xsd:<http://www.w3.org/2001/XMLSchema#>
PREFIX ensembl:<http://identifiers.org/ensembl/>
PREFIX chembl: <http://rdf.farmbio.uu.se/chembl/onto/#>
PREFIX dc: <http://purl.org/dc/elements/1.1/>
PREFIX dcterms:   <http://purl.org/dc/terms/>

SELECT DISTINCT ?iduniprot ?updown  ?pvalue  ?pathway  ?pathwayTitle WHERE {

?geneList rdf:type obo:OBI_0000118 .
?geneList efo:has_member ?member .
?independantVariable obo:IAO_0000136 ?geneList .
?independantVariable rdf:type obo:OBI_0000750 .
?independantVariable obo:OBI_0000293 ?exFactor .
?exFactor rdf:type efo:EFO_0000270   .
?member obo:IAO_0000136 ?ensemblgene .
?member efo:p_value ?pvalue .
?member efo:t_statistic ?t_stat .
?member efo:EFO_0004034 ?updown .

?ensemblgene rdfs:label ?geneLabel .
?ensemblgene gxa:associated_protein ?uniprot .

BIND ( IRI( CONCAT('http://identifiers.org/uniprot/', SUBSTR( str(?uniprot),33))) AS ?iduniprot) .

SERVICE <http://sparql.wikipathways.org/sparql> {
 ?s ?p ?iduniprot .
    ?s dcterms:isPartOf ?pathway .
   ?pathway dc:title ?pathwayTitle

}
}

Code examples

Java

For java we recommend the Jena Framework.

import com.hp.hpl.jena.query.Query;
import com.hp.hpl.jena.query.QueryExecution;
import com.hp.hpl.jena.query.QueryExecutionFactory;
import com.hp.hpl.jena.query.QueryFactory;
import com.hp.hpl.jena.query.QuerySolution;
import com.hp.hpl.jena.query.ResultSet;

public class javaCodeExample {

	public static void main(String[] args) {
		String sparqlQueryString = "SELECT * WHERE {?s ?p ?o} LIMIT 10";
		Query query = QueryFactory.create(sparqlQueryString);
		QueryExecution queryExecution = QueryExecutionFactory.sparqlService("http://sparql.wikipathways.org", query);
		ResultSet resultSet = queryExecution.execSelect();
		while (resultSet.hasNext()) {
			QuerySolution solution = resultSet.next();
			System.out.print(solution.get("s"));
			System.out.print("\t"+solution.get("p"));
			System.out.println("\t"+solution.get("o"));
		}
	}
}

php

For php we recommend the arc2: Easy RDF and SPARQL for LAMP systems

R

   library(rrdf)
   sparql.remote(
     "http://sparql.wikipathways.org/",
     "SELECT DISTINCT ?p WHERE { ?s ?p ?o }"
   )

Bioclipse

The below code works in both the JavaScript and the Groovy console:

   rdf.sparqlRemote(
     "http://sparql.wikipathways.org/",
     "SELECT DISTINCT ?p WHERE { ?s ?p ?o }"
   )

SPARQL from the command line

For quick and easy querying, we recommend to use curl (Linux and OS X)

curl -F "query=SELECT * WHERE {?s ?p ?o} LIMIT 10" http://sparql.wikipathways.org

Return to Help Contents

@@ Line 183: / Line 183: @@
 }
 </PRE>
+[http://sparql.wikipathways.org/?default-graph-uri=&query=PREFIX+rdf%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0D%0APREFIX+rdfs%3A+%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0D%0APREFIX+dc%3A++%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Felements%2F1.1%2F%3E%0D%0APREFIX+foaf%3A+%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0D%0APREFIX+schema%3A+%3Chttp%3A%2F%2Fschema.org%2F%3E%0D%0APREFIX+wp%3A++++++%3Chttp%3A%2F%2Fvocabularies.wikipathways.org%2Fwp%23%3E%0D%0APREFIX+dcterms%3A++%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0D%0ASELECT+DISTINCT+%3Fdepicts+%3Ftitle+%3FspeciesLabel+%3Fidentifier+%3Fontology+%3Flabel+%0D%0AFROM+%3Chttp%3A%2F%2Fops.wikipathways.org%3E%0D%0AFROM+%3Chttp%3A%2F%2Fclontology.wikipathways.org%3E%0D%0AFROM+%3Chttp%3A%2F%2Fdoidontology.wikipathways.org%3E%0D%0AFROM+%3Chttp%3A%2F%2Fpwontology.wikipathways.org%3E%0D%0AWHERE+%7B%0D%0A%09%3Fpathway+foaf%3Apage+%3Fdepicts+.%0D%0A++++++++%3Fpathway+dc%3Atitle+%3Ftitle+.%0D%0A++++++++%3Fpathway+wp%3Aorganism+%3Fspecies+.%0D%0A++++++++%3Fspecies+rdfs%3Alabel+%3FspeciesLabel+.%0D%0A++++++++%3Fpathway+dc%3Aidentifier+%3Fidentifier+.%0D%0A++++++++OPTIONAL+%7B%3Fpathway+wp%3ApathwayOntology+%3Fontology+.%0D%0A++++++++%3Fontology+rdfs%3Alabel+%3Flabel+.%7D%0D%0A%7D+&format=text%2Fhtml&timeout=0&debug=on Execute]
 == Datasource oriented queries ==

Help:WikiPathways SPARQL queries

From WikiPathways

Revision as of 16:19, 7 January 2013

Contents

Resources

Other sparql endpoints

Submit ideas

Prefixes

Example queries

Data curation oriented queries

Get the pathway with the erroneous data source "null"

Get all geneproducts that lack either a DataSource or an Identifier

Pathway oriented queries

Get the species currently in WikiPathways with their respective URI's

List pathways and their species

List the species captured in WikiPathways and the number of pathways per species

Count the pathways per pathway category

List all pathways of category Metabolic Process

Get all pathways with CYP protein

Count the number of Pathways per Pathway Ontology term

Get a full dump of all pathways from the analytical set and they pathway ontological terms

Datasource oriented queries

Get all datasources currently captured in WikiPathways

Get the number of entries per datasource in WikiPathways

Count the identifiers per data source

Count the identifiers per data source and order them from high to low

Return all Chembl compounds in WikiPathways and the pathways they are in

Curators oriented queries

Extract the amount of pathways edited per contributor

find the pathways a user have edited so far.

Federated queries

WikiPathways with GeneWiki

WikiPathways with ChEMBL: ChEMBL compounds in WikiPathways (without BridgeDB)

WikiPathways with ChEMBL: all ChEMBL assays for pathways

WikiPathways with ChEMBL: all molecules targeting pathways

WikiPathways with EBI Atlas RDF

Code examples

Java

php

R

Bioclipse

SPARQL from the command line

Views

Personal tools

search

Download

Activity

Tools

Community Portals

Toolbox