sparql-examples

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

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

Query_155

rq turtle/ttl

Cell lines with a EGFR mutation

Use at


PREFIX cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
select ?cl ?cl_name ?status ?seqvar_class ?seqvar_label ?gene_ac ?gene_name  where {
  values (?seqvar_class ?gene_ac) { (cello:GeneMutation  "HGNC:3236") } # mutations (of) EGFR gene
  ?cl cello:recommendedName ?cl_name .
  ?cl cello:hasSequenceVariationInfo ?annot .
  ?annot cello:variationStatus ?status .
  ?annot cello:hasTarget ?seqvar .
  ?seqvar a ?seqvar_class .
  ?seqvar rdfs:label ?seqvar_label .
  ?seqvar cello:ofGene ?gene .
  ?gene cello:isIdentifiedByXref ?xref .
  ?xref cello:accession ?gene_ac .
  ?xref rdfs:label ?gene_name.
}
order by ?ac
limit 10000
    

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?ac")
  v6("?annot")
  v4("?cl"):::projected 
  v5("?cl_name"):::projected 
  v10("?gene")
  v3("?gene_ac"):::projected 
  v12("?gene_name"):::projected 
  v8("?seqvar")
  v2("?seqvar_class"):::projected 
  v9("?seqvar_label"):::projected 
  v7("?status"):::projected 
  v11("?xref")
  bind0[/VALUES ?gene_ac ?seqvar_class/]
  bind0-->v2
  bind0-->v3
  bind00(["cello:GeneMutation"])
  bind00 --> bind0
  bind01(["HGNC:3236"])
  bind01 --> bind0
  v4 --"cello:recommendedName"-->  v5
  v4 --"cello:hasSequenceVariationInfo"-->  v6
  v6 --"cello:variationStatus"-->  v7
  v6 --"cello:hasTarget"-->  v8
  v8 --"a"-->  v2
  v8 --"rdfs:label"-->  v9
  v8 --"cello:ofGene"-->  v10
  v10 --"cello:isIdentifiedByXref"-->  v11
  v11 --"cello:accession"-->  v3
  v11 --"rdfs:label"-->  v12