aboutsummaryrefslogtreecommitdiff
path: root/doc/database.org
diff options
context:
space:
mode:
authorPjotr Prins2016-05-25 08:21:30 +0000
committerPjotr Prins2016-05-25 08:21:30 +0000
commit5925dc7199a9fc6766c0468f5625068d1bd9603f (patch)
tree7544c44ec1e7f51635d42af0c2ff0809d38799bd /doc/database.org
parent36dc2d077debe2c82f13b67887689bd11025cf1b (diff)
downloadgenenetwork2-5925dc7199a9fc6766c0468f5625068d1bd9603f.tar.gz
Docs: database reverse engineering
Diffstat (limited to 'doc/database.org')
-rw-r--r--doc/database.org16
1 files changed, 15 insertions, 1 deletions
diff --git a/doc/database.org b/doc/database.org
index 6e0f42c9..2221c4fb 100644
--- a/doc/database.org
+++ b/doc/database.org
@@ -681,7 +681,21 @@ No longer used
** Species & Strain (should be sample)
-Menu
+select * from Species;
++----+-----------+----------------------+----------------+----------------------+-------------------------+------------+---------+
+| Id | SpeciesId | SpeciesName | Name | MenuName | FullName | TaxonomyId | OrderId |
++----+-----------+----------------------+----------------+----------------------+-------------------------+------------+---------+
+| 1 | 1 | Mouse | mouse | Mouse | Mus musculus | 10090 | 30 |
+| 2 | 2 | Rat | rat | Rat | Rattus norvegicus | 10116 | 40 |
+| 3 | 3 | Arabidopsis thaliana | arabidopsis | Arabidopsis thaliana | Arabidopsis thaliana | 3702 | 60 |
+| 4 | 4 | Human | human | Human | Homo sapiens | 9606 | 10 |
+| 5 | 5 | Barley | barley | Barley | Hordeum vulgare | 4513 | 70 |
+| 6 | 6 | Drosophila | drosophila | Drosophila | Drosophila melanogaster | 7227 | 50 |
+| 7 | 7 | Macaque monkey | macaque monkey | Macaque monkey | Macaca mulatta | 9544 | 20 |
+| 8 | 8 | Soybean | soybean | Soybean | Soybean | 3847 | 80 |
+| 9 | 9 | Tomato | tomato | Tomato | Tomato | 4081 | 90 |
++----+-----------+----------------------+----------------+----------------------+-------------------------+------------+---------+
+
** InbredSet