sparql-examples

A set of SPARQL examples that are used in different SIB resources

View the Project on GitHub sib-swiss/sparql-examples

15

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

Use at

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