Query_130

rq turtle/ttl

• author
• contributor
• publication
• stats

Top 100 authors of publications referenced in Cellosaurus

Use at

• https://sparql.cellosaurus.org/sparql

PREFIX cello: <https://purl.expasy.org/cellosaurus/rdf/ontology/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX schema: <https://schema.org/>
select ?person_name (count(distinct ?publi) as ?publi_count)
where {
  ?cl a / rdfs:subClassOf cello:CellLine .
  ?cl cello:references ?publi .
  ?publi ?p ?contr .
  ?contr a schema:Person .
  ?contr cello:name ?person_name .
}
group by ?person_name
order by desc(count(distinct(?publi)))
limit 100
    

graph TD
classDef projected fill:lightgreen;
classDef literal fill:orange;
classDef iri fill:yellow;
  v6("?_anon_39b94405334d4c98a94d4349b2e25270265")
  v1("?cl")
  v4("?contr")
  v3("?p")
  v5("?person_name"):::projected 
  v2("?publi"):::projected 
  v7("?publi_count")
  a2((" "))
  a1((" "))
  c3(["cello:CellLine"]):::iri 
  c5([https://schema.org/Person]):::iri 
  v1 --"a"-->  a2
  a2 --"rdfs:subClassOf"-->  c3
  v1 --"cello:references"-->  v2
  v2 -->v3--> v4
  v4 --"a"-->  c5
  v4 --"cello:name"-->  v5
  bind2[/"count(?publi)"/]
  v2 --o bind2
  bind2 --as--o v6
  bind3[/"count(?publi)"/]
  v2 --o bind3
  bind3 --as--o v7