aboutsummaryrefslogtreecommitdiff
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>