A set of SPARQL examples that are used in different SIB resources
For a given list of LipidX lipid identifiers return the list of published Isomeric subspecies. Output should include the LipidX ID and the corresponding SwissLipids ID(s) and name(s) plus PubMed ID(s). This query first identifies SwissLipids identifiers for a given list of LipidX identifiers. It then retrieves the corresponding Isomeric subspecies that are linked to at least one publication, and the corresponding PMIDs. extends ex:15
PREFIX SWISSLIPID: <https://swisslipids.org/rdf/SLM_>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT
?swisslipid
?lipidx
?isomericsubSwisslipid
?pubmed
WHERE {
VALUES ?hmdb {'HMDB00269' 'MDB00032'}
BIND (IRI(CONCAT('http://identifiers.org/lipidx/', ?lipidx)) AS ?lipidxIRI)
?swisslipid rdfs:seeAlso ?lipidxIRI .
?swisslipid rdfs:subClassOf ?isomericsubSwisslipid .
?isomericsubSwisslipid SWISSLIPID:rank SWISSLIPID:Isomeric_Subspecies .
?isomericsubSwisslipid SWISSLIPID:citation ?pubmed .
}
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v1("?hmdb")
v4("?isomericsubSwisslipid"):::projected
v2("?lipidxIRI")
v5("?pubmed"):::projected
v3("?swisslipid"):::projected
c4(["SWISSLIPID:Isomeric_Subspecies"]):::iri
bind0[/VALUES ?hmdb/]
bind0-->v1
bind00(["HMDB00269"])
bind00 --> bind0
bind01(["MDB00032"])
bind01 --> bind0
bind1[/"concat('http://identifiers.org/lipidx/',?lipidx)"/]
null --o bind1
bind1 --as--o v2
v3 --"rdfs:seeAlso"--> v2
v3 --"rdfs:subClassOf"--> v4
v4 --"SWISSLIPID:rank"--> c4
v4 --"SWISSLIPID:citation"--> v5