@prefix ex: .
@prefix rdf: .
@prefix rdfs: .
@prefix schema: .
@prefix sh: .
@prefix spex: .
ex:idr_imaged_proteins_grouped_by_their_uniprot_curated_subcellular_location a sh:SPARQLExecutable,
sh:SPARQLSelectExecutable ;
rdfs:label "IDR-imaged proteins grouped by their UniProt-curated subcellular location" ;
rdfs:comment "A federated query that maps the subcellular-compartment coverage of the IDR image collection onto UniProt. For every protein annotated with a UniProt ID in IDR it joins to UniProt's curated Subcellular Location Annotation and groups the results by cellular component, returning for each location the number of distinct imaged proteins, the number of IDR images, and an example image URL."^^rdf:HTML ;
spex:federatesWith ;
sh:select """PREFIX ome:
PREFIX omekg:
PREFIX up:
PREFIX skos:
SELECT ?location ?locationLabel
(COUNT(DISTINCT ?acc) AS ?nProteins)
(COUNT(DISTINCT ?img) AS ?nImages)
(SAMPLE(?imgUrl) AS ?exampleImage)
WHERE {
{
SELECT DISTINCT ?acc ?location ?locationLabel WHERE {
{ SELECT DISTINCT ?acc WHERE { ?e0 ome:key "UniProt ID" ; ome:value ?acc } }
BIND(IRI(CONCAT("http://purl.uniprot.org/uniprot/", ?acc)) AS ?protein)
SERVICE {
?protein up:annotation ?scl .
?scl a up:Subcellular_Location_Annotation ; up:locatedIn ?loc .
?loc up:cellularComponent ?location .
?location skos:prefLabel ?locationLabel .
}
}
}
?e ome:key "UniProt ID" ; ome:value ?acc .
?ann ome:mapEntry ?e .
?img ome:hasAnnotation ?ann ; omekg:ome_details ?imgUrl .
}
GROUP BY ?location ?locationLabel
ORDER BY DESC(?nImages)""" ;
schema:keywords "IDR" , "UniProt" , "subcellular location" , "cellularComponent" , "Protein" , "microscopy" ;
schema:target .