Returns the studies (OBI investigations) that are part of a given project, with each study's title, more specific study types, conductors, and further-information links, restricted to studies published by a member, maintainer, or admin of the project's space.
prefix rdfs: <http://www.w3.org/2000/01/rdf-schema#> prefix dct: <http://purl.org/dc/terms/> prefix np: <http://www.nanopub.org/nschema#> prefix npa: <http://purl.org/nanopub/admin/> prefix npx: <http://purl.org/nanopub/x/> prefix gen: <https://w3id.org/kpxl/gen/terms/> prefix obo: <http://purl.obolibrary.org/obo/> prefix prov: <http://www.w3.org/ns/prov#> prefix foaf: <http://xmlns.com/foaf/0.1/> select ?study ?study_label (group_concat(distinct str(?subtype); separator="\n") as ?subtype_multi_iri) (group_concat(distinct ?subtypeLabel; separator="\n") as ?subtype_label_multi) (group_concat(distinct str(?person); separator="\n") as ?person_multi_iri) (group_concat(distinct ?personLabel; separator="\n") as ?person_label_multi) (group_concat(distinct str(?link); separator="\n") as ?link_multi_iri) ?np ("^" as ?np_label) where { values ?_project_multi_iri {} service <https://w3id.org/np/l/nanopub-query-1.1/repo/spaces> { select (group_concat(?mpk; separator=" ") as ?memberPubkeys) where { graph npa:graph { <http://purl.org/nanopub/admin/thisRepo> npa:hasCurrentSpaceState ?stateG . } values ?_project_multi_iri {} graph ?stateG { ?_project_multi_iri npa:isMaintainedBy? ?space . ?ri a gen:RoleInstantiation ; npa:forSpace ?space ; npa:forAgent ?agent ; npa:hasRoleType ?roleType . filter(?roleType in (gen:AdminRole, gen:MaintainerRole, gen:MemberRole)) ?acct a npa:AccountState ; npa:agent ?agent ; npa:pubkey ?mpk . } } } graph npa:graph { ?np npa:hasValidSignatureForPublicKeyHash ?npPubkey . filter not exists { ?npx npx:invalidates ?np ; npa:hasValidSignatureForPublicKeyHash ?npPubkey . } filter not exists { ?supNp npx:supersedes ?np . } filter not exists { ?np npx:hasNanopubType npx:ExampleNanopub . } ?np np:hasAssertion ?a . ?np np:hasPublicationInfo ?pi . } filter(contains(?memberPubkeys, ?npPubkey)) graph ?a { ?study a obo:OBI_0000066 ; dct:isPartOf ?_project_multi_iri . optional { ?study rdfs:label ?study_label } } optional { graph ?a { ?study a ?subtype . filter(?subtype != obo:OBI_0000066) } optional { graph ?pi { ?subtype rdfs:label ?subtypeLabel } } } optional { graph ?a { ?study prov:wasAssociatedWith ?person } optional { graph ?pi { ?person foaf:name ?personLabel } } } optional { graph ?a { ?study rdfs:seeAlso ?link } } } group by ?study ?study_label ?np order by ?study_label