IGS / gEAR

The gEAR Portal was created as a data archive and viewer for gene expression data including microarrays, bulk RNA-Seq, single-cell RNA-Seq and more.
https://umgear.org
GNU Affero General Public License v3.0
10 stars 5 forks source link

Updates needed for GCID version of gEAR #125

Open jorvis opened 2 years ago

jorvis commented 2 years ago

Transforming a list of issues e-mailed from Julie into tasks/questions:

songeric1107 commented 2 years ago

I think only these two are left.

https://github.com/jorvis/gEAR/issues/1030

Rhizopus delemar (taxon: 246409)

Aspergillus fumigatus (taxon: 330879)

adkinsrs commented 2 years ago

Added red/blue barcharts for the two Brugia Malayi datasets that did not have them. Left one as the SVG default and changed the other to use the barchart as default

songeric1107 commented 2 years ago

upload two Rhizopus delemar datasets and create a profile. all the others are in the gcid already

https://gcid.umgear.org/p?l=a20d57ee

jorvis commented 2 years ago

@songeric1107 @adkinsrs

What's the status of Aspergillus dataset migration? I don't see any in the system still

songeric1107 commented 2 years ago

I am working on it now

songeric1107 commented 2 years ago

load the Aspergillus to gcid. https://gcid.umgear.org/p?l=7be3a9d6

however, the curated image could not display in the front page.

songeric1107 commented 2 years ago

similar for Rhizopus profile. my curation could not display in the front page. Screen Shot 2022-03-14 at 8 51 01 PM Screen Shot 2022-03-14 at 8 51 13 PM

https://gcid.umgear.org/dataset_curator.html#/dataset/7e0184d0-2d30-6faa-0f38-34b89cef477d/displays

adkinsrs commented 2 years ago

I'm loading Aspergillus and Rhizopus genes into the mysql database. List provided by @songeric1107 and I am keeping track of "gene" table row indexes in case we get better annotations and want to reupload

adkinsrs commented 1 year ago

Use cases for mapping

jorvis commented 1 year ago

Wolbachia paper with ID mapping needs examples:

https://journals.asm.org/doi/full/10.1128/mSystems.00596-19#fig9

adkinsrs commented 1 year ago

so… i don’t think i have an actual wolbachia gene mapping file. Pretty sure I created something by extracting the entries from the database on the old GCID server. But we can recreate it using the mySQL gene.ensembl_id to gene.gene_symbol fields where the gene_symbol would be the aliases.

One concerning thing is that the ensembl IDs were just listed as “gene####” (generated by a grad student), and they map to wBM#### or WBM_RS####, but not WBGene#### (which was never given to me nor in the old database

adkinsrs commented 1 year ago

So for Julie’s data: WBGene - Brugia accession wBm & WBM_RS - Wolbachia wBm strain

All are loaded in the GCID database, and we can map aliases for wBm to WBM_RS (though I need to ensure the script I have does what I think it does). I asked him if there is an host-pathogen ortholog mapping between Brugia and Wolbachia and waiting for a response. I’m guessing we may want that, as she may have asked for the ability to search for that at one point.

UPDATE - Julie says no ortholog mapping between Brugia & Wolbachia wBm

adkinsrs commented 1 year ago

Wolbachia - http://bacteria.ensembl.org/Wolbachia_endosymbiont_strain_trs_of_brugia_malayi_gca_000008385/Info/Index Brugia - https://wormbase.org/species/b_malayi#03--10