rows { options { physical_type: PHYSICAL_STREAM_TYPE_QUADS max_name_table_size: 128 max_prefix_table_size: 16 max_datatype_table_size: 16 logical_type: LOGICAL_STREAM_TYPE_DATASETS version: 2 } } rows { prefix { value: "https://w3id.org/np/" } } rows { name { value: "RAr8XlsXJ4f_h_9mtf2yBHtIR2CdM5oLHvsA19o5U1NRU" } } rows { namespace { name: "this" value { prefix_id: 1 } } } rows { prefix { value: "https://w3id.org/np/RAr8XlsXJ4f_h_9mtf2yBHtIR2CdM5oLHvsA19o5U1NRU/" } } rows { name { } } rows { namespace { name: "sub" value { prefix_id: 2 } } } rows { prefix { value: "http://www.nanopub.org/nschema#" } } rows { namespace { name: "np" value { prefix_id: 3 name_id: 2 } } } rows { prefix { value: "https://w3id.org/kpxl/grlc/" } } rows { namespace { name: "grlc" value { prefix_id: 4 name_id: 2 } } } rows { prefix { value: "http://purl.org/dc/terms/" } } rows { namespace { name: "dct" value { prefix_id: 5 name_id: 2 } } } rows { prefix { value: "https://w3id.org/np/o/ntemplate/" } } rows { namespace { name: "nt" value { prefix_id: 6 name_id: 2 } } } rows { prefix { value: "http://purl.org/nanopub/x/" } } rows { namespace { name: "npx" value { prefix_id: 7 name_id: 2 } } } rows { prefix { value: "http://www.w3.org/2001/XMLSchema#" } } rows { namespace { name: "xsd" value { prefix_id: 8 name_id: 2 } } } rows { prefix { value: "http://www.w3.org/2000/01/rdf-schema#" } } rows { namespace { name: "rdfs" value { prefix_id: 9 name_id: 2 } } } rows { prefix { value: "https://orcid.org/" } } rows { namespace { name: "orcid" value { prefix_id: 10 name_id: 2 } } } rows { prefix { value: "http://www.w3.org/ns/prov#" } } rows { namespace { name: "prov" value { prefix_id: 11 name_id: 2 } } } rows { prefix { value: "http://xmlns.com/foaf/0.1/" } } rows { namespace { name: "foaf" value { prefix_id: 12 name_id: 2 } } } rows { name { value: "hasAssertion" } } rows { name { value: "assertion" } } rows { name { value: "Head" } } rows { quad { s_iri { prefix_id: 1 name_id: 1 } p_iri { prefix_id: 3 name_id: 3 } o_iri { prefix_id: 2 } g_iri { } } } rows { name { value: "hasProvenance" } } rows { name { value: "provenance" } } rows { quad { p_iri { prefix_id: 3 } o_iri { prefix_id: 2 } } } rows { name { value: "hasPublicationInfo" } } rows { name { value: "pubinfo" } } rows { quad { p_iri { prefix_id: 3 } o_iri { prefix_id: 2 } } } rows { prefix { value: "http://www.w3.org/1999/02/22-rdf-syntax-ns#" } } rows { name { value: "type" } } rows { name { value: "Nanopublication" } } rows { quad { p_iri { prefix_id: 13 } o_iri { prefix_id: 3 } } } rows { name { value: "get-space-knowledge-product-counts" } } rows { name { value: "description" } } rows { quad { s_iri { prefix_id: 2 } p_iri { prefix_id: 5 } o_literal { lex: "Returns one row per direct sub-space (project) of the given space, with the number of knowledge products the project has delivered per category (all ff:has-* output relations, formal FAIR outputs as well as informal / public-engagement outputs) and a total count. Sub-spaces without any products are included with zero counts; products of deeper nested sub-spaces are rolled up to the direct sub-space. Restricted to links authored by a member, maintainer, or admin of some space in the subtree." } g_iri { prefix_id: 2 name_id: 4 } } } rows { name { value: "license" } } rows { prefix { value: "http://www.apache.org/licenses/" } } rows { name { value: "LICENSE-2.0" } } rows { quad { p_iri { prefix_id: 5 name_id: 14 } o_iri { prefix_id: 14 } } } rows { name { value: "grlc-query" } } rows { quad { p_iri { prefix_id: 13 name_id: 10 } o_iri { prefix_id: 4 name_id: 16 } } } rows { name { value: "label" } } rows { quad { p_iri { prefix_id: 9 } o_literal { lex: "Get knowledge product counts per project for a space" } } } rows { name { value: "endpoint" } } rows { prefix { value: "https://w3id.org/np/l/nanopub-query-1.1/repo/" } } rows { name { value: "full" } } rows { quad { p_iri { prefix_id: 4 } o_iri { prefix_id: 15 } } } rows { name { value: "sparql" } } rows { quad { p_iri { prefix_id: 4 } o_literal { lex: "prefix rdfs: \nprefix np: \nprefix npa: \nprefix npx: \nprefix gen: \nprefix ff: \n\nselect ?Project (coalesce(min(?plabel), replace(str(?project), \"^.*/\", \"\")) as ?Project_label)\n (count(distinct if(?outputProp = ff:has-article, ?output, ?undefined)) as ?Articles)\n (count(distinct if(?outputProp = ff:has-dataset, ?output, ?undefined)) as ?Datasets)\n (count(distinct if(?outputProp = ff:has-software, ?output, ?undefined)) as ?Software)\n (count(distinct if(?outputProp = ff:has-method, ?output, ?undefined)) as ?Methods)\n (count(distinct if(?outputProp = ff:has-dmp, ?output, ?undefined)) as ?DMPs)\n (count(distinct if(?outputProp = ff:has-preregistration, ?output, ?undefined)) as ?Preregistrations)\n (count(distinct if(?outputProp = ff:has-presentation, ?output, ?undefined)) as ?Presentations)\n (count(distinct if(?outputProp = ff:has-blog-post, ?output, ?undefined)) as ?Blogs)\n (count(distinct if(?outputProp = ff:has-media-coverage, ?output, ?undefined)) as ?Media)\n (count(distinct if(?outputProp = ff:has-social-post, ?output, ?undefined)) as ?Social)\n (count(distinct if(?outputProp = ff:has-podcast, ?output, ?undefined)) as ?Podcasts)\n (count(distinct if(?outputProp = ff:has-discussion, ?output, ?undefined)) as ?Discussions)\n (count(distinct concat(str(?outputProp), \"|\", str(?output))) as ?Total)\nwhere {\n service {\n select ?project ?memberPubkeys where {\n { select (group_concat(distinct ?mpk; separator=\" \") as ?memberPubkeys) where {\n graph npa:graph { npa:hasCurrentSpaceState ?stateG . }\n values ?_space_multi_iri {}\n graph ?stateG {\n ?ri a gen:RoleInstantiation ; npa:forSpace ?proj ; npa:forAgent ?agent ; npa:hasRoleType ?rt .\n filter(?rt in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole))\n filter(?proj = ?_space_multi_iri || strstarts(str(?proj), concat(str(?_space_multi_iri), \"/\")))\n ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?mpk .\n }\n } }\n graph npa:graph { npa:hasCurrentSpaceState ?stateG2 . }\n values ?_space_multi_iri {}\n graph ?stateG2 { ?_space_multi_iri npa:hasSubSpace ?project . }\n }\n }\n optional {\n graph npa:graph {\n ?np npa:hasValidSignatureForPublicKeyHash ?npPubkey .\n filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?npPubkey . }\n filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }\n ?np np:hasAssertion ?a .\n }\n filter(contains(?memberPubkeys, ?npPubkey))\n graph ?a { ?p ?outputProp ?output . }\n values ?outputProp { ff:has-article ff:has-dataset ff:has-software ff:has-method ff:has-dmp ff:has-preregistration ff:has-presentation ff:has-blog-post ff:has-media-coverage ff:has-social-post ff:has-podcast ff:has-discussion }\n filter(?p = ?project || strstarts(str(?p), concat(str(?project), \"/\")))\n }\n optional {\n graph npa:graph {\n ?lnp npa:hasValidSignatureForPublicKeyHash ?lpk .\n filter not exists { ?lnpx npx:invalidates ?lnp ; npa:hasValidSignatureForPublicKeyHash ?lpk . }\n ?lnp np:hasAssertion ?la .\n }\n filter(contains(?memberPubkeys, ?lpk))\n graph ?la { ?project rdfs:label ?plabel . }\n }\n bind(?project as ?Project)\n}\ngroup by ?project ?Project\norder by ?project" } } } rows { name { value: "wasAttributedTo" } } rows { name { value: "0000-0002-1267-0234" } } rows { quad { s_iri { prefix_id: 2 name_id: 4 } p_iri { prefix_id: 11 name_id: 21 } o_iri { prefix_id: 10 } g_iri { prefix_id: 2 name_id: 7 } } } rows { name { value: "name" } } rows { quad { s_iri { prefix_id: 10 name_id: 22 } p_iri { prefix_id: 12 } o_literal { lex: "Tobias Kuhn" } g_iri { prefix_id: 2 name_id: 9 } } } rows { name { value: "created" } } rows { datatype { value: "http://www.w3.org/2001/XMLSchema#dateTime" } } rows { quad { s_iri { prefix_id: 1 name_id: 1 } p_iri { prefix_id: 5 name_id: 24 } o_literal { lex: "2026-08-19T09:56:49Z" datatype: 1 } } } rows { name { value: "creator" } } rows { quad { p_iri { } o_iri { prefix_id: 10 name_id: 22 } } } rows { prefix { value: "https://creativecommons.org/licenses/by/4.0/" } } rows { quad { p_iri { prefix_id: 5 name_id: 14 } o_iri { prefix_id: 16 name_id: 2 } } } rows { name { value: "embeds" } } rows { quad { p_iri { prefix_id: 7 name_id: 26 } o_iri { prefix_id: 2 name_id: 12 } } } rows { quad { p_iri { prefix_id: 9 name_id: 17 } o_literal { lex: "Get knowledge product counts per project for a space" } } } rows { name { value: "wasCreatedFromProvenanceTemplate" } } rows { prefix { id: 8 value: "http://purl.org/np/" } } rows { name { value: "RAcm8OurwUk15WOgBM9wySo-T3a5h6as4K8YR5MBrrxUc" } } rows { quad { p_iri { prefix_id: 6 name_id: 27 } o_iri { prefix_id: 8 } } } rows { name { value: "wasCreatedFromPubinfoTemplate" } } rows { name { value: "RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8" } } rows { quad { p_iri { prefix_id: 6 } o_iri { prefix_id: 1 } } } rows { name { value: "RARW4MsFkHuwjycNElvEVtuMjpf4yWDL10-0C5l2MqqRQ" } } rows { quad { o_iri { } } } rows { name { value: "RAoTD7udB2KtUuOuAe74tJi1t3VzK0DyWS7rYVAq1GRvw" } } rows { quad { o_iri { } } } rows { name { value: "RAukAcWHRDlkqxk7H2XNSegc1WnHI569INvNr-xdptDGI" } } rows { quad { o_iri { } } } rows { name { value: "wasCreatedFromTemplate" } } rows { name { value: "RAEFAt-QcFK0ZhqfvlsmS10BnzGJA0xwOICZXkO-ai87k" } } rows { quad { p_iri { prefix_id: 6 } o_iri { prefix_id: 1 } } } rows { name { value: "sig" } } rows { name { value: "hasAlgorithm" } } rows { quad { s_iri { prefix_id: 2 } p_iri { prefix_id: 7 } o_literal { lex: "RSA" } } } rows { name { value: "hasPublicKey" } } rows { quad { p_iri { } o_literal { lex: "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCwUtewGCpT5vIfXYE1bmf/Uqu1ojqnWdYxv+ySO80ul8Gu7m8KoyPAwuvaPj0lvPtHrg000qMmkxzKhYknEjq8v7EerxZNYp5B3/3+5ZpuWOYAs78UnQVjbHSmDdmryr4D4VvvNIiUmd0yxci47dTFUj4DvfHnGd6hVe5+goqdcwIDAQAB" } } } rows { name { value: "hasSignature" } } rows { quad { p_iri { } o_literal { lex: "Vgc1V4qtQ/P0e9lfoyQBV26vjNjLPZvzIHSFSz/fxSiIsNAPWiEOhkZPxFdMSkVvyLXbQSn/DHpEV/1GpBmMbZXkc0pdAdrseLsyPlAJ7CSxhcoxTk3NTtPNCRRTmvd2iA8Ket9iRqZopFKlgKiN1ca9ZeOIwYAu6+KSRDxXQZk=" } } } rows { name { value: "hasSignatureTarget" } } rows { quad { p_iri { } o_iri { prefix_id: 1 name_id: 1 } } } rows { name { value: "signedBy" } } rows { quad { p_iri { prefix_id: 7 name_id: 41 } o_iri { prefix_id: 10 name_id: 22 } } }