query-91da276feb698e6c01a9f69ea9c3636a

rq turtle/ttl

title: Which are the available structures found in taxon on Wikidata, for which a PDB structure ID is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?pdb_id) AS ?count) (GROUP_CONCAT(DISTINCT ?pdb_id; SEPARATOR = ", ") AS ?pdb) WHERE { ?structure p:P703 []; p:P235 []; # To exclude proteins wdt:P638 ?pdb_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a PDB structure ID is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?pdb_id) AS ?count) (GROUP_CONCAT(DISTINCT ?pdb_id; SEPARATOR = ", ") AS ?pdb) WHERE { ?structure p:P703 []; p:P235 []; # To exclude proteins wdt:P638 ?pdb_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a PDB structure ID is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?pdb_id) AS ?count) (GROUP_CONCAT(DISTINCT ?pdb_id; SEPARATOR = ", ") AS ?pdb) WHERE { ?structure p:P703 []; p:P235 []; # To exclude proteins wdt:P638 ?pdb_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a PDB structure ID is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?pdb_id) AS ?count) (GROUP_CONCAT(DISTINCT ?pdb_id; SEPARATOR = ", ") AS ?pdb) WHERE { ?structure p:P703 []; p:P235 []; # To exclude proteins wdt:P638 ?pdb_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a PDB structure ID is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?pdb_id) AS ?count) (GROUP_CONCAT(DISTINCT ?pdb_id; SEPARATOR = ", ") AS ?pdb) WHERE { ?structure p:P703 []; p:P235 []; # To exclude proteins wdt:P638 ?pdb_id. } GROUP BY ?structure ORDER BY DESC (?count) title: Which are the available structures found in taxon on Wikidata, for which a PDB structure ID is available? SELECT DISTINCT ?structure (COUNT(DISTINCT ?pdb_id) AS ?count) (GROUP_CONCAT(DISTINCT ?pdb_id; SEPARATOR = ", ") AS ?pdb) WHERE { ?structure p:P703 []; p:P235 []; # To exclude proteins wdt:P638 ?pdb_id. } GROUP BY ?structure ORDER BY DESC (?count)

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX p: <http://www.wikidata.org/prop/>
#title: Which are the available structures found in taxon on Wikidata, for which a PDB structure ID is available?
SELECT DISTINCT ?structure (COUNT(DISTINCT ?pdb_id) AS ?count) (GROUP_CONCAT(DISTINCT ?pdb_id; SEPARATOR = ", ") AS ?pdb) WHERE {
  ?structure p:P703 [];
             p:P235 [];        # To exclude proteins
             wdt:P638 ?pdb_id.
}
GROUP BY ?structure
ORDER BY DESC (?count)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v4("?count") v4("?pdb") v3("?pdb_id"):::projected v2("?structure"):::projected a1((" ")) a2((" ")) v2 --"p:P703"--> a1 v2 --"p:P235"--> a2 v2 --"p:direct/P638"--> v3 bind2[/"count(?pdb_id)"/] v3 --o bind2 bind2 --as--o v4 bind3[/"?pdb_id"/] v3 --o bind3 bind3 --as--o v4