aboutsummaryrefslogtreecommitdiff
path: root/rdf-documentation/publication-metadata.md
diff options
context:
space:
mode:
Diffstat (limited to 'rdf-documentation/publication-metadata.md')
-rw-r--r--rdf-documentation/publication-metadata.md51
1 files changed, 51 insertions, 0 deletions
diff --git a/rdf-documentation/publication-metadata.md b/rdf-documentation/publication-metadata.md
new file mode 100644
index 0000000..018f6da
--- /dev/null
+++ b/rdf-documentation/publication-metadata.md
@@ -0,0 +1,51 @@
+# Publications Metadata
+## 'publication'
+
+## Generated Triples:
+
+The following SQL query was executed:
+
+```sql
+SELECT IF(Publication.PubMed_ID IS NULL, '', CONVERT(Publication.PubMed_Id, INT)) AS pmid, Publication.Id, IFNULL(PubMed_ID, '') AS pubmedId, Publication.Title, Publication.Journal, Publication.Volume, Publication.Pages, Publication.Month, IF(Publication.Year = 0, NULL, Publication.Year) AS Year, Publication.Authors, Publication.Abstract FROM Publication
+```
+
+The above query results to triples that have the form:
+
+```text
+pubmed:pmid -> rdf:type -> fabio:ResearchPaper
+pubmed:pmid -> fabio:hasPubMedId -> pubmed:pubmedId
+pubmed:pmid -> dct:title -> Publication(Title)
+pubmed:pmid -> fabio:Journal -> Publication(Journal)
+pubmed:pmid -> prism:volume -> Publication(Volume)
+pubmed:pmid -> fabio:page -> Publication(Pages)
+pubmed:pmid -> prism:publicationDate -> "Publication(Month)"^^xsd:gMonth
+pubmed:pmid -> fabio:hasPublicationYear -> "Year"^^xsd:gYear
+pubmed:pmid -> dct:abstract -> PublicationAbstract
+pubmed:pmid -> dct:creator -> PublicationAuthors
+```
+Here's an example query:
+
+```sparql
+PREFIX gnt: <http://genenetwork.org/terms/>
+PREFIX fabio: <http://purl.org/spar/fabio/>
+PREFIX dct: <http://purl.org/dc/terms/>
+PREFIX prism: <http://prismstandard.org/namespaces/basic/2.0/>
+PREFIX gn: <http://genenetwork.org/id/>
+PREFIX gnc: <http://genenetwork.org/category/>
+PREFIX pubmed: <http://rdf.ncbi.nlm.nih.gov/pubmed/>
+PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
+PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
+PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
+
+SELECT * WHERE {
+ ?s rdf:type fabio:ResearchPaper .
+ ?s ?p ?o .
+}
+```
+
+Expected Result:
+
+```rdf
+gn:unpublished_1 rdf:type fabio:ResearchPaper .
+```
+