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: "RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck"
  }
}
rows {
  namespace {
    name: "this"
    value {
      prefix_id: 1
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/RA3U23LL3xbNwsu92fAqsKb0kagOud4f9TlRQq3evNJck#"
  }
}
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: "http://purl.org/dc/terms/"
  }
}
rows {
  namespace {
    name: "dct"
    value {
      prefix_id: 4
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/o/ntemplate/"
  }
}
rows {
  namespace {
    name: "nt"
    value {
      prefix_id: 5
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://purl.org/nanopub/x/"
  }
}
rows {
  namespace {
    name: "npx"
    value {
      prefix_id: 6
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/2001/XMLSchema#"
  }
}
rows {
  namespace {
    name: "xsd"
    value {
      prefix_id: 7
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://www.w3.org/2000/01/rdf-schema#"
  }
}
rows {
  namespace {
    name: "rdfs"
    value {
      prefix_id: 8
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "https://orcid.org/"
  }
}
rows {
  namespace {
    name: "orcid"
    value {
      prefix_id: 9
      name_id: 2
    }
  }
}
rows {
  prefix {
    value: "http://purl.org/np/"
  }
}
rows {
  namespace {
    name: "ns1"
    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-user-stats-from-userid"
  }
}
rows {
  name {
    value: "description"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 2
    }
    p_iri {
      prefix_id: 4
    }
    o_literal {
      lex: "This query returns some general user statistics in the form of number of valid/invalidated/accepted nanopublications published."
    }
    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: 4
      name_id: 14
    }
    o_iri {
      prefix_id: 14
    }
  }
}
rows {
  prefix {
    value: "https://w3id.org/kpxl/grlc/"
  }
}
rows {
  name {
    value: "grlc-query"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 13
      name_id: 10
    }
    o_iri {
      prefix_id: 15
      name_id: 16
    }
  }
}
rows {
  name {
    value: "label"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 8
    }
    o_literal {
      lex: "Get some general user statistics"
    }
  }
}
rows {
  name {
    value: "endpoint"
  }
}
rows {
  prefix {
    value: "https://w3id.org/np/l/nanopub-query-1.1/repo/"
  }
}
rows {
  name {
    value: "meta"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 15
    }
    o_iri {
      prefix_id: 16
    }
  }
}
rows {
  name {
    value: "sparql"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 15
    }
    o_literal {
      lex: "prefix np: <http://www.nanopub.org/nschema#>\r\nprefix npa: <http://purl.org/nanopub/admin/>\r\nprefix npx: <http://purl.org/nanopub/x/>\r\nprefix xsd: <http://www.w3.org/2001/XMLSchema#>\r\nprefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>\r\nprefix dct: <http://purl.org/dc/terms/>\r\nprefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>\r\nprefix nt: <https://w3id.org/np/o/ntemplate/>\r\nprefix bibo: <http://purl.org/ontology/bibo/>\r\nprefix pav: <http://purl.org/pav/>\r\n\r\nselect ?key ?value where {\r\n{\r\nselect ?key (count(?np) as ?value) where {\r\n\r\n    graph npa:graph {\r\n      ?np npa:hasValidSignatureForPublicKey ?pubkey .\r\n      ?np dct:creator ?_userid_iri .\r\n      bind( exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } as ?invalidated )\r\n    }\r\n\r\nbind(if(?invalidated,\"invalidatedNpCount\",\"validNpCount\") as ?key)\r\nvalues ?key { \"invalidatedNpCount\" \"validNpCount\" }\r\n\r\n}\r\ngroup by ?key ?invalidated\r\n}\r\nunion\r\n{\r\nselect ?key (sum(?npcount) as ?value) where {\r\n\r\nbind(\"acceptedNpCount\" as ?key)\r\n\r\noptional { <x:> <x:> ?_userid_iri }  # ensure grlc is picking up the placeholder\r\n\r\nvalues ?npType {\r\n  <https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub>\r\n  <https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub>\r\n  <https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub>\r\n}\r\nbind(uri(concat(\"https://w3id.org/np/l/nanopub-query-1.1/repo/type/\", sha256(str(?npType)))) as ?service)\r\n\r\nservice ?service { select (count(distinct ?np) as ?npcount) where { optional {\r\n  graph npa:graph {\r\n    ?np npa:hasValidSignatureForPublicKey ?pubkey .\r\n    ?np np:hasPublicationInfo ?i .\r\n    filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }\r\n  }\r\n  { {\r\n    graph ?i { ?np pav:authoredBy ?_userid_iri . }\r\n  } union {\r\n    graph ?i {\r\n      ?np bibo:authorList ?authorList .\r\n      ?authorList ?hasElement ?_userid_iri .\r\n      filter(strstarts(str(?hasElement), str(rdf:_)))\r\n    }\r\n  } }\r\n} }\r\ngroup by ?np\r\n} }\r\ngroup by ?key\r\n}\r\n}\r\norder by ?key"
    }
  }
}
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: 9
    }
    g_iri {
      prefix_id: 2
      name_id: 7
    }
  }
}
rows {
  name {
    value: "name"
  }
}
rows {
  quad {
    s_iri {
      prefix_id: 9
      name_id: 22
    }
    p_iri {
      prefix_id: 12
    }
    o_literal {
      lex: "Tobias Kuhn"
    }
    g_iri {
      prefix_id: 2
      name_id: 9
    }
  }
}
rows {
  name {
    value: "sig"
  }
}
rows {
  name {
    value: "hasAlgorithm"
  }
}
rows {
  quad {
    s_iri {
      name_id: 24
    }
    p_iri {
      prefix_id: 6
    }
    o_literal {
      lex: "RSA"
    }
  }
}
rows {
  name {
    value: "hasPublicKey"
  }
}
rows {
  quad {
    p_iri {
    }
    o_literal {
      lex: "MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQD4Wj537OijfOWVtsHMznuXKISqBhtGDQZfdO6pbb4hg9EHMcUFGTLbWaPrP783PHv8HMAAPjvEkHLaOHMIknqhaIa5236lfBO3r+ljVdYBElBcLvROmwG+ZGtmPNZf7lMhI15xf5TfoaSa84AFRd5J2EXekK6PhaFQhRm1IpSYtwIDAQAB"
    }
  }
}
rows {
  name {
    value: "hasSignature"
  }
}
rows {
  quad {
    p_iri {
    }
    o_literal {
      lex: "L3waFYv2e7v7nZnJKEFDlsffil2ZWMRK8MUmuk9nvfR+gn2pu3lUWeXjzZs+UTS6Dl9KR5lXh3oc1UFRDNrCdGjqYGa/OUMw+FTjCNCcP3eqkXW8EcY73qsarHSVh0q4IPnTRJ4QDAiMdVhA6MOKnUUewD3YeD1nG3/5huDZK6Y="
    }
  }
}
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: 6
      name_id: 29
    }
    o_iri {
      prefix_id: 9
      name_id: 22
    }
  }
}
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: 4
      name_id: 30
    }
    o_literal {
      lex: "2024-09-23T10:32:50.049Z"
      datatype: 1
    }
  }
}
rows {
  name {
    value: "creator"
  }
}
rows {
  quad {
    p_iri {
    }
    o_iri {
      prefix_id: 9
      name_id: 22
    }
  }
}
rows {
  prefix {
    id: 5
    value: "https://creativecommons.org/licenses/by/4.0/"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 4
      name_id: 14
    }
    o_iri {
      prefix_id: 5
      name_id: 2
    }
  }
}
rows {
  name {
    value: "introduces"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 32
    }
    o_iri {
      prefix_id: 2
      name_id: 12
    }
  }
}
rows {
  name {
    value: "wasCreatedAt"
  }
}
rows {
  prefix {
    id: 7
    value: "https://nanodash.knowledgepixels.com/"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 6
      name_id: 33
    }
    o_iri {
      prefix_id: 7
      name_id: 2
    }
  }
}
rows {
  prefix {
    id: 10
    value: "https://w3id.org/np/o/ntemplate/"
  }
}
rows {
  name {
    value: "wasCreatedFromProvenanceTemplate"
  }
}
rows {
  prefix {
    id: 3
    value: "http://purl.org/np/"
  }
}
rows {
  name {
    value: "RANwQa4ICWS5SOjw7gp99nBpXBasapwtZF1fIM3H2gYTM"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 10
      name_id: 34
    }
    o_iri {
      prefix_id: 3
    }
  }
}
rows {
  name {
    value: "wasCreatedFromPubinfoTemplate"
  }
}
rows {
  name {
    value: "RAA2MfqdBCzmz9yVWjKLXNbyfBNcwsMmOqcNUxkk1maIM"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 10
    }
    o_iri {
      prefix_id: 3
    }
  }
}
rows {
  name {
    value: "RAh1gm83JiG5M6kDxXhaYT1l49nCzyrckMvTzcPn-iv90"
  }
}
rows {
  quad {
    o_iri {
    }
  }
}
rows {
  name {
    value: "wasCreatedFromTemplate"
  }
}
rows {
  name {
    value: "RAYvkQOT9-zrcql5lzMW9OpiPjA9UvSh-RezaVwYmWvns"
  }
}
rows {
  quad {
    p_iri {
      prefix_id: 10
    }
    o_iri {
      prefix_id: 1
    }
  }
}