From 1f29d21150743f9ab27fac52a8d4265148e5c38f Mon Sep 17 00:00:00 2001 From: Pjotr Prins Date: Fri, 7 Jul 2023 03:21:59 -0500 Subject: Added note on slow RDF query --- topics/RDF/example-sparql-queries.gmi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'topics') diff --git a/topics/RDF/example-sparql-queries.gmi b/topics/RDF/example-sparql-queries.gmi index 4665272..54b2edc 100644 --- a/topics/RDF/example-sparql-queries.gmi +++ b/topics/RDF/example-sparql-queries.gmi @@ -4,7 +4,7 @@ => https://sparql.genenetwork.org/sparql?default-graph-uri=http%3A%2F%2Fgenenetwork.org&qtxt=PREFIX%20gn%3A%20%3Chttp%3A%2F%2Fgenenetwork.org%2F%3E%0APREFIX%20dct%3A%20%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0APREFIX%20generif%3A%20%3Chttps%3A%2F%2Fwww.ncbi.nlm.nih.gov%2Fgene%3FDb%3Dgene%26Cmd%3DDetailsSearch%26Term%3D%3E%0A%0ASELECT%20%3Fsymbol%20%3FgnEntry%20%3FcreatedOn%20(GROUP_CONCAT(%3Fpmid%3B%20SEPARATOR%3D%22%5Cn%22)%20AS%20%3FPubMedId)%20%3Fweburl%20WHERE%20%7B%0A%20%20%3Fgenerif%20gn%3Asymbol%20%3Fsymbol%20.%0A%20%20%3Fgenerif%20gn%3AgeneWikiEntryOfGn%20_%3AgnEntry%20.%0A%20%20_%3AgnEntry%20gn%3AgeneWikiEntry%20%3FgnEntry%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20dct%3Acreated%20%3FcreatedOn%20.%0A%20%20OPTIONAL%20%7B%20_%3AgnEntry%20foaf%3Ahomepage%20%3Fweburl%20%7D%20.%0A%20%20OPTIONAL%20%7B%20_%3AgnEntry%20dct%3Asource%20%3Fpmid%7D%20.%0A%20%20OPTIONAL%20%7B%0A%20%20%20%20%3Fgenerif%20gn%3AwikiEntryOfSpecies%20%3FspeciesName%20.%0A%20%20%20%20%3Fspecies%20gn%3Aname%20%3FspeciesName%20%3B%0A%20%20%20%20%20%20%20%20%20%20%20%20%20gn%3AbinomialName%20%3FspeciesBinomialName%20.%20%20%20%20%0A%20%20%7D%20.%0A%20%20FILTER(%20lcase(%3Fsymbol)%20%3D%20%22epha2%22%20)%0A%7D%20GROUP%20BY%20%3FcreatedOn%20%3FgnEntry%20%3Fgenerif%20%3Fsymbol%20%3Fweburl%20ORDER%20BY%20ASC(%3FcreatedOn)&format=text%2Fhtml&timeout=0&signal_void=on Get all GN GeneWiki metadata for a particular symbol E.g. "Epha2" -=> https://sparql.genenetwork.org/sparql?default-graph-uri=http%3A%2F%2Fgenenetwork.org&qtxt=PREFIX%20gn%3A%20%3Chttp%3A%2F%2Fgenenetwork.org%2F%3E%0APREFIX%20dct%3A%20%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0APREFIX%20generif%3A%20%3Chttps%3A%2F%2Fwww.ncbi.nlm.nih.gov%2Fgene%3FDb%3Dgene%26Cmd%3DDetailsSearch%26Term%3D%3E%0A%0ASELECT%20DISTINCT%20%3Fsubject%20%3Fpredicate%20%3Frelation%20%3Fdescription%20WHERE%20%7B%0A%20%20%3Fsubject%20%3Fpredicate%20%3Fsymbol%20.%0A%20%20%3Fpredicate%20%3Frelation%20%3Fdescription%20.%0A%20%20FILTER(%20lcase(str(%3Fsymbol))%20%3D%20%22a2m%22)%0A%7D&format=text%2Fhtml&timeout=0&signal_void=on Finding out relationships of a symbol E.g. "a2m" +=> https://sparql.genenetwork.org/sparql?default-graph-uri=http%3A%2F%2Fgenenetwork.org&qtxt=PREFIX%20gn%3A%20%3Chttp%3A%2F%2Fgenenetwork.org%2F%3E%0APREFIX%20dct%3A%20%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0APREFIX%20generif%3A%20%3Chttps%3A%2F%2Fwww.ncbi.nlm.nih.gov%2Fgene%3FDb%3Dgene%26Cmd%3DDetailsSearch%26Term%3D%3E%0A%0ASELECT%20DISTINCT%20%3Fsubject%20%3Fpredicate%20%3Frelation%20%3Fdescription%20WHERE%20%7B%0A%20%20%3Fsubject%20%3Fpredicate%20%3Fsymbol%20.%0A%20%20%3Fpredicate%20%3Frelation%20%3Fdescription%20.%0A%20%20FILTER(%20lcase(str(%3Fsymbol))%20%3D%20%22a2m%22)%0A%7D&format=text%2Fhtml&timeout=0&signal_void=on Finding out relationships of a symbol E.g. "a2m" (note very slow query!) => https://sparql.genenetwork.org/sparql?default-graph-uri=&qtxt=PREFIX%20chebi%3A%20%3Chttp%3A%2F%2Fpurl.obolibrary.org%2Fobo%2FCHEBI_%3E%0APREFIX%20dct%3A%20%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2F%3E%0APREFIX%20foaf%3A%20%3Chttp%3A%2F%2Fxmlns.com%2Ffoaf%2F0.1%2F%3E%0APREFIX%20generif%3A%20%3Chttp%3A%2F%2Fwww.ncbi.nlm.nih.gov%2Fgene%3Fcmd%3DRetrieve%26dopt%3DGraphics%26list_uids%3D%3E%0APREFIX%20gn%3A%20%3Chttp%3A%2F%2Fgenenetwork.org%2F%3E%0APREFIX%20hgnc%3A%20%3Chttp%3A%2F%2Fbio2rdf.org%2Fhgnc%3A%3E%0APREFIX%20homologene%3A%20%3Chttps%3A%2F%2Fbio2rdf.org%2Fhomologene%3A%3E%0APREFIX%20kegg%3A%20%3Chttp%3A%2F%2Fbio2rdf.org%2Fns%2Fkegg%23%3E%0APREFIX%20molecularTrait%3A%20%3Chttp%3A%2F%2Fgenenetwork.org%2Fmolecular-trait%2F%3E%0APREFIX%20nuccore%3A%20%3Chttps%3A%2F%2Fwww.ncbi.nlm.nih.gov%2Fnuccore%2F%3E%0APREFIX%20omim%3A%20%3Chttps%3A%2F%2Fwww.omim.org%2Fentry%2F%3E%0APREFIX%20owl%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2002%2F07%2Fowl%23%3E%0APREFIX%20phenotype%3A%20%3Chttp%3A%2F%2Fgenenetwork.org%2Fphenotype%2F%3E%0APREFIX%20pubchem%3A%20%3Chttps%3A%2F%2Fpubchem.ncbi.nlm.nih.gov%2F%3E%0APREFIX%20pubmed%3A%20%3Chttp%3A%2F%2Frdf.ncbi.nlm.nih.gov%2Fpubmed%2F%3E%0APREFIX%20rdf%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F1999%2F02%2F22-rdf-syntax-ns%23%3E%0APREFIX%20rdfs%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2000%2F01%2Frdf-schema%23%3E%0APREFIX%20taxon%3A%20%3Chttp%3A%2F%2Fpurl.uniprot.org%2Ftaxonomy%2F%3E%0APREFIX%20uniprot%3A%20%3Chttp%3A%2F%2Fpurl.uniprot.org%2Funiprot%2F%3E%0APREFIX%20up%3A%20%3Chttp%3A%2F%2Fpurl.uniprot.org%2Fcore%2F%3E%0APREFIX%20xsd%3A%20%3Chttp%3A%2F%2Fwww.w3.org%2F2001%2FXMLSchema%23%3E%0A%0ASELECT%20%3Fp%20%3Fo%20WHERE%20%7B%0Apubmed%3A2760876%20%3Fp%20%3Fo%20.%0A%7D%0A&format=text%2Fhtml&timeout=0&signal_void=on Get all metadata about a publication with pmid:2760876 -- cgit v1.2.3