References for: sparql
Full identifier: https://w3id.org/kpxl/grlc/sparql
Nanopublication | Part | Subject | Predicate | Object | Published By | Published On |
---|---|---|---|---|---|---|
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
has the query
|
Tobias Kuhn
|
2025-05-28T14:38:58.062Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 grlc: <https://w3id.org/kpxl/grlc/>
select ?np ?label ?pubkeyhash ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkeyhash . }
?np dct:created ?date .
?np npx:introduces ?query .
?np np:hasAssertion ?a .
?np npx:hasNanopubType grlc:grlc-query .
optional { ?np rdfs:label ?label }
}
graph ?a {
?query grlc:endpoint ?endpoint .
filter(strstarts(str(?endpoint), "https://w3id.org/np/l/nanopub-query"))
}
} order by desc(?date)
|
Tobias Kuhn
|
2025-05-22T13:07:00.446Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
has the query
|
Tobias Kuhn
|
2025-05-22T07:51:21.941Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 dct: <http://purl.org/dc/terms/>
prefix fip: <https://w3id.org/fair/fip/terms/>
prefix search: <http://www.openrdf.org/contrib/lucenesail#>
select distinct ?thing ?label ?description ?np ?pubkey ?date where {
graph npa:graph {
values ?type { fip:FAIR-Specification fip:Metadata-schema fip:Semantic-model fip:Structured-vocabulary fip:Provenance-model }
?np npx:hasNanopubType ?type .
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np npx:introduces|npx:describes ?thing .
?np rdfs:label ?label .
optional { ?np dct:description ?description . }
?np np:hasAssertion ?a .
}
?np search:matches [
search:query ?_query ;
search:property rdfs:label ;
search:score ?score ;
search:snippet ?snippet ] .
}
limit 10
|
Tobias Kuhn
|
2025-04-24T14:16:14.567Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np npx:hasNanopubType <http://semanticscience.org/resource/SIO_001066> .
?np np:hasAssertion ?a .
optional { ?np rdfs:label ?label }
}
} limit 100
|
Tobias Kuhn
|
2025-04-23T09:16:01.864Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix prov: <http://www.w3.org/ns/prov#>
prefix schema: <https://schema.org/>
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 ?dataset ?label ?repository where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np np:hasAssertion ?a .
?np np:hasProvenance ?p .
}
graph ?a {
?dataset a <http://purl.org/dc/dcmitype/Dataset> .
optional { ?dataset dct:title ?label . }
optional { ?dataset schema:maintainer ?repository . }
}
graph ?p {
?a prov:wasAttributedTo <https://ror.org/027bh9e22> .
}
}
|
Tobias Kuhn
|
2025-04-16T13:00:36.581Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np np:hasAssertion ?a .
optional { ?np rdfs:label ?label }
}
} order by desc(?date) limit 10
|
Tobias Kuhn
|
2025-04-14T14:19:02.042Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?creator ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npx:hasNanopubType <http://purl.org/spar/cito/cites> .
?np dct:created ?date .
?np np:hasAssertion ?a .
?np npx:signedBy ?creator .
optional { ?np rdfs:label ?label }
}
} order by desc(?date)
|
Tobias Kuhn
|
2025-04-14T13:45:15.996Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 dct: <http://purl.org/dc/terms/>
prefix search: <http://www.openrdf.org/contrib/lucenesail#>
select ?np ?label ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?__pubkey .
optional { ?np rdfs:label ?label . }
?np dct:created ?date .
}
?np search:matches [
search:query ?_query ;
search:property rdfs:label ;
search:score ?score ;
search:snippet ?snippet ] .
}
limit 100
|
Tobias Kuhn
|
2025-04-10T17:41:59.830Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 dct: <http://purl.org/dc/terms/>
prefix search: <http://www.openrdf.org/contrib/lucenesail#>
select distinct ?thing ?label ?description ?np ?pubkey ?date where {
graph npa:graph {
?np npx:hasNanopubType ?__type_iri .
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:created ?date .
?np npx:introduces|npx:describes ?thing .
?np rdfs:label ?label .
optional { ?np dct:description ?description . }
?np np:hasAssertion ?a .
}
?np search:matches [
search:query ?_query ;
search:property rdfs:label ;
search:score ?score ;
search:snippet ?snippet ] .
}
limit 10
|
Tobias Kuhn
|
2025-04-10T09:38:01.279Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 dct: <http://purl.org/dc/terms/>
prefix search: <http://www.openrdf.org/contrib/lucenesail#>
select distinct ?thing ?label ?description ?np ?pubkey ?date where {
graph npa:graph {
?np npx:hasNanopubType ?__type_iri .
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np npx:introduces|npx:describes ?thing .
?np rdfs:label ?label .
optional { ?np dct:description ?description . }
?np np:hasAssertion ?a .
}
?np search:matches [
search:query ?_query ;
search:property rdfs:label ;
search:score ?score ;
search:snippet ?snippet ] .
}
limit 10
|
Tobias Kuhn
|
2025-04-10T09:35:41.157Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?graphpred ?subj ?pred ?obj ?date ?pubkey where {
graph ?g {
?__subj_iri ?__pred_iri ?__obj_iri .
bind(?__subj_iri as ?subj)
bind(?__pred_iri as ?pred)
bind(?__obj_iri as ?obj)
}
graph npa:graph {
?np ?__graphpred_iri ?g .
bind(?__graphpred_iri as ?graphpred)
values ?graphpred { np:hasAssertion np:hasProvenance np:hasPublicationInfo }
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?__pubkey .
bind(?__pubkey as ?pubkey)
?np dct:created ?date .
}
} limit 1000
|
Tobias Kuhn
|
2025-04-10T09:01:48.311Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?graphpred ?subj ?pred ?obj ?date ?pubkey where {
graph ?g {
?__subj_iri ?__pred_iri ?__obj_iri .
bind(?__subj_iri as ?subj)
bind(?__pred_iri as ?pred)
bind(?__obj_iri as ?obj)
}
graph npa:graph {
?np ?__graphpred_iri ?g .
bind(?__graphpred_iri as ?graphpred)
values ?graphpred { np:hasAssertion np:hasProvenance np:hasPublicationInfo }
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?__pubkey .
bind(?__pubkey as ?pubkey)
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
}
} limit 1000
|
Tobias Kuhn
|
2025-04-10T09:00:16.935Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix np: <http://www.nanopub.org/nschema#>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix dct: <http://purl.org/dc/terms/>
select ?newerVersion ?date ?retractedBy ?supersededBy where {
graph npa:graph {
?_np_iri npa:hasValidSignatureForPublicKey ?pubkey .
}
graph npa:networkGraph {
?newerVersion (npx:supersedes)* ?_np_iri .
}
graph npa:graph {
filter exists { ?newerVersion npa:hasValidSignatureForPublicKey ?pubkey . }
?newerVersion dct:created ?date .
}
optional { graph npa:graph { ?retractedBy npx:retracts ?newerVersion ; npa:hasValidSignatureForPublicKey ?pubkey . } }
optional { graph npa:graph { ?supersededBy npx:supersedes ?newerVersion ; npa:hasValidSignatureForPublicKey ?pubkey . } }
}
order by desc(?date) ?newerVersion
|
Tobias Kuhn
|
2025-04-08T12:25:54.695Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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{<x:> <x:> <x:>}}} # (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
filter(!bound(?pkh) || exists {?any_np npa:hasValidSignatureForPublicKeyHash ?pkh }) # Filter out the hashes for which no repo exists; try to do this better with future versions of Nanopub Query
} } #
#==================================================================#---------------------
bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice)
service ?pubkeyservice {
select ?np ?pubkey ?date ?label {
{ select ?np ?pubkey ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:created ?date .
} } order by desc(?date) }
graph npa:graph {
?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 . }
}
} limit 100
}
}
order by desc(?date)
limit 100
|
Tobias Kuhn
|
2025-04-08T07:27:54.115Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?pred (count(distinct ?np) as ?predcount) where {
graph npa:graph {
?np np:hasAssertion ?a .
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
graph ?a {
?subj ?pred ?obj .
}
} group by ?pred
order by desc(?predcount)
limit 50
|
Tobias Kuhn
|
2025-04-02T13:45:46.334Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix fip: <https://w3id.org/fair/fip/terms/>
prefix dct: <http://purl.org/dc/terms/>
prefix dce: <http://purl.org/dc/elements/1.1/>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix np: <http://www.nanopub.org/nschema#>
select ?fip_index ?fip_title ?decl_np where {
graph npa:graph {
?fip_index npx:hasNanopubType npx:NanopubIndex .
?fip_index npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?index_np_x npx:invalidates ?fip_index ; npa:hasValidSignatureForPublicKey ?pubkey . }
?fip_index np:hasAssertion ?index_a .
?fip_index rdfs:label ?fip_title .
?fip_index dct:created ?index_date .
?decl_np npa:hasValidSignatureForPublicKey ?decl_pubkey .
filter not exists { ?decl_np_x npx:invalidates ?decl_np ; npa:hasValidSignatureForPublicKey ?decl_pubkey . }
?decl_np npx:hasNanopubType fip:FIP-Declaration .
?decl_np dct:created ?date .
}
graph ?index_a {
?fip_index npx:includesElement ?decl_np .
}
filter not exists {
graph npa:graph { # Moving this to a separate graph for performance reasons with RDF4J LMDB engine
# Matching on the title string is an ugly hack:
?fip_newer_index rdfs:label ?fip_title .
}
graph npa:graph {
?fip_newer_index npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?fip_newer_index_x npx:invalidates ?fip_newer_index ; npa:hasValidSignatureForPublicKey ?pubkey . }
?fip_newer_index dct:created ?newer_date .
}
filter(?newer_date > ?index_date).
}
}
|
Tobias Kuhn
|
2025-03-31T19:30:19.539Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
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 ?intronp ?date ?pubkey where {
graph npa:graph {
?intronp npx:hasNanopubType npx:declaredBy .
?intronp npa:hasValidSignatureForPublicKey ?intronp_pubkey .
filter not exists { ?intronp_x npx:invalidates ?intronp ; npa:hasValidSignatureForPublicKey ?intronp_pubkey . }
?intronp np:hasAssertion ?a .
?intronp dct:created ?date .
}
graph ?a {
?keydeclaration npx:declaredBy ?user .
?keydeclaration npx:hasPublicKey ?pubkey .
optional {
?user foaf:name ?name .
}
}
}
order by ?user desc(?date)
|
Tobias Kuhn
|
2025-03-12T07:50:46.006Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?community (group_concat(distinct ?supercommunity; separator=" ") as ?supercommunities) (group_concat(distinct ?sc; separator=" ") as ?sc) where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npx:hasNanopubType fip:FAIR-Implementation-Community .
?np (npx:introduces|npx:describes) ?community .
?np np:hasAssertion ?a .
}
graph ?a {
?community dct:isPartOf ?supercommunity .
}
optional {
graph npa:graph {
?disapproval np:hasAssertion ?da .
?disapproval npa:hasValidSignatureForPublicKey ?dpubkey .
filter not exists { ?disapproval_x npx:invalidates ?disapproval ; npa:hasValidSignatureForPublicKey ?dpubkey . }
}
graph <https://w3id.org/np/RAkVk6aKWsmgcuKtPA7OSp2h-GbDfx8xrz_kJAAgY8Xa4#assertion> {
?dpubkeys npx:hasPublicKey ?dpubkey .
}
graph ?da {
?dsomebody ( npx:disapproves-of | npx:disapprovesOf ) ?np .
}
} filter(!bound(?disapproval)) # for some reason this is much faster than "filter not exists"
bind(replace(str(?supercommunity), ".*#", "") as ?sc)
} group by ?community
|
Tobias Kuhn
|
2025-03-11T11:06:47.124Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix fip: <https://w3id.org/fair/fip/terms/>
prefix dct: <http://purl.org/dc/terms/>
prefix dce: <http://purl.org/dc/elements/1.1/>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix np: <http://www.nanopub.org/nschema#>
prefix dcat: <https://www.w3.org/ns/dcat#>
select ?decl_np ?community ?c ?question ?q ?sort ?nochoice ?decl ?rel ?resource_id_used ?startdate ?enddate ?date where {
graph npa:graph {
?decl_np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?decl_np_x npx:invalidates ?decl_np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?decl_np npx:hasNanopubType fip:FIP-Declaration .
?decl_np dct:created ?date .
?decl_np np:hasAssertion ?assertion .
}
graph ?assertion {
?decl a fip:FIP-Declaration .
?decl fip:refers-to-question ?question .
{
{ ?decl fip:declares-current-use-of ?resource_id_used . bind(fip:declares-current-use-of as ?rel) }
union
{ ?decl fip:declares-planned-use-of ?resource_id_used . bind(fip:declares-planned-use-of as ?rel) }
union
{ ?decl fip:declares-planned-replacement-of ?resource_id_used . bind(fip:declares-planned-replacement-of as ?rel) }
union
{ ?decl fip:declares-replacement-from ?resource_id_used . bind(fip:declares-replacement-from as ?rel) } # unofficial
union
{ ?decl fip:declares-replacement-to ?resource_id_used . bind(fip:declares-replacement-to as ?rel) } # unofficial
}
# grlc gives an error for some reason if these two optional statements are at the end of the graph block:
optional { ?decl dcat:startDate ?startdate . }
optional { ?decl dcat:endDate ?enddate . }
?decl fip:declared-by ?community .
}
bind (replace(str(?community), ".*#", "") as ?c)
bind (replace(str(?supercommunity), ".*#", "") as ?sc)
bind (replace(str(?question), "^.*-([^-MD]+(-[MD]+)?)$", "$1") as ?q)
bind (concat(replace(?q, "F|M", "0"), "x") as ?sort)
bind ("" as ?nochoice)
}
|
Tobias Kuhn
|
2025-03-11T08:35:11.206Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?resource_pref_id ?res ?reslabel ?res_np_date ?resourcetype ?res_np ?np_pre ?pubkey_hash ?np_pre_pubkey_hash where {
graph npa:graph {
?res_np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?res_np ; npa:hasValidSignatureForPublicKey ?pubkey . }
bind(sha256(?pubkey) as ?pubkey_hash) ## workaround due to https://github.com/knowledgepixels/nanopub-query/issues/14
?res_np npx:hasNanopubType fip:FAIR-Enabling-Resource-to-be-Developed .
filter not exists { ?res_np npx:hasNanopubType fip:FAIR-Enabling-Resource . }
?res_np (npx:introduces|npx:describes) ?resource_pref_id .
bind(replace(str(?resource_pref_id), "^.*?(#|/)([^/#]*/?[^/#]*)/?$", "$2") as ?res)
?res_np dct:created ?res_np_date .
?res_np rdfs:label ?reslabel .
bind(fip:FAIR-Enabling-Resource-to-be-Developed as ?resourcetype)
}
optional { select * { graph npa:networkGraph {
?res_np npx:supersedes* ?np_pre_x .
} } }
bind(coalesce(?np_pre_x, ?res_np) as ?np_pre)
bind(concat(str(?np_pre), " ", ?pubkey_hash) as ?np_pre_pubkey_hash)
} order by ?resource_pref_id ?res_np
|
Tobias Kuhn
|
2025-03-10T14:39:44.670Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?resource_pref_id ?res ?reslabel ?res_np_date ?resourcetype ?res_np ?np_pre ?pubkey_hash ?np_pre_pubkey_hash where {
graph npa:graph {
?res_np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?res_np ; npa:hasValidSignatureForPublicKey ?pubkey . }
bind(sha256(?pubkey) as ?pubkey_hash) ## workaround due to https://github.com/knowledgepixels/nanopub-query/issues/14
?res_np npx:hasNanopubType fip:Available-FAIR-Enabling-Resource .
filter not exists { ?res_np npx:hasNanopubType fip:FAIR-Enabling-Resource . }
?res_np (npx:introduces|npx:describes) ?resource_pref_id .
bind(replace(str(?resource_pref_id), "^.*?(#|/)([^/#]*/?[^/#]*)/?$", "$2") as ?res)
?res_np dct:created ?res_np_date .
?res_np rdfs:label ?reslabel .
bind(fip:Available-FAIR-Enabling-Resource as ?resourcetype)
}
optional { select * { graph npa:networkGraph {
?res_np npx:supersedes* ?np_pre_x .
} } }
bind(coalesce(?np_pre_x, ?res_np) as ?np_pre)
bind(concat(str(?np_pre), " ", ?pubkey_hash) as ?np_pre_pubkey_hash)
} order by ?resource_pref_id ?res_np
|
Tobias Kuhn
|
2025-03-10T14:23:45.486Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?resource_pref_id ?res ?reslabel ?res_np_date ?resourcetype ?res_np ?np_pre ?pubkey_hash ?np_pre_pubkey_hash where {
graph npa:graph {
?res_np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?res_np ; npa:hasValidSignatureForPublicKey ?pubkey . }
bind(sha256(?pubkey) as ?pubkey_hash) ## workaround due to https://github.com/knowledgepixels/nanopub-query/issues/14
?res_np npx:hasNanopubType fip:FAIR-Enabling-Resource .
?res_np (npx:introduces|npx:describes) ?resource_pref_id .
bind(replace(str(?resource_pref_id), "^.*?(#|/)([^/#]*/?[^/#]*)/?$", "$2") as ?res)
?res_np dct:created ?res_np_date .
?res_np rdfs:label ?reslabel .
bind( exists { ?res_np npx:hasNanopubType fip:Available-FAIR-Enabling-Resource } as ?available_resource )
bind( exists { ?res_np npx:hasNanopubType fip:FAIR-Enabling-Resource-to-be-Developed } as ?tobedeveloped_resource )
bind(if(?available_resource, fip:Available-FAIR-Enabling-Resource,
if(?tobedeveloped_resource, fip:FAIR-Enabling-Resource-to-be-Developed,
fip:FAIR-Enabling-Resource
)
) as ?resourcetype )
}
optional { select * { graph npa:networkGraph {
?res_np npx:supersedes* ?np_pre_x .
} } }
bind(coalesce(?np_pre_x, ?res_np) as ?np_pre)
bind(concat(str(?np_pre), " ", ?pubkey_hash) as ?np_pre_pubkey_hash)
} order by ?resource_pref_id ?res_np
|
Tobias Kuhn
|
2025-03-10T14:08:10.379Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?res_np ?qualification_np where {
values ?qpubkey {
"MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCtpcftn7kbe6toJbOTDQaCcCssEFSWqt6J4rZ02w+TfY7/eIOgJZYOlpL6G3AzO2RNmVYWRPSlMiykaFuaRuBitvk1GKfGdprfZbvXwmeOxpqCTRBQX9EnFyQyd+Ra/ajfw/UsG8skeu1xnUEpnQbpgbQYc/fvhJNN0UwEc77mOwIDAQAB"^^xsd:string
"MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDO4xkU+/dGujq1raR66QtRqquMxiJ9hm2uzc2uBj7bCBBRnWhTw7M8f77BqAFHShgxqxYTr2do7/tVmoKeM51ISyttxWrh9ebZRoz5o6Muxt7HyA4sLHAmnixeZ5VJfZzsKAmVN23Y2ZiCqMoXjtcp5jO2lOC0AXaGPftnaA8b9QIDAQAB"^^xsd:string
"MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQCFntPrMZqvg2kVhCNArNnEn37ddXGwZ/0r4C8CS4lDry7C7YkYgng9yb0UMZQUHiTVkR/5A4m/xjE+Vy+AnwcWUeB75SfGZjE5ylI6VeHjTHi9+2hh2PHYIWnkhU4WHl3COEnxSSa/VouvPzZ2BIWLH6fTrq7NNL3RF5hGegGG0QIDAQAB"^^xsd:string
}
graph npa:graph {
?qualification_np npa:hasValidSignatureForPublicKey ?qpubkey .
filter not exists { ?qualification_np_x npx:invalidates ?qualification_np ; npa:hasValidSignatureForPublicKey ?qpubkey . }
?qualification_np np:hasAssertion ?qa .
}
graph ?qa {
?qualifier npx:qualifies ?res_np .
}
} order by ?res_np ?qualification_np
|
Tobias Kuhn
|
2025-03-10T13:24:40.367Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#>
prefix fip: <https://w3id.org/fair/fip/terms/>
prefix dct: <http://purl.org/dc/terms/>
prefix dce: <http://purl.org/dc/elements/1.1/>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix np: <http://www.nanopub.org/nschema#>
prefix dcat: <https://www.w3.org/ns/dcat#>
select distinct ?resource_id ?np_pre ?pubkey_hash ?np_pre_pubkey_hash where {
graph npa:graph {
?np_pre npa:hasValidSignatureForPublicKeyHash ?pubkey_hash .
?np_pre np:hasAssertion ?res_a .
?np_pre (npx:introduces|npx:describes) ?resource_id .
values ?resourcetype { fip:Available-FAIR-Enabling-Resource fip:FAIR-Enabling-Resource-to-be-Developed fip:FAIR-Enabling-Resource }
?np_pre npx:hasNanopubType ?resourcetype .
}
bind(concat(str(?np_pre), " ", ?pubkey_hash) as ?np_pre_pubkey_hash)
} order by ?resource_id ?np_pre
|
Tobias Kuhn
|
2025-03-10T13:11:54.509Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?creator ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np npx:hasNanopubType npx:ExampleNanopub .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
filter not exists { ?np npx:hasNanopubType npx:retracts . }
?np dct:created ?date .
optional { ?np rdfs:label ?label . }
optional { ?np npx:signedBy ?creator . }
}
} order by desc(?date) limit 100
|
Tobias Kuhn
|
2025-02-27T09:52:58.349Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?creator ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
filter not exists { ?np npx:hasNanopubType npx:retracts . }
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
?np dct:created ?date .
optional { ?np rdfs:label ?label . }
optional { ?np npx:signedBy ?creator . }
}
} order by desc(?date) limit 100
|
Tobias Kuhn
|
2025-02-27T09:50:13.963Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?creator ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
filter not exists { ?np npx:hasNanopubType npx:retracts . }
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
?np dct:created ?date .
optional { ?np rdfs:label ?label . }
optional { ?np npx:signedBy ?creator . }
}
} order by desc(?date) limit 100
|
Tobias Kuhn
|
2025-02-27T09:49:59.815Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 foaf: <http://xmlns.com/foaf/0.1/>
prefix nt: <https://w3id.org/np/o/ntemplate/>
prefix opo: <https://w3id.org/kpxl/opo/terms/>
select distinct (count(distinct ?person) as ?count) ?thing (min(?thingLabel) as ?thingLabel) where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npx:hasNanopubType opo:thinksIsUnderrated .
?np dct:created ?date .
?np dct:creator ?person .
?np np:hasAssertion ?a .
?np np:hasPublicationInfo ?i.
}
graph ?a {
?person opo:thinksIsUnderrated ?thing .
}
optional { graph ?i {
?thing nt:hasLabelFromApi ?thingLabel1 .
} }
optional { graph <http://purl.org/np/RA6p8TsYKPUmy6yoKuxjBKn2vRKczjIWrcS2lyyX61myE#assertion> {
?thing rdfs:label ?thingLabel2 .
} }
bind(coalesce(?thingLabel2, ?thingLabel1) as ?thingLabel)
}
group by ?thing
order by desc(?count)
|
Tobias Kuhn
|
2025-02-26T14:38:46.734Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 foaf: <http://xmlns.com/foaf/0.1/>
prefix nt: <https://w3id.org/np/o/ntemplate/>
prefix opo: <https://w3id.org/kpxl/opo/terms/>
select distinct (count(distinct ?person) as ?count) ?thing (min(?thingLabel) as ?thingLabel) where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npx:hasNanopubType opo:thinksIsOverrated .
?np dct:created ?date .
?np dct:creator ?person .
?np np:hasAssertion ?a .
?np np:hasPublicationInfo ?i.
}
graph ?a {
?person opo:thinksIsOverrated ?thing .
}
optional { graph ?i {
?thing nt:hasLabelFromApi ?thingLabel1 .
} }
optional { graph <http://purl.org/np/RA6p8TsYKPUmy6yoKuxjBKn2vRKczjIWrcS2lyyX61myE#assertion> {
?thing rdfs:label ?thingLabel2 .
} }
bind(coalesce(?thingLabel2, ?thingLabel1) as ?thingLabel)
}
group by ?thing
order by desc(?count)
|
Tobias Kuhn
|
2025-02-26T14:35:16.517Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 foaf: <http://xmlns.com/foaf/0.1/>
prefix nt: <https://w3id.org/np/o/ntemplate/>
prefix opo: <https://w3id.org/kpxl/opo/terms/>
select distinct ?person ?rel ?thing ?np ?date where {
{ {
graph npa:graph {
?np np:hasAssertion ?a .
?np npx:hasNanopubType opo:thinksIsOverrated .
bind(opo:thinksIsOverrated as ?rel)
}
graph ?a {
?person opo:thinksIsOverrated ?thing .
}
} union {
graph npa:graph {
?np np:hasAssertion ?a .
?np npx:hasNanopubType opo:thinksIsUnderrated .
}
graph ?a {
?person opo:thinksIsUnderrated ?thing .
bind(opo:thinksIsUnderrated as ?rel)
}
} }
graph npa:graph {
?np np:hasPublicationInfo ?i.
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np npa:hasValidSignatureForPublicKey ?pubkey .
}
graph ?i {
?np dct:creator ?person .
}
}
order by desc(?date)
|
Tobias Kuhn
|
2025-02-26T14:05:33.187Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?service ?serviceType ?date ?pubkey where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
optional { ?np dct:created ?date . }
?np np:hasAssertion ?a .
}
graph ?a {
?service a npx:NanopubService .
?service a ?serviceType .
filter(?serviceType != npx:NanopubService)
}
} order by desc(?date)
|
Tobias Kuhn
|
2025-02-26T11:08:08.316Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix prov: <http://www.w3.org/ns/prov#>
prefix schema: <https://schema.org/>
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 ?dataset ?label ?repository where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np np:hasAssertion ?a .
?np np:hasProvenance ?p .
}
graph ?a {
?dataset a <http://purl.org/dc/dcmitype/Dataset> .
optional { ?dataset dct:title ?label . }
optional { ?dataset schema:maintainer ?repository . }
}
graph ?p {
?a prov:wasAttributedTo ?agent .
}
}
|
Tobias Kuhn
|
2025-02-13T12:31:05.537Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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#>
select ?approved_np ?approver ?pubkey ?np ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npx:hasNanopubType npx:approvesOf .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
?np dct:created ?date .
?np dct:creator ?approver .
?np np:hasAssertion ?a .
}
graph ?a {
?approver npx:approvesOf ?approved_np .
filter(regex(str(?approved_np), '^.*[^A-Za-z0-9-_]RA[A-Za-z0-9-_]{43}$'))
}
}
|
Tobias Kuhn
|
2025-02-12T07:48:13.409Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npx:introduces ?_thing_iri .
?np dct:created ?date .
}
} order by desc(?date)
|
Tobias Kuhn
|
2025-01-31T11:14:21.920Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
select distinct ?np where {
{ graph npa:graph {
?np npa:hasValidSignatureForPublicKeyHash ?_pubkeyhash .
?np npx:hasNanopubType ?_type_iri .
} }
union
{ graph npa:graph {
?np npa:hasValidSignatureForPublicKeyHash ?_pubkeyhash .
?np npx:invalidates ?npx .
?npx npx:hasNanopubType ?_type_iri .
} }
}
|
Tobias Kuhn
|
2025-01-14T07:54:02.552Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
select ?np where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKeyHash ?_pubkeyhash .
}
}
|
Tobias Kuhn
|
2025-01-07T12:07:43.896Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix npa: <http://purl.org/nanopub/admin/>
select distinct ?pubkey ?pubkeyhash where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np npa:hasValidSignatureForPublicKeyHash ?pubkeyhash .
}
} order by ?pubkey
|
Tobias Kuhn
|
2024-12-18T12:09:43.587Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?month (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 .
}
graph ?prov {
?assertion prov:wasAttributedTo ?userid .
}
}
filter not exists {
graph npa:graph { ?np npa:hasSubIri ?userid . }
}
bind(substr(str(?date), 0, 8) as ?month)
}
group by ?month
order by desc(?month)
|
Tobias Kuhn
|
2024-12-08T11:15:18.688Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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/>
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 .
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)
?event dct:date ?eventDate .
optional {
?event tpff:has-event-organizer ?eventOrganizer .
}
optional {
?event tpff:has-event-facilitator ?eventFacilitator .
}
#optional {
# values ?eventType { tpff:In-Person-Event tpff:Hybrid-Event tpff:Virtual-Event }
# ?event a ?eventType .
# bind(replace(str(?eventType), '^.*/', '') as ?eventTypeName)
#}
optional {
?event rdfs:seeAlso ?eventMoreInfoLink .
}
}
}
group by ?event ?eventShortName ?eventLongName ?eventDate ?np
order by desc(?eventDate)
|
Tobias Kuhn
|
2024-12-04T08:43:22.729Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
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 np: <http://www.nanopub.org/nschema#>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix nt: <https://w3id.org/np/o/ntemplate/>
select distinct ?np ?npLabel ?date ?pubkey where {
graph ?assertion {
?statement ?relation ?_thing_iri .
values ?relation { rdf:subject rdf:predicate rdf:object nt:possibleValue }
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
filter not exists { ?np npx:hasNanopubType nt:UnlistedTemplate . }
?np np:hasAssertion ?assertion .
?np dct:created ?date .
optional { ?np rdfs:label ?npLabel }
}
} limit 1000
|
Tobias Kuhn
|
2024-12-02T12:45:20.034Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix dct: <http://purl.org/dc/terms/>
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 nt: <https://w3id.org/np/o/ntemplate/>
select ?label ?relation ?np ?npLabel ?date ?pubkey where {
graph ?g {
?_thing_iri ?relation ?label .
values ?relation { rdfs:label dct:title nt:hasLabelFromApi }
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npa:hasGraph ?g .
?np dct:created ?date .
optional { ?np rdfs:label ?npLabel }
}
} limit 1000
|
Tobias Kuhn
|
2024-11-29T10:11:08.285Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix dct: <http://purl.org/dc/terms/>
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 nt: <https://w3id.org/np/o/ntemplate/>
select ?class ?classLabel ?np ?npLabel ?date ?pubkey where {
graph ?g {
?_thing_iri a ?class .
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npa:hasGraph ?g .
?np np:hasPublicationInfo ?i .
?np dct:created ?date .
optional { ?np rdfs:label ?npLabel }
}
optional { graph ?g { ?class rdfs:label ?classLabel1 . } }
optional { graph ?g { ?class dct:title ?classLabel2 . } }
optional { graph ?i { ?class rdfs:label ?classLabel3 . } }
optional { graph ?i { ?class nt:hasLabelFromApi ?classLabel4 . } }
bind(coalesce(?classLabel1, ?classLabel2, ?classLabel3, ?classLabel4) as ?classLabel)
} limit 1000
|
Tobias Kuhn
|
2024-11-29T09:49:38.202Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix dct: <http://purl.org/dc/terms/>
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 nt: <https://w3id.org/np/o/ntemplate/>
select ?instance ?instanceLabel ?np ?npLabel ?date ?pubkey where {
graph ?g {
?instance a ?_class_iri .
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npa:hasGraph ?g .
?np np:hasPublicationInfo ?i .
?np dct:created ?date .
optional { ?np rdfs:label ?npLabel . }
}
optional { graph ?g { ?instance rdfs:label ?instanceLabel1 . } }
optional { graph ?g { ?instance dct:title ?instanceLabel2 . } }
optional { graph ?i { ?instance rdfs:label ?instanceLabel3 . } }
optional { graph ?i { ?instance nt:hasLabelFromApi ?instanceLabel4 . } }
bind(coalesce(?instanceLabel1, ?instanceLabel2, ?instanceLabel3, ?instanceLabel4) as ?instanceLabel)
} limit 1000
|
Tobias Kuhn
|
2024-11-29T09:00:19.432Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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/>
select distinct ?np ?date ?pubkey where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
}
graph npa:graph {
?np npa:hasGraph ?g .
}
graph ?g {
{ { ?_ref_iri ?pred ?obj . } union { ?subj ?_ref_iri ?obj . } union { ?subj ?pred ?_ref_iri . } }
}
} limit 1000
|
Tobias Kuhn
|
2024-11-27T16:30:49.140Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix dct: <http://purl.org/dc/terms/>
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/>
select ?instance ?np ?label ?date ?pubkey where {
graph ?g {
?instance a ?_class_iri .
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npa:hasGraph ?g .
?np dct:created ?date .
optional { ?np rdfs:label ?label }
}
} order by desc(?date) limit 10
|
Tobias Kuhn
|
2024-11-22T11:05:11.710Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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/>
select (count(?instance) as ?count) where {
graph ?g {
?instance a ?_class_iri .
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npa:hasGraph ?g .
}
}
|
Tobias Kuhn
|
2024-11-22T09:12:02.436Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 dct: <http://purl.org/dc/terms/>
prefix search: <http://www.openrdf.org/contrib/lucenesail#>
select distinct ?thing ?label ?description ?np ?pubkey ?date where {
graph npa:graph {
?np npx:hasNanopubType <https://w3id.org/fair/3pff/3PFF-event> .
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np npx:introduces|npx:describes ?thing .
?np rdfs:label ?label .
optional { ?np dct:description ?description . }
?np np:hasAssertion ?a .
}
?np search:matches [
search:query ?_query ;
search:property rdfs:label ;
search:score ?score ;
search:snippet ?snippet ] .
filter not exists { service <https://w3id.org/np/l/nanopub-query-1.1/repo/type/39692876d0a7881c82e9a2cb6dc8859fb16fa69fb41cea2ace2f8fa70bc52aed> { # (http://purl.org/nanopub/x/disapprovesOf)
graph npa:graph {
?disapproval_np np:hasAssertion ?da ;
npa:hasValidSignatureForPublicKey ?dpubkey .
filter not exists { ?disapproval_npx npx:invalidates ?disapproval_np ; npa:hasValidSignatureForPublicKey ?dpubkey . }
}
graph <https://w3id.org/np/RA5PyVZnfPpd5ozkVjzQQbWyfLXCmeApLfhsyl8Rgnmh8#assertion> {
?qpubkeys npx:hasPublicKey ?dpubkey .
}
graph ?da {
?disapprover npx:disapprovesOf ?np .
}
} }
}
limit 10
|
Tobias Kuhn
|
2024-11-12T08:22:08.144Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 dct: <http://purl.org/dc/terms/>
prefix search: <http://www.openrdf.org/contrib/lucenesail#>
select ?np ?label ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?__pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?__pubkey . }
optional { ?np rdfs:label ?label . }
?np dct:created ?date .
}
?np search:matches [
search:query ?_query ;
search:property rdfs:label ;
search:score ?score ;
search:snippet ?snippet ] .
}
limit 100
|
Tobias Kuhn
|
2024-10-25T10:52:19.309Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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#>
select ?np ?label ?pubkey ?date where {
graph npa:graph {
?np npx:introduces ?_thing_iri .
?np npa:hasValidSignatureForPublicKey ?pubkey .
optional { ?np rdfs:label ?label . }
?np dct:created ?date .
}
}
|
Tobias Kuhn
|
2024-10-25T09:46:15.442Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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#>
select ?np ?label ?pubkey ?date where {
graph npa:graph {
?np npx:hasNanopubType ?_type_iri .
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
optional { ?np rdfs:label ?label . }
?np dct:created ?date .
}
}
|
Tobias Kuhn
|
2024-10-25T08:59:50.719Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?pubkey ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np rdfs:label ?label .
values ?type {
<https://w3id.org/kpxl/rel/terms/hasRelationTo>
<https://w3id.org/kpxl/rel/terms/tendsToHaveRelationTo>
<https://w3id.org/linkflows/superpattern/terms/SuperPatternInstance>
<http://purl.org/petapico/o/hycl#AIDA-Sentence>
<https://w3id.org/biolink/vocab/related_to>
<http://www.w3.org/2004/02/skos/core#relatedMatch>
}
?np npx:hasNanopubType ?type .
?np dct:creator ?__creator_iri .
?np dct:created ?date .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
}
order by desc(?date)
|
Tobias Kuhn
|
2024-10-25T08:30:12.151Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?comment ?ref_np ?pubkey ?date where {
graph npa:graph {
?ref_np npa:hasValidSignatureForPublicKey ?ref_pubkey .
values ?ref_type { <https://w3id.org/kpxl/rel/terms/hasRelationTo> <https://w3id.org/kpxl/rel/terms/tendsToHaveRelationTo> <https://w3id.org/linkflows/superpattern/terms/SuperPatternInstance> <http://purl.org/petapico/o/hycl#AIDA-Sentence> <https://w3id.org/biolink/vocab/related_to> <http://www.w3.org/ns/mls#Run> }
?ref_np npx:hasNanopubType ?ref_type .
filter not exists { ?ref_np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?ref_npx npx:invalidates ?ref_np ; npa:hasValidSignatureForPublicKey ?ref_pubkey . }
graph npa:networkGraph {
?np npa:refersToNanopub ?ref_np .
}
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np npx:hasNanopubType <http://purl.org/spar/cito/cites> .
?np rdfs:label ?label .
?np dct:created ?date .
service <https://query.knowledgepixels.com/repo/type/2c1cce3f3152738c1009d59251409392aaaa3b0324bcb5fdfb4b7b944b8f0c18> {
select ?np ?comment where {
graph npa:graph {
?np np:hasAssertion ?a .
}
graph ?a {
?a rdfs:comment ?comment .
}
}
}
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
} order by desc(?date)
|
Tobias Kuhn
|
2024-10-25T08:19:09.616Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?pubkey ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np rdfs:label ?label .
values ?type { <https://w3id.org/kpxl/rel/terms/hasRelationTo> <https://w3id.org/kpxl/rel/terms/tendsToHaveRelationTo> <https://w3id.org/linkflows/superpattern/terms/SuperPatternInstance> <http://purl.org/petapico/o/hycl#AIDA-Sentence> <https://w3id.org/biolink/vocab/related_to> <http://www.w3.org/ns/mls#Run> }
?np npx:hasNanopubType ?type .
?np dct:creator ?__creator_iri .
?np dct:created ?date .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
}
order by desc(?date)
|
Tobias Kuhn
|
2024-10-25T08:16:31.791Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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/>
select ?np (?__graphpred_iri as ?graphpred) ?subj ?pred ?obj ?date (?__pubkey as ?pubkey) where {
graph ?g {
{ { bind(?_ref_iri as ?subj) } union { bind(?_ref_iri as ?pred) } union { bind(?_ref_iri as ?obj) } }
?subj ?pred ?obj .
}
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?__pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?__pubkey . }
?np dct:created ?date .
?np ?__graphpred_iri ?g .
values ?__graphpred_iri { np:hasAssertion np:hasProvenance np:hasPublicationInfo }
}
} limit 100
|
Tobias Kuhn
|
2024-10-23T13:49:38.234Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 bibo: <http://purl.org/ontology/bibo/>
select ?np ?label ?firstAuthor ?date where {
values ?pubkey { "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37" "cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0" "170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6" }
graph npa:graph {
?np dct:created ?date .
?np npa:hasValidSignatureForPublicKeyHash ?pubkey .
?np rdfs:label ?label .
?np np:hasPublicationInfo ?i .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . }
}
graph ?i {
?np bibo:authorList ?authorList .
?authorList rdf:_1 ?firstAuthor .
}
}
order by desc(?date)
limit 100
|
Tobias Kuhn
|
2024-10-02T09:32:23.309Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 bibo: <http://purl.org/ontology/bibo/>
select ?np ?label ?firstAuthor ?date where {
values ?pubkey { "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37" "cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0" "170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6" }
graph npa:graph {
?np dct:created ?date .
?np npa:hasValidSignatureForPublicKeyHash ?pubkey .
?np rdfs:label ?label .
?np np:hasPublicationInfo ?i .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . }
}
graph ?i {
?np bibo:authorList ?authorList .
?authorList rdf:_1 ?firstAuthor .
}
}
order by desc(?date)
limit 100
|
Tobias Kuhn
|
2024-10-02T09:31:37.672Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 bibo: <http://purl.org/ontology/bibo/>
select ?np ?label ?firstAuthor ?date where {
values ?pubkey { "1162349fdeaf431e71ab55898cb2a425b971d466150c2aa5b3c1beb498045a37" "cfe248c38933693b1ddeb62e17976a4d2396b0c738af5356bfffbe559d1a3de0" "170211c91a70e67992d52c760de3f0052c8c7271bd3c225ef0347245e8517ff6" }
graph npa:graph {
?np dct:created ?date .
?np npa:hasValidSignatureForPublicKeyHash ?pubkey .
?np rdfs:label ?label .
?np np:hasPublicationInfo ?i .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?pubkey . }
}
graph ?i {
?np bibo:authorList ?authorList .
?authorList rdf:_1 ?firstAuthor .
}
}
order by desc(?date)
limit 100
|
Tobias Kuhn
|
2024-10-02T09:30:11.399Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 cito: <http://purl.org/spar/cito/>
select distinct ?np ?person ?rel ?reltext ?pub ?text ?date ?pubkey where {
graph npa:networkGraph {
?_pub_iri npx:supersedes* ?pub .
}
graph npa:graph {
?np np:hasAssertion ?a .
?np np:hasPublicationInfo ?i.
?np dct:created ?date .
?np dct:creator ?person .
?np npx:hasNanopubType cito:cites .
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
graph ?a {
?a dct:creator ?person .
?a ?rel ?pub .
optional { ?a rdfs:comment ?text . }
filter(strstarts(str(?rel), str(cito:)))
}
graph <http://purl.org/np/RA6d0qLmlRdXd-ubre83LxP22auJdJjXGzaW3W3qH4Neo#assertion> {
?rel rdfs:label ?reltext .
}
}
order by desc(?date)
|
Tobias Kuhn
|
2024-10-01T11:23:37.294Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?type ?month ?npCount ?npCountType where {
{ select ?type ?month (count(?np) as ?npCount) where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np dct:creator ?_creator_iri .
?np npx:hasNanopubType ?type .
bind(substr(str(?date), 0, 8) as ?month)
bind(now() as ?now)
bind(concat(str(year(?now)), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?lastMonth)
bind(concat(str(year(?now)-1), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?firstMonth)
filter(?month > ?firstMonth && ?month <= ?lastMonth)
}
}
group by ?type ?month
order by ?type desc(?month)
}
{ select ?type (count(?np) as ?npCountType) where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np dct:creator ?_creator_iri .
?np npx:hasNanopubType ?type .
bind(substr(str(?date), 0, 8) as ?month)
bind(now() as ?now)
bind(concat(str(year(?now)), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?lastMonth)
bind(concat(str(year(?now)-1), '-', if(month(?now)>9,'','0'), str(month(?now))) as ?firstMonth)
filter(?month > ?firstMonth && ?month <= ?lastMonth)
}
}
group by ?type
order by desc(?npCountType)
limit 10
}
}
order by desc(?npCountType) ?type desc(?month)
|
Tobias Kuhn
|
2024-09-30T17:58:22.513Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 biodiv: <https://w3id.org/kpxl/biodiv/terms/>
select ?np ?label ?pubkey ?date where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np dct:created ?date .
?np rdfs:label ?label .
?np dct:creator ?__creator_iri .
?np npx:hasNanopubType biodiv:BiodivNanopub .
filter(not exists { ?np npx:hasNanopubType <https://w3id.org/kpxl/pensoft/rio/terms/RIOJournalNanopub> } )
filter(not exists { ?np npx:hasNanopubType <https://w3id.org/kpxl/pensoft/bdj/terms/BiodiversityDataJournalNanopub> } )
filter(not exists { ?np npx:hasNanopubType <https://w3id.org/kpxl/ios/ds/terms/DataScienceNanopub> } )
}
}
order by desc(?date)
limit 100
|
Tobias Kuhn
|
2024-09-30T11:17:26.405Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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/>
select distinct ?creator ?pubkey where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:creator ?creator .
filter(!strstarts(str(?creator), str(?np)))
}
}
order by ?creator
|
Tobias Kuhn
|
2024-09-30T06:36:35.595Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 dct: <http://purl.org/dc/terms/>
prefix search: <http://www.openrdf.org/contrib/lucenesail#>
select distinct ?suggestion {
{ select ?suggestion where {
graph npa:graph {
?np rdfs:label ?label .
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:created ?date .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
filter(!contains(?_query, " "))
filter(strEnds(?_query, "*"))
?np search:matches [
search:query ?_query ;
search:property rdfs:label ;
search:score ?score ;
search:snippet ?snippet ] .
bind(replace(?snippet, ".*<B>(.*)</B>.*", "$1") as ?suggestion)
} limit 100 }
} group by ?suggestion
|
Tobias Kuhn
|
2024-09-27T10:23:45.614Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?intronp ?date ?pubkey where {
graph npa:graph {
?intronp npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?intronpx npx:invalidates ?intronp ; npa:hasValidSignatureForPublicKey ?pubkey . }
?intronp dct:created ?date .
?intronp np:hasAssertion ?a .
}
graph ?a {
?keydeclaration npx:declaredBy ?user .
optional {
?user foaf:name ?name .
}
}
}
order by ?user desc(?date)
|
Tobias Kuhn
|
2024-09-25T09:31:04.551Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix np: <http://www.nanopub.org/nschema#>
prefix npa: <http://purl.org/nanopub/admin/>
prefix npx: <http://purl.org/nanopub/x/>
prefix dct: <http://purl.org/dc/terms/>
select ?latest ?date where {
graph npa:graph {
?_np_iri npa:hasValidSignatureForPublicKey ?pubkey .
?latest npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?latest ; npa:hasValidSignatureForPublicKey ?pubkey . }
?latest dct:created ?date .
}
graph npa:networkGraph {
?latest (npx:supersedes)* ?_np_iri .
}
}
|
Tobias Kuhn
|
2024-09-25T08:58:33.887Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 nt: <https://w3id.org/np/o/ntemplate/>
prefix dct: <http://purl.org/dc/terms/>
select ?template_np ?label (sum(?npcount) as ?overallcount) {
{ select ?used_template_np (count(distinct ?np) as ?npcount) where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np np:hasPublicationInfo ?i .
}
graph ?i {
?np nt:wasCreatedFromTemplate ?used_template_np .
}
} group by ?used_template_np }
bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/type/", sha256(str(nt:AssertionTemplate)))) as ?atservice)
{ service ?atservice {
graph npa:networkGraph {
?template_np npx:supersedes* ?used_template_np .
}
graph npa:graph {
?used_template_np npa:hasValidSignatureForPublicKey ?pubkey .
?template_np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?template_npx npx:invalidates ?template_np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?used_template_np np:hasAssertion ?a .
}
graph ?a {
?a rdfs:label ?label .
}
} }
} group by ?template_np ?label order by desc(?overallcount) limit 10
|
Tobias Kuhn
|
2024-09-24T12:18:41.405Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:created ?date .
?np npx:hasNanopubType ?_type_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
|
Tobias Kuhn
|
2024-09-24T08:55:18.819Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 {
#==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------
{ select ?pkh { # <- VAR pkh
bind(?_pubkeyhashes as ?vs) # <- VAR _pubkeyhashes
{select*{optional{<x:> <x:> <x:>}}} # (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
filter(!bound(?pkh) || exists {?any_np npa:hasValidSignatureForPublicKeyHash ?pkh }) # Filter out the hashes for which no repo exists; try to do this better with future versions of Nanopub Query
} } #
#==================================================================#---------------------
bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?pubkeyservice)
service ?pubkeyservice { select distinct ?np ?invalidated { optional {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:creator ?_userid_iri .
bind( exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } 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)
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
|
Tobias Kuhn
|
2024-09-23T17:57:56.841Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:creator ?_userid_iri .
bind( exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } 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
|
Tobias Kuhn
|
2024-09-23T10:32:50.049Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 {
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
|
Tobias Kuhn
|
2024-09-23T10:25:48.641Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 {
#==================== MULTI-VALUE PLACEHOLDER =====================#------ config: ------
{ select ?pkh { # <- VAR pkh
bind(?__pubkeyhashes as ?pubkeyhashes) # <- VAR __pubkeyhashes
bind(if(bound(?pubkeyhashes), ?pubkeyhashes, "") as ?vs) #
{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
filter(!bound(?pkh) || exists {?any_np npa:hasValidSignatureForPublicKeyHash ?pkh }) # Filter out the hashes for which no repo exists; try to do this better with future versions of Nanopub Query
} } #
#==================================================================#---------------------
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/full>) as ?service) # Should be /meta once RDF4J bug is resolved and we can allow for >1 concurrent queries
service ?service { select distinct ?np ?invalidated { optional {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:creator ?_userid_iri .
bind( exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . } 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
|
Tobias Kuhn
|
2024-09-23T09:32:10.130Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
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 fdof: <https://w3id.org/fdof/ontology#>
select ?fdo ?label ?type ?np ?creator where {
graph npa:graph {
?np npx:hasNanopubType fdof:FAIRDigitalObject .
?np dct:creator ?creator .
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np np:hasAssertion ?a .
}
graph ?a {
?fdo fdof:hasInformationObjectType ?__type_iri .
bind(?__type_iri as ?type)
?fdo rdfs:label ?label .
bind(?__query as ?query)
filter(if(bound(?query), contains(lcase(str(?label)), lcase(?query)), true))
}
}
|
Tobias Kuhn
|
2024-09-20T14:18:38.086Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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/>
select ?thing ?label where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
?np npx:introduces ?thing .
?np np:hasAssertion ?a .
}
graph ?a {
?thing rdfs:label ?label .
filter(contains(lcase(str(?label)), lcase(?_query)))
}
}
limit 10
|
Tobias Kuhn
|
2024-09-20T08:31:01.551Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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>)
filter(!regex(str(?userid), '[^A-Za-z0-9-_]RA[A-Za-z0-9-_]{43}$'))
}
group by ?userid
order by desc(?count)
limit 10
|
Tobias Kuhn
|
2024-09-16T08:54:54.936Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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
filter(exists {?any_np npa:hasValidSignatureForPublicKeyHash ?pkh }) # Filter out the hashes for which no repo exists; try to do this better with future versions of Nanopub Query
} } #
#==================================================================#---------------------
bind(uri(concat("https://w3id.org/np/l/nanopub-query-1.1/repo/pubkey/", ?pkh)) as ?service)
service ?service {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:created ?date .
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
|
Tobias Kuhn
|
2024-09-16T07:24:32.817Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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
|
Tobias Kuhn
|
2024-09-13T12:42:51.411Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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
|
Tobias Kuhn
|
2024-09-13T10:51:29.858Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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)
|
Tobias Kuhn
|
2024-09-11T16:59:22.683Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 .
}
}
}
|
Tobias Kuhn
|
2024-09-11T13:52:05.084Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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)
|
Tobias Kuhn
|
2024-09-11T13:13:27.725Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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)
|
Tobias Kuhn
|
2024-09-11T13:03:35.823Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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)
|
Tobias Kuhn
|
2024-09-11T12:14:49.275Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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)
}
|
Tobias Kuhn
|
2024-09-11T11:34:59.392Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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
|
Tobias Kuhn
|
2024-09-11T06:54:04.269Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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
|
Tobias Kuhn
|
2024-09-11T06:46:30.405Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 nt: <https://w3id.org/np/o/ntemplate/>
prefix xsd: <http://www.w3.org/2001/XMLSchema#>
prefix dct: <http://purl.org/dc/terms/>
select distinct ?template (count(distinct ?np) as ?count) where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np np:hasPublicationInfo ?i .
}
graph ?i {
?np nt:wasCreatedFromTemplate ?template .
}
}
group by ?template
order by desc(?count)
limit 10
|
Tobias Kuhn
|
2024-08-07T05:15:21.725Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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(strstarts(str(?userid), "https://orcid.org/"))
}
group by ?userid
order by desc(?count)
limit 10
|
Tobias Kuhn
|
2024-08-07T04:57:56.933Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:created ?date .
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 10
|
Tobias Kuhn
|
2024-08-05T15:11:05.700Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 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 . }
}
graph ?i {
?np bibo:authorList ?authorList .
?authorList ?hasElement ?_author_iri .
filter(strstarts(str(?hasElement), str(rdf:_)))
}
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
|
Tobias Kuhn
|
2024-07-16T10:41:18.664Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?taxonName (max(?taxonNameLabel) as ?taxonNameLabel) (count(?taxonName) as ?taxonNameCount) 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 . }
}
graph ?a {
?association <https://w3id.org/kpxl/biodiv/terms/hasTaxonName> ?taxonName .
}
optional {
graph ?i {
?taxonName <https://w3id.org/np/o/ntemplate/hasLabelFromApi> ?taxonNameLabel .
}
}
}
group by ?taxonName
order by desc(?taxonNameCount)
limit 10
|
Tobias Kuhn
|
2024-07-09T15:20:11.610Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 distinct ?journal (count(?np) as ?npcount) where {
{
service <https://w3id.org/np/l/nanopub-query-1.1/repo/type/4bd6efc556b296ff29805b28082513e9a66c850f7ae38d176568f447863ba1da> {
bind("Biodiversity Data Journal" as ?journal)
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
}
} union {
service <https://w3id.org/np/l/nanopub-query-1.1/repo/type/26df80496b38ffcad72b10e137bc78dbc6087e9eb171c09b10f2c9bf4240abc6> {
bind("Data Science" as ?journal)
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
}
} union {
service <https://w3id.org/np/l/nanopub-query-1.1/repo/type/9d535811c66bd27b8c44331f56c51b3290b40e8e26c1b1638b4de5d4b13ec159> {
bind("RIO Journal" as ?journal)
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . }
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
}
}
}
group by ?journal
order by desc(?npcount)
|
Tobias Kuhn
|
2024-07-09T11:36:30.465Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 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 . }
}
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
|
Tobias Kuhn
|
2024-07-09T11:15:14.504Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 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 . }
}
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
|
Tobias Kuhn
|
2024-07-09T11:05:28.227Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 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 . }
}
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
|
Tobias Kuhn
|
2024-07-09T11:04:59.414Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
select * where { bind("third version" as ?t) }
|
Tobias Kuhn
|
2024-07-02T10:54:59.121Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 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 {
bind(replace(str(?_np_iri), "^.*[^a-zA-Z0-9-_](RA[a-zA-Z0-9-_]{43})$", "$1") as ?ac)
?np npa:artifactCode ?ac .
optional {<x:> <x:> ?_np_iri} # for grlc to pick up the placeholder
?np npa:hasHeadGraph ?h .
?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
|
Tobias Kuhn
|
2024-07-01T07:47:13.780Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?pred ?obj ?date ?creator where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:created ?date .
?np dct:creator ?creator .
?np np:hasAssertion ?assertion .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
graph ?assertion {
?_subj_iri ?pred ?obj .
}
}
order by desc(?date)
|
Tobias Kuhn
|
2024-06-17T12:08:54.476Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
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 foaf: <http://xmlns.com/foaf/0.1/>
prefix oa: <http://www.w3.org/ns/oa#>
select ?target_source ?field ?value ?np ?user where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?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 . }
}
graph ?a {
?ann a oa:Annotation .
?ann oa:hasTarget ?target .
?target oa:hasSource ?target_source .
?target oa:hasSelector ?selector .
?selector a <http://example.org/FieldValueSelector> .
?selector <http://example.org/hasField> ?field .
?ann oa:hasBody ?body .
?body rdf:value ?value .
}
graph ?i {
optional {
?sig npx:hasSignatureTarget ?np .
?sig npx:signedBy ?user .
}
}
} order by desc(?date)
|
Tobias Kuhn
|
2024-04-16T13:32:27.823Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
sparql
|
prefix dbo: <http://dbpedia.org/ontology/>
prefix dbp: <http://dbpedia.org/property/>
prefix schema: <http://schema.org/>
prefix rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
select ?band ?album where {
?band rdf:type dbo:Band .
?album rdf:type schema:MusicAlbum .
?band dbo:genre ?__genre_iri .
?album dbp:artist ?band .
} limit 100
|
Tobias Kuhn
|
2024-03-13T12:32:46.643Z
|
||
links a nanopublication to its assertion
http://www.nanopub.org/nschema#hasAssertion
assertion
|
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 ?pred ?obj ?date ?creator where {
graph npa:graph {
?np npa:hasValidSignatureForPublicKey ?pubkey .
?np dct:created ?date .
?np dct:creator ?creator .
?np np:hasAssertion ?assertion .
filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKey ?pubkey . }
}
graph ?assertion {
?_subj_iri ?pred ?obj .
}
}
order by desc(?date)
|
Tobias Kuhn
|
2024-02-15T09:44:45.884Z
|