summaryrefslogtreecommitdiff
path: root/issues/gemma
diff options
context:
space:
mode:
authorPjotr Prins2024-05-07 11:24:27 +0200
committerPjotr Prins2024-05-07 11:24:27 +0200
commita33b062cb2631064c9d5323ddc208933caf28624 (patch)
treee5e98f9f2c14f72ccea4e499c0c0984ae64b0950 /issues/gemma
parenta7bf2095c48bb8cd8fead123849d7e64c85b5bfb (diff)
downloadgn-gemtext-a33b062cb2631064c9d5323ddc208933caf28624.tar.gz
Precompute
Diffstat (limited to 'issues/gemma')
-rw-r--r--issues/gemma/lmm-precomputed-scores.gmi37
1 files changed, 8 insertions, 29 deletions
diff --git a/issues/gemma/lmm-precomputed-scores.gmi b/issues/gemma/lmm-precomputed-scores.gmi
index 744d51a..8db9722 100644
--- a/issues/gemma/lmm-precomputed-scores.gmi
+++ b/issues/gemma/lmm-precomputed-scores.gmi
@@ -7,36 +7,15 @@ Here we will track introducing a new precomputation of scores for GN. Interestin
* assigned: pjotrp
* priority: high
* type: bug, enhancement
-* status: unclear
+* status: ongoing
* keywords: database, gemma, reaper
-# Old storage
-
-The old reaper scores are in
-
-```
-MariaDB [db_webqtl]> select ProbeSetId,ProbeSetFreezeId,Locus,LRS,additive from ProbeSetXRef limit 10;
-+------------+------------------+----------------+------------------+--------------------+
-| ProbeSetId | ProbeSetFreezeId | Locus | LRS | additive |
-+------------+------------------+----------------+------------------+--------------------+
-| 1 | 1 | rs13480619 | 12.590069931048 | -0.28515625 |
-| 2 | 1 | rs29535974 | 10.5970737900941 | -0.116783333333333 |
-| 3 | 1 | rs49742109 | 6.0970532702754 | 0.112957489878542 |
-| 4 | 1 | rsm10000002321 | 11.7748675511731 | -0.157113725490196 |
-| 5 | 1 | rsm10000019445 | 10.9232633740162 | 0.114764705882353 |
-| 6 | 1 | rsm10000017255 | 8.45741703245224 | -0.200034412955466 |
-| 7 | 1 | rs4178505 | 7.46477918183565 | 0.104331983805668 |
-| 8 | 1 | rsm10000144086 | 12.1201771258006 | -0.134278431372548 |
-| 9 | 1 | rsm10000014965 | 11.8837168740735 | 0.341458333333334 |
-| 10 | 1 | rsm10000020208 | 10.2809848009836 | -0.173866666666667 |
-+------------+------------------+----------------+------------------+--------------------+
-10 rows in set (0.000 sec)
-```
-
-This means for every dataset one single maximum score gets stored (?)
-
-Moved to
+# Tasks
-=> ../../topics/systems/mariadb/precompute-mapping-input-data.gmi
+* [ ] Add the log values, effect size and number of individuals to the xapian search.
+
+# Note
-* closed
+First implementation in
+
+=> ../../topics/systems/mariadb/precompute-mapping-input-data.gmi