- Slow query
issue opened on May 27 2023 by Pjotr Prins, last updated on May 29 2023 by Pjotr Prins; 0 of 2 tasks done
Slow query
Essentially two tables were utf8 (= utf8mb3). The others are utf8mb4. When comparing text fields mariadb can't optimize because it is translating utf8mb3 for every comparison. Changing...
- Slow query
issue opened on Mar 23 2022 by Frederick Muriuki Muriithi
Slow query
## Tags
* assigned: Uditgulati
* priority: high
* status: stalled
* keywords: slow query, from github
## Description
=> https://github.com/genenetwork/genenetwork2/issues/419 From GitHub...
- Global search does not close connections properly (and is slow)
✓ issue opened on Mar 23 2022 by Frederick Muriuki Muriithi, last updated on Oct 14 2022 by Arun Isaac
Global search does not close connections properly (and is slow)
## Tags
* type: bug
* priority: medium
* status: stalled
* assigned: Uditgulati
* keywords: global search, db connections, medium...
- Annotate traits page with metadata from RDF
✓ issue opened on Sep 30 2022 by Munyoki Kilyungi, last updated on Dec 15 2022 by Munyoki Kilyungi; 16 of 16 tasks done
My findings are: federated queries can be slow (querying wikidata took as long as 5-30 seconds). As such, a better strategy would be to write scripts to enrich our dataset from other data sources...
- Sheepdog
issue opened on Nov 08 2021 by Pjotr Prins, last updated on Jul 01 2022 by Arun Isaac; 3 of 17 tasks done
...exists)
* [ ] synchronize between queues using a dump
* [ ] sheepdog_expect.rb - expect PINGs
* [ ] sheepdog_rsync.rb - test for 'total size is 0'
* [ ] sheepdog_list tag and filter switches improve...
- GN1 github problem
issue opened on Dec 17 2022 by Pjotr Prins
...rm --cached --ignore-unmatch \
MouseTissuesRWWMay08.xls' --prune-empty --tag-name-filter cat -- --all
git reflog expire --expire=now --all && git gc --prune=now --aggressive
```
Note this rewrites...
- GN1 Production
issue opened on Sep 15 2021 by Pjotr Prins, last updated on Mar 14 2022 by Frederick Muriuki Muriithi; 3 of 8 tasks done
...pjotrp, zachs, robw
## List of outstanding issues
(see also E-mail Rob 14 Sep 2021)
* [ ] Fix annotating metadata - or do we have GN2 alternative?
=> gn1-slowness.gmi [.] Clean up tmp dirs with CRON...
- rewrite sampledata fetching with genofiles using scheme
issue opened on Jul 19 2023 by Alexander_Kabui, last updated on Jul 26 2023 by Alexander_Kabui; 2 of 6 tasks done
.../data-vault-2
### TODOS
* [x] reading the genofile
* [x] parsing the genofile to obtain the sample names,metadata
* [] adding unit tests for the module
* [] query statements fetch sampledata...
- Designing an issue tracker on gemini
✓ issue opened on Jul 25 2021 by Pjotr Prins, last updated on Feb 02 2022 by Pjotr Prins
...help wanted
* closed
the keyword statement may have aliases, such as tag and kanban. To undo a keyword simply remove them from the file.
Can't think of anything more to add to make it really useful...
- Fetch trait names for phenotypes
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
...query returns detailed information for transcript expression traits, but not for traits from the 'Publish' database.
### Describe the solution you'd like
For example, downloading the data as CSV via...
- Add track for showing which regions in mouse/rat correspond to human regions to the mapping figure
issue opened on Jul 21 2022 by Zachary Sloan, last updated on Sep 14 2022 by Pjotr Prins
...an arrow depending on the strand (whether the query strand matches the reference
[ ] Store the homology chain file data differently (keeping it as a text file might be fine, but need to find a better...
- AI UI Enhancements
issue opened on Mar 01 2024 by Pjotr Prins; 0 of 3 tasks done
...GN searched for the term(s) "shh" in 754 datasets and 39,765,944 traits across 10 species
and found 1210 results that match your query.
You can filter these results by adding key words in the fields...
- Variant Browser seems to be using mm9
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
...do not match the query.
Searching for a gene gives correct coordinates in the search box at http://www.genenetwork.org/snp_browser, but the results are for the same coordinates in mm9 (see screenshot).
- Fallback issues
issue opened on Mar 22 2024 by Pjotr Prins, last updated on Apr 05 2024 by Pjotr Prins; 3 of 6 tasks done
...prepare_url
scheme, auth, host, port, path, query, fragment = parse_url(url)
File "/gnu/store/a39cgbdawj9vp24nsz9q25sf9g5vda7c-profile/lib/python3.10/site-packages/urllib3/util/url.py", line 397...
- Add the option to save traits uploaded with the Submit Trait option
issue opened on Jul 19 2022 by Zachary Sloan
...data, meta-data
# Description
Current the Submit Trait feature only allows for trait data (submitted as just a string of values) to be saved as a "temp" trait (that is saved in Redis for a limited...
- Capture Data on the BXDs in RDF
✓ issue opened on Mar 23 2022 by Frederick Muriuki Muriithi, last updated on Oct 12 2022 by Munyoki Kilyungi
...biomedcentral.com/articles/10.1186/2041-1480-4-13 The Vertebrate Trait Ontology: a controlled vocabulary for the annotation of trait data across species
When an ontology exists and it looks sensible...
- Fetch trait data using genofiles
issue opened on Jul 11 2023 by Alexander_Kabui, last updated on Jul 13 2023 by Alexander_Kabui; 2 of 3 tasks done
...Genoset and Publish data types
### Publish Dataset
Example for phenotype fetching data for phenotype 35
```sql
SELECT A.Sample, A.Value, A.SE, A.Count, B.CaseAttributes FROM
(SELECT DISTINCT st.Name...
- csv export meta data are not commented out
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
...meta data
## Description
=> https://github.com/genenetwork/genenetwork2/issues/594 From GitHub
csv export data can't be read using the example R code
The csv looks like this:
```
Phenotype ID: 11320...
- Allow analyses to be done between traits from "individuals" groups and their corresponding "main" group
issue opened on Jul 21 2022 by Zachary Sloan
...data, meta-data
# Description
Currently you can't do an analysis beween traits from the "main" BXD group and traits from any of the BXD individuals groups, but it should technically be possible to do...
- 'TempDataSet' object has no attribute 'query_for_group' (error)
✓ issue opened on Mar 22 2022 by Frederick Muriuki Muriithi, last updated on Sep 28 2022 by Alexander_Kabui
...data that I tried to upload and check on GN2 was the
median-lateral position of the representation of visual space on V1. It was
old data that we had, but never uploaded, because we were investigating...
- Wrong CSV in ITP_10001 longevity dataset
✓ issue opened on Apr 11 2022 by BonfaceKilz, last updated on Apr 12 2022 by BonfaceKilz
...download that data for use, they were not being stripped out. As a consequence, opening the csv file in Excel (or similar) software resulted in data that seems jumbled up.
### Tue 12 Apr 2022 13:33:31...
- Add an 'Edit Issue' Link to Tissue
✓ issue opened on Mar 24 2022 by Frederick Muriuki Muriithi, last updated on Apr 15 2022 by Arun Isaac
...expected, see the `edit page` link/button at
=> http://gemini.thebird.nl/gemini/genenetwork/gn-gemtext-threads/topics/data-uploads/editing-data.gmi
noting how it drops you straight into editting the...
- Fallbacks and backups
issue opened on Aug 31 2021 by Pjotr Prins, last updated on Jun 28 2024 by Pjotr Prins; 3 of 25 tasks done
...backups
* [ ] mount bacchus on HPC
## Backup and restore
We are using borg for backing up data. Borg is excellent at deduplication and compression of data and is pretty fast too. Incremental copies...
- GN Markdown Editor Integration
issue opened on Jun 07 2024 by Alexander_Kabui, last updated on Aug 22 2024 by Alexander_Kabui; 9 of 10 tasks done
...@gmail.com",
"username": "test",
"commit_message": "init commit",
"prev_commit": "7cbfc40d98b49a64e98e7cd562f373053d0325bd"
}'
```
It expects the following data in JSON format:
* `content` (the data...
- Multi-trait heat map failed
issue opened on Mar 23 2022 by Frederick Muriuki Muriithi
...trimmed_values)
IndexError: reaper: the length of the strain list and the value list are different,
```
One of my traits had missing data, deselecting this trait fixed the problem. Record 20761.
- Capture state of phenotypes in a HASH
issue opened on Mar 23 2022 by Frederick Muriuki Muriithi
...hash can be computed over data that is streamed over the REST API - so people van validate client side (as a feature).
This mentions RDF - which I think
* aruni
was involved in. I (fredm) have tagged...
- Adding principal component to collection returns an error
issue opened on Mar 23 2022 by Frederick Muriuki Muriithi, last updated on Apr 07 2022 by Alexander Kabui
...'BXD Aged hippocampus individual data' dataset (GN712).
### Expected behavior
The PC should be treated as a normal trait and added to the collection.
### Screenshots
Environment setup (please complete...
- Linking genotype files to datasets
issue opened on Jul 07 2023 by Alexander_Kabui, last updated on Jul 11 2023 by Alexander_Kabui
...data fetch all possible groups in a dataset then use that to fetch all linked genofiles
As an example example the dataset HC_M2_0606_P is of type Probeset and linked groups for this dataset include...
- GN2 Time Machines
issue opened on Aug 19 2022 by Pjotr Prins, last updated on Sep 05 2022 by Alexander_Kabui; 4 of 10 tasks done
.../mysql/data/mysqld.pid
+# ExecStartPost=/bin/sh -c "systemctl unset-environment _WSREP_START_POSITION"
-ExecStartPost=/etc/mysql/debian-start
+RestartSec=15s
+TimeoutStartSec=infinity
+TimeoutStopSec...