about summary refs log tree commit diff
diff options
context:
space:
mode:
authorPjotr Prins2016-05-25 08:21:30 +0000
committerPjotr Prins2016-05-25 08:21:30 +0000
commit5925dc7199a9fc6766c0468f5625068d1bd9603f (patch)
tree7544c44ec1e7f51635d42af0c2ff0809d38799bd
parent36dc2d077debe2c82f13b67887689bd11025cf1b (diff)
downloadgenenetwork2-5925dc7199a9fc6766c0468f5625068d1bd9603f.tar.gz
Docs: database reverse engineering
-rw-r--r--doc/database.org16
-rw-r--r--doc/database.svg21
2 files changed, 33 insertions, 4 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 
 
diff --git a/doc/database.svg b/doc/database.svg
index ae9d55a5..9ddc2f47 100644
--- a/doc/database.svg
+++ b/doc/database.svg
@@ -15,7 +15,7 @@
    id="svg2"
    version="1.1"
    inkscape:version="0.91 r13725"
-   sodipodi:docname="drawing.svg">
+   sodipodi:docname="database.svg">
   <defs
      id="defs4">
     <marker
@@ -228,7 +228,7 @@
      inkscape:pageopacity="0.0"
      inkscape:pageshadow="2"
      inkscape:zoom="0.98994949"
-     inkscape:cx="359.48602"
+     inkscape:cx="361.50633"
      inkscape:cy="527.18241"
      inkscape:document-units="px"
      inkscape:current-layer="layer1"
@@ -252,7 +252,7 @@
         <dc:format>image/svg+xml</dc:format>
         <dc:type
            rdf:resource="http://purl.org/dc/dcmitype/StillImage" />
-        <dc:title></dc:title>
+        <dc:title />
       </cc:Work>
     </rdf:RDF>
   </metadata>
@@ -863,5 +863,20 @@
        inkscape:connector-curvature="0"
        inkscape:transform-center-x="-32.453094"
        inkscape:transform-center-y="114.65633" />
+    <text
+       xml:space="preserve"
+       style="font-style:normal;font-weight:normal;font-size:12.5px;line-height:125%;font-family:sans-serif;letter-spacing:0px;word-spacing:0px;fill:#000000;fill-opacity:1;stroke:none;stroke-width:1px;stroke-linecap:butt;stroke-linejoin:miter;stroke-opacity:1"
+       x="150.51273"
+       y="40.18935"
+       id="text3465"
+       sodipodi:linespacing="125%"><tspan
+         sodipodi:role="line"
+         id="tspan3467"
+         x="150.51273"
+         y="40.18935">speciesid</tspan><tspan
+         sodipodi:role="line"
+         x="150.51273"
+         y="55.81435"
+         id="tspan3469" /></text>
   </g>
 </svg>