- 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...
- 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...
- 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).
- 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...
- 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...
- '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...
- 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.
- 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...