Difference between revisions of "Data Analysts Week 15"
(→Milestone 5: adding more detail) |
(→Milestone 5: updating procedure) |
||
| Line 1: | Line 1: | ||
===Milestone 5=== | ===Milestone 5=== | ||
| − | #We | + | #We examined the YEASTRACT output for profile 41 in Excel, and selected the first 23 transcription factors for analysis. This list was sent to the Coder/Designers, who found 22 of these factors in the database. |
| − | #[[User:Msymond1| Dean Symonds]] assisted us in creating an input workbook for GRNmap using queries to the Microsoft Access database created by the Coders/Designers. | + | #[[User:Msymond1| Dean Symonds]] assisted us in creating an input workbook for GRNmap using queries to the Microsoft Access database created by the Coders/Designers. The query designs are linked here: [https://lmu.app.box.com/folder/261861431194?s=y6x97kqcjlxfezhnbpvck4h4oe4pm366] |
The queries were created to fill our workbook sheets as follows: | The queries were created to fill our workbook sheets as follows: | ||
*production_rates | *production_rates | ||
*degradation_rates | *degradation_rates | ||
| − | * | + | *optimization_parameters |
| − | * | + | *threshold_b |
| − | * | + | The input data is linked here: [https://lmu.app.box.com/file/1518231373852] |
| + | |||
| + | *This data was sent to Dr. Dahlquist, who ran GRNmap and uploaded the GRNmap output to BOX. | ||
| + | |||
| + | After obtaining out GRNmap results, we got together as a group to work on our presentation, paper, and uploading the remaining deliverables to our page. | ||
==Acknowledgements== | ==Acknowledgements== | ||
Revision as of 10:27, 3 May 2024
Milestone 5
- We examined the YEASTRACT output for profile 41 in Excel, and selected the first 23 transcription factors for analysis. This list was sent to the Coder/Designers, who found 22 of these factors in the database.
- Dean Symonds assisted us in creating an input workbook for GRNmap using queries to the Microsoft Access database created by the Coders/Designers. The query designs are linked here: [1]
The queries were created to fill our workbook sheets as follows:
- production_rates
- degradation_rates
- optimization_parameters
- threshold_b
The input data is linked here: [2]
- This data was sent to Dr. Dahlquist, who ran GRNmap and uploaded the GRNmap output to BOX.
After obtaining out GRNmap results, we got together as a group to work on our presentation, paper, and uploading the remaining deliverables to our page.
Acknowledgements
This procedure was adapted from the Data Analysis page Milestone 3 and 4 protocol, linked here: Data Analysis The procedure for Milestone 3 was also adapted from the steps outlined in the Week 9 assignment page. The procedure for Milestone 4 was also adapted from the steps outlined in the Week 10 assignment page. For Milestone 5, we followed the procedure listed on Data Analysis. Our quality assurance, Hailey Ivanson was a key part in completing these milestones, and her help was very valuable. Dean Symonds assisted us in creating an input workbook for GRNmap using queries to the Microsoft Access database created by the Coders/Designers.
References
LMU BioDB 2024. (2024). Week 14. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_14
LMU BioDB 2024. (2024). Week 15. Retrieved May 2, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_15
LMU BioDB 2024. (2024). Week 9. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_9
LMU BioDB 2024. (2024). Week 10. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_10
LMU BioDB 2024. (2024). Data Analysis. Retrieved April 23, 2024 from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Data_Analysis
Team Pages
Role Pages
Except for what is noted above, this entry was completed by Katie and Charlotte and not copied from another source. Ckapla12 (talk) 19:10, 2 May 2024 (PDT)
