diff options
author | Munyoki Kilyungi | 2023-08-24 13:08:59 +0300 |
---|---|---|
committer | Munyoki Kilyungi | 2023-08-24 13:09:20 +0300 |
commit | edca04399ae950698a89a64160cd35f6164f4b1c (patch) | |
tree | d9367d9bb35e00e0af2681437c6b53fa06902fc1 /rdf-documentation/dump-genotype.md | |
parent | 04fccc0b9d0cdee9679a8682f825e605e7368bd3 (diff) | |
download | gn-docs-edca04399ae950698a89a64160cd35f6164f4b1c.tar.gz |
Update autogenerated docs
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
Diffstat (limited to 'rdf-documentation/dump-genotype.md')
-rw-r--r-- | rdf-documentation/dump-genotype.md | 117 |
1 files changed, 0 insertions, 117 deletions
diff --git a/rdf-documentation/dump-genotype.md b/rdf-documentation/dump-genotype.md deleted file mode 100644 index 2f5edbc..0000000 --- a/rdf-documentation/dump-genotype.md +++ /dev/null @@ -1,117 +0,0 @@ -# Genotype Metadata -## 'dump-genofreeze' - -## Generated Triples: - -The following SQL query was executed: - -```sql -SELECT GenoFreeze.Name, GenoFreeze.Name, GenoFreeze.FullName, GenoFreeze.ShortName, GenoFreeze.CreateTime, InbredSet.Name AS InbredSetName FROM GenoFreeze LEFT JOIN InfoFiles ON InfoFiles.InfoPageName = GenoFreeze.Name LEFT JOIN InbredSet ON GenoFreeze.InbredSetId = InbredSet.InbredSetId WHERE GenoFreeze.public > 0 AND GenoFreeze.confidentiality < 1 AND InfoFiles.InfoPageName IS NULL -``` - -The above query results to triples that have the form: - -```text -gn:Genofreeze_name_ -> rdf:type -> gnc:genotypeDataset -gn:Genofreeze_name_ -> rdfs:label -> GenoFreeze(Name) -gn:Genofreeze_name_ -> skos:prefLabel -> GenoFreeze(FullName) -gn:Genofreeze_name_ -> skos:altLabel -> GenoFreeze(ShortName) -gn:Genofreeze_name_ -> dct:created -> "GenoFreeze(CreateTime)"^^xsd:date -gn:Genofreeze_name_ -> gnt:belongsToInbredSet -> gn:_inbredset_inbredsetname -``` -Here's an example query: - -```sparql -PREFIX dct: <http://purl.org/dc/terms/> -PREFIX gn: <http://genenetwork.org/id/> -PREFIX gnc: <http://genenetwork.org/category/> -PREFIX gnt: <http://genenetwork.org/term/> -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> -PREFIX owl: <http://www.w3.org/2002/07/owl#> -PREFIX skos: <http://www.w3.org/2004/02/skos/core#> -PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> - -SELECT * WHERE { - ?s rdf:type gnc:genotypeDataset . - ?s rdfs:label "B6D2RIGeno" . - ?s skos:prefLabel "B6D2RI Genotypes" . - ?s ?p ?o . -} -``` - -Expected Result: - -```rdf -gn:B6d2rigeno rdf:type gnc:genotypeDataset . -gn:B6d2rigeno rdfs:label "B6D2RIGeno" . -gn:B6d2rigeno skos:prefLabel "B6D2RI Genotypes" . -gn:B6d2rigeno skos:altLabel "B6D2RIGeno" . -gn:B6d2rigeno dct:created "2022-10-24"^^xsd:date . -gn:B6d2rigeno gnt:belongsToInbredSet gn:_b6d2ri . -``` - - -## 'dump-genotypes' - -## Generated Triples: - -The following SQL query was executed: - -```sql -SELECT Geno.Name, Geno.Name, Geno.Chr, IFNULL(Geno.Mb, '') AS Mb, IFNULL(Geno.Mb_mm8, '') AS Mb_mm8, IFNULL(Geno.Mb_2016, '') AS Mb_2016, Geno.Sequence, Geno.Source, IF((Source2 = Source), NULL, Source2) AS Source2, Species.Fullname, Geno.chr_num, Geno.Comments FROM Geno LEFT JOIN Species USING (SpeciesId) -``` - -The above query results to triples that have the form: - -```text -gn:Geno_name_ -> rdf:type -> gnc:genotype -gn:Geno_name_ -> skos:prefLabel -> GenoName -gn:Geno_name_ -> gnt:chr -> Geno(Chr) -gn:Geno_name_ -> gnt:mb -> "Mb"^^xsd:double -gn:Geno_name_ -> gnt:mbMm8 -> "Mb_mm8"^^xsd:double -gn:Geno_name_ -> gnt:mb2016 -> "Mb_2016"^^xsd:double -gn:Geno_name_ -> gnt:hasSequence -> Geno(Sequence) -gn:Geno_name_ -> gnt:hasSource -> Geno(Source) -gn:Geno_name_ -> gnt:hasAltSourceName -> Source2 -gn:Geno_name_ -> gnt:belongsToSpecies -> gn:Species_fullname -gn:Geno_name_ -> gnt:chrNum -> "Geno(chr_num)"^^xsd:int -gn:Geno_name_ -> rdfs:comments -> Geno(Comments) -``` -Here's an example query: - -```sparql -PREFIX dct: <http://purl.org/dc/terms/> -PREFIX gn: <http://genenetwork.org/id/> -PREFIX gnc: <http://genenetwork.org/category/> -PREFIX gnt: <http://genenetwork.org/term/> -PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#> -PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> -PREFIX owl: <http://www.w3.org/2002/07/owl#> -PREFIX skos: <http://www.w3.org/2004/02/skos/core#> -PREFIX xsd: <http://www.w3.org/2001/XMLSchema#> - -SELECT * WHERE { - ?s rdf:type gnc:genotype . - ?s skos:prefLabel "D1Mit296" . - ?s gnt:chr "1" . - ?s gnt:mb #{"9.749729"^^xsd:double}# . - ?s ?p ?o . -} -``` - -Expected Result: - -```rdf -gn:D1mit296 rdf:type gnc:genotype . -gn:D1mit296 skos:prefLabel "D1Mit296" . -gn:D1mit296 gnt:chr "1" . -gn:D1mit296 gnt:mb "9.749729"^^xsd:double . -gn:D1mit296 gnt:mbMm8 "9.734943"^^xsd:double . -gn:D1mit296 gnt:mb2016 "9.73981"^^xsd:double . -gn:D1mit296 gnt:hasSequence "CTTGCATGCCTGCGGNTNCGNACTCTAGAGGATCTCCCTATTATTNTNACATNACTTTNAATTAAAATAATAATCAGATAACTTCAACNNNNTGNNCACTTCTGTCAAGTGGACAGAAATAAACATAGAGCCTAATTATCCTGAATTTNAGAGAAAAGAGTGTGTTTANCACAANAGAACAGTTATAGATCTACACACACACACACACACACACACACACACACATACAGTTTGAAAAATGCATCAGTTGAGACC" . -gn:D1mit296 gnt:hasSource "Mit" . -gn:D1mit296 gnt:belongsToSpecies gn:Mus_musculus . -gn:D1mit296 gnt:chrNum "1"^^xsd:int . -``` - |