MSymond1 Week 15

Progress Report

Milestone 3 continued

• 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

Milestone 4

• 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

Milesone 5

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

Milestone 6

• 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. and I was running into problems running the query with the network table
• We imported profile 41 genes into access as another table to run queries with
• I noticed the problem was that profile 41 only included standard names of the genes rather than the systematic names, which was not the primary key for most of the database, and the network table did not include the standard names so I could not link those two tables together using it
• My solution was to link the gene table to the profile table using their standard names. However, I noticed that the gene table did not include the standard names for the genes, so I imported another gene table from yeastmine that does include the standard names. Then I was able to link the profile 41 table to the gene table using the standard names and then I was able to run a query using the query design and I was able to answer question 4.
• I also noticed that the first three questions were incorrect since they did not include all of the genes, I'm not sure how that happened with Andrew's queries, but I went ahead and ran them again and fixed that issue
• Dr. Dahlquist also noticed that Andrew's queries included the data from the control expression group rather than the CHP treated expression group, so I fixed that too
• I followed the rest of the directions for the rest of the questions for milestone 6 and ran into no problems
• I was able to give the GRNmap excel file to Dr. Dahlquist for her to run it

Presentation

slides [1]

Team Journal Assignment

1. 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
2. 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.

User Page

• User:Msymond1

Assignment Pages

• Week 1
• Week 2
• Week 3
• Week 4
• Week 5
• Week 6
• Week 8
• Week 9
• Week 10
• Week 12
• Week 13
• Week 15

Individual Journal Pages

• MSymond1 Week 1
• MSymond1 Week 2
• MSymond1 KMill104 Week 3
• NeMO_Week4
• MSymond1 Week 5
• MSymond1 Week 6
• MSymond1 Week 8
• MSymond1 Week 9
• MSymond1 Week 10
• MSymond1 Week 12
• MSymond1 Week 13
• MSymond1 Week 15

Class Journal Pages

• Class Journal Week 1
• Class Journal Week 2
• Class Journal Week 3
• Class Journal Week 4
• Class Journal Week 5
• Class Journal Week 6
• Class Journal Week 8
• Class Journal Week 9
• Class Journal Week 10