@prefix ex: .
@prefix rdfs: .
@prefix schema: .
@prefix sh: .
ex:2 a sh:SPARQLExecutable,
sh:SPARQLSelectExecutable ;
rdfs:label "Potential lipid structures for lipid analytes"@en ;
rdfs:comment """For a given (list of) lipid Species identifier(s) (e.g. SWISSLIPID:000056420 (Phosphatidylcholine (20:2)) SWISSLIPID:000308470 (Triacylglycerol (64:6))), return a list of the corresponding Molecular subspecies (if any), Structural subspecies (if any), and Isomeric subspecies.
The query should return the lipid recommended names as well as identifiers.
The list should be sorted by level in the hierarchy (Isomeric subspecies last).
Future versions of this query should be generic enough to work from any start point (Species, Molecular subspecies, Structural subspecies).
Recapitulates the “browse lipid analytes” function of the website (in batch)."""@en ;
sh:prefixes _:sparql_examples_prefixes ;
sh:select """PREFIX SWISSLIPID:
PREFIX rdfs:
# Example 2
SELECT ?startId ?startName ?rank ?id ?name
WHERE
{
# query: list of SwissLipids Species identifiers
VALUES ?startId { SWISSLIPID:000056420 SWISSLIPID:000308470 }
?startId SWISSLIPID:rank SWISSLIPID:Species .
# SwissLipids Species name
?startId rdfs:label ?startName .
# Hierarchical search
?id rdfs:subClassOf+ ?startId .
?id SWISSLIPID:rank ?rank .
VALUES ?rank { SWISSLIPID:Isomeric_Subspecies SWISSLIPID:Molecular_Subspecies SWISSLIPID:Structural_Subspecies}
?id rdfs:label ?name .
}
ORDER BY DESC(?rank) ?startId""" ;
schema:target .