Query_132

rq turtle/ttl

• insecta
• species
• publication
• year

Publications referenced in insect cell line entries

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 ?ref_class ?in_year ?id ?title_shortened where {
  ?cl cello:derivedFromIndividualBelongingToSpecies / cello:isIdentifiedByXref ?species_xref .
  ?species_xref cello:more_specific_than* / skos:notation "50557" . # Insecta in NCBI_TaxID
  ?cl cello:references ?ref .
  ?ref a ?ref_class .
  ?ref cello:internalId ?id .
  ?ref cello:title ?title .
  ?ref cello:publicationYear ?year .
  bind(concat('in ', ?year) as ?in_year)
  bind(substr(?title,0,120) as ?title_shortened)
}
order by ?year
limit 1000
    

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v2("?cl")
  v6("?id"):::projected 
  v8("?in_year"):::projected 
  v4("?ref")
  v5("?ref_class"):::projected 
  v3("?species_xref")
  v7("?title")
  v9("?title_shortened"):::projected 
  v1("?year")
  a1((" "))
  a2((" "))
  c5(["50557"]):::literal 
  v2 --"cello:derivedFromIndividualBelongingToSpecies"-->  a1
  a1 --"cello:isIdentifiedByXref"-->  v3
  v3 --"cello:more_specific_than"-->  a2
  a2 --"skos:notation"-->  c5
  v2 --"cello:references"-->  v4
  v4 --"a"-->  v5
  v4 --"cello:internalId"-->  v6
  v4 --"cello:title"-->  v7
  v4 --"cello:publicationYear"-->  v1
  bind0[/"concat('in ',?year)"/]
  v1 --o bind0
  bind0 --as--o v8
  bind1[/"substring(?title,'0^^xsd:integer','120^^xsd:integer')"/]
  v7 --o bind1
  bind1 --as--o v9