Nanopublications

Matches in Nanopublications for { ?s <https://w3id.org/kpxl/grlc/sparql> ?o ?g. }

Showing items 501 to 600 of ±731 with 100 items per page.

first
previous
next

get-recommended-fsrs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix fip: <https://w3id.org/fair/fip/terms/> select distinct ?fsr ?fsr_label (group_concat(distinct ?community_link; separator = ', ') as ?communities) where { graph npa:graph { ?np npx:hasNanopubType fip:recommended-by . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?fsr fip:recommended-by ?community . } { select ?fsr ?fsr_label where { { select ?latest_curators_assertion where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } } } graph npa:graph { ?np npx:introduces|npx:describes ?fsr . ?np rdfs:label ?fsr_label ; npa:hasValidSignatureForPublicKey ?pubkey ; dct:created ?date . filter(str(?date) > "2022") filter exists { ?np npx:hasNanopubType ?fsr_type . values ?fsr_type { fip:FAIR-Enabling-Resource fip:FAIR-Supporting-Resource } } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } filter not exists { graph ?da { ?disapprover npx:disapprovesOf ?np . } graph npa:graph { ?disapproval_np np:hasAssertion ?da ; npa:hasValidSignatureForPublicKey ?dpubkey . filter not exists { ?disapproval_npx npx:invalidates ?disapproval_np ; npa:hasValidSignatureForPublicKey ?dpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?dpubkey . } } } } { select ?community ?community_label where { graph npa:graph { ?np npx:hasNanopubType fip:FAIR-Implementation-Community . ?np npa:hasValidSignatureForPublicKey ?pubkey ; dct:created ?date ; np:hasAssertion ?a . ?np npx:introduces|npx:describes ?community . ?np dct:created ?date . filter(str(?date) > "2022") filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?a { ?community a fip:FAIR-Implementation-Community ; rdfs:label ?community_label . } } } bind(concat('<a href="', str(?community), '">', str(?community_label), '</a>') as ?community_link) } group by ?fsr ?fsr_label order by ?fsr_label" assertion.
get-highlights sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix oa: <http://www.w3.org/ns/oa#> select ?comment ?source ?text_quote ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType oa:Annotation . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?annotation . ?np np:hasAssertion ?a . } graph ?a { ?annotation a oa:Annotation . ?annotation oa:motivatedBy oa:highlighting . ?annotation oa:hasBody ?body . ?body rdf:value ?comment . ?annotation oa:hasTarget ?target . ?target oa:hasSource ?source . ?target oa:hasSelector ?selector . ?selector oa:exact ?text_quote . } } order by desc(?date)" assertion.
get-latest-variables sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix iadopt: <https://w3id.org/iadopt/ont/> select ?variable (min(?variable_label) as ?variable_label) ?creator ?np ?date where { graph npa:graph { ?np npx:hasNanopubType iadopt:Variable . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np npx:introduces ?variable . ?np npx:signedBy ?creator . } graph ?a { ?variable a iadopt:Variable . ?variable rdfs:label ?variable_label . } } group by ?variable ?creator ?np ?date order by desc(?date)" assertion.
get-latest-variables sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix iadopt: <https://w3id.org/iadopt/ont/> prefix skos: <http://www.w3.org/2004/02/skos/core#> select ?variable (coalesce(?variable_prefLabel, min(?variable_label)) as ?variable_label) ?creator ?np ?date where { graph npa:graph { ?np npx:hasNanopubType iadopt:Variable . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?variable . ?np npx:signedBy ?creator . } graph ?a { ?variable a iadopt:Variable . optional { ?variable rdfs:label ?variable_label . } optional { ?variable skos:prefLabel ?variable_prefLabel . } } } group by ?variable ?variable_prefLabel ?creator ?np ?date order by desc(?date)" assertion.
get-latest-variables sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix iadopt: <https://w3id.org/iadopt/ont/> prefix skos: <http://www.w3.org/2004/02/skos/core#> select ?variable (coalesce(?variable_prefLabel, min(?variable_label)) as ?variable_label) ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType iadopt:Variable . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?variable . ?np npx:signedBy ?creator . } graph ?a { ?variable a iadopt:Variable . optional { ?variable rdfs:label ?variable_label . } optional { ?variable skos:prefLabel ?variable_prefLabel . } } } group by ?variable ?variable_prefLabel ?creator ?np ?date order by desc(?date)" assertion.
get-collections-for-resource sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix dcmitype: <http://purl.org/dc/dcmitype/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?collection ?collection_label ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType dcmitype:Collection . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?collection } graph ?a { ?collection a dcmitype:Collection . ?collection rdfs:label ?collection_label . optional { ?collection dct:description ?description } values ?_resource_multi_iri {} ?collection dct:isPartOf|gen:isMaintainedBy ?_resource_multi_iri . } } order by ?collection_label" assertion.
get-planned-event-attendances sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?event ?event_label ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:plansToAttend . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np npx:signedBy ?_user_iri . ?np np:hasAssertion ?a . } graph ?a { ?_user_iri gen:plansToAttend ?event . optional { ?event rdfs:label ?event_label } optional { ?event dct:date ?date } } } order by desc(?date)" assertion.
get-all-user-intros sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npx: <http://purl.org/nanopub/x/> prefix npa: <http://purl.org/nanopub/admin/> prefix dct: <http://purl.org/dc/terms/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?user ?name ?isSoftware ?intronp ?date ?pubkey ?pubkeyHash ?authoritative ?keyLocation where { graph npa:graph { ?intronp npa:hasValidSignatureForPublicKey ?introPubkey . filter not exists { ?intronpx npx:invalidates ?intronp ; npa:hasValidSignatureForPublicKey ?introPubkey . } ?intronp dct:created ?date . ?intronp np:hasAssertion ?a . } graph ?a { ?keydeclaration npx:declaredBy ?user . ?keydeclaration npx:hasPublicKey ?pubkey . optional { ?user foaf:name ?name . } optional { ?keydeclaration npx:hasKeyLocation ?keyLocation . } bind(exists { ?user a npx:SoftwareAgent } as ?isSoftware) } bind(?pubkey = ?introPubkey as ?authoritative) bind(sha256(?pubkey) as ?pubkeyHash) } order by ?user desc(?authoritative) desc(?date)" assertion.
get-sub-resources sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?space ?space_label ?entity_main_type ?np where { graph npa:graph { values ?entity_main_type { gen:Space gen:MaintainedResource } ?np npx:hasNanopubType ?entity_main_type . ?np npx:introduces ?space . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { values ?_super_resource_multi_iri {} { { ?space a ?entity_main_type . filter(strstarts(str(?space), concat(str(?_super_resource_multi_iri), "/"))) } union { ?space a gen:Space . ?space dct:isPartOf ?_super_resource_multi_iri . } union { ?space a gen:MaintainedResource . ?space gen:isMaintainedBy ?_super_resource_multi_iri . } } filter exists { ?space a ?__resource_type_iri } ?space rdfs:label ?space_label . } } order by ?space_label" assertion.
get-sub-resources sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?space ?space_label ?entity_main_type ?np where { graph npa:graph { values ?entity_main_type { gen:Space gen:MaintainedResource } ?np npx:hasNanopubType ?entity_main_type . ?np npx:introduces ?space . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { { { values ?_super_resource_multi_iri {} ?space a ?entity_main_type . filter(strstarts(str(?space), concat(str(?_super_resource_multi_iri), "/"))) } union { values ?_super_resource_multi_iri {} ?space a gen:Space . ?space dct:isPartOf ?_super_resource_multi_iri . } union { values ?_super_resource_multi_iri {} ?space a gen:MaintainedResource . ?space gen:isMaintainedBy ?_super_resource_multi_iri . } } filter exists { ?space a ?__resource_type_iri } ?space rdfs:label ?space_label . } } order by ?space_label" assertion.
get-sub-resources sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?resource ?resource_label ?entity_main_type ?np where { graph npa:graph { values ?entity_main_type { gen:Space gen:MaintainedResource } ?np npx:hasNanopubType ?entity_main_type . ?np npx:introduces ?resource . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { { { values ?_super_resource_multi_iri {} ?resource a ?entity_main_type . filter(strstarts(str(?resource), concat(str(?_super_resource_multi_iri), "/"))) bind(substr(str(?resource), strlen(str(?_super_resource_multi_iri)) + 2, strlen(str(?resource)) - strlen(str(?_super_resource_multi_iri)) - 1) as ?suffix) filter(!contains(?suffix, "/")) } union { values ?_super_resource_multi_iri {} ?resource a gen:Space . ?resource dct:isPartOf ?_super_resource_multi_iri . } union { values ?_super_resource_multi_iri {} ?resource a gen:MaintainedResource . ?resource gen:isMaintainedBy ?_super_resource_multi_iri . } } filter exists { ?resource a ?__resource_type_iri } ?resource rdfs:label ?resource_label . } } order by ?resource_label" assertion.
get-filtered-nanopub-list sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np ?label ?date (group_concat(distinct ?t; separator=' ') as ?types) (?__pubkeys_multi as ?pubkey) where { graph npa:graph { values ?__pubkeys_multi {} ?np npa:hasValidSignatureForPublicKeyHash ?__pubkeys_multi . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?__pubkeys_multi . } values ?__types_multi_iri {} ?np npx:hasNanopubType ?__types_multi_iri . ?np npx:hasNanopubType ?t . ?np dct:created ?date . bind(coalesce(?__endtime, "9999") as ?endtime) filter(?endtime > str(?date)) bind(coalesce(?__starttime, "0000") as ?starttime) filter(?starttime < str(?date)) optional { ?np rdfs:label ?label } } } group by ?np ?label ?date ?__pubkeys_multi order by desc(?date) limit 100" assertion.
get-items-of-collection sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?item ?item_label ?type ?source ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:CollectionElement . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?item . } graph ?a { ?item a ?type . filter(?type != gen:CollectionElement) ?item rdfs:label ?item_label . optional { ?item dct:source ?source } values ?_collection_multi_iri {} ?item dct:isPartOf ?_collection_multi_iri . } } order by ?item_label" assertion.
get-messages-about-resource sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix schema: <https://schema.org/> select ?text (group_concat(concat('<a href="', str(?link), '">link</a>'); separator=", ") as ?link) ?user ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np dct:creator ?user . ?np np:hasAssertion ?a . } graph ?a { ?a rdfs:label ?text . values ?_resource_multi_iri {} ?a schema:about ?_resource_multi_iri . optional { ?a rdfs:seeAlso ?link . } } } group by ?text ?user ?date ?np order by desc(?date)" assertion.
get-taxontaxon-nanopubs sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix biolink: <https://w3id.org/biolink/vocab/> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> select distinct ?np ?label ?subjtaxonname ?subjtaxonlabel ?rel ?objtaxonname ?objtaxonlabel ?source ?date where { graph npa:graph { ?np npx:hasNanopubType biolink:OrganismTaxonToOrganismTaxonAssociation . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np np:hasProvenance ?p . ?np np:hasPublicationInfo ?i . optional { ?np rdfs:label ?label } } graph ?a { ?association a biolink:OrganismTaxonToOrganismTaxonAssociation . ?association biolink:subject ?subjtaxon . ?subjtaxon biodiv:hasTaxonName ?subjtaxonname . ?association biolink:predicate ?rel . ?association biolink:object ?objtaxon . ?objtaxon biodiv:hasTaxonName ?objtaxonname . } graph <http://purl.org/np/RAVTdAMPj7oOfekUVyIcrXX9HheGa_0QCC5-PK7Di8DPg/assertion> { ?rel rdfs:label ?rellabel . } optional { graph ?p { ?a prov:wasDerivedFrom ?source } } graph ?i { optional { ?subjtaxonname nt:hasLabelFromApi ?subjtaxonlabel . } optional { ?objtaxonname nt:hasLabelFromApi ?objtaxonlabel . } } } order by desc(?date)" assertion.
get-papers-for-author sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix fabio: <http://purl.org/spar/fabio/> prefix bibo: <http://purl.org/ontology/bibo/> select ?paper ?paper_label ?journal ?journal_label ?publication_date where { values ?_author_multi_iri {} graph npa:graph { ?np npx:hasNanopubType fabio:ScholarlyWork . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?paper . } graph ?a { ?paper dct:title ?paper_label . ?paper bibo:authorList ?author_list . ?paper dct:date ?publication_date . ?author_list ?rdfseqpred ?_author_multi_iri . filter(strstarts(str(?rdfseqpred), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) optional { ?paper dct:isPartOf ?journal . ?journal dct:title ?journal_label . } } }" assertion.
get-papers-for-author sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix fabio: <http://purl.org/spar/fabio/> prefix bibo: <http://purl.org/ontology/bibo/> select ?paper ?paper_label ?journal ?journal_label ?publication_date where { values ?_author_multi_iri {} graph npa:graph { ?np npx:hasNanopubType fabio:ScholarlyWork . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?paper . } graph ?a { ?paper dct:title ?paper_label . ?paper bibo:authorList ?author_list . ?paper dct:date ?publication_date . ?author_list ?rdfseqpred ?_author_multi_iri . filter(strstarts(str(?rdfseqpred), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) optional { ?paper dct:isPartOf ?journal . ?journal dct:title ?journal_label . } } } order by desc(?publication_date)" assertion.
get-classes-of-ontology-ns sparql "prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> select distinct ?class ?class_label (?definition as ?description) ?superclass ?np ("^" as ?np_label) where { values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType owl:Class . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?class . ?np np:hasAssertion ?a . } graph ?a { {{ ?class a owl:Class . filter(strstarts(str(?class), ?__ontologyNamespace)) } union { ?class a owl:Class . ?class dct:partOf ?_ontology_multi_iri . }} optional { ?class rdfs:subClassOf ?superclass . } optional { ?class rdfs:label ?class_label . } optional { ?class skos:definition ?definition . } } } order by ?class_label" assertion.
get-ai-in-edu-approaches sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?approach ?approach_label ?class ?reference ?reference_label ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType <https://w3id.org/spaces/AI-in-education/r/terms/AI-in-Education-approach> . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:signedBy ?creator . ?np np:hasAssertion ?a . ?np npx:introduces ?approach . } graph ?a { ?approach a <https://w3id.org/spaces/AI-in-education/r/terms/AI-in-Education-approach> . optional { ?approach a ?class . filter(?class != <https://w3id.org/spaces/AI-in-education/r/terms/AI-in-Education-approach>) } ?approach rdfs:label ?approach_label . ?approach dct:source ?reference . ?reference rdfs:label ?reference_label . } }" assertion.
get-urban-organism-associations sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix biolink: <https://w3id.org/biolink/vocab/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?relation ?relation_label ?taxon_name ?taxon_name_label ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType biodiv:OrganismToEnvironmentAssociation . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np dct:created ?date . ?np dct:creator ?creator . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . optional { ?np rdfs:label ?label } } graph ?a { ?association a biodiv:OrganismToEnvironmentAssociation . ?association biolink:subject ?organism . ?organism a ?taxonConcept . ?taxonConcept biodiv:hasTaxonName ?taxon_name . ?association biolink:predicate ?relation . ?association biolink:object <http://purl.obolibrary.org/obo/ENVO_00000856> . } optional { graph ?i { ?taxon_name nt:hasLabelFromApi ?taxon_name_label . } } optional { graph ?i { ?relation nt:hasLabelFromApi ?relation_label . } } optional { graph ?i { values (?relation ?relation_label) { ( <http://purl.obolibrary.org/obo/RO_0002303> "has habitat" ) } } } } order by desc(?date)" assertion.
get-spaces-and-roles-for-agent sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select distinct ?space (group_concat(?role; separator=" ") as ?roles) where { values ?_agent_multi_iri {} { { graph npa:graph { ?spaceRole_np npx:hasNanopubType gen:SpaceMemberRole . ?spaceRole_np npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . filter not exists { ?spaceRole_npx npx:invalidates ?spaceRole_np ; npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . } ?spaceRole_np np:hasAssertion ?spaceRole_a . } graph ?spaceRole_a { ?space gen:hasRole ?role . } } union { bind(<https://w3id.org/np/RA_eEJjQbxzSqYSwPzfjzOZi5sMPpUmHskFNsgJYSws8I/adminRole> as ?role) } } graph ?role_a { ?role a gen:SpaceMemberRole . ?role rdfs:label ?roleLabel . ?role dct:title ?roleTitle . ?role schema:name ?roleName . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } { { graph ?role_a { ?role gen:hasRegularProperty ?reg . } graph ?link_a { ?_agent_multi_iri ?reg ?space . } bind(?reg as ?property) bind(false as ?inverse) } union { graph ?role_a { ?role gen:hasInverseProperty ?inv . } graph ?link_a { ?space ?inv ?_agent_multi_iri . } bind(?inv as ?property) bind(true as ?inverse) } } graph npa:graph { ?link_np np:hasAssertion ?link_a . ?link_np npa:hasValidSignatureForPublicKeyHash ?link_pubkey . filter not exists { ?link_npx npx:invalidates ?link_np ; npa:hasValidSignatureForPublicKeyHash ?link_pubkey . } ?link_np dct:created ?link_date . } } group by ?space order by ?space" assertion.
get-spaces-for-agent sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select distinct ?space where { values ?_agent_multi_iri {} { { graph npa:graph { ?spaceRole_np npx:hasNanopubType gen:SpaceMemberRole . ?spaceRole_np npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . filter not exists { ?spaceRole_npx npx:invalidates ?spaceRole_np ; npa:hasValidSignatureForPublicKeyHash ?spaceRole_pubkey . } ?spaceRole_np np:hasAssertion ?spaceRole_a . } graph ?spaceRole_a { ?space gen:hasRole ?role . } } union { bind(<https://w3id.org/np/RA_eEJjQbxzSqYSwPzfjzOZi5sMPpUmHskFNsgJYSws8I/adminRole> as ?role) } } graph ?role_a { ?role a gen:SpaceMemberRole . ?role rdfs:label ?roleLabel . ?role dct:title ?roleTitle . ?role schema:name ?roleName . } graph npa:graph { ?role_np npx:embeds ?role . ?role_np np:hasAssertion ?role_a . } { { graph ?role_a { ?role gen:hasRegularProperty ?reg . } graph ?link_a { ?_agent_multi_iri ?reg ?space . } bind(?reg as ?property) bind(false as ?inverse) } union { graph ?role_a { ?role gen:hasInverseProperty ?inv . } graph ?link_a { ?space ?inv ?_agent_multi_iri . } bind(?inv as ?property) bind(true as ?inverse) } } graph npa:graph { ?link_np np:hasAssertion ?link_a . ?link_np npa:hasValidSignatureForPublicKeyHash ?link_pubkey . filter not exists { ?link_npx npx:invalidates ?link_np ; npa:hasValidSignatureForPublicKeyHash ?link_pubkey . } ?link_np dct:created ?link_date . } } order by desc(?link_date)" assertion.
get-classes-of-ontology-ns sparql "prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> select distinct ?class ?class_label (?definition as ?description) ?np ("^" as ?np_label) where { values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType owl:Class . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?class . ?np np:hasAssertion ?a . } graph ?a { {{ ?class a owl:Class . filter(strstarts(str(?class), ?__ontologyNamespace)) } union { ?class a owl:Class . ?class dct:partOf ?_ontology_multi_iri . }} optional { ?class rdfs:subClassOf ?superclass . } optional { ?class rdfs:label ?class_label . } optional { ?class skos:definition ?definition . } } } order by ?class_label" assertion.
get-filtered-nanopub-list sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np ?label ?date (group_concat(distinct ?t; separator=' ') as ?types) (?__np_pubkeys_multi as ?pubkey) where { graph npa:graph { values ?__np_pubkeys_multi {} ?np npa:hasValidSignatureForPublicKeyHash ?__np_pubkeys_multi . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?__np_pubkeys_multi . } values ?__types_multi_iri {} ?np npx:hasNanopubType ?__types_multi_iri . ?np npx:hasNanopubType ?t . ?np dct:created ?date . bind(coalesce(?__np_endtime, "9999") as ?endtime) filter(?endtime > str(?date)) bind(coalesce(?__np_starttime, "0000") as ?starttime) filter(?starttime < str(?date)) optional { ?np rdfs:label ?label } } } group by ?np ?label ?date ?__np_pubkeys_multi order by desc(?date) limit 100" assertion.
get-weekly-active-user-count sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?approxweek (substr(str(min(?date)), 0, 11) as ?firstday) (count(distinct ?userid) as ?usercount) where { { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:creator ?userid . ?np dct:created ?date . } } union { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasAssertion ?assertion . ?np np:hasProvenance ?prov . ?np dct:created ?date . ?np dct:creator ?tool . values ?tool { <https://fip-wizard.ds-wizard.org/wizard> } } graph ?prov { ?assertion prov:wasAttributedTo ?userid . } } filter not exists { graph npa:graph { ?np npa:hasSubIri ?userid . } } bind(xsd:integer((year(?date)*365 + month(?date)*365/12 + day(?date)) / 7) as ?approxweek) } group by ?approxweek order by desc(?approxweek)" assertion.
get-relevant-resources sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?resource ?resource_label ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:isRelevantFor . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . optional { ?np rdfs:label ?label } } values ?_entity_multi_iri {} graph ?a { ?resource gen:isRelevantFor ?_entity_multi_iri . optional { ?resource rdfs:label ?resource_label . } } }" assertion.
get-environments-for-taxon sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix biolink: <https://w3id.org/biolink/vocab/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select distinct ?relation ?relation_label ?environment ?environment_label ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType biolink:OrganismTaxonToEnvironmentAssociation . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?association . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . } graph ?a { ?association a biolink:OrganismTaxonToEnvironmentAssociation . ?association biolink:subject ?taxonConcept . ?taxonConcept biodiv:hasTaxonName ?_taxonname_iri . ?association biolink:predicate ?relation . ?association biolink:object ?environment . } optional { graph ?i { ?relation nt:hasLabelFromApi ?relation_label } } optional { graph ?i { ?environment nt:hasLabelFromApi ?environment_label } } }" assertion.
get-environments-for-taxon sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix biolink: <https://w3id.org/biolink/vocab/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select distinct ?relation ?relation_label ?environment ?environment_label ?creator ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType biolink:OrganismTaxonToEnvironmentAssociation . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?association . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . ?np npx:signedBy ?creator . } graph ?a { ?association a biolink:OrganismTaxonToEnvironmentAssociation . ?association biolink:subject ?taxonConcept . ?taxonConcept biodiv:hasTaxonName ?_taxonname_iri . ?association biolink:predicate ?relation . ?association biolink:object ?environment . } optional { graph ?i { ?relation nt:hasLabelFromApi ?relation_label } } optional { graph ?i { ?environment nt:hasLabelFromApi ?environment_label } } }" assertion.
get-environments-for-taxon sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix biolink: <https://w3id.org/biolink/vocab/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select distinct ?relation ?relation_label ?environment ?environment_label ?source ?creator ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType biolink:OrganismTaxonToEnvironmentAssociation . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?association . ?np np:hasAssertion ?a . ?np np:hasProvenance ?p . ?np np:hasPublicationInfo ?i . ?np npx:signedBy ?creator . } graph ?a { ?association a biolink:OrganismTaxonToEnvironmentAssociation . ?association biolink:subject ?taxonConcept . ?taxonConcept biodiv:hasTaxonName ?_taxonname_iri . ?association biolink:predicate ?relation . ?association biolink:object ?environment . } optional { graph ?p { ?a dct:source ?source } } optional { graph ?i { ?relation nt:hasLabelFromApi ?relation_label } } optional { graph ?i { ?environment nt:hasLabelFromApi ?environment_label } } }" assertion.
get-uncertainty-estimates sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix mac: <https://w3id.org/spaces/mac/r/ontology/> select ?dataset ?mz_estimate ?rt_estimate ?i_estimate ?uncertainty_model ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType mac:uncertainty_model . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:signedBy ?creator . ?np np:hasAssertion ?a . } graph ?a { ?dataset mac:has_mz_uncertainty_estimate ?mz_estimate . ?dataset mac:has_RT_uncertainty_estimate ?rt_estimate . ?dataset mac:has_I_uncertainty_estimate ?i_estimate . ?a dct:conformsTo ?uncertainty_model . } } order by desc(?date)" assertion.
find-gofair-qualified-things sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> prefix prov: <http://www.w3.org/ns/prov#> select distinct ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np (group_concat(distinct ?recommender; separator=" ") as ?recommenders) (group_concat(distinct ?recommendation_np; separator=" ") as ?recommendation_nps) (count(distinct ?recommender) as ?recommender_count) (sample(?fairAssessmentLevel) as ?fairAssessmentLevel) (sample(?fairAssessmentLevelNp) as ?fairAssessmentLevelNp) where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } graph npa:graph { ?np npx:hasNanopubType ?__type_iri . ?np npa:hasValidSignatureForPublicKey ?pubkey . optional { ?retraction npx:retracts ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } optional { ?newversion npx:supersedes ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np (npx:introduces|npx:describes) ?thing . ?np rdfs:label ?label . ?np dct:description ?description . ?np dct:created ?date . filter(str(?date) > "2022") } bind(concat(" ",lcase(str(?label))," ",lcase(str(?description))," ") as ?text) filter( contains(?text, lcase(str(?_searchterm))) ) optional { graph npa:graph { ?disapproval npa:hasValidSignatureForPublicKey ?dpubkey . } graph ?latest_curators_assertion { ?dpubkeys npx:hasPublicKey ?dpubkey . } graph npa:graph { filter not exists { ?disapproval_x npx:invalidates ?disapproval ; npa:hasValidSignatureForPublicKey ?dpubkey . } ?disapproval np:hasAssertion ?da . } graph ?da { ?dsomebody ( npx:disapproves-of | npx:disapprovesOf ) ?np . } } filter(!bound(?disapproval)) # Faster than "filter not exists" for some reason optional { graph npa:graph { ?recommendation_np npx:hasNanopubType fip:recommended-by . ?recommendation_np npa:hasValidSignatureForPublicKey ?rpubkey . filter not exists { ?recommendation_np_x npx:invalidates ?recommendation_np ; npa:hasValidSignatureForPublicKey ?rpubkey . } ?recommendation_np np:hasAssertion ?ra . ?recommendation_np np:hasProvenance ?rp . } graph ?ra { ?thing fip:recommended-by ?recommender . } #graph ?rp { # ?ra prov:wasDerivedFrom ?rfip_np . #} #graph npa:graph { # ?rfip_np npx:hasNanopubType fip:Reference-FAIR-Implementation-Profile . # ?rfip_np npa:hasValidSignatureForPublicKey ?rfip_pubkey . # ?latest_rfip_np npa:hasValidSignatureForPublicKey ?rfip_pubkey . # filter not exists { ?latest_rfip_npx npx:invalidates ?latest_rfip_np ; npa:hasValidSignatureForPublicKey ?rfip_pubkey . } #} #graph npa:networkGraph { # ?latest_rfip_np (npx:supersedes)* ?rfip_np . #} #graph ?rfip_qa { # ?rfip_qualifier npx:qualifies ?latest_rfip_np . #} #graph npa:graph { # ?rfip_qualification_np np:hasAssertion ?rfip_qa . # ?rfip_qualification_np npx:hasNanopubType npx:qualifies . # ?rfip_qualification_np npa:hasValidSignatureForPublicKey ?rfip_qpubkey . # filter not exists { ?rfip_qualification_np_x npx:invalidates ?rfip_qualification_np ; npa:hasValidSignatureForPublicKey ?rfip_qpubkey . } #} #graph ?latest_curators_assertion { # ?rfip_qpubkeys npx:hasPublicKey ?rfip_qpubkey . #} } optional { graph npa:graph { ?qualification_np npx:hasNanopubType npx:qualifies . ?qualification_np npa:hasValidSignatureForPublicKey ?qpubkey . } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } graph npa:graph { filter not exists { ?qualification_np_x npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } ?qualification_np np:hasAssertion ?qa . } graph ?qa { ?qualifier npx:qualifies ?np . } } optional { graph npa:graph { ?fairAssessmentLevelNp npx:hasNanopubType fip:has-FAIR-assessment . ?fairAssessmentLevelNp npa:hasValidSignatureForPublicKey ?lpubkey . } graph ?latest_curators_assertion { ?lpubkeys npx:hasPublicKey ?lpubkey . } graph npa:graph { filter not exists { ?fairAssessmentLevelNp_x npx:invalidates ?fairAssessmentLevelNp ; npa:hasValidSignatureForPublicKey ?lpubkey . } ?fairAssessmentLevelNp np:hasAssertion ?la . } graph ?la { ?thing fip:has-FAIR-assessment ?fairAssessmentLevel . } } filter(!bound(?levelNp)) # Faster than "filter not exists" for some reason } group by ?thing ?label ?description ?np ?date ?pubkey ?retraction ?newversion ?qualifier ?qualification_np order by desc(?recommender_count) asc(?label)" assertion.
get-dggs-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select distinct ?np ?pubkey ?date ?label ?title ?text ?supersedes ?supersedes_count where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . # Valid signature and not invalidated filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_inv . } # This is the LATEST version (nothing supersedes it) filter not exists { ?newer_np npx:supersedes ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_super . } # Not retracted filter not exists { ?retraction_np npx:retracts ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_ret . } ?np dct:created ?date . ?np np:hasAssertion ?a . } # Check if this nanopub supersedes others (to show version history) optional { graph npa:graph { ?np npx:supersedes ?supersedes . } } graph ?a { ?s ?p ?o . filter( isLiteral(?o) && regex(str(?o), "DGGS|Discrete Global Grid|discrete global grid", "i") ) } optional { graph ?a { ?s rdfs:label ?label } } optional { graph ?a { ?s dct:title ?title } } bind(?o as ?text) } order by desc(?date)" assertion.
get-dggs-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?np ?pubkey ?date (sample(?label) as ?label) (sample(?title) as ?title) (sample(?text) as ?text) (sample(?supersedes) as ?supersedes) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_inv . } filter not exists { ?newer_np npx:supersedes ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_super . } filter not exists { ?retraction_np npx:retracts ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey_ret . } ?np dct:created ?date . ?np np:hasAssertion ?a . } optional { graph npa:graph { ?np npx:supersedes ?supersedes . } } graph ?a { ?s ?p ?o . filter( isLiteral(?o) && regex(str(?o), "DGGS|Discrete Global Grid|discrete global grid", "i") ) } optional { graph ?a { ?s rdfs:label ?label } } optional { graph ?a { ?s dct:title ?title } } bind(?o as ?text) } group by ?np ?pubkey ?date order by desc(?date)" assertion.
sparql-construct-query-test sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> construct { ?np rdfs:label ?label . } where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np rdfs:label ?label . } } limit 10" assertion.
get-coauthors sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix fabio: <http://purl.org/spar/fabio/> prefix bibo: <http://purl.org/ontology/bibo/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?coauthor_id ?coauthor_label (count(distinct ?paper) as ?paper_count) where { values ?_author_multi_iri {} graph npa:graph { ?np npx:hasNanopubType fabio:ScholarlyWork . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?paper . } graph ?a { ?paper dct:title ?paper_label . ?paper bibo:authorList ?author_list . ?paper dct:date ?publication_date . ?author_list ?rdfseqpred1 ?_author_multi_iri . filter(strstarts(str(?rdfseqpred1), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?author_list ?rdfseqpred2 ?coauthor . filter(strstarts(str(?rdfseqpred2), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?coauthor foaf:name ?coauthor_label . bind(if(strstarts(str(?coauthor), "https://orcid.org/"), ?coauthor, ?coauthor_label) as ?coauthor_id) filter(?coauthor != ?_author_multi_iri) optional { ?paper dct:isPartOf ?journal . ?journal dct:title ?journal_label . } } } group by ?coauthor_id ?coauthor_label order by desc(?paper_count)" assertion.
get-coauthors sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix fabio: <http://purl.org/spar/fabio/> prefix bibo: <http://purl.org/ontology/bibo/> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?coauthor ?coauthor_label (count(distinct ?paper) as ?paper_count) where { values ?_author_multi_iri {} graph npa:graph { ?np npx:hasNanopubType fabio:ScholarlyWork . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?paper . } graph ?a { ?paper dct:title ?paper_label . ?paper bibo:authorList ?author_list . ?paper dct:date ?publication_date . ?author_list ?rdfseqpred1 ?_author_multi_iri . filter(strstarts(str(?rdfseqpred1), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?author_list ?rdfseqpred2 ?coauthor_id . filter(strstarts(str(?rdfseqpred2), "http://www.w3.org/1999/02/22-rdf-syntax-ns#_")) ?coauthor_id foaf:name ?coauthor_label . bind(if(strstarts(str(?coauthor_id), "https://orcid.org/"), ?coauthor_id, ?coauthor_label) as ?coauthor) filter(?coauthor_id != ?_author_multi_iri) optional { ?paper dct:isPartOf ?journal . ?journal dct:title ?journal_label . } } } group by ?coauthor ?coauthor_label order by desc(?paper_count)" assertion.
get-iadopt-variable-definition sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix iadopt: <https://w3id.org/iadopt/ont/> construct { ?subj ?pred ?obj . } where { graph npa:graph { ?np npx:introduces ?_variable_iri . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . filter not exists { ?np2 npx:introduces ?_variable_iri . ?np2 npa:hasValidSignatureForPublicKeyHash ?pubkey2 . filter not exists { ?np2x npx:invalidates ?np2 ; npa:hasValidSignatureForPublicKeyHash ?pubkey2 . } ?np2 dct:created ?date2 . filter(?date2 > ?date) } } graph npa:graph { ?np np:hasAssertion ?a . } graph ?a { ?subj ?pred ?obj . } } order by ?subj ?pred ?obj" assertion.
fers_by_type sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix fip: <https://w3id.org/fair/fip/terms/> prefix search: <http://www.openrdf.org/contrib/lucenesail#> select distinct ?np ?thing ?description ?label ?date ?types ?qualifier (group_concat(distinct ?community; separator=" ") as ?communities) (count(distinct ?community) as ?community_count) where { { select ?latest_curators_assertion where { graph npa:graph { <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> npa:hasValidSignatureForPublicKey ?curators_np_pk . ?latest_curators_np npa:hasValidSignatureForPublicKey ?curators_np_pk . filter not exists { ?latest_curators_npx npx:invalidates ?latest_curators_np ; npa:hasValidSignatureForPublicKey ?curators_np_pk . } ?latest_curators_np np:hasAssertion ?latest_curators_assertion . } graph npa:networkGraph { ?latest_curators_np (npx:supersedes)* <https://w3id.org/np/RA27Uhopq4MHZziL2lKXX-wTb1jz4KVLbHaupxyAcCt9Y> . filter not exists { ?latest_curators_npxx npx:supersedes ?latest_curators_np } } } } { select ?np ?thing ?label ?description ?date (group_concat(distinct ?type; separator=" ") as ?types) where { graph npa:graph { ?np rdfs:label ?label ; dct:description ?description ; npa:hasValidSignatureForPublicKey ?pubkey ; dct:created ?date . ?np npx:introduces|npx:describes ?thing . filter(str(?date) > "2022") filter exists { ?np npx:hasNanopubType ?fsr_type . values ?fsr_type { fip:FAIR-Enabling-Resource fip:FAIR-Supporting-Resource } } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npx:hasNanopubType ?_type_iri . ?np npx:hasNanopubType ?type . values ?type { fip:Authentication-and-authorization-service fip:Editor fip:FAIR-Representation-Service fip:FAIR-Supporting-Software fip:Identifier-service fip:Provenance-Tracking-Service fip:Registry fip:Validation-Service fip:Web-API fip:Communication-protocol fip:Crosswalk fip:FAIR-Implementation-Profile fip:Knowledge-representation-language fip:Metadata-schema fip:Metadata-data-linking-schema fip:Provenance-model fip:Semantic-model fip:Structured-vocabulary fip:FAIR-Data-Policy fip:Data-usage-license fip:Metadata-preservation-policy fip:Persistency-Policy fip:FAIR-Practice } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } filter not exists { graph ?da { ?disapprover npx:disapprovesOf ?np . } graph npa:graph { ?disapproval_np np:hasAssertion ?da ; npa:hasValidSignatureForPublicKey ?dpubkey . filter not exists { ?disapproval_npx npx:invalidates ?disapproval_np ; npa:hasValidSignatureForPublicKey ?dpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?dpubkey . } } } group by ?np ?thing ?label ?description ?date } optional { graph ?qa { ?qualifier npx:qualifies ?np . } graph npa:graph { ?qualification_np np:hasAssertion ?qa ; npa:hasValidSignatureForPublicKey ?qpubkey . filter not exists { ?qualification_npx npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . } } graph ?latest_curators_assertion { ?qpubkeys npx:hasPublicKey ?qpubkey . } } optional { graph npa:graph { ?decl_np npx:hasNanopubType fip:FIP-Declaration . ?decl_np np:hasAssertion ?decl_a ; npa:hasValidSignatureForPublicKey ?decl_pubkey . filter not exists { ?decl_npx npx:invalidates ?decl_np ; npa:hasValidSignatureForPublicKey ?decl_pubkey . } } graph ?decl_a { ?decl a fip:FIP-Declaration . # ---- # not really needed but seems to make query faster: values ?use { fip:declares-current-use-of fip:declares-planned-use-of fip:declares-planned-development-of fip:declares-planned-replacement-of } ?decl ?use ?thing . # ---- ?decl fip:declared-by ?community . } } } group by ?np ?thing ?description ?label ?date ?types ?qualifier order by desc(?community_count)" assertion.
get-planned-event-attendances sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select ?event ?event_label ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:plansToAttend . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np npx:signedBy ?_user_iri . ?np np:hasAssertion ?a . } graph ?a { ?_user_iri gen:plansToAttend ?event . optional { ?event rdfs:label ?event_label } optional { ?event dct:date ?date1 } } optional { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(gen:Space)))) as ?space_repo) service ?space_repo { graph npa:graph { ?nps npx:introduces ?event . ?nps npa:hasValidSignatureForPublicKeyHash ?pks . filter not exists { ?npsx npx:invalidates ?nps ; npa:hasValidSignatureForPublicKeyHash ?pks . } ?nps np:hasAssertion ?as . } graph ?as { ?event schema:startDate ?datetime . bind(xsd:date(substr(str(?datetime), 0, 11)) as ?date2) } } } bind(coalesce(?date1, ?date2) as ?date) } order by desc(?date)" assertion.
get-planned-event-attendances sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> select distinct ?event ?event_label ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:plansToAttend . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np npx:signedBy ?_user_iri . ?np np:hasAssertion ?a . } graph ?a { ?_user_iri gen:plansToAttend ?event . optional { ?event rdfs:label ?event_label } optional { ?event dct:date ?date1 } } optional { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(gen:Space)))) as ?space_repo) service ?space_repo { graph npa:graph { ?nps npx:introduces ?event . ?nps npa:hasValidSignatureForPublicKeyHash ?pks . filter not exists { ?npsx npx:invalidates ?nps ; npa:hasValidSignatureForPublicKeyHash ?pks . } ?nps np:hasAssertion ?as . } graph ?as { ?event schema:startDate ?datetime . bind(xsd:date(substr(str(?datetime), 0, 11)) as ?date2) } } } bind(coalesce(?date1, ?date2) as ?date) } order by desc(?date)" assertion.
get-definitions-of-ontology-ns sparql "prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> select distinct ?np ?term ?term_label ?creator ?date where { values ?_ontology_multi_iri {} graph npa:graph { values ?termType { owl:Class rdf:Property owl:ObjectProperty owl:DatatypeProperty owl:NamedIndividual } ?np npx:hasNanopubType ?termType . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?term . optional { ?np npx:signedBy ?creator . } ?np np:hasAssertion ?a . } graph ?a { {{ ?term a ?termType . filter(strstarts(str(?term), ?__ontologyNamespace)) } union { ?term a ?termType . ?term dct:partOf ?_ontology_multi_iri . }} optional { ?term rdfs:label ?term_label . } } } order by ?label" assertion.
get-definitions-of-ontology-ns sparql "prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix schema: <https://schema.org/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select distinct ?np ?item ?item_label ?creator ?date where { values ?_ontology_multi_iri { <https://w3id.org/fair/fip/terms/FIP-Ontology> } graph npa:graph { values ?itemType { owl:Class rdf:Property owl:ObjectProperty owl:DatatypeProperty owl:NamedIndividual gen:Paragraph } ?np npx:hasNanopubType ?itemType . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?item . optional { ?np npx:signedBy ?creator . } ?np np:hasAssertion ?a . } graph ?a { {{ ?item a ?itemType . filter(strstarts(str(?item), ?__ontologyNamespace)) } union { ?item a ?itemType . ?item dct:partOf|schema:isPartOf ?_ontology_multi_iri . }} optional { ?item rdfs:label|schema:title ?item_label . } } } order by ?label" assertion.
get-definitions-of-ontology-ns sparql "prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix schema: <https://schema.org/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select distinct ?np ?item ?item_label ?creator ?date where { values ?_ontology_multi_iri {} graph npa:graph { values ?itemType { owl:Class rdf:Property owl:ObjectProperty owl:DatatypeProperty owl:NamedIndividual gen:Paragraph } ?np npx:hasNanopubType ?itemType . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?item . optional { ?np npx:signedBy ?creator . } ?np np:hasAssertion ?a . } graph ?a { {{ ?item a ?itemType . filter(strstarts(str(?item), ?__ontologyNamespace)) } union { ?item a ?itemType . ?item dct:partOf|schema:isPartOf ?_ontology_multi_iri . }} optional { ?item rdfs:label|schema:title ?item_label . } } } order by ?label" assertion.
get-definitions-of-ontology-ns sparql "prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix schema: <https://schema.org/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select distinct ?np ("^" as ?np_label) ?item ?item_label ?creator ?date where { values ?_ontology_multi_iri {} graph npa:graph { values ?itemType { owl:Class rdf:Property owl:ObjectProperty owl:DatatypeProperty owl:NamedIndividual gen:Paragraph } ?np npx:hasNanopubType ?itemType . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np npx:introduces ?item . optional { ?np npx:signedBy ?creator . } ?np np:hasAssertion ?a . } graph ?a { {{ ?item a ?itemType . filter(strstarts(str(?item), ?__ontologyNamespace)) } union { ?item a ?itemType . ?item dct:partOf|schema:isPartOf ?_ontology_multi_iri . }} optional { ?item rdfs:label|schema:title ?item_label . } } } order by ?label" assertion.
get-ontology-versions sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix owl: <http://www.w3.org/2002/07/owl#> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?ontologyVersion ?ontologyVersion_label ?creator ?np ("^" as ?np_label) where { values ?_ontology_multi_iri {} graph npa:graph { ?np npx:hasNanopubType owl:Ontology . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?ontologyVersion . ?np npx:signedBy ?creator . } graph ?a { ?ontologyVersion rdfs:label ?ontologyVersion_label . ?ontologyVersion dct:isVersionOf ?_ontology_multi_iri . ?ontologyVersion gen:hasContentIndex ?contentIndex . } } order by desc(?ontologyVersion)" assertion.
get-classes-of-ontology-version sparql "prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix gen: <https://w3id.org/kpxl/gen/terms/> select distinct ?class ?class_label (?definition as ?description) (?termNp as ?np) ("^" as ?np_label) where { graph npa:graph { ?_ontologyVersionNp_iri npx:introduces ?ontologyVersion . ?_ontologyVersionNp_iri np:hasAssertion ?ontologyVersionNpA . } graph ?ontologyVersionNpA { ?ontologyVersion a owl:Ontology . ?ontologyVersion gen:hasContentIndex ?contentIndex . } graph npa:graph { ?contentIndex np:hasAssertion ?contentIndexA . } graph ?contentIndexA { ?contentIndex npx:includesElement ?termNp . } graph npa:graph { } graph npa:graph { ?termNp dct:created ?date . ?termNp npx:introduces ?class . ?termNp np:hasAssertion ?termNpA . } graph ?termNpA { ?class a owl:Class . optional { ?class rdfs:label ?class_label . } optional { ?class skos:definition ?definition . } } } order by ?class_label" assertion.
get-classes-of-ontology-version sparql "prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix gen: <https://w3id.org/kpxl/gen/terms/> select distinct ?property ?property_label (?definition as ?description) (?termNp as ?np) ("^" as ?np_label)where { graph npa:graph { ?_ontologyVersionNp_iri npx:introduces ?ontologyVersion . ?_ontologyVersionNp_iri np:hasAssertion ?ontologyVersionNpA . } graph ?ontologyVersionNpA { ?ontologyVersion a owl:Ontology . ?ontologyVersion gen:hasContentIndex ?contentIndex . } graph npa:graph { ?contentIndex np:hasAssertion ?contentIndexA . } graph ?contentIndexA { ?contentIndex npx:includesElement ?termNp . } graph npa:graph { } graph npa:graph { ?termNp dct:created ?date . ?termNp npx:introduces ?property . ?termNp np:hasAssertion ?termNpA . } graph ?termNpA { ?property a rdf:Property . optional { ?property rdfs:label ?property_label . } optional { ?property skos:definition ?definition . } } } order by ?property_label" assertion.
get-individuals-of-ontology-version sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix gen: <https://w3id.org/kpxl/gen/terms/> select distinct ?individual ?individual_label (?definition as ?description) (?termNp as ?np) ("^" as ?np_label) where { graph npa:graph { ?_ontologyVersionNp_iri npx:introduces ?ontologyVersion . ?_ontologyVersionNp_iri np:hasAssertion ?ontologyVersionNpA . } graph ?ontologyVersionNpA { ?ontologyVersion a owl:Ontology . ?ontologyVersion gen:hasContentIndex ?contentIndex . } graph npa:graph { ?contentIndex np:hasAssertion ?contentIndexA . } graph ?contentIndexA { ?contentIndex npx:includesElement ?termNp . } graph npa:graph { } graph npa:graph { ?termNp dct:created ?date . ?termNp npx:introduces ?individual . ?termNp np:hasAssertion ?termNpA . } graph ?termNpA { ?individual a owl:NamedIndividual . optional { ?individual rdfs:label ?individual_label . } optional { ?individual skos:definition ?definition . } } } order by ?individual_label" assertion.
get-paragraphs-of-ontology-version sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <https://schema.org/> select distinct ?paragraph ?paragraph_label (?itemNp as ?np) ("^" as ?np_label) where { graph npa:graph { ?_ontologyVersionNp_iri npx:introduces ?ontologyVersion . ?_ontologyVersionNp_iri np:hasAssertion ?ontologyVersionNpA . } graph ?ontologyVersionNpA { ?ontologyVersion a owl:Ontology . ?ontologyVersion gen:hasContentIndex ?contentIndex . } graph npa:graph { ?contentIndex np:hasAssertion ?contentIndexA . } graph ?contentIndexA { ?contentIndex npx:includesElement ?itemNp . } graph npa:graph { ?itemNp dct:created ?date . ?itemNp npx:introduces ?paragraph . ?itemNp np:hasAssertion ?itemNpA . } graph ?itemNpA { ?paragraph schema:title ?paragraph_label . ?paragraph a gen:Paragraph . ?paragraph gen:hasContent ?content . } } order by ?paragraph_label" assertion.
get-paragraphs-of-ontology-version sparql "prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#type> prefix owl: <http://www.w3.org/2002/07/owl#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix skos: <http://www.w3.org/2004/02/skos/core#> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <https://schema.org/> select distinct ?title ?content ?date ?np ("^" as ?np_label) where { graph npa:graph { ?_ontologyVersionNp_iri npx:introduces ?ontologyVersion . ?_ontologyVersionNp_iri np:hasAssertion ?ontologyVersionNpA . } graph ?ontologyVersionNpA { ?ontologyVersion a owl:Ontology . ?ontologyVersion gen:hasContentIndex ?contentIndex . } graph npa:graph { ?contentIndex np:hasAssertion ?contentIndexA . } graph ?contentIndexA { ?contentIndex npx:includesElement ?itemNp . } graph npa:graph { ?itemNp dct:created ?date . ?itemNp npx:introduces ?paragraph . ?itemNp np:hasAssertion ?itemNpA . } graph ?itemNpA { ?paragraph schema:title ?title . ?paragraph a gen:Paragraph . ?paragraph gen:hasContent ?content . } } order by ?title" assertion.
get-rocrate-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select distinct ?rocrate ?date ?np (?__pubkeyhash as ?pubkey) where { graph npa:graph { ?np npx:hasNanopubType npx:RoCrateNanopub . ?np npa:hasValidSignatureForPublicKeyHash ?__pubkeyhash . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?__pubkeyhash . } ?np dct:created ?date . ?np npx:introduces ?rocrate . ?np npx:signedBy ?__rocratebot_iri . } } order by desc(?date)" assertion.
get-rocrate-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select distinct ?rocrate ?date (?__agent_iri as ?agent) ?np (?__pubkeyhash as ?pubkey) where { graph npa:graph { ?np npx:hasNanopubType npx:RoCrateNanopub . ?np npa:hasValidSignatureForPublicKeyHash ?__pubkeyhash . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?__pubkeyhash . } ?np dct:created ?date . ?np npx:introduces ?rocrate . ?np npx:signedBy ?__agent_iri . } } order by desc(?date)" assertion.
get-posts-by-user sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix schema: <https://schema.org/> select ?title ?about ?text ?date ?url ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType schema:SocialMediaPosting . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np npx:introduces ?post . ?np np:hasAssertion ?a . } graph ?a { ?post schema:headline ?title . ?post schema:articleBody ?text . ?post schema:datePublished ?date . ?post schema:author ?_author_iri . optional { ?post schema:url ?url . } optional { ?post rdfs:seeAlso ?about . } } } order by desc(?date)" assertion.
get-all-user-profile-pics sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npx: <http://purl.org/nanopub/x/> prefix npa: <http://purl.org/nanopub/admin/> prefix schema: <https://schema.org/> select ?user ?imageUrl where { graph npa:graph { ?np np:hasAssertion ?a . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } } graph ?a { ?user schema:image ?imageUrl . } }" assertion.
sparql-construct-query-test sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> construct { ?np rdfs:label ?label . } where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } ?np rdfs:label ?label . } } limit 10" assertion.
get-all-user-default-license sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npx: <http://purl.org/nanopub/x/> prefix npa: <http://purl.org/nanopub/admin/> prefix kpxl_terms: <https://w3id.org/kpxl/gen/terms/> select ?user ?license where { graph npa:graph { ?np np:hasAssertion ?a . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } } graph ?a { ?user kpxl_terms:hasDefaultLicense ?license . } }" assertion.
get-all-rocrate-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select distinct ?rocrate ?date ?np where { graph npa:graph { ?np npx:hasNanopubType npx:RoCrateNanopub . filter not exists { ?npx npx:invalidates ?np } ?np dct:created ?date . ?np npx:introduces ?rocrate . } } order by desc(?date)" assertion.
get-all-rocrate-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select distinct ?rocrate ?date ?np where { graph npa:graph { ?np npx:hasNanopubType npx:RoCrateNanopub . filter not exists { ?npx npx:invalidates ?np } ?np dct:created ?date . ?np npx:introduces ?rocrate . } } order by desc(?date)" assertion.
get-all-ro-crate-nanopubs-again sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select distinct ?rocrate ?date ?np where { graph npa:graph { ?np npx:hasNanopubType npx:RoCrateNanopub . filter not exists { ?npx npx:invalidates ?np } ?np dct:created ?date . ?np npx:introduces ?rocrate . } } order by desc(?date)" assertion.
get-3pff-events sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> prefix schema: <http://schema.org/> select (?event as ?Event_ID) (?eventShortName as ?Event_ID__label) (?eventLongName as ?Event_Name) (?eventDate as ?Date) (group_concat(distinct ?eventOrganizer; separator=" ") as ?Organizers) (group_concat(distinct ?eventFacilitator; separator=" ") as ?Facilitators) (group_concat(distinct ?eventMoreInfoLink; separator=" ") as ?More_Info) (?np as ?Source) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?npCreator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . # Date Handling: Check for both predicates optional { ?event dct:date ?dateDct . } optional { ?event schema:startDate ?dateSchema . } bind(coalesce(?dateDct, ?dateSchema) as ?eventDate) bind(replace(str(?eventName), ' ?\\|.*$', '') as ?eventShortName) bind(replace(str(?eventName), '^([A-Z0-9]{2,3}).*$', '$1') as ?eventSeries) bind(replace(str(?eventName), '^.*\\| ?(.*)$', '$1') as ?eventLongName) optional { ?event tpff:has-event-organizer ?eventOrganizer . } optional { ?event tpff:has-event-facilitator ?eventFacilitator . } optional { ?event rdfs:seeAlso ?eventMoreInfoLink . } } } group by ?event ?eventShortName ?eventLongName ?eventDate ?np order by desc(?eventDate)" assertion.
get-3pff-events sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix tpff: <https://w3id.org/fair/3pff/> prefix schema: <http://schema.org/> select (?event as ?Event_ID) (?eventShortName as ?Event_ID__label) (?eventLongName as ?Event_Name) (?eventDate as ?Date) (group_concat(distinct ?eventOrganizer; separator=" ") as ?Organizers) (group_concat(distinct ?eventFacilitator; separator=" ") as ?Facilitators) (group_concat(distinct ?eventMoreInfoLink; separator=" ") as ?More_Info) (?np as ?Source) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?npDate . ?np dct:creator ?npCreator . ?np np:hasAssertion ?assertion . ?np npx:introduces ?event . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?assertion { ?event a tpff:3PFF-event . ?event rdfs:label ?eventName . # Date Handling: Check for both predicates optional { ?event dct:date ?dateDct . } optional { ?event schema:startDate ?dateSchema . } bind(coalesce(?dateDct, strBefore(str(?dateSchema), "T")) as ?eventDate) bind(replace(str(?eventName), ' ?\\|.*$', '') as ?eventShortName) bind(replace(str(?eventName), '^([A-Z0-9]{2,3}).*$', '$1') as ?eventSeries) bind(replace(str(?eventName), '^.*\\| ?(.*)$', '$1') as ?eventLongName) optional { ?event tpff:has-event-organizer ?eventOrganizer . } optional { ?event tpff:has-event-facilitator ?eventFacilitator . } optional { ?event rdfs:seeAlso ?eventMoreInfoLink . } } } group by ?event ?eventShortName ?eventLongName ?eventDate ?np order by desc(?eventDate)" assertion.
get-personal-urls sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?url ?url_label where { graph npa:graph { ?np npx:hasNanopubType rdfs:seeAlso . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np np:hasAssertion ?a . } graph ?a { ?_user_iri rdfs:seeAlso ?url . ?url rdfs:label ?url_label . } } order by ?url_label" assertion.
get-personal-urls sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> select ?urllink where { graph npa:graph { ?np npx:hasNanopubType rdfs:seeAlso . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np np:hasAssertion ?a . } graph ?a { ?_user_iri rdfs:seeAlso ?url . ?url rdfs:label ?url_label . } bind(concat("<a target=\"_blank\" href=\"", str(?url), "\">", ?url_label, "</a>") as ?urllink) } order by ?url_label" assertion.
get-latest-nanopubs-by-user sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select distinct ?np ?label ?date where { graph npa:graph { ?np npx:signedBy ?_user_iri . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . optional { ?np rdfs:label ?label . } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } order by desc(?date) limit 100" assertion.
get-future-planned-event-attendances sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix schema: <http://schema.org/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> select distinct ?event ?event_label ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType gen:plansToAttend . ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np npx:signedBy ?_user_iri . ?np np:hasAssertion ?a . } graph ?a { ?_user_iri gen:plansToAttend ?event . optional { ?event rdfs:label ?event_label } optional { ?event dct:date ?date1 } } optional { bind(iri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(gen:Space)))) as ?space_repo) service ?space_repo { graph npa:graph { ?nps npx:introduces ?event . ?nps npa:hasValidSignatureForPublicKeyHash ?pks . filter not exists { ?npsx npx:invalidates ?nps ; npa:hasValidSignatureForPublicKeyHash ?pks . } ?nps np:hasAssertion ?as . } graph ?as { ?event schema:startDate ?datetime . bind(xsd:date(substr(str(?datetime), 0, 11)) as ?date2) } } } bind(coalesce(?date1, ?date2) as ?date) filter(?date >= xsd:date(substr(str(now()), 0, 11))) } order by ?date" assertion.
get-all-iadopt-variables sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix iadopt: <https://w3id.org/iadopt/ont/> prefix skos: <http://www.w3.org/2004/02/skos/core#> select ?variable ?variable_label ?property ?property_label ?entity ?entity_label ?matrix ?matrix_label ?context ?context_label ?creator ?np ("^" as ?np_label) ?date where { graph npa:graph { ?np npx:hasNanopubType iadopt:Variable . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?variable . ?np npx:signedBy ?creator . } graph ?a { ?variable a iadopt:Variable . optional { ?variable rdfs:label ?variable_label . } optional { ?variable iadopt:hasObservableProperty ?property . optional { ?property rdfs:label ?property_label . } } optional { ?variable iadopt:hasObjectOfInterest ?entity . optional { ?entity rdfs:label ?entity_label . } } optional { ?variable iadopt:hasMatrix ?matrix . optional { ?matrix rdfs:label ?matrix_label . } } optional { ?variable iadopt:hasContextObject ?context . optional { ?context rdfs:label ?context_label . } } } } order by desc(?date)" assertion.
get-all-views sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> select ?view ?view_label ?query ?space ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . } graph ?a { ?view a gen:SpaceQueryView . ?view dct:title ?view_label . ?view gen:hasViewQuery ?query . optional { ?view gen:isViewForSpace ?space . } } } order by desc(?date)" assertion.
get-all-resource-views sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix nt: <https://w3id.org/np/o/ntemplate/> select ?view ?view_label ?viewKind ?type ?query (count(distinct ?actionTemplate) as ?template_count) (min(?actionTemplate) as ?first_template) (min(?actionLabel) as ?first_template_label) ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?pi . } graph ?pi { ?np nt:wasCreatedFromTemplate <https://w3id.org/np/RARLsTlqbTesu1b0WJZ-zL1z96xumOiqbK3l_vV6iZoww> . } graph ?a { ?view a gen:ResourceView . optional { ?view a ?type . filter(?type != gen:ResourceView) } optional { ?view rdfs:label ?view_label . } optional { ?view dct:isVersionOf ?viewKind . } optional { ?view gen:hasViewQuery ?query . } optional { ?view gen:hasViewAction ?action . ?action gen:hasActionTemplate ?actionTemplate . optional { ?action rdfs:label ?actionLabel . } } } } group by ?view ?view_label ?viewKind ?type ?query ?date ?np order by desc(?date)" assertion.
get-all-iadopt-variables sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix iadopt: <https://w3id.org/iadopt/ont/> prefix skos: <http://www.w3.org/2004/02/skos/core#> select ?variable ?variable_label ?entity ?entity_label ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType iadopt:Variable . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?variable . ?np npx:signedBy ?creator . } graph ?a { ?variable a iadopt:Variable . optional { ?variable rdfs:label ?variable_label . } optional { ?variable iadopt:hasObjectOfInterest ?entity . optional { ?entity rdfs:label ?entity_label . } } } } order by desc(?date)" assertion.
get-all-iadopt-variables sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix iadopt: <https://w3id.org/iadopt/ont/> prefix skos: <http://www.w3.org/2004/02/skos/core#> select ?variable ?variable_label ?entity ?entity_label ?creator ?date ?np ("^" as ?np_label) where { graph npa:graph { ?np npx:hasNanopubType iadopt:Variable . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } ?np dct:created ?date . ?np np:hasAssertion ?a . ?np npx:introduces ?variable . ?np npx:signedBy ?creator . } graph ?a { ?variable a iadopt:Variable . optional { ?variable rdfs:label ?variable_label . } optional { ?variable iadopt:hasObjectOfInterest ?entity . optional { ?entity rdfs:label ?entity_label . } } } } order by desc(?date)" assertion.
get-presentations-by-speaker sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix wd: <http://www.wikidata.org/entity/> select ?presentation ?presentation_label ?date ?event ?event_label ?np ("^" as ?np_label) where { graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np dct:created ?npdate . ?np np:hasAssertion ?a . ?np npx:introduces ?presentation . } graph ?a { ?presentation a wd:Q604733 . ?presentation wd:P823 ?_speaker_iri . optional { ?presentation rdfs:label ?presentation_label . } optional { ?presentation dct:date ?date . } optional { ?presentation dct:isPartOf ?event . optional { ?event rdfs:label ?event_label . } } } } order by desc(?date)" assertion.
get-accepted-nanopubs-by-author sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select ?np ?label ?npType ?timestamp where { optional { <x:> <x:> ?_author_iri } # for grlc to pick up the placeholder values (?npType ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { select distinct ?np ?label ?timestamp where { graph npa:graph { ?np dct:created ?timestamp . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?_author_iri . filter(strstarts(str(?hasElement), str(rdf:_))) } } group by ?np ?label ?timestamp } } order by desc(?timestamp)" assertion.
get-latest-accepted sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select ?np ?label ?npType ?mainAuthor ?authorEtAl ?timestamp ?date where { values (?npType ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { select distinct ?np ?label (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(if(count(distinct ?author)>0, count(distinct ?author), count(distinct ?creator)) > 1, " et al.", "") as ?authorEtAl) ?timestamp (substr(str(?timestamp), 0, 11) as ?date) where { graph npa:graph { ?np dct:created ?timestamp . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?label ?timestamp } } order by desc(?timestamp) limit 10" assertion.
get-top-authors sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix pav: <http://purl.org/pav/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select ?author (count(distinct ?np) as ?npcount) where { values (?npType ?journalName ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } } filter(bound(?author)) } group by ?author order by desc(?npcount) limit 10" assertion.
get-publisher-version-at-bdj-journal sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?publisher_version_np where { values ?pubkeys { "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6" } graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?_np_iri . } }" assertion.
get-publisher-version-at-bdj-journal sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?publisher_version_np ?npType ?journalName where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?np npa:artifactCode ?ac . } values (?npType ?journalName ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(?__type_iri as ?t) filter(!bound(?t) || ?t = ?npType) bind(uri(concat("https://query.knowledgepixels.com/repo/type/", sha256(str(?npType)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?np . } } }" assertion.
get-publisher-version-at-bdj-journal sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?publisher_version_np ?npType ?journalName where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?np npa:artifactCode ?ac . } values (?npType ?journalName ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(?__type_iri as ?t) filter(!bound(?t) || ?t = ?npType) bind(uri(concat("https://query.knowledgepixels.com/repo/type/", sha256(str(?npType)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?np . } } }" assertion.
get-publisher-version sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?publisher_version_np ?npType ?journalName where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?np npa:artifactCode ?ac . } values (?npType ?journalName ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(?__type_iri as ?t) filter(!bound(?t) || ?t = ?npType) bind(uri(concat("https://query.knowledgepixels.com/repo/type/", sha256(str(?npType)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?np . } } }" assertion.
get-publisher-version sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?publisher_version_np ?npType ?journalName where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?np npa:artifactCode ?ac . } values (?npType ?journalName ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(?__type_iri as ?t) filter(!bound(?t) || ?t = ?npType) bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?np . } } }" assertion.
get-head-np-info sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix pav: <http://purl.org/pav/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?head_version_np ?author_version_np ?publisher_version_np ?npType ?journalName ?creator ?mainAuthor ?authorCount ?introducedThing ?label ?date { { select ?head_version_np ?author_version_np ?publisher_version_np ?npType ?journalName where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?author_version_np npa:artifactCode ?ac . } optional { values (?npType ?journalName ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?author_version_np . } } } } } bind(coalesce(?publisher_version_np, ?author_version_np) as ?head_version_np) bind(?head_version_np as ?np) { select distinct ?np (coalesce(?signer, min(?declaredCreator)) as ?creator) (coalesce(?firstAuthor, min(?author), min(?creator)) as ?mainAuthor) (if(count(distinct ?author)>0,count(distinct ?author),count(distinct ?creator)) as ?authorCount) ?introducedThing ?label ?date where { graph npa:graph { ?np dct:created ?date . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasPublicationInfo ?i . ?np dct:creator ?declaredCreator . optional { ?np npx:signedBy ?signer . } optional { ?np npx:introduces ?introducedThing . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?signer ?introducedThing ?label ?date ?firstAuthor } }" assertion.
get-head-np-info sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix pav: <http://purl.org/pav/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?head_version_np ?author_version_np ?publisher_version_np ?np_type ?journal_name ?creator ?main_creator_or_author ?main_author ?author_count ?label ?date ?author_version_date { { select ?head_version_np ?author_version_np ?publisher_version_np ?np_type ?journal_name ?author_version_date where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?author_version_np npa:artifactCode ?ac . ?author_version_np dct:created ?author_version_date . } optional { values (?np_type ?journal_name ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?np_type)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?author_version_np . } } } } } bind(coalesce(?publisher_version_np, ?author_version_np) as ?head_version_np) bind(?head_version_np as ?np) { select distinct ?np (coalesce(?signer, min(?declaredCreator)) as ?creator) (coalesce(?firstAuthor, min(?author), min(?creator)) as ?main_author) (if(count(distinct ?author)>0,count(distinct ?author),count(distinct ?creator)) as ?author_count) ?label ?date where { graph npa:graph { ?np dct:created ?date . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasPublicationInfo ?i . ?np dct:creator ?declaredCreator . optional { ?np npx:signedBy ?signer . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?signer ?introducedThing ?label ?date ?firstAuthor } }" assertion.
get-head-np-info sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix pav: <http://purl.org/pav/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?head_version_np ?author_version_np ?publisher_version_np ?np_type ?journal_name ?main_author_or_creator ?creator ?main_author ?author_count ?label ?date ?author_version_date { { select ?head_version_np ?author_version_np ?publisher_version_np ?np_type ?journal_name ?author_version_date where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?author_version_np npa:artifactCode ?ac . ?author_version_np dct:created ?author_version_date . } optional { values (?np_type ?journal_name ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?np_type)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?author_version_np . } } } } } bind(coalesce(?publisher_version_np, ?author_version_np) as ?head_version_np) bind(?head_version_np as ?np) { select distinct ?np (coalesce(?signer, min(?declaredCreator)) as ?creator) (coalesce(?firstAuthor, min(?author), min(?creator)) as ?main_author) (if(count(distinct ?author)>0,count(distinct ?author),count(distinct ?creator)) as ?author_count) ?label ?date where { graph npa:graph { ?np dct:created ?date . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasPublicationInfo ?i . ?np dct:creator ?declaredCreator . optional { ?np npx:signedBy ?signer . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?signer ?introducedThing ?label ?date ?firstAuthor } bind(coalesce(?main_author, ?creator) as ?main_author_or_creator) }" assertion.
get-head-np-info sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix pav: <http://purl.org/pav/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?head_version_np ?author_version_np ?publisher_version_np ?np_type ?journal_name ?main_author_or_creator ?creator ?main_author ?author_count ?label ?date ?author_version_date { { select ?given_np ?head_version_np ?author_version_np_pre ?publisher_version_np ?np_type ?journal_name ?author_version_date where { graph npa:graph { bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?given_np npa:artifactCode ?ac . } optional { values (?np_type ?journal_name ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?np_type)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } { graph ?i { ?publisher_version_np prov:wasDerivedFrom ?given_np . bind(?given_np as ?author_version_np_pre) } } union { graph ?i { filter(?publisher_version_np = ?given_np) ?publisher_version_np prov:wasDerivedFrom ?author_version_np_pre . } } } } } } bind(coalesce(?author_version_np_pre, ?given_np) as ?author_version_np) graph npa:graph { ?author_version_np dct:created ?author_version_date . } bind(coalesce(?publisher_version_np, ?author_version_np) as ?head_version_np) bind(?head_version_np as ?np) { select distinct ?np (coalesce(?signer, min(?declaredCreator)) as ?creator) (coalesce(?firstAuthor, min(?author), min(?creator)) as ?main_author) (if(count(distinct ?author)>0,count(distinct ?author),count(distinct ?creator)) as ?author_count) ?label ?date where { graph npa:graph { ?np dct:created ?date . ?np rdfs:label ?label . ?np np:hasPublicationInfo ?i . ?np dct:creator ?declaredCreator . optional { ?np npx:signedBy ?signer . } } optional { graph ?i { ?np pav:authoredBy ?author . } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?author . filter(strstarts(str(?hasElement), str(rdf:_))) } } optional { graph ?i { ?np bibo:authorList ?authorList . ?authorList rdf:_1 ?firstAuthor . } } } group by ?np ?signer ?introducedThing ?label ?date ?firstAuthor } bind(coalesce(?main_author, ?creator) as ?main_author_or_creator) }" assertion.
get-biodiv-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix biolink: <https://w3id.org/biolink/vocab/> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix prov: <http://www.w3.org/ns/prov#> select distinct ?np ?label (group_concat(distinct ?creator; separator = ", ") as ?creators) ?pubkey ?date ?provtlabel ?provsrc where { graph npa:graph { ?np np:hasPublicationInfo ?i. ?np np:hasProvenance ?p. ?np np:hasAssertion ?a. ?np dct:created ?date . ?np rdfs:label ?labelx . bind(str(?labelx) as ?label) ?np dct:creator ?__creator_iri . bind(?__creator_iri as ?creator) ?np npx:hasNanopubType biodiv:BiodivNanopub . ?np npa:hasValidSignatureForPublicKey ?pubkey . optional { ?np npx:hasNanopubType ?__type_iri . bind(?__type_iri as ?type) } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?i { ?np nt:wasCreatedFromProvenanceTemplate ?provtnp . } optional { graph ?p { ?a prov:wasDerivedFrom ?provsrc . } } optional { graph npa:graph { ?provtnp rdfs:label ?provtlabelx . bind(str(?provtlabelx) as ?provtlabel) } } } group by ?np ?label ?type ?pubkey ?date ?provtlabel ?provsrc order by desc(?date)" assertion.
get-biodiv-nanopubs sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix biolink: <https://w3id.org/biolink/vocab/> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix biodiv: <https://w3id.org/kpxl/biodiv/terms/> prefix prov: <http://www.w3.org/ns/prov#> select distinct ?np ?label (group_concat(distinct ?creator; separator = ", ") as ?creators) ?pubkey ?date ?provtlabel ?provsrc where { graph npa:graph { ?np np:hasPublicationInfo ?i. ?np np:hasProvenance ?p. ?np np:hasAssertion ?a. ?np dct:created ?date . ?np rdfs:label ?labelx . bind(str(?labelx) as ?label) ?np dct:creator ?__creator_iri . bind(?__creator_iri as ?creator) ?np npx:hasNanopubType biodiv:BiodivNanopub . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np npx:hasNanopubType ?__type_iri . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?i { ?np nt:wasCreatedFromProvenanceTemplate ?provtnp . } optional { graph ?p { ?a prov:wasDerivedFrom ?provsrc . } } optional { graph npa:graph { ?provtnp rdfs:label ?provtlabelx . bind(str(?provtlabelx) as ?provtlabel) } } } group by ?np ?label ?type ?pubkey ?date ?provtlabel ?provsrc order by desc(?date)" assertion.
get-nanopubs-for-paper sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> select distinct ?np ?user ?type ?subj ?subjLabel ?rel ?relLabel ?text ?selection ?date where { graph npa:graph { ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i. ?np dct:created ?date . ?np dct:creator ?user . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?a { ?subj ?rel <https://doi.org/10.3897/rio.9.e95174> . } optional { ?a rdfs:comment ?textPre . bind(str(?textPre) as ?text) } optional { graph <http://purl.org/np/RA6d0qLmlRdXd-ubre83LxP22auJdJjXGzaW3W3qH4Neo#assertion> { ?rel rdfs:label ?relLabelPre . bind("cito" as ?typePre) } } optional { graph ?a { ?annotation oa:hasTarget ?annotationtarget ; oa:hasBody ?annotationbody . ?annotationbody rdf:value ?annotationtext . ?annotationtarget oa:hasSource <https://doi.org/10.3897/rio.9.e95174> ; oa:hasSelector ?annotationSelector . optional { ?annotationSelector oa:prefix ?annotatedprefix . } ?annotationSelector oa:exact ?annotatedtext . optional { ?annotationSelector oa:suffix ?annotatedsuffix . } bind("oa" as ?typePre) bind(str(?annotationtext) as ?text) bind(concat(?annotatedprefix, "<h>", ?annotatedtext, "</h>", ?annotatedsuffix) as ?selection) } } bind(replace(str(?subj), '^.*?([a-zA-Z0-9\\-\\_]+)$', '$1') as ?subjLabel). bind(coalesce(str(?relLabelPre), replace(str(?rel), '^.*?([a-zA-Z0-9\\-\\_]+)$', '$1')) as ?relLabel). bind(coalesce(?typePre, "other") as ?type). } order by desc(?date)" assertion.
get-nanopubs-for-paper sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> select distinct ?np ?user ?type ?subj ?subjLabel ?rel ?relLabel ?text ?selection ?date where { graph npa:graph { ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i. ?np dct:created ?date . ?np dct:creator ?user . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?a { ?subj ?rel ?_paper_iri . } optional { ?a rdfs:comment ?textPre . bind(str(?textPre) as ?text) } optional { graph <http://purl.org/np/RA6d0qLmlRdXd-ubre83LxP22auJdJjXGzaW3W3qH4Neo#assertion> { ?rel rdfs:label ?relLabelPre . bind("cito" as ?typePre) } } optional { graph ?a { ?annotation oa:hasTarget ?annotationtarget ; oa:hasBody ?annotationbody . ?annotationbody rdf:value ?annotationtext . ?annotationtarget oa:hasSource ?_paper_iri ; oa:hasSelector ?annotationSelector . optional { ?annotationSelector oa:prefix ?annotatedprefix . } ?annotationSelector oa:exact ?annotatedtext . optional { ?annotationSelector oa:suffix ?annotatedsuffix . } bind("oa" as ?typePre) bind(str(?annotationtext) as ?text) bind(concat(?annotatedprefix, "<h>", ?annotatedtext, "</h>", ?annotatedsuffix) as ?selection) } } bind(replace(str(?subj), '^.*?([a-zA-Z0-9\\-\\_]+)$', '$1') as ?subjLabel). bind(coalesce(str(?relLabelPre), replace(str(?rel), '^.*?([a-zA-Z0-9\\-\\_]+)$', '$1')) as ?relLabel). bind(coalesce(?typePre, "other") as ?type). } order by desc(?date)" assertion.
get-nanopubs-for-paper sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> select distinct ?np ?user ?type ?subj ?subjLabel ?rel ?relLabel ?text ?selection ?date where { graph npa:graph { ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i. ?np dct:created ?date . ?np dct:creator ?user . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?a { ?subj ?rel ?_paper_iri . } optional { ?a rdfs:comment ?textPre . bind(str(?textPre) as ?text) } optional { graph <http://purl.org/np/RA6d0qLmlRdXd-ubre83LxP22auJdJjXGzaW3W3qH4Neo#assertion> { ?rel rdfs:label ?relLabelPre . bind("cito" as ?typePre) } } optional { graph ?a { ?annotation oa:hasTarget ?annotationtarget ; oa:hasBody ?annotationbody . ?annotationbody rdf:value ?annotationtext . ?annotationtarget oa:hasSource ?_paper_iri ; oa:hasSelector ?annotationSelector . optional { ?annotationSelector oa:prefix ?annotatedprefix . } ?annotationSelector oa:exact ?annotatedtext . optional { ?annotationSelector oa:suffix ?annotatedsuffix . } bind("oa" as ?typePre) bind(str(?annotationtext) as ?text) bind(concat(?annotatedprefix, "<h>", ?annotatedtext, "</h>", ?annotatedsuffix) as ?selection) } } bind(replace(str(?subj), '^.*?([a-zA-Z0-9\\-\\_]+)$', '$1') as ?subjLabel). bind(coalesce(str(?relLabelPre), replace(str(?rel), '^.*?([a-zA-Z0-9\\-\\_]+)$', '$1')) as ?relLabel). bind(coalesce(?typePre, "other") as ?type). } order by desc(?date)" assertion.
get-reactions sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> select distinct ?np ?user ?rel ?reltext ?pub ?text ?date ?pubkey where { graph npa:networkGraph { <https://doi.org/10.3897/rio.9.e95174> npx:supersedes* ?pub . } graph npa:graph { ?np np:hasAssertion ?a . ?np dct:created ?date . ?np dct:creator ?user . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?a { ?a dct:creator ?user . ?a ?rel ?pub . optional { ?a rdfs:comment ?text . } filter regex(str(?rel), "http://purl.org/spar/cito/.*") } graph <http://purl.org/np/RA6d0qLmlRdXd-ubre83LxP22auJdJjXGzaW3W3qH4Neo#assertion> { ?rel rdfs:label ?reltext . } } order by desc(?date)" assertion.
get-reactions sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix oa: <http://www.w3.org/ns/oa#> select distinct ?np ?user ?rel ?reltext ?pub ?text ?date ?pubkey where { graph npa:networkGraph { ?_pub_iri npx:supersedes* ?pub . } graph npa:graph { ?np np:hasAssertion ?a . ?np dct:created ?date . ?np dct:creator ?user . ?np npa:hasValidSignatureForPublicKey ?pubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } graph ?a { ?a dct:creator ?user . ?a ?rel ?pub . optional { ?a rdfs:comment ?text . } filter regex(str(?rel), "http://purl.org/spar/cito/.*") } graph <http://purl.org/np/RA6d0qLmlRdXd-ubre83LxP22auJdJjXGzaW3W3qH4Neo#assertion> { ?rel rdfs:label ?reltext . } } order by desc(?date)" assertion.
get-publisher-version sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix prov: <http://www.w3.org/ns/prov#> select ?publisher_version_np ?npType ?journalName where { graph npa:graph { bind(replace(str(?_npid), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac) ?np npa:artifactCode ?ac . } values (?npType ?journalName ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "RIO Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "Biodiversity Data Journal" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "Data Science" "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(?__type_iri as ?t) filter(!bound(?t) || ?t = ?npType) bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { graph npa:graph { ?publisher_version_np npa:hasValidSignatureForPublicKey ?pubkey . ?publisher_version_np np:hasPublicationInfo ?i . filter not exists { ?publisher_version_np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?publisher_version_np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } graph ?i { ?publisher_version_np prov:wasDerivedFrom ?np . } } }" assertion.
get-accepted-nanopubs-by-author sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix pav: <http://purl.org/pav/> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> select ?np ?label ?npType ?timestamp where { values (?npType ?pubkeys) { (<https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") (<https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37 cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0 170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6") } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { select distinct ?np ?label ?timestamp where { graph npa:graph { ?np dct:created ?timestamp . ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np rdfs:label ?label . ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?i . filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter(contains(?pubkeys, sha256(?pubkey))) } { { graph ?i { ?np pav:authoredBy ?_author_iri . } } union { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?_author_iri . filter(strstarts(str(?hasElement), str(rdf:_))) } } } } group by ?np ?label ?timestamp } } order by desc(?timestamp)" assertion.
get-user-stats sparql "prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> prefix dct: <http://purl.org/dc/terms/> prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix nt: <https://w3id.org/np/o/ntemplate/> prefix bibo: <http://purl.org/ontology/bibo/> prefix pav: <http://purl.org/pav/> select ?key ?value where { { select ?key (count(?np) as ?value) where { optional { <x:> <x:> ?_pubkeyhashes } # ensure grlc is picking up the placeholder #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?_pubkeyhashes as ?vs) # <- VAR _pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # values ?x {0 1 2 3 4 5 6 7 8 9} values ?y {0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?service) service ?service { select distinct ?np ?invalidated { optional { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . bind( exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?_pubkeyhashes, sha256(str(?pubkeyx)))) } as ?invalidated ) } } } } bind(if(?invalidated,"invalidatedNpCount","validNpCount") as ?key) values ?key { "invalidatedNpCount" "validNpCount" } } group by ?key ?invalidated } union { select ?key (sum(?npcount) as ?value) where { bind("acceptedNpCount" as ?key) optional { <x:> <x:> ?_userid_iri } # ensure grlc is picking up the placeholder values ?npType { <https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> <https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> <https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> } bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(?npType)))) as ?service) service ?service { select (count(distinct ?np) as ?npcount) where { optional { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasPublicationInfo ?i . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } } { { graph ?i { ?np pav:authoredBy ?_userid_iri . } } union { graph ?i { ?np bibo:authorList ?authorList . ?authorList ?hasElement ?_userid_iri . filter(strstarts(str(?hasElement), str(rdf:_))) } } } } } group by ?np } } group by ?key } } order by ?key" assertion.
get-top-creators-last30d sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> prefix prov: <http://www.w3.org/ns/prov#> prefix foaf: <http://xmlns.com/foaf/0.1/> select distinct ?userid (count(distinct ?np) as ?count) where { { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:creator ?userid . } } union { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np np:hasAssertion ?assertion . ?np np:hasProvenance ?prov . } graph ?prov { ?assertion prov:wasAttributedTo ?userid . } } filter(?userid != <https://orcid.org/1234-1234-1234-1234>) filter(?userid != <https://orcid.org/0000-0000-0000-0000>) } group by ?userid order by desc(?count) limit 10" assertion.
get-latest-nanopubs-from-pubkeys sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?__pubkeyhashes as ?vs) # <- VAR __pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # values ?x {0 1 2 3 4 5 6 7 8 9} values ?y {0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice) bind(if(bound(?pkh), ?pubkeyservice, <https://w3id.org/np/l/nanopub-query-1.1/repo/meta>) as ?service) service ?service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . ?np dct:creator ?_userid_iri . optional { ?np rdfs:label ?label } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?_pubkeyhashes, sha256(str(?pubkeyx)))) } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } order by desc(?date) limit 100" assertion.
get-latest-nanopubs-from-pubkeys sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?__pubkeyhashes as ?vs) # <- VAR __pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # values ?x {0 1 2 3 4 5 6 7 8 9} values ?y {0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice) bind(if(bound(?pkh), ?pubkeyservice, <https://w3id.org/np/l/nanopub-query-1.1/repo/meta>) as ?service) service ?service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . ?np dct:creator ?_userid_iri . optional { ?np rdfs:label ?label } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?__pubkeyhashes, sha256(str(?pubkeyx)))) } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } order by desc(?date) limit 100" assertion.
get-latest-nanopubs-from-pubkeys sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?__pubkeyhashes as ?vs) # <- VAR __pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # values ?x {0 1 2 3 4 5 6 7 8 9} values ?y {0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice) bind(if(bound(?pkh), ?pubkeyservice, <https://w3id.org/np/l/nanopub-query-1.1/repo/meta>) as ?service) service ?service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . ?np dct:creator ?__userid_iri . optional { ?np rdfs:label ?label } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?__pubkeyhashes, sha256(str(?pubkeyx)))) } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } order by desc(?date) limit 100" assertion.
get-latest-nanopubs-from-pubkeys-userid sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(?__pubkeyhashes as ?vs) # <- VAR __pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # values ?x {0 1 2 3 4 5 6 7 8 9} values ?y {0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice) bind(if(bound(?pkh), ?pubkeyservice, <https://w3id.org/np/l/nanopub-query-1.1/repo/meta>) as ?service) service ?service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . ?np dct:creator ?__userid_iri . optional { ?np rdfs:label ?label } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?__pubkeyhashes, sha256(str(?pubkeyx)))) } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } order by desc(?date) limit 100" assertion.
get-latest-nanopubs-from-pubkeys-userid sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(if(?__pubkeyhashes = "", ?unbound, ?__pubkeyhashes) as ?vs) # <- VAR __pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # values ?x {0 1 2 3 4 5 6 7 8 9} values ?y {0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice) bind(if(bound(?pkh), ?pubkeyservice, <https://w3id.org/np/l/nanopub-query-1.1/repo/meta>) as ?service) service ?service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . ?np dct:creator ?__userid_iri . optional { ?np rdfs:label ?label } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkeyx . filter(contains(?__pubkeyhashes, sha256(str(?pubkeyx)))) } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } order by desc(?date) limit 100" assertion.
get-latest-nanopubs-from-pubkeys-userid sparql "prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix xsd: <http://www.w3.org/2001/XMLSchema#> prefix dct: <http://purl.org/dc/terms/> select ?np ?label ?pubkey ?date where { #==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------ { select ?pkh { # <- VAR pkh bind(if(?__pubkeyhashes = "", ?unbound, ?__pubkeyhashes) as ?vs) # <- VAR __pubkeyhashes {select*{optional{?a ?b ?c}}limit 1} # (for some Virtuoso ver.) # values ?x {0 1 2 3 4 5 6 7 8 9} values ?y {0 1 2 3 4 5 6 7 8 9} # bind((10*?x)+?y as ?n) # (works up to a maximum of 100 values) # bind(" " as ?sep) # (separator as single regex-compatible char) # <- CONST sep bind(concat("^([^",?sep,"]*",?sep,"){",str(?n),"}") as ?p) # bind(concat(?sep,".*") as ?p0) # filter(if(?n=0,true,regex(?vs,?p))) # (?n=0 check for Viruoso) # bind(replace(if(?n=0,?vs,replace(?vs,?p,"")),?p0,"") as ?pkh) # <- VAR pkh } } # #==================================================================#--------------------- bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice) bind(if(bound(?pkh), ?pubkeyservice, <https://w3id.org/np/l/nanopub-query-1.1/repo/meta>) as ?service) service ?service { graph npa:graph { ?np npa:hasValidSignatureForPublicKey ?pubkey . ?np dct:created ?date . ?np dct:creator ?__userid_iri . optional { ?np rdfs:label ?label } filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } filter not exists { ?np npx:hasNanopubType npx:retracts . } } } } order by desc(?date) limit 100" assertion.

first
previous
next