diff options
| author | Pjotr Prins | 2016-05-25 08:21:30 +0000 |
|---|---|---|
| committer | Pjotr Prins | 2016-05-25 08:21:30 +0000 |
| commit | 5925dc7199a9fc6766c0468f5625068d1bd9603f (patch) | |
| tree | 7544c44ec1e7f51635d42af0c2ff0809d38799bd /doc/database.org | |
| parent | 36dc2d077debe2c82f13b67887689bd11025cf1b (diff) | |
| download | genenetwork2-5925dc7199a9fc6766c0468f5625068d1bd9603f.tar.gz | |
Docs: database reverse engineering
Diffstat (limited to 'doc/database.org')
| -rw-r--r-- | doc/database.org | 16 |
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 |