diff options
author | Pjotr Prins | 2023-03-24 10:45:54 +0100 |
---|---|---|
committer | Pjotr Prins | 2023-03-24 10:45:54 +0100 |
commit | 0c81484eb1d5862f990f6b44ac1df480c3fcc9d9 (patch) | |
tree | dbd0f00012401b928c66f9a92f60377c73b2a663 /topics/systems/mariadb | |
parent | 03f29b98d4b7468b63cf6fd0cc6cc6abfd558b3d (diff) | |
download | gn-gemtext-0c81484eb1d5862f990f6b44ac1df480c3fcc9d9.tar.gz |
Info on dumping database to RDF
Diffstat (limited to 'topics/systems/mariadb')
-rw-r--r-- | topics/systems/mariadb/precompute-mapping-input-data.gmi | 11 |
1 files changed, 9 insertions, 2 deletions
diff --git a/topics/systems/mariadb/precompute-mapping-input-data.gmi b/topics/systems/mariadb/precompute-mapping-input-data.gmi index 9ce4c95..d26a97a 100644 --- a/topics/systems/mariadb/precompute-mapping-input-data.gmi +++ b/topics/systems/mariadb/precompute-mapping-input-data.gmi @@ -115,7 +115,7 @@ Rob voiced a wish to retain all scores (at least those above 1.0). This is not f ## Notes on ProbeSetXRef -ProbeSetXRef is pretty small, currently @5.6Gb and 48,307,650 rows, so we could decide to add columns to track different mappers. Something funny +ProbeSetXRef is pretty small, currently @5.6Gb and 48,307,650 rows, so we could decide to add columns to track different mappers. Something funny ``` select count(LRS) from ProbeSetXRef; @@ -150,5 +150,12 @@ MariaDB [db_webqtl]> select count(*) from ProbeSetXRef where LRS=0 and Locus="rs +----------+ ``` -There is obviously more. I think this table can use some cleaning up? +There is obviously more. I think this table can use some cleaning up? +## Preparing for GEMMA + +A good dataset to take apart is + +=> http://genenetwork.org/show_trait?trait_id=1436869_at&dataset=HC_M2_0606_P + +because it has 71 BXD samples and 32 other samples. |