query-8514afcf80f1add5a963a1280f6d7463

rq turtle/ttl

PropertiesGene Ontology ID (P686)subclass of (P279)found in taxon (P703)UniProt protein ID (P352)molecular function (P680)instance of (P31)publication date (P577)PubMed publication ID (P698)stated in (P248)curator (P1640)determination method or standard (P459)

Use at

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT distinct ?uniprot ?determinationLabel ?curatorLabel ?reference_stated_inLabel ?pmid ?publication_date ?go_id ?sig_rec_goLabel WHERE  {

  ?sig_rec_go wdt:P686 ?go_id . # get GO IDs
  ?sig_rec_go wdt:P279* wd:Q21109843 . # that are subclasses of "signaling receptor activity"

  ?protein wdt:P703 wd:Q15978631 . # get items that are "found in taxon" human
  ?protein wdt:P352 ?uniprot . # and have a uniprot ID

  ?protein wdt:P680 ?sig_rec_go . # proteins where the MF a signaling receptor activity subclass
  ?protein p:P680 ?statement . # get statements

  ?statement pq:P459 ?determination . # get 'determination method' qualifiers associated with the statements
  ?determination wdt:P31 wd:Q28955254 . # filter where the determination method is a "manual assertion"

  ?statement prov:wasDerivedFrom/pr:P248 ?reference_stated_in . # get the "stated in" reference
  ?reference_stated_in wdt:P31 wd:Q13442814 . # stated in a "scientific article"
  ?reference_stated_in wdt:P577 ?publication_date . # get the publication date
  ?reference_stated_in wdt:P698 ?pmid . # get the pubmed id
  FILTER (?publication_date >= "2014-01-01T00:00:00Z"^^xsd:dateTime) . # filter where publication date is after 2014

  ?statement prov:wasDerivedFrom/pr:P1640 ?curator . # get the curator

  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }

} limit 50

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v10("?curator") v7("?determination") v3("?go_id"):::projected v9("?pmid"):::projected v4("?protein") v1("?publication_date"):::projected v8("?reference_stated_in") v2("?sig_rec_go") v6("?statement") v5("?uniprot"):::projected a1((" ")) a2((" ")) c4(["wd:Q21109843"]):::iri c22(["en"]):::literal c6(["wd:Q15978631"]):::iri c15(["wd:Q13442814"]):::iri c20(["bd:serviceParam"]):::iri c12(["wd:Q28955254"]):::iri f0[["?publication_date >= '2014-01-01T00:00:00Z^^xsd:dateTime'"]] f0 --> v1 v2 --"p:direct/P686"--> v3 v2 --"p:direct/P279"--> c4 v4 --"p:direct/P703"--> c6 v4 --"p:direct/P352"--> v5 v4 --"p:direct/P680"--> v2 v4 --"p:P680"--> v6 v6 --"p:qualifier/P459"--> v7 v7 --"p:direct/P31"--> c12 v6 --"prov:wasDerivedFrom"--> a1 a1 --"p:reference/P248"--> v8 v8 --"p:direct/P31"--> c15 v8 --"p:direct/P577"--> v1 v8 --"p:direct/P698"--> v9 v6 --"prov:wasDerivedFrom"--> a2 a2 --"p:reference/P1640"--> v10 subgraph s1["http://wikiba.se/ontology#label"] style s1 stroke-width:4px; c20 --"wikibase:language"--> c22 end