A set of SPARQL examples that are used in different SIB resources
For a given (list of) lipid Species identifiers (e.g. SWISSLIPID:000056493, Phosphatidylcholine (32:0)), return a list of the corresponding Molecular subspecies (if any), Structural subspecies (if any), and Isomeric subspecies (if any) which are associated with at least one citation (PMID: PubMed id). The query should return the lipid identifiers (?id), recommended names (?name), and PMIDs (?citation). Future versions of this query should be generic enough to work from any start point (Species, Molecular subspecies, Structural subspecies).
PREFIX SWISSLIPID: <https://swisslipids.org/rdf/SLM_>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
# Example 3
SELECT ?startId ?startLabel ?rank ?id ?name ?citation
WHERE
{
# Queried lipid species
VALUES ?startId { SWISSLIPID:000056493 }
?startId rdfs:label ?startLabel .
?id rdfs:subClassOf+ ?startId .
VALUES ?rank { SWISSLIPID:Isomeric_Subspecie SWISSLIPID:Molecular_Subspecies SWISSLIPID:Structural_Subspecies}
?id SWISSLIPID:rank ?rank ;
rdfs:label ?name ;
SWISSLIPID:citation ?citation .
}
ORDER BY ?startId ?id DESC(?rank)
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v6("?citation"):::projected
v2("?id"):::projected
v5("?name"):::projected
v5("?rank"):::projected
v4("?startId"):::projected
v4("?startLabel"):::projected
bind0[/VALUES ?startId/]
bind0-->v4
bind00(["SWISSLIPID:000056493"])
bind00 --> bind0
v4 --"rdfs:label"--> v4
v2 --"rdfs:subClassOf"--> v4
bind1[/VALUES ?rank/]
bind1-->v5
bind10(["SWISSLIPID:Isomeric_Subspecie"])
bind10 --> bind1
bind11(["SWISSLIPID:Molecular_Subspecies"])
bind11 --> bind1
bind12(["SWISSLIPID:Structural_Subspecies"])
bind12 --> bind1
v2 --"SWISSLIPID:rank"--> v5
v2 --"rdfs:label"--> v5
v2 --"SWISSLIPID:citation"--> v6