SPARQL example query
16: For a given list of LipidX lipid identifiers return the list of corresponding LIPID MAPS IDs. Output should include LipidX ID, the corresponding SwissLipids ID and name, plus the LIPID MAPS ID. This query first identifies SwissLipids identifiers for a given list of LipidX identifiers. It then retrieves the corresponding Isomeric subspecies and from them the required LIPID MAPS identifiers. Extends ID mapping to LipidX identifiers and by using the hierarchy. extends ex:15
SELECT ?TODO WHERE {?TODO a ?TODO}Use17: For a given list of LipidX lipid identifiers return the list of corresponding HMDB IDs. Output should include LipidX ID, the corresponding SwissLipids ID and name, plus the HMDB ID. This query first identifies SwissLipids identifiers for a given list of LipidX identifiers. It then retrieves the corresponding Isomeric subspecies and from them the required HMDB identifiers. Extends ID mapping to LipidX identifiers and by using the hierarchy. extends ex:16
SELECT ?TODO WHERE {?TODO a ?TODO}Use18: For a given list of LipidX lipid identifiers return the list of corresponding ChEBI IDs. Output should include LipidX ID, the corresponding SwissLipids ID and name, plus the HMDB ID. This query first identifies SwissLipids identifiers for a given list of LipidX identifiers. It then retrieves the required ChEBI identifiers from them. Extends ID mapping to LipidX identifiers and by using the hierarchy. extends ex:15
SELECT ?TODO WHERE {?TODO a ?TODO}Use19: For a given list of LipidX lipid identifiers return the list of possible structures and relevant enzymes. Output should include the LipidX ID, the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the proteins. This query first identifies SwissLipids identifiers for a given list of LipidX identifiers. It then retrieves the corresponding Isomeric subspecies, and from them retrieves the list of reactions in which they participate, and the enzymes that catalyze them. extends ex:16
SELECT ?TODO WHERE {?TODO a ?TODO}Use20: Returns the list of lipid analytes identified in a list of tissues (UBERON lipid identifiers). Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the tissues. A simple query which does not traverse the hierarchy.
SELECT ?TODO WHERE {?TODO a ?TODO}Use21: Returns the list of possible lipid structures for a list of tissues (UBERON lipid identifiers). Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the tissues. This query first retrieves SwissLipids identifiers for a given list of UBERON identifiers. It then retrieves the corresponding Isomeric subspecies and returns those. Extends ex:20
SELECT ?TODO WHERE {?TODO a ?TODO}Use22: Returns the list of possible lipid structures for a list of tissues (UBERON lipid identifiers), but considers only those lipids associated with one or more publications. Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the tissues. This query first retrieves SwissLipids identifiers for a given list of UBERON identifiers. It then retrieves the corresponding Isomeric subspecies and returns those that are linked to at least one PMID. As that PMID does not necessarily reflect association to the tissue in question we don’t return that. Extends ex:3, ex:23
SELECT ?TODO WHERE {?TODO a ?TODO}Use23: Returns the list of lipid analytes associated with a list of one or more subcellular locations (GO cellular components). Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the cellular components.
SELECT ?TODO WHERE {?TODO a ?TODO}Use24: Returns the list of possible lipid structures associated with a list of one or more subcellular locations (GO cellular components). Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the cellular components. This query first retrieves SwissLipids identifiers for a given list of GO cellular component identifiers. It then retrieves the corresponding Isomeric subspecies and returns those. Extends ex:25
SELECT ?TODO WHERE {?TODO a ?TODO}Use25: Returns the list of possible lipid structures associated with a list of one or more subcellular locations (GO cellular components), but considers only those lipids associated with one or more publications. Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the cellular components. This query first identifies SwissLipids identifiers for a given list of GO cellular component identifiers. It then retrieves the corresponding Isomeric subspecies and returns those that are linked to at least one PMID. As that PMID does not necessarily reflect association to the cellular compartment in question we don’t return that. Extends ex:3, ex:25
SELECT ?TODO WHERE {?TODO a ?TODO}Use26: Returns the list of lipid analytes associated with a list of one or more organisms (NCBI taxonomic IDs). Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the organisms.
SELECT ?TODO WHERE {?TODO a ?TODO}Use27: Returns the list of possible lipid structures associated with a list of one or more organisms (NCBI taxonomic IDs). Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the organisms. This query first identifies SwissLipids identifiers for a given list of NCBI taxonomic IDs. It then retrieves the corresponding Isomeric subspecies and returns those. Extends ex:26
SELECT ?TODO WHERE {?TODO a ?TODO}Use28: Returns the list of possible lipid structures associated with a list of one or more organisms (NCBI taxonomic IDs), but considers only those lipids associated with one or more publications. Output should include the corresponding SwissLipids ID(s) and name(s), and the name(s) and ID(s) of the organisms. This query first identifies SwissLipids identifiers for a given list of NCBI taxonomic IDs. It then retrieves the corresponding Isomeric subspecies and returns those that are linked to at least one PMID. As that PMID does not necessarily reflect association to the cellular compartment in question we don’t return that. Extends ex:3, ex:28
SELECT ?TODO WHERE {?TODO a ?TODO}Use29: Returns the list of possible lipid structures for a list of tissues (UBERON lipid identifiers), but considers only those lipids associated with LIPID MAPS identifers. Output should include the corresponding SwissLipids ID(s) and name(s), LIPID MAPS identifiers, and the name(s) and ID(s) of the tissues. This query first retrieves SwissLipids identifiers for a given list of UBERON identifiers. It then retrieves the corresponding Isomeric subspecies and returns those that are linked to LIPID MAPS.
SELECT ?TODO WHERE {?TODO a ?TODO}Use30: Returns the list of possible lipid structures for a list of tissues (UBERON lipid identifiers), but considers only those lipids associated with LIPID MAPS identifers. Output should include the corresponding SwissLipids ID(s) and name(s), LIPID MAPS identifiers, and the name(s) and ID(s) of the tissues. This query first retrieves SwissLipids identifiers for a given list of UBERON identifiers. It then retrieves the corresponding Isomeric subspecies and returns those that are linked to LIPID MAPS.
SELECT ?TODO WHERE {?TODO a ?TODO}Use31: Returns the list of possible lipid structures associated with a list of one or more subcellular locations (GO cellular components), but considers only those lipids associated with LIPID MAPS identifers. Output should include the corresponding SwissLipids ID(s) and name(s), LIPID MAPS identifiers, and the name(s) and ID(s) of the subcellular locations (GO cellular components). This query first retrieves SwissLipids identifiers for a given list of subcellular locations (GO cellular component identifiers). It then retrieves the corresponding Isomeric subspecies and returns those that are linked to LIPID MAPS.
SELECT ?TODO WHERE {?TODO a ?TODO}Use32: Returns the list of possible lipid structures associated with a list of one or more organisms (NCBI taxonomic IDs) but considers only those lipids associated with LIPID MAPS identifers. Output should include the corresponding SwissLipids ID(s) and name(s), LIPID MAPS identifiers, and the name(s) and NCBI taxonomic ID(s) of the organisms. This query first retrieves SwissLipids identifiers for a given list of organisms (NCBI taxonomic IDs). It then retrieves the corresponding Isomeric subspecies and returns those that are linked to LIPID MAPS.
SELECT ?TODO WHERE {?TODO a ?TODO}Use33: Returns the list of possible lipid structures associated with a list of one or more subcellular locations (GO cellular components), but considers only those lipids associated with LIPID MAPS identifers. Output should include the corresponding SwissLipids ID(s) and name(s), LIPID MAPS identifiers, and the name(s) and ID(s) of the subcellular locations (GO cellular components). This query first retrieves SwissLipids identifiers for a given list of subcellular locations (GO cellular component identifiers). It then retrieves the corresponding Isomeric subspecies and returns those that are linked to LIPID MAPS.
SELECT ?TODO WHERE {?TODO a ?TODO}Use34: Returns the list of possible lipid structures associated with a list of one or more organisms (NCBI taxonomic IDs) but considers only those lipids associated with LIPID MAPS identifers. Output should include the corresponding SwissLipids ID(s) and name(s), LIPID MAPS identifiers, and the name(s) and NCBI taxonomic ID(s) of the organisms. This query first retrieves SwissLipids identifiers for a given list of organisms (NCBI taxonomic IDs). It then retrieves the corresponding Isomeric subspecies and returns those that are linked to LIPID MAPS.
SELECT ?TODO WHERE {?TODO a ?TODO}Use35: Returns the list of isomeric subspecies containing a specific combination of fatty acids at defined positions. If the user supplies a single fatty acid and position (e.g. hexadecanoate at sn1), find all lipids with that fatty acid at that position, irrespective of whether or not there are other fatty acids at positions (here sn2, sn3). could generalize this query to allow logical combinations of fatty acids (e.g. hexadecanoate at sn1 AND (9Z)-octadecenoate at sn2, hexadecanoate at sn1 AND NOT (9Z)-octadecenoate at sn2, etc) Output should include the corresponding SwissLipids ID(s) and name(s).
SELECT ?TODO WHERE {?TODO a ?TODO}Use36: Returns the list of isomeric subspecies containing a specific combination of fatty acids at defined positions, but only those isomeric subspecies that are associated with a publication. If the user supplies a single fatty acid and position (e.g. hexadecanoate at sn1), find all lipids with that fatty acid at that position, irrespective of whether or not there are other fatty acids at positions (here sn2, sn3). could generalize this query to allow logical combinations of fatty acids (e.g. hexadecanoate at sn1 AND (9Z)-octadecenoate at sn2, hexadecanoate at sn1 AND NOT (9Z)-octadecenoate at sn2, etc) Output should include the corresponding SwissLipids ID(s) and name(s) and PMIDs.
SELECT ?startId ?startName ?tail1 ?tailName1 ?tail2 ?tailName2 ?id ?name ?pubmed WHERE { VALUES ?startId { SWISSLIPID:000121946 } ?startId rdfs:label ?startName . # tail components ?startId SWISSLIPID:haspart ?tail1 . ?startId SWISSLIPID:haspart ?tail2 . FILTER(!sameTerm(?tail1, ?tail2)) ?tail1 rdfs:label ?tailName1 . ?tail2 rdfs:label ?tailName2 . # Retrieve lipids with similar tails ?id SWISSLIPID:haspart ?tail1 , ?tail2 . # Restrict to isomeric subspecies with PubMed citation(s) ?id SWISSLIPID:rank SWISSLIPID:Isomeric_Subspecies . ?id SWISSLIPID:citation ?pubmed . # Retrieve name ?id rdfs:label ?name . } ORDER BY ?id ?tail1 ?tail2Use37: Returns the list of isomeric subspecies that contain the same fatty acid component(s) at the same position(s) as a user-defined lipid. The user supplies a lipid ID, from which we first retrieve the fatty acids and their positions, after which we search for other lipids with the same combination of fatty acids at the same positions. This query could be useful in the website (classification tab): for a given lipid, provide a list of the other lipids with the same “tail” e.g. for PA(16:0/18:1(9Z)) => hexadecanoate@sn1 AND (9Z)-octadecenoate@sn2 => PC(16:0/18:1(9Z)), PE(16:0/18:1(9Z)), PG(16:0/18:1(9Z)), PI(16:0/18:1(9Z)), PIP[3](16:0/18:1(9Z)), PIP[4](16:0/18:1(9Z)), PIP[5](16:0/18:1(9Z)), PI2P[3,4](16:0/18:1(9Z)), PI2P[4,5](16:0/18:1(9Z)), PI2P[3,5](16:0/18:1(9Z)), PI3P[3,4,5](16:0/18:1(9Z)), PS(16:0/18:1(9Z))… Output should include the corresponding SwissLipids ID(s) and name(s).
# Example 37 SELECT ?startId ?startName ?tail1 ?tailName1 ?tail2 ?tailName2 ?id ?name WHERE { VALUES ?startId { SWISSLIPID:000121946 } ?startId rdfs:label ?startName . # tail components ?startId SWISSLIPID:haspart ?tail1 . ?startId SWISSLIPID:haspart ?tail2 . FILTER(!sameTerm(?tail1, ?tail2)) ?tail1 rdfs:label ?tailName1 . ?tail2 rdfs:label ?tailName2 . # Retrieve lipids with similar tails ?id SWISSLIPID:haspart ?tail1 , ?tail2 . # Restrict to isomeric subspecies with PubMed citation(s) ?id SWISSLIPID:rank SWISSLIPID:Isomeric_Subspecies . # Retrieve name ?id rdfs:label ?name . } ORDER BY ?id ?tail1 ?tail2Use38: Returns the list of isomeric subspecies that contain the same fatty acid component(s) at the same position(s) as a user-defined lipid, but limits the output to published lipids linked to a PMID. Output should include the corresponding SwissLipids ID(s) and name(s) and the PMID(s) for each. Extends ex:36 Output should include the corresponding SwissLipids ID(s) and name(s).
# Example 38 SELECT ?startId ?startName ?tail1 ?tailName1 ?tail2 ?tailName2 ?id ?name ?pubmed WHERE { VALUES ?startId { SWISSLIPID:000121946 } ?startId rdfs:label ?startName . # tail components ?startId SWISSLIPID:haspart ?tail1 . ?startId SWISSLIPID:haspart ?tail2 . FILTER(!sameTerm(?tail1, ?tail2)) ?tail1 rdfs:label ?tailName1 . ?tail2 rdfs:label ?tailName2 . # Retrieve lipids with similar tails ?id SWISSLIPID:haspart ?tail1 , ?tail2 . # Restrict to isomeric subspecies with PubMed citation(s) ?id SWISSLIPID:rank SWISSLIPID:Isomeric_Subspecies . ?id SWISSLIPID:citation ?pubmed . # Retrieve name ?id rdfs:label ?name . } ORDER BY ?id ?tail1 ?tail2Use