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: "RA3eOlVIpCTrzzjK1yzwKMZq-x0vXHMAWhCvhXNKEvTgk"
  }
}
rows {
  namespace {
    name: "this"
    value {
      prefix_id: 1
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/RA3eOlVIpCTrzzjK1yzwKMZq-x0vXHMAWhCvhXNKEvTgk/"
  }
}
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-activity-overview-of-space"
  }
}
rows {
  name {
    value: "description"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
    }
    p_iri {
      prefix_id: 5
    }
    o_literal {
      lex: "Returns one row per kind of activity (study) reported across the projects of a space: the kind with its label, how many activities of that kind there are, and how many projects report at least one. Activities are the resources typed obo:OBI_0000066 (study) that declare themselves part of the space itself or of a space whose IRI extends it with a slash, the same sub-space convention the sibling \'all projects\' views use; the kind is any more specific type the study carries in addition to obo:OBI_0000066, such as the OBI investigation classes or the schema.org study classes offered by the \'Defining a study\' template, labelled from the pubinfo of the study nanopublication, with studies carrying no more specific type reported as \'study (kind unspecified)\'. A study with several specific types counts once under each of them, mirroring the sibling evidence overview query, whose shape this query follows. Only study nanopublications signed by a current admin, maintainer or member of a space in the subtree count, with invalidated, superseded and example nanopublications skipped; the membership lookup is a federated sub-select sharing no variables with the rest of the query, so it runs once."
    }
    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 the activity kinds reported across the projects of 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 np: <http://www.nanopub.org/nschema#>\nprefix npa: <http://purl.org/nanopub/admin/>\nprefix npx: <http://purl.org/nanopub/x/>\nprefix gen: <https://w3id.org/kpxl/gen/terms/>\nprefix dct: <http://purl.org/dc/terms/>\nprefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>\nprefix obo: <http://purl.obolibrary.org/obo/>\n\nselect ?activity_type\n       (min(?typeLabel) as ?activity_type_label)\n       (sum(?n) as ?activities)\n       (count(distinct ?project) as ?projects)\nwhere {\n  {\n    select ?activity_type ?project (min(?typeLabel0) as ?typeLabel) (count(distinct ?study) as ?n) where {\n      values ?_space_multi_iri {}\n      {\n        select (group_concat(?mpk; separator=\" \") as ?memberPubkeys) where {\n          service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> {\n            select ?mpk where {\n              values ?_space_multi_iri {}\n              graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?stateG . }\n              graph ?stateG {\n                ?ri a gen:RoleInstantiation ; npa:forSpace ?sp ; npa:forAgent ?agent ; npa:hasRoleType ?roleType .\n                filter(?roleType in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole))\n                ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?mpk .\n              }\n              filter(?sp = ?_space_multi_iri || strstarts(str(?sp), concat(str(?_space_multi_iri), \"/\")))\n            }\n          }\n        }\n      }\n      graph npa:graph {\n        ?studyNp np:hasAssertion ?studyA ; np:hasPublicationInfo ?studyPi ; npa:hasValidSignatureForPublicKeyHash ?studyPk .\n        filter not exists { ?studyInv npx:invalidates ?studyNp ; npa:hasValidSignatureForPublicKeyHash ?studyPk }\n        filter not exists { ?studySup npx:supersedes ?studyNp }\n        filter not exists { ?studyNp npx:hasNanopubType npx:ExampleNanopub }\n      }\n      filter(contains(?memberPubkeys, ?studyPk))\n      graph ?studyA { ?study a obo:OBI_0000066 ; dct:isPartOf ?project . }\n      filter(?project = ?_space_multi_iri || strstarts(str(?project), concat(str(?_space_multi_iri), \"/\")))\n      # The more specific kind is any further type the study carries; its label is\n      # recorded in the pubinfo of the study nanopublication.\n      optional {\n        graph ?studyA { ?study a ?sub . filter(?sub != obo:OBI_0000066) }\n        optional { graph ?studyPi { ?sub rdfs:label ?subLabel } }\n      }\n      bind(coalesce(?sub, obo:OBI_0000066) as ?activity_type)\n      bind(coalesce(?subLabel, if(bound(?sub), replace(str(?sub), \"^.*[/#]\", \"\"), \"study (kind unspecified)\")) as ?typeLabel0)\n    } group by ?activity_type ?project\n  }\n}\ngroup by ?activity_type\norder by desc(?activities) ?activity_type_label"
    }
  }
}
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-09-13T05:36:15Z"
      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 the activity kinds reported across the projects of a space"
    }
  }
}
rows {
  name {
    value: "wasCreatedFromProvenanceTemplate"
  }
}
rows {
  name {
    value: "RA7lSq6MuK_TIC6JMSHvLtee3lpLoZDOqLJCLXevnrPoU"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 27
    }
    o_iri {
      prefix_id: 1
    }
  }
}
rows {
  name {
    value: "wasCreatedFromPubinfoTemplate"
  }
}
rows {
  name {
    value: "RACJ58Gvyn91LqCKIO9zu1eijDQIeEff28iyDrJgjSJF8"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
    }
    o_iri {
      prefix_id: 1
    }
  }
}
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: "RjAmWzk4EeclRpiOBP2Tj0TbcIPEjMJ/WqLex5m58R1OuTy2yWx2tI6ZG0hWZYhBlhKvhp/RI6LP2X23Wo7IFXbAcfSiy1LklSL6FCkPrI3TrWjklLY+GQRXqQgxqcP3LJFC6ODZtW9c4N7eHReGSlLH7IRXIvQQtF3c/xR0JqI="
    }
  }
}
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: 39
    }
    o_iri {
      prefix_id: 10
      name_id: 22
    }
  }
}