summaryrefslogtreecommitdiff
path: root/topics/gn-uploader
diff options
context:
space:
mode:
authorFrederick Muriuki Muriithi2024-04-04 15:14:51 +0300
committerFrederick Muriuki Muriithi2024-04-04 15:21:51 +0300
commit3cddf08ad288f123619ca2a346beae7e85387cb2 (patch)
treeb3c4289ab274790cc4128d065e21b0888643f70a /topics/gn-uploader
parentb3ab3f9fdb10a972712da757af115495b5b241e1 (diff)
downloadgn-gemtext-3cddf08ad288f123619ca2a346beae7e85387cb2.tar.gz
gn-uploder: Document how to add new platforms.
Diffstat (limited to 'topics/gn-uploader')
-rw-r--r--topics/gn-uploader/adding-platforms.gmi96
1 files changed, 96 insertions, 0 deletions
diff --git a/topics/gn-uploader/adding-platforms.gmi b/topics/gn-uploader/adding-platforms.gmi
new file mode 100644
index 0000000..9e9ac2c
--- /dev/null
+++ b/topics/gn-uploader/adding-platforms.gmi
@@ -0,0 +1,96 @@
+# Adding Platforms
+
+## Tags
+
+* status: open
+* priority: medium
+* type: documentation
+* assigned: fredm, flisso, acenteno
+* keywords: doc, documentation, platform, gn-uploader, uploader
+
+## Description
+
+For the new data being uploaded, we sometimes need to add new platforms to the system. This document will list the new platforms that were added and the process to add them.
+
+The platforms will be listed below, according to the species.
+
+## Arabidopsis thaliana
+
+First off, get the species identifier:
+```
+MariaDB [db_webqtl]> SELECT * FROM Species WHERE SpeciesName LIKE 'Arabidopsis%';
++----+-----------+-------------+-------------+---------------------------------------------+----------------------+--------+---------------+------------+---------+
+| Id | SpeciesId | SpeciesName | Name | MenuName | FullName | Family | FamilyOrderId | TaxonomyId | OrderId |
++----+-----------+-------------+-------------+---------------------------------------------+----------------------+--------+---------------+------------+---------+
+| 3 | 3 | Arabidopsis | arabidopsis | Arabidopsis (Arabidopsis thaliana, araTha1) | Arabidopsis thaliana | Plants | 3 | 3702 | 45 |
++----+-----------+-------------+-------------+---------------------------------------------+----------------------+--------+---------------+------------+---------+
+1 row in set (0.00 sec)
+```
+
+From this we see the Id is "3". We will use this identifier when creating the new platform(s).
+
+### A. thaliana Platforms
+
+=> https://www.ncbi.nlm.nih.gov/geo/query/acc.cgi?acc=GPL198 GPL198: Affymetrix Arabidopsis ATH1 Genome Array
+
+## Drosophila melanogaster dm6
+
+…
+
+## Glossophaga soricina
+
+…
+
+## Glycine max
+
+…
+
+## Homo sapiens
+
+…
+
+## Hordeum vulgare
+
+…
+
+## Macaca mulatta
+
+…
+
+## Mus musculus
+
+…
+
+## Oryzias latipes
+
+…
+
+## Populus trichocarpa
+
+…
+
+## Rattus norvegicus
+
+…
+
+## Solanum lycopersicum
+
+…
+
+## Inserting A Platform: Example
+
+Using the "GPL198" (for the A. thaliana species) as an example, we add the new platform with the following queries:
+
+```
+INSERT INTO GeneChip(
+ GeneChipName, Name, GeoPlatform, Title, SpeciesId, GO_tree_value)
+VALUES(
+ "Affymetrix Arabidopsis ATH1 Genome Array (ATH1-121501)",
+ "Affy_AG_ATH1_121501", "GPL198", "Affymetrix Arabidopsis ATH1 Genome Array",
+ "3", "affy_ag_ath1_121501");
+
+UPDATE GeneChip SET GeneChipId=Id WHERE GeoPlatform="GPL198";
+```
+
+The rules for the data in the `Name` field can be found under the
+=> https://gn1.genenetwork.org/webqtl/main.py?FormID=schemaShowPage#GeneChip GeneChip section of the Schema documentation.