From WikiPathways
On sparql.wikipathways.org wikipathways content is replicated. Currently this SPARQL endpoint is being developed, with very irregular updates.
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 foaf: <http://xmlns.com/foaf/0.1/>
PREFIX schema: <http://schema.org/>
Example queries
Datasource oriented queries
| Get all datasource currently captured in WikiPathways
| select distinct ?datasource count(?datasource) as ?numberEntries
WHERE {
?concept dc:source ?datasource
}
| Execute
|
| Get the number of entries per datasource in WikiPathways
| SELECT DISTINCT ?datasource
WHERE {
?concept dc:source ?datasource
}
| Execute
|
| Count the identifiers per data source
|
SELECT DISTINCT ?datasource ?identifier count(?identifier) AS ?numberEntries
WHERE {
?concept dc:source ?datasource .
?concept dc:identifier ?identifier
}
| Execute
|
| 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)
| Execute
|
Curators oriented queries
| Extract contributors
| SELECT DISTINCT ?contributor
WHERE {
?pathway dc:contributor ?contributor
}
| Execute
|
| Extract the amount of pathways edited per contributor
| SELECT DISTINCT ?contributor, count(?pathway) as ?pathwaysEdited
WHERE {
?pathway dc:contributor ?contributor
}
ORDER BY DESC(?pathwaysEdited)
| Execute
|
| find the pathways a user have edited so far. Change the name in the query
| SELECT DISTINCT ?pathway, ?pathwayLabel
WHERE {
?pathway dc:contributor wpuser:Andra .
?pathway dc:contributor ?contributor .
?pathway rdfs:label ?pathwayLabel .
}
| Execute
|
