Query_103

di
disease
individual

Cell lines derived from an individual with a diabetes mellitus or more specific disease

Use at

https://sparql.cellosaurus.org/sparql

PREFIX cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/>
PREFIX skos: <http://www.w3.org/2004/02/skos/core#>
select distinct ?cl ?cl_name ?disease_name ?disease_concept_scheme ?disease_concept_notation  where {
  values ?generic_concept_notation { "C2985" } # notation of Diabetes mellitus in NCIt
  ?cl cello:derivedFromIndividualWithDisease ?disease .
  ?cl cello:recommendedName ?cl_name .
  ?disease cello:name ?disease_name .
  ?disease cello:isIdentifiedByXref ?xref .
  ?xref skos:notation ?disease_concept_notation .
  ?xref skos:inScheme ?disease_concept_scheme .
  ?xref cello:more_specific_than* ?generic_concept .
  ?generic_concept skos:notation ?generic_concept_notation .
  ?generic_concept skos:inScheme ?concept_scheme .
}
order by ?cl
limit 2000
    

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v1("?cl"):::projected 
  v4("?cl_name"):::projected 
  v10("?concept_scheme")
  v3("?disease")
  v7("?disease_concept_notation"):::projected 
  v8("?disease_concept_scheme"):::projected 
  v5("?disease_name"):::projected 
  v9("?generic_concept")
  v2("?generic_concept_notation")
  v6("?xref")
  bind0[/VALUES ?generic_concept_notation/]
  bind0-->v2
  bind00(["C2985"])
  bind00 --> bind0
  v1 --"cello:derivedFromIndividualWithDisease"-->  v3
  v1 --"cello:recommendedName"-->  v4
  v3 --"cello:name"-->  v5
  v3 --"cello:isIdentifiedByXref"-->  v6
  v6 --"skos:notation"-->  v7
  v6 --"skos:inScheme"-->  v8
  v6 --"cello:more_specific_than"-->  v9
  v9 --"skos:notation"-->  v2
  v9 --"skos:inScheme"-->  v10