Asandle1 Week 15
To User Page: User: Asandle1 To Template: Template:Asandle1
Contents
Assignment Pages
Journals
Individual
Class Journals
Electronic Lab Notebook
This Journal is combination between week 14 and 15. To get to the Team Journal Page please click here: Yeast Beasts To get to the Previous Journal click here: Asandle1 Week 13
In Class Thursday April 18th Notes
- Dean immediately told me he needed help getting the text for the degradation imported
- I told him I knew how to fix it and he just needed to import the text to excel instead of copy pasting. Dr. Dahlquist helped him with that.
- we solved the issue of the #REF and Blanks, we didn't end up needing those two columns so we just deleted them
- Dean shared into the box up to the additional steps he took.
- Everything is into the file and we are having the other group look over what we did.
- We are now thinking about what to put down for metadata, I asked what we need for metadata and Dr. Dahlquist is explaining to us what metadata is and what to put in for it.
- Added a sheet and named it Metadata
- Added a Primary Key, Description, Data Source, Date Accessed, Data Updated Date, and Publication (Pubmed ID) or DOI Column
- Entered the info under each of these sections, and shared a screenshot with Dean to make sure we don't do the same work twice
April 21 Notes
- Trying to get in touch with to see where he left off so I know where to progress for next steps
April 22 Notes
- Dean looks to have created 4 of the tables but I need to speak with him in person to make corrections
- Created the metadata table
- Added detailed descriptions for table items
- Access File is on Box in each iteration, uploaded most recent version to box.
April 23 Notes
- Issue with Degradation rates and production rates on access going to 0's and 1's.
- I told Dean to ignore this issue and I will Deal with it while he deals with the expression table.
- Dr. Dahlquist tried reimporting and it works, so I am going to import both Degradation_Rates and Production_Rates again.
- I tried importing and had no issues
- Fixed the issues and everything worked fine
- Dean is working on the Expression_Table right now while I was fixing these. He encountered some issues for the Data team to solve.
- Dean said there is an error in the Network table. He said he can't make something a primary key because of a null value. I told him thats an excel importing issue, and we need to fix it in excel. I told Dean I will deal with it because he is not understanding the issue.
- I connected all of the relationships for the primary keys. Meta data remains unconnected since it is a separate piece.
April 25 Notes
We are waiting for QA to finish Milestone 5 so we can do Milestone 6, In the meantime we are going to work on the presentation Got the Gene list for profile 41 from the Data Analyst Team which are: Rpn4, Gcn4, Pdr1, Xbp1, Met28, Mga2, Spt23, Bas1, Yap1, Sok2, Msn2, Crz1, Rlm1, Fhl1, Pdr3, Cbf1, Rph1, Met31, Stp1, Msn4, Tec1, Rgm1, Stp2.
Answers to Questions
1. What worked?
Everything, “worked” but we noticed we could save time by adding the gene name and systematic name both on the gene table.
2. What didn't work?
The class website did not work.
3. What will I do next to fix what didn't work?
I don't have a fix but it meant that I took notes and did not have them save, so I lost some of my detailed notes on the methods for the past week. I am trying to determine what I would have saved them as.
References & Acknowledgements
Acknowlegements
- Dean and I communicated about the project via text, at one point I didn't hear from him so I called him and he promptly got back to me.
- Dr. Dahlquist helped us solve some issues with the data in the production_rates and degradation_rates tables. She also provided assistance with the expression table.
References
- LMU BioDB 2024. (2024). Coder/Designer. Retrieved April 17, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Coder/Designer
- Community Central Fandom. (2024). Forum:How do I link to a heading on another page?. Retrieved April 17, 2024, from https://community.fandom.com/wiki/Forum:How_do_I_link_to_a_heading_on_another_page%3F
Used week 13 as an outline Except for what is noted above, this individual journal entry was completed by me and not copied from another source. Asandle1 (talk)
