diff options
| author | Munyoki Kilyungi | 2023-08-15 21:15:11 +0300 |
|---|---|---|
| committer | Munyoki Kilyungi | 2023-08-15 21:15:11 +0300 |
| commit | be450b02198f08363986aecfd5227752d2e4ca72 (patch) | |
| tree | bdcd718c86fc7366a5cfa0b234ff307f0c15c052 /rdf-documentation/dump-species-metadata.md | |
| parent | a9472810f601b48c643724c9186ec44721732fa7 (diff) | |
| download | gn-docs-be450b02198f08363986aecfd5227752d2e4ca72.tar.gz | |
Update auto-generated docs
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'rdf-documentation/dump-species-metadata.md')
| -rw-r--r-- | rdf-documentation/dump-species-metadata.md | 14 |
1 files changed, 7 insertions, 7 deletions
diff --git a/rdf-documentation/dump-species-metadata.md b/rdf-documentation/dump-species-metadata.md index 6a3c485..495905a 100644 --- a/rdf-documentation/dump-species-metadata.md +++ b/rdf-documentation/dump-species-metadata.md @@ -244,18 +244,18 @@ gn:Mus_musculus gnt:organism taxon:10090 . The following SQL query was executed: ```sql -SELECT CAST(CONVERT(BINARY CONVERT(Strain.Name USING latin1) USING utf8) AS VARCHAR(15000)) AS StrainName, 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, IF ((Strain.Symbol != Strain.Name), Strain.Symbol, '') AS Symbol FROM Strain LEFT JOIN Species ON Strain.SpeciesId = Species.SpeciesId ``` The above query results to triples that have the form: ```text -gn:Strainname -> rdf:type -> gnc:strain -gn:Strainname -> gnt:species -> gn:Species_fullname -gn:Strainname -> rdfs:label -> StrainName -gn:Strainname -> rdfs:label -> Name2 -gn:Strainname -> gnt:alias -> Alias -gn:Strainname -> gnt:symbol -> Symbol +gn:Strain_name_ -> rdf:type -> gnc:strain +gn:Strain_name_ -> gnt:species -> gn:Species_fullname +gn:Strain_name_ -> rdfs:label -> StrainName +gn:Strain_name_ -> rdfs:label -> Name2 +gn:Strain_name_ -> gnt:alias -> Alias +gn:Strain_name_ -> gnt:symbol -> Symbol ``` Here's an example query: |