Difference between revisions of "MSymond1 Week 10"

From LMU BioDB 2024
Jump to navigation Jump to search
(changed protocol to past tenst)
(Methods & Results: put it in past tense)
Line 53: Line 53:
 
##** In the [http://amigo.geneontology.org/amigo/medial_search?q=GO%3A0044848 results] page, I clicked on the button that says "Link to detailed information about <term>, in this case "biological phase"".  
 
##** In the [http://amigo.geneontology.org/amigo/medial_search?q=GO%3A0044848 results] page, I clicked on the button that says "Link to detailed information about <term>, in this case "biological phase"".  
 
##** The definition was on the next results page, e.g. [http://amigo.geneontology.org/amigo/term/GO:0044848 here].
 
##** The definition was on the next results page, e.g. [http://amigo.geneontology.org/amigo/term/GO:0044848 here].
 +
==== Using YEASTRACT to Infer which Transcription Factors Regulate a Cluster of Genes ====
 +
# I opened the gene list in Excel for the one of the significant profiles from the stem analysis that you chose to perform the GO analysis.  It was a cluster with a clear cold shock/recovery up/down or down/up pattern, and was one of the largest clusters.
 +
#* I Copied the list of gene IDs onto the clipboard.
 +
# I launched a web browser and go to the [http://www.yeastract.com/ YEASTRACT database].
 +
#* On the left panel of the window, I clicked on the link to [http://www.yeastract.com/formrankbytf.php ''Rank by TF''].
 +
#* I pasted the list of genes from your cluster into the box labeled ''ORFs/Genes''.
 +
#* I checked the box for ''Check for all TFs''.
 +
#* I accepted the defaults for the Regulations Filter (Documented, DNA binding or expression evidence)
 +
#* I Did '''''not''''' apply a filter for "Filter Documented Regulations by environmental condition".
 +
#* I ranked genes by TF using: The % of genes in the list and in YEASTRACT regulated by each TF.
 +
#* I clicked the ''Search'' button.
 +
# I answered the following questions:
 +
#* In the results window that appears, the p values colored green are considered "significant", the ones colored yellow are considered "borderline significant" and the ones colored pink are considered "not significant".  '''''How many transcription factors are green or "significant"?'''''
 +
#* '''''Copy the table of results from the web page and paste it into a new Excel workbook to preserve the results.'''''
 +
#** Copy by selecting and dragging down on the table.
 +
#** When pasting into Excel, remember to Paste special > Paste values.
 +
#** '''''Upload the Excel file to the wiki and link to it in your electronic lab notebook.'''''
 +
#** '''''Are CIN5 or GLN3 on the list?  If so, what is their "% in user set", "% in YEASTRACT", and "p value"?'''''
 +
 +
==== Creating and Visualizing Your Gene Regulatory Network with GRNsight (Tuesday, March 26)====
 +
 +
# I selected from the list of "significant" transcription factors in YEASTRACT, which ones you will use to run the model. I used these transcription factors and added GLN3 and CIN5. 
 +
#* Generally, I included the top transcription factors with the smallest p values.  '''''Explain in your electronic notebook how you decided on which transcription factors to include.  Record the list and your justification in your electronic lab notebook.'''''  Each group member will select a different network (they can have some overlapping transcription factors, but some should also be different).
 +
# I went to the [https://dondi.github.io/GRNsight/beta.html GRNsight beta] website.
 +
# Under the "Network" panel on the left-hand side, I clicked the button "Load from database".
 +
#* I typed the standard name of the transcription factor in the "Select gene" field and clicked the find button (magnifying glass).
 +
#* I continued to add transcription factors in this way until I had 15-20.
 +
#* I clicked the "Generate Network" button.
 +
#* my network appeared on the screen.
 +
# I checked to see if all of the rectangular boxes (nodes) are connected by at least one arrow to another node.  If there was not a node that is connected, I went back to the "Load from database" button and selected the transcription factors again, leaving out the node that was disconnected.
 +
#* '''''I Recorded in the electronic lab notebook the number of genes and edges in your network (found at the upper right of the menu bar).'''''
 +
# Under the "Layout" section, clicked on the "Grid Layout" button.
 +
#* I exported the network image by going to the Export menu and selecting "Export Image > To PNG".  '''''I Uploaded the file to the wiki and display it on your individual journal page.'''''
 +
 +
==== Creating the GRNmap Input Workbook (Tuesday, March 26)====
 +
 +
We will also use GRNsight to automatically generate the input workbook for the GRNmap modeling software.  '''Note that this feature is still under development, and we will be performing quality control on the exported workbook.'''
 +
 +
# With your final network still open in GRNsight, I selected from the Export menu "Export Data > To Excel".  In the window that appears, I selected the following:
 +
#* Under "Select the Expression Data Source:", I chose "Dahlquist_2018"
 +
#* Under "Select Workbook Sheets to Export:", I selected the following:
 +
#** Network sheets
 +
#*** "network"
 +
#** Expression sheets
 +
#*** dcin5_log2_expression
 +
#*** dgln3_log2_expression
 +
#*** wt_log2_expression
 +
#** Additional sheets
 +
#*** "degradation_rates"
 +
#*** "optimization_parameters"
 +
#*** "production_rates"
 +
#*** "threshold_b"
 +
#* I clicked the "Export Workbook" button.
 +
# I opened the workbook in Excel to perform quality control.  I checked that it has the following sheets with the following content:
 +
#* The "network" sheet had an adjacency matrix with your selected regulatory transcription factors across the top row and in the first column. 
 +
#* The "dcin5_log2_expression", "dgln3_log2_expression", and "wt_log2_expression" sheets had log2 fold changes for each of your selected regulatory transcription factors for each time point (15, 30, 60, 90, 120).  Replicate values have the same column headers.  If a particular gene is missing all 4-5 replicate values at a particular timepoint for a particular strain, it was excluded it from the analysis.  I went back to generating the network and repeated the steps to generate the network and exported to Excel without that gene. I recorded this in my electronic lab notebook.
 +
#* The "production_rates" and "degradation_rates" sheets should had values for each gene.
 +
#* The "threshold_b" sheet had a value of 0 for each gene.
 +
#* In the "optimization_parameters" sheet, I changed the "alpha" value to 0.02 instead of 0.002.
 +
#* I inserted a new worksheet and name it "network_weights".
 +
#** I Copied the entire content of the "network" sheet into the "network_weights" sheet.
 +
# '''''I saved and uploaded the Excel Workbook to the wiki and linked to it on the individual journal page.'''''
 +
  
 
#I chose profile 9 because it has very dynamic lines and a wide range of values across all of the lines.
 
#I chose profile 9 because it has very dynamic lines and a wide range of values across all of the lines.

Revision as of 21:32, 3 April 2024

media:Symonds_Week10_Profiles.zip media: Symonds_week_10Golist.zip media:Symonds_Miller_STEM_Presentation.pptx

Methods & Results

  1. I Prepared my microarray data file for loading into STEM.
    • I inserted a new worksheet into your Excel workbook, and named it "(STRAIN)_stem".
    • I selected all of the data from the "(STRAIN)_ANOVA" worksheet and Paste special > paste values into your "(STRAIN)_stem" worksheet.
      • My leftmost column should have the column header "Master_Index". Rename this column to "SPOT". Column B should be named "ID". I Renamed this column to "Gene Symbol". Delete the column named "Standard_Name".
      • I Filtered the data on the B-H corrected p value to be > 0.05 (that's greater than in this case).
        • Once the data had been filtered, I selected all of the rows (except for your header row) and deleted the rows by right-clicking and choosing "Delete Row" from the context menu. I Undid the filter. This ensured that it clustered only the genes with a "significant" change in expression and not the noise"
      • I Deleted all of the data columns EXCEPT for the Average Log Fold change columns for each timepoint (for example, wt_AvgLogFC_t15, etc.).
      • I Renamed the data columns with just the time and units (for example, 15m, 30m, etc.).
      • I saved my work. Then used Save As to save this spreadsheet as Text (Tab-delimited) (*.txt). I clicked OK to the warnings and close your file.
        • Note that you should turn on the file extensions if you have not already done so.
  2. I downloaded and extracted the STEM software. Click here to go to the STEM web site.
    • I clicked on the download link and downloaded the stem.zip file to your Desktop.
    • I extracted the file by right-clicking on it and selecting "Extract all" from the menu.
    • This created a folder called stem.
    • Inside the folder, double-click on the stem.jar to launch the STEM program.
  3. Running STEM
    1. In section 1 (Expression Data Info) of the the main STEM interface window, I clicked on the Browse... button to navigate to and select your file.
      • I clicked on the radio button No normalization/add 0.
      • I checked the box next to Spot IDs included in the data file.
    2. In section 2 (Gene Info) of the main STEM interface window, I left the default selection for the three drop-down menu selections for Gene Annotation Source, Cross Reference Source, and Gene Location Source as "User provided".
    3. I clicked the "Browse..." button to the right of the "Gene Annotation File" item. I Browsed to your "stem" folder and select the file "gene_association.sgd.gz" and click Open.
    4. In section 3 (Options) of the main STEM interface window, I made sure that the Clustering Method says "STEM Clustering Method" and do not change the defaults for Maximum Number of Model Profiles or Maximum Unit Change in Model Profiles between Time Points.
    5. In section 4 (Execute) I clicked on the yellow Execute button to run STEM.
    6. A new window opened called "All STEM Profiles (1)". Each box corresponded to a model expression profile. Colored profiles had a statistically significant number of genes assigned; they were arranged in order from most to least significant p value. Profiles with the same color belong to the same cluster of profiles. The number in each box is simply an ID number for the profile.
      • I clicked on the button that says "Interface Options...". At the bottom of the Interface Options window that appeared below where it says "X-axis scale should be:", I clicked on the radio button that says "Based on real time". Then closed the Interface Options window.
      • I took a screenshot of this window (on a PC, simultaneously press the Alt and PrintScreen buttons to save the view in the active window to the clipboard) and paste it into a PowerPoint presentation to save your figures.
    7. I clicked on each of the SIGNIFICANT profiles (the colored ones) to open a window showing a more detailed plot containing all of the genes in that profile.
      • I took a screenshot of each of the individual profile windows and saved the images in your PowerPoint presentation.
      • At the bottom of each profile window, there were two yellow buttons "Profile Gene Table" and "Profile GO Table". For each of the profiles, I clicked on the "Profile Gene Table" button to see the list of genes belonging to the profile. In the window that appeared, I clicked on the "Save Table" button and save the file to your desktop. I made the filename descriptive of the contents, e.g. "wt_profile#_genelist.txt", where I replaced the number symbol with the actual profile number.
        • I uploaded these files to the wiki and linked to them on your individual journal page. Note that it was easier to zip all the files together and upload them as one file. To do this, I selected all of the files you want to zip together. Then right clicked and selected "Send to" and "Compressed (zipped) folder" from the context menu.
      • For each of the significant profiles, I clicked on the "Profile GO Table" to see the list of Gene Ontology terms belonging to the profile. In the window that appears, I clicked on the "Save Table" button and save the file to your desktop. Make your filename descriptive of the contents, e.g. "wt_profile#_GOlist.txt", where you use "wt", "dGLN3", etc. to indicate the dataset and where you replace the number symbol with the actual profile number. At this point you have saved all of the primary data from the STEM software and it's time to interpret the results!
        • I uploaded these files to the wiki and linked to them on your individual journal page. Note that it was be easier to zip all the files together and upload them as one file. To do this, I selected all of the files I wanted to zip together. Then right clicked and selected "Send to" and "Compressed (zipped) folder" from the context menu.
  4. Analyzing and Interpreting STEM Results
    1. I selected one of the profiles I saved in the previous step for further intepretation of the data. It is suggested to choose one that has a pattern of up- or down-regulated genes at the cold shock timepoints. Each member of your group should choose a different profile. Answer the following:
      • Why did you select this profile? In other words, why was it interesting to you?
      • How many genes belong to this profile?
      • How many genes were expected to belong to this profile?
      • What is the p value for the enrichment of genes in this profile? Bear in mind that we just finished computing p values to determine whether each individual gene had a significant change in gene expression at each time point. This p value determines whether the number of genes that show this particular expression profile across the time points is significantly more than expected.
      • I opened the GO list file I saved for this profile in Excel. This list showed all of the Gene Ontology terms that are associated with genes that fit this profile. I Selected the third row and then chose from the menu Data > Filter > Autofilter. I filtered on the "p-value" column to show only GO terms that have a p value of < 0.05. How many GO terms are associated with this profile at p < 0.05? The GO list also had a column called "Corrected p-value". This correction was needed because the software had performed thousands of significance tests. I filtered on the "Corrected p-value" column to show only GO terms that have a corrected p value of < 0.05. How many GO terms are associated with this profile with a corrected p value < 0.05?
      • I selected 6 Gene Ontology terms from your filtered list (either p < 0.05 or corrected p < 0.05).
        • Each member of the group reported on his or her own cluster in your research presentation. I chose terms that are the most significant, but that are also not too redundant. For example, "RNA metabolism" and "RNA biosynthesis" are redundant with each other because they mean almost the same thing.
          • I noted whether the same GO terms are showing up in multiple clusters.
        • I Looked up the definitions for each of the terms at http://geneontology.org. In your journal entry, I discussed the biological interpretation of these GO terms. In other words, why does the cell react to cold shock by changing the expression of genes associated with these GO terms? Also, what does this have to do with the transcription factor being deleted (for the groups working with deletion strain data)?
        • To easily look up the definitions, I went to http://geneontology.org.
        • I copied and pasted the GO ID (e.g. GO:0044848) into the search field on the left of the page.
        • In the results page, I clicked on the button that says "Link to detailed information about <term>, in this case "biological phase"".
        • The definition was on the next results page, e.g. here.

Using YEASTRACT to Infer which Transcription Factors Regulate a Cluster of Genes

  1. I opened the gene list in Excel for the one of the significant profiles from the stem analysis that you chose to perform the GO analysis. It was a cluster with a clear cold shock/recovery up/down or down/up pattern, and was one of the largest clusters.
    • I Copied the list of gene IDs onto the clipboard.
  2. I launched a web browser and go to the YEASTRACT database.
    • On the left panel of the window, I clicked on the link to Rank by TF.
    • I pasted the list of genes from your cluster into the box labeled ORFs/Genes.
    • I checked the box for Check for all TFs.
    • I accepted the defaults for the Regulations Filter (Documented, DNA binding or expression evidence)
    • I Did not apply a filter for "Filter Documented Regulations by environmental condition".
    • I ranked genes by TF using: The % of genes in the list and in YEASTRACT regulated by each TF.
    • I clicked the Search button.
  3. I answered the following questions:
    • In the results window that appears, the p values colored green are considered "significant", the ones colored yellow are considered "borderline significant" and the ones colored pink are considered "not significant". How many transcription factors are green or "significant"?
    • Copy the table of results from the web page and paste it into a new Excel workbook to preserve the results.
      • Copy by selecting and dragging down on the table.
      • When pasting into Excel, remember to Paste special > Paste values.
      • Upload the Excel file to the wiki and link to it in your electronic lab notebook.
      • Are CIN5 or GLN3 on the list? If so, what is their "% in user set", "% in YEASTRACT", and "p value"?

Creating and Visualizing Your Gene Regulatory Network with GRNsight (Tuesday, March 26)

  1. I selected from the list of "significant" transcription factors in YEASTRACT, which ones you will use to run the model. I used these transcription factors and added GLN3 and CIN5.
    • Generally, I included the top transcription factors with the smallest p values. Explain in your electronic notebook how you decided on which transcription factors to include. Record the list and your justification in your electronic lab notebook. Each group member will select a different network (they can have some overlapping transcription factors, but some should also be different).
  2. I went to the GRNsight beta website.
  3. Under the "Network" panel on the left-hand side, I clicked the button "Load from database".
    • I typed the standard name of the transcription factor in the "Select gene" field and clicked the find button (magnifying glass).
    • I continued to add transcription factors in this way until I had 15-20.
    • I clicked the "Generate Network" button.
    • my network appeared on the screen.
  4. I checked to see if all of the rectangular boxes (nodes) are connected by at least one arrow to another node. If there was not a node that is connected, I went back to the "Load from database" button and selected the transcription factors again, leaving out the node that was disconnected.
    • I Recorded in the electronic lab notebook the number of genes and edges in your network (found at the upper right of the menu bar).
  5. Under the "Layout" section, clicked on the "Grid Layout" button.
    • I exported the network image by going to the Export menu and selecting "Export Image > To PNG". I Uploaded the file to the wiki and display it on your individual journal page.

Creating the GRNmap Input Workbook (Tuesday, March 26)

We will also use GRNsight to automatically generate the input workbook for the GRNmap modeling software. Note that this feature is still under development, and we will be performing quality control on the exported workbook.

  1. With your final network still open in GRNsight, I selected from the Export menu "Export Data > To Excel". In the window that appears, I selected the following:
    • Under "Select the Expression Data Source:", I chose "Dahlquist_2018"
    • Under "Select Workbook Sheets to Export:", I selected the following:
      • Network sheets
        • "network"
      • Expression sheets
        • dcin5_log2_expression
        • dgln3_log2_expression
        • wt_log2_expression
      • Additional sheets
        • "degradation_rates"
        • "optimization_parameters"
        • "production_rates"
        • "threshold_b"
    • I clicked the "Export Workbook" button.
  2. I opened the workbook in Excel to perform quality control. I checked that it has the following sheets with the following content:
    • The "network" sheet had an adjacency matrix with your selected regulatory transcription factors across the top row and in the first column.
    • The "dcin5_log2_expression", "dgln3_log2_expression", and "wt_log2_expression" sheets had log2 fold changes for each of your selected regulatory transcription factors for each time point (15, 30, 60, 90, 120). Replicate values have the same column headers. If a particular gene is missing all 4-5 replicate values at a particular timepoint for a particular strain, it was excluded it from the analysis. I went back to generating the network and repeated the steps to generate the network and exported to Excel without that gene. I recorded this in my electronic lab notebook.
    • The "production_rates" and "degradation_rates" sheets should had values for each gene.
    • The "threshold_b" sheet had a value of 0 for each gene.
    • In the "optimization_parameters" sheet, I changed the "alpha" value to 0.02 instead of 0.002.
    • I inserted a new worksheet and name it "network_weights".
      • I Copied the entire content of the "network" sheet into the "network_weights" sheet.
  3. I saved and uploaded the Excel Workbook to the wiki and linked to it on the individual journal page.


  1. I chose profile 9 because it has very dynamic lines and a wide range of values across all of the lines.
    • There are 200 genes assigned to this profile
    • There are 60.3 genes expected to belong to this profile
    • The p-value for this profile is 3.1E-48
    • 28 GO terms are associated with a p-value of less than .05, and 4 GO terms are associated with a p-value of less than .05
      • vesicle-mediated transport (GO:0016192): A cellular transport process in which transported substances are moved in membrane-bounded vesicles; transported substances are enclosed in the vesicle lumen or located in the vesicle membrane. The process begins with a step that directs a substance to the forming vesicle, and includes vesicle budding and coating. Vesicles are then targeted to, and fuse with, an acceptor membrane.
      • Golgi apparatus (GO:0005794): A membrane-bound cytoplasmic organelle of the endomembrane system that further processes the core oligosaccharides (e.g. N-glycans) added to proteins in the endoplasmic reticulum and packages them into membrane-bound vesicles. The Golgi apparatus operates at the intersection of the secretory, lysosomal, and endocytic pathways.
      • cytoplasmic translation (GO:0002181): The chemical reactions and pathways resulting in the formation of a protein in the cytoplasm. This is a ribosome-mediated process in which the information in messenger RNA (mRNA) is used to specify the sequence of amino acids in the protein.
      • protein transport (GO:0015031): The directed movement of proteins into, out of or within a cell, or between cells, by means of some agent such as a transporter or pore.
      • ribosomal small subunit assembly (GO:0000028): The aggregation, arrangement and bonding together of constituent RNAs and proteins to form the small ribosomal subunit.
      • transaminase activity (GO:0008483): Combining with the neurotransmitter dopamine and activating adenylate cyclase via coupling to Gi/Go to initiate a change in cell activity.
  2. The YEASTRACT results
    • 25 of the genes were green and significant
    • media:Symonds_YEASTRACTresults.xlsx
    • Yes, CIN5 is in the table, 39.00% is in user set, 3.39% is in scerevisiae, and the p-value is 0.005141327836732. GLN3 is also in the database, 34.00% is in the user set, 2.76% is in scerevisiae, and the p-value is 0.346793143826899.
  3. GRNsight results
    • I decided which genes to include by using the genes with the smallest p-values on my chart, I added them to the network in order from least to greatest, all of the p-values were at most E-5.
    • My network had 19 genes and 41 edges.
    • The picture is to the right
      Symonds 3-26-24 GRN (Yeastmine - SGD 2024-03-19; 19 genes, 41 edges).png
  4. My GRNsight excel file media:Symonds GRN (Yeastmine - SGD 2024-03-19; 19 genes, 41 edges) weighted.xlsx


User Page

Assignment Pages

Individual Journal Pages

Class Journal Pages