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

Make sample sheet for SRP441343 and add to makeAnnotsXml.py

    Details

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

      Description

      mark-2022-timeseries experiment has been submitted to SRA and rerun with nextflow. A sanity check will need to be performed on the original data and the rerun SRA data to ensure the submission to NCBI was correct.

      The next step is adding the SRA data to IGB Quickload. To do this a sample sheet is required.

        Attachments

          Activity

          Mdavis4290 Molly Davis (Inactive) created issue -
          Mdavis4290 Molly Davis (Inactive) made changes -
          Field Original Value New Value
          Epic Link IGBF-2993 [ 21429 ]
          Mdavis4290 Molly Davis (Inactive) made changes -
          Status To-Do [ 10305 ] In Progress [ 3 ]
          aloraine Ann Loraine made changes -
          Rank Ranked higher
          Mdavis4290 Molly Davis (Inactive) made changes -
          Status In Progress [ 3 ] To-Do [ 10305 ]
          Mdavis4290 Molly Davis (Inactive) made changes -
          Status To-Do [ 10305 ] In Progress [ 3 ]
          Show
          Mdavis4290 Molly Davis (Inactive) added a comment - - edited Branch : https://bitbucket.org/mdavis4290/molly-2-splicing-analysis/branch/IGBF-3638b
          Mdavis4290 Molly Davis (Inactive) made changes -
          Status In Progress [ 3 ] Needs 1st Level Review [ 10005 ]
          Mdavis4290 Molly Davis (Inactive) made changes -
          Rank Ranked higher
          Mdavis4290 Molly Davis (Inactive) made changes -
          Assignee Molly Davis [ molly ] Ann Loraine [ aloraine ]
          aloraine Ann Loraine made changes -
          Sprint Spring 5 [ 189 ] Spring 5, Spring 6 [ 189, 190 ]
          aloraine Ann Loraine made changes -
          Rank Ranked higher
          aloraine Ann Loraine made changes -
          Sprint Spring 5, Spring 6 [ 189, 190 ] Spring 5, Spring 6, Spring 7 [ 189, 190, 191 ]
          aloraine Ann Loraine made changes -
          Rank Ranked higher
          Hide
          aloraine Ann Loraine added a comment -

          Please check with makeAnnotsXml.py for the next step.

          Show
          aloraine Ann Loraine added a comment - Please check with makeAnnotsXml.py for the next step.
          aloraine Ann Loraine made changes -
          Status Needs 1st Level Review [ 10005 ] First Level Review in Progress [ 10301 ]
          aloraine Ann Loraine made changes -
          Status First Level Review in Progress [ 10301 ] To-Do [ 10305 ]
          aloraine Ann Loraine made changes -
          Assignee Ann Loraine [ aloraine ] Molly Davis [ molly ]
          Mdavis4290 Molly Davis (Inactive) made changes -
          Status To-Do [ 10305 ] In Progress [ 3 ]
          Hide
          Mdavis4290 Molly Davis (Inactive) added a comment - - edited

          Adding SRA submission to makeAnnotsXml.py

              # Johnson lab mark-2022-timeseries SRA submission SRP441343
              repo = "https://bitbucket.org/hotpollen/splicing-analysis"
              branch = "main"
              filename = "SRP441343_sample_sheet.xlsx"
              path = "ExternalData/"+filename
              getSampleSheetFromRepo(filename,repo,path,branch)
              spreadsheet = pd.read_excel(filename)
              sample_sheet = SampleSheet(spreadsheet)
              sample_sheet.addGenome(SL5)
              sample_sheet.addGenome(SL4)
              to_return.append(sample_sheet)
          
          export PYTHONPATH=/Users/mollydavis333/Desktop/igbquickload
          
          python -m pip install requests
          
          pip install openpyxl
          
          conda create -c conda-forge -n name_of_my_env python pandas
          
          source activate name_of_my_env
          
          ./makeAnnotsXml.py
          
          Show
          Mdavis4290 Molly Davis (Inactive) added a comment - - edited Adding SRA submission to makeAnnotsXml.py # Johnson lab mark-2022-timeseries SRA submission SRP441343 repo = "https: //bitbucket.org/hotpollen/splicing-analysis" branch = "main" filename = "SRP441343_sample_sheet.xlsx" path = "ExternalData/" +filename getSampleSheetFromRepo(filename,repo,path,branch) spreadsheet = pd.read_excel(filename) sample_sheet = SampleSheet(spreadsheet) sample_sheet.addGenome(SL5) sample_sheet.addGenome(SL4) to_return.append(sample_sheet) export PYTHONPATH=/Users/mollydavis333/Desktop/igbquickload python -m pip install requests pip install openpyxl conda create -c conda-forge -n name_of_my_env python pandas source activate name_of_my_env ./makeAnnotsXml.py
          Mdavis4290 Molly Davis (Inactive) made changes -
          Summary Make sample sheet for SRP441343 Make sample sheet for SRP441343 and add to makeAnnotsXml.py
          Show
          Mdavis4290 Molly Davis (Inactive) added a comment - Branch : https://bitbucket.org/mdavis4290/molly-genome-browser-visualization/branch/IGBF-3638
          Mdavis4290 Molly Davis (Inactive) made changes -
          Status In Progress [ 3 ] Needs 1st Level Review [ 10005 ]
          Mdavis4290 Molly Davis (Inactive) made changes -
          Assignee Molly Davis [ molly ]
          Mdavis4290 Molly Davis (Inactive) made changes -
          Assignee Ann Loraine [ aloraine ]
          aloraine Ann Loraine made changes -
          Sprint Spring 5, Spring 6, Spring 7 [ 189, 190, 191 ] Spring 5, Spring 6, Spring 7, Spring 8 [ 189, 190, 191, 192 ]
          aloraine Ann Loraine made changes -
          Rank Ranked higher
          Hide
          aloraine Ann Loraine added a comment -

          I did not try to run the new code as Molly Davis has already been able to run it, as noted above.
          Moving to "ready for pull request."

          Show
          aloraine Ann Loraine added a comment - I did not try to run the new code as Molly Davis has already been able to run it, as noted above. Moving to "ready for pull request."
          aloraine Ann Loraine made changes -
          Status Needs 1st Level Review [ 10005 ] First Level Review in Progress [ 10301 ]
          aloraine Ann Loraine made changes -
          Status First Level Review in Progress [ 10301 ] Ready for Pull Request [ 10304 ]
          aloraine Ann Loraine made changes -
          Assignee Ann Loraine [ aloraine ] Molly Davis [ molly ]
          Show
          Mdavis4290 Molly Davis (Inactive) added a comment - PR : https://bitbucket.org/hotpollen/genome-browser-visualization/pull-requests/6
          Mdavis4290 Molly Davis (Inactive) made changes -
          Assignee Molly Davis [ molly ]
          Mdavis4290 Molly Davis (Inactive) made changes -
          Status Ready for Pull Request [ 10304 ] Pull Request Submitted [ 10101 ]
          Mdavis4290 Molly Davis (Inactive) made changes -
          Assignee Ann Loraine [ aloraine ]
          aloraine Ann Loraine made changes -
          Status Pull Request Submitted [ 10101 ] Reviewing Pull Request [ 10303 ]
          Hide
          aloraine Ann Loraine added a comment -

          PR is merged. Ready for testing.

          Show
          aloraine Ann Loraine added a comment - PR is merged. Ready for testing.
          aloraine Ann Loraine made changes -
          Status Reviewing Pull Request [ 10303 ] Merged Needs Testing [ 10002 ]
          aloraine Ann Loraine made changes -
          Assignee Ann Loraine [ aloraine ]
          aloraine Ann Loraine made changes -
          Sprint Spring 5, Spring 6, Spring 7, Spring 8 [ 189, 190, 191, 192 ] Spring 5, Spring 6, Spring 7, Spring 8, Spring 9 [ 189, 190, 191, 192, 193 ]
          aloraine Ann Loraine made changes -
          Rank Ranked higher
          Hide
          aloraine Ann Loraine added a comment -

          Sample sheet is good. Moving to DONE.

          Show
          aloraine Ann Loraine added a comment - Sample sheet is good. Moving to DONE.
          aloraine Ann Loraine made changes -
          Status Merged Needs Testing [ 10002 ] Post-merge Testing In Progress [ 10003 ]
          aloraine Ann Loraine made changes -
          Resolution Done [ 10000 ]
          Status Post-merge Testing In Progress [ 10003 ] Closed [ 6 ]
          aloraine Ann Loraine made changes -
          Assignee Molly Davis [ molly ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved: