From e42749edb171151665093db8345a9052d680f016 Mon Sep 17 00:00:00 2001 From: Munyoki Kilyungi Date: Fri, 12 Apr 2024 13:27:06 +0300 Subject: Update RDF documentation. Signed-off-by: Munyoki Kilyungi --- rdf-documentation/strains.md | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'rdf-documentation/strains.md') diff --git a/rdf-documentation/strains.md b/rdf-documentation/strains.md index 87a8ce9..db05318 100644 --- a/rdf-documentation/strains.md +++ b/rdf-documentation/strains.md @@ -6,7 +6,7 @@ The following SQL query was executed: ```sql -SELECT Strain.Name, Species.Fullname, Strain.Name, IF ((Strain.Name2 != Strain.Name), Strain.Name2, '') AS Name2, IF ((Strain.Alias != Strain.Name), Strain.Alias, '') AS Alias, IF ((Strain.Symbol != Strain.Name), Strain.Symbol, '') AS Symbol FROM Strain LEFT JOIN Species ON Strain.SpeciesId = Species.SpeciesId +SELECT Strain.Name, Species.Fullname, Strain.Name, IF ((Strain.Name2 != Strain.Name), Strain.Name2, '') AS Name2, IF ((Strain.Alias != Strain.Name), Strain.Alias, '') AS Alias, Strain.Symbol FROM Strain LEFT JOIN Species ON Strain.SpeciesId = Species.SpeciesId ``` The above query results to triples that have the form: @@ -17,7 +17,7 @@ gn:Strain_name_ -> gnt:belongsToSpecies -> gn:Species_fullname gn:Strain_name_ -> rdfs:label -> StrainName gn:Strain_name_ -> skos:altLabel -> Name2 gn:Strain_name_ -> gnt:alias -> Alias -gn:Strain_name_ -> gnt:symbol -> Symbol +gn:Strain_name_ -> gnt:geneSymbol -> Strain(Symbol) ``` Here's an example query: -- cgit v1.2.3