- 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
...query.
## Indices
ProbeSet has a large number of columns, indices and full text indices(!)
## Nailing it down
The obvious thing to try is to reduce the query and see what speeds it up again. So, let's...
- 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...
- 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).
- 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...
- 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
...[Warning] Aborted connection 45219 to db: 'db_webqtl' user: 'webqtlout' host: '127.0.0.1' (CLOSE_CONNECTION)
```
generating 6Mb of log file info.
In fact, every row in the table has a SQL query...
- Fetch trait names for phenotypes
issue opened on Mar 22 2022 by Frederick Muriuki Muriithi
.../564 From GitHub
The 'Fetch Trait Info' query returns detailed information for transcript expression traits, but not for traits from the 'Publish' database.
### Describe the solution you'd like
For...
- 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
...showing homology across mouse/human/maybe rat (done for mouse, won't be hard to also enable for other species)
[ ] Make it display an arrow depending on the strand (whether the query strand matches...
- 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
...query for the trait:
```
PREFIX gn: <http://genenetwork.org/>
SELECT ?name ?dataset ?dataset_group ?title ?summary ?aboutTissue ?aboutPlatform ?aboutProcessing
WHERE {
?dataset gn:accessionId "GN112"...
- 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...