Uploaded image for project: 'IGB'
  1. IGB
  2. IGBF-3407

Separate SL4 names from the description column to a new column

    Details

    • Type: Task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      File: muday-144-SL5_counts-salmon.txt

      Request email:
      Also, we have a small problem with the excel files on the DE genes within genotype and between treatments, that I think you can help us with easily.
      We are trying to run an enrichment analysis and the software does not recognize the newest V5 genome. You gave us the S4 IDs, but they are part of the description, rather than a separate column. Is there a way to add this to the spreadsheet as a column? That way we can cut and paste a group without manually extracting each gene ID from that text heavy gene description list.
      Thanks
      Gloria

        Attachments

          Activity

          Mdavis4290 Molly Davis created issue -
          Mdavis4290 Molly Davis made changes -
          Field Original Value New Value
          Epic Link IGBF-3277 [ 22158 ]
          Hide
          Mdavis4290 Molly Davis added a comment - - edited

          Dr. Muday asked for the SL4 gene names to be their own column with the description. So I made an R script and created an output file with the columns "SL4, SL5, Description". I also just added the new SL4 column to the original counts file.
          Script:
          SL4_SL5_Description.R
          File with just gene names and description:
          SL4_SL5_description_tomato.csv
          File with SL4 column added on to the end of original counts file:
          SL4_SL5_counts_muday-144.csv

          Show
          Mdavis4290 Molly Davis added a comment - - edited Dr. Muday asked for the SL4 gene names to be their own column with the description. So I made an R script and created an output file with the columns "SL4, SL5, Description". I also just added the new SL4 column to the original counts file. Script: SL4_SL5_Description.R File with just gene names and description: SL4_SL5_description_tomato.csv File with SL4 column added on to the end of original counts file: SL4_SL5_counts_muday-144.csv
          Mdavis4290 Molly Davis made changes -
          Attachment SL4_SL5_Description.R [ 17930 ]
          Mdavis4290 Molly Davis made changes -
          Attachment SL4_SL5_description_tomato.csv [ 17931 ]
          Mdavis4290 Molly Davis made changes -
          Attachment SL4_SL5_counts_muday-144.csv [ 17932 ]
          Mdavis4290 Molly Davis made changes -
          Summary Separate SL4 names from the description column to their own column Separate SL4 names from the description column to a new column
          Mdavis4290 Molly Davis made changes -
          Status To-Do [ 10305 ] In Progress [ 3 ]
          Mdavis4290 Molly Davis made changes -
          Status In Progress [ 3 ] Needs 1st Level Review [ 10005 ]
          Mdavis4290 Molly Davis made changes -
          Assignee Molly Davis [ molly ]
          Hide
          Mdavis4290 Molly Davis added a comment - - edited

          Reviewer:

          • Please check code for any running errors or output errors. Also if I need to clean anything up!
          • Check the output files and see if the structure is correct and makes sense based on Dr. Muday's request.
            Thank you!
          Show
          Mdavis4290 Molly Davis added a comment - - edited Reviewer: Please check code for any running errors or output errors. Also if I need to clean anything up! Check the output files and see if the structure is correct and makes sense based on Dr. Muday's request. Thank you!
          Hide
          ann.loraine Ann Loraine added a comment - - edited

          Possible improvements:

          • Modify "AddGeneAnnotations.Rmd" so that it adds a new column "SL4_gene_id"

          Possible benefit of above: Fewer files to track

          Show
          ann.loraine Ann Loraine added a comment - - edited Possible improvements: Modify "AddGeneAnnotations.Rmd" so that it adds a new column "SL4_gene_id" Possible benefit of above: Fewer files to track
          ann.loraine Ann Loraine made changes -
          Status Needs 1st Level Review [ 10005 ] First Level Review in Progress [ 10301 ]
          ann.loraine Ann Loraine made changes -
          Status First Level Review in Progress [ 10301 ] To-Do [ 10305 ]
          ann.loraine Ann Loraine made changes -
          Assignee Molly Davis [ molly ]
          Hide
          ann.loraine Ann Loraine added a comment - - edited

          References / Documentation:

          This makes gene descriptions, using input from SL4_SL5_description.R.

          Possible improvement:

          • Modify the "DescriptionMapping" code to create SL4_SL5_description_tomato.csv (new file)
          • Make new repo to capture just the description mapping code, and make it a "product" for bioinformatics researchers like us
          Show
          ann.loraine Ann Loraine added a comment - - edited References / Documentation: https://bitbucket.org/hotpollen/splicing-analysis/src/main/DescriptionMapping/ This makes gene descriptions, using input from SL4_SL5_description.R. Possible improvement: Modify the "DescriptionMapping" code to create SL4_SL5_description_tomato.csv (new file) Make new repo to capture just the description mapping code, and make it a "product" for bioinformatics researchers like us
          Mdavis4290 Molly Davis made changes -
          Status To-Do [ 10305 ] In Progress [ 3 ]
          Mdavis4290 Molly Davis made changes -
          Status In Progress [ 3 ] To-Do [ 10305 ]
          ann.loraine Ann Loraine made changes -
          Sprint Summer 7 2023 Aug 7 [ 176 ] Summer 7 2023 Aug 7, Summer 8 2023 Aug 21 [ 176, 177 ]
          ann.loraine Ann Loraine made changes -
          Rank Ranked higher
          Hide
          ann.loraine Ann Loraine added a comment - - edited

          Re-reading above, I realized that my previous comments sounded too much like commands for my taste, and not enough like suggestions. I revised them.

          Show
          ann.loraine Ann Loraine added a comment - - edited Re-reading above, I realized that my previous comments sounded too much like commands for my taste, and not enough like suggestions. I revised them.
          ann.loraine Ann Loraine made changes -
          Status To-Do [ 10305 ] In Progress [ 3 ]
          ann.loraine Ann Loraine made changes -
          Status In Progress [ 3 ] Needs 1st Level Review [ 10005 ]
          ann.loraine Ann Loraine made changes -
          Status Needs 1st Level Review [ 10005 ] First Level Review in Progress [ 10301 ]
          ann.loraine Ann Loraine made changes -
          Status First Level Review in Progress [ 10301 ] Ready for Pull Request [ 10304 ]
          ann.loraine Ann Loraine made changes -
          Status Ready for Pull Request [ 10304 ] Pull Request Submitted [ 10101 ]
          ann.loraine Ann Loraine made changes -
          Status Pull Request Submitted [ 10101 ] Reviewing Pull Request [ 10303 ]
          ann.loraine Ann Loraine made changes -
          Status Reviewing Pull Request [ 10303 ] Merged Needs Testing [ 10002 ]
          ann.loraine Ann Loraine made changes -
          Status Merged Needs Testing [ 10002 ] Post-merge Testing In Progress [ 10003 ]
          ann.loraine Ann Loraine made changes -
          Resolution Done [ 10000 ]
          Status Post-merge Testing In Progress [ 10003 ] Closed [ 6 ]

            People

            • Assignee:
              Mdavis4290 Molly Davis
              Reporter:
              Mdavis4290 Molly Davis
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: