diff options
| author | Munyoki Kilyungi | 2024-04-12 13:27:06 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2024-04-12 13:27:06 +0300 |
| commit | e42749edb171151665093db8345a9052d680f016 (patch) | |
| tree | 2b67fbd7a56f980454db5d980573b65aa1bf92c9 /rdf-documentation/strains.md | |
| parent | 8a92d6874737ceac36113ed5a67ddf54f59953ae (diff) | |
| download | gn-docs-e42749edb171151665093db8345a9052d680f016.tar.gz | |
Update RDF documentation.
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'rdf-documentation/strains.md')
| -rw-r--r-- | rdf-documentation/strains.md | 4 |
1 files changed, 2 insertions, 2 deletions
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: |