MSymond1 Week 15

Progress Report

I was able to obtain the data from the yeastmine website by scrolling down and selecting the table with “all verified uncharacterized dubious ORFs”, the data table included all of the columns that Dr. Dahlquist suggested I include in the table
The production and degradation tables could be saved as txt files which could then be opened in excel directly
The metadata table was created with assistance from my professor in which she helped us gather the necessary materials for it

The database creation went mostly well with a few issues along the way such as
Importing the tables from excel led to some problems of all values being either 0 or 1 on production rates or degradation rates tables, so we started to export the tables from excel as a txt file and then open them in access at txt files
In the relationships window, we connected the systematic name column for each of the tables to ensure they would all be connected since that column was the primary key in each of the data tables

The quality assurance team was able to verify that the database was correct and had all necessary fields

We were informed by the data analysts that they selected profile 41 to analyze, this profile included 23 genes initially
At first we were stuck and were not sure how to obtain the necessary data for the GRNmap, but Dr. Dahlquist pointed out that we can use the database that we created to run queries and find the necessary fields for each of the 23 genes
I was informed that Andrew had completed the first three queries for the first three tables on the GRNmap excel sheet
I followed the sample GRNmap excel sheet as a template for the queries.

This week, me and my partner completed milestones 1 and 2, and we are currently working on milestone 3, there are some complications in milestone 3, for a large part of it requires Microsoft Access, and there are also some issues in importing tables to excel. MSymond1
Each team member should reflect on the team's progress:
1. The things that worked well are cleaning up the data for the network table, which was done in class on Tuesday, the data table looks much more organized and the p values have all been successfully converted
2. The other data tables are not pasting into excel as neatly as anticipated, I am also unaware of how to obtain the data from the yeastmine website.
3. To fix these issues, I will ask Dr. Dahlquist for further advice in class on Thursday.