A set of SPARQL examples that are used in different SIB resources
Some cell lines with a CDKN2A deletion
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 ?zygozity ?gene_ac ?gene_name where {
values ( ?seqvar_class ?gene_ac_xsd ) { ( cello:GeneDeletion "HGNC:1787") } # HGNC accession of CDKN2A
?cl cello:recommendedName ?cl_name .
?cl cello:hasSequenceVariationInfo ?annot .
?annot cello:variationStatus ?status .
?annot cello:hasTarget ?seqvar .
optional { ?seqvar cello:zygosity ?zygozity . }
?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 ?cl_name
limit 1000
graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
v5("?annot")
v4("?cl"):::projected
v1("?cl_name"):::projected
v10("?gene")
v12("?gene_ac"):::projected
v3("?gene_ac_xsd")
v13("?gene_name"):::projected
v7("?seqvar")
v2("?seqvar_class"):::projected
v9("?seqvar_label"):::projected
v6("?status"):::projected
v11("?xref")
v8("?zygozity"):::projected
bind0[/VALUES ?gene_ac_xsd ?seqvar_class/]
bind0-->v2
bind0-->v3
bind00(["cello:GeneDeletion"])
bind00 --> bind0
bind01(["HGNC:1787"])
bind01 --> bind0
v4 --"cello:recommendedName"--> v1
v4 --"cello:hasSequenceVariationInfo"--> v5
v5 --"cello:variationStatus"--> v6
v5 --"cello:hasTarget"--> v7
subgraph optional0["(optional)"]
style optional0 fill:#bbf,stroke-dasharray: 5 5;
v7 -."cello:zygosity".-> v8
end
v7 --"a"--> v2
v7 --"rdfs:label"--> v9
v7 --"cello:ofGene"--> v10
v10 --"cello:isIdentifiedByXref"--> v11
v11 --"cello:accession"--> v12
v11 --"rdfs:label"--> v13