# Kristen M. Horstmann Week 13 Journal

## Electronic Notebook

### Corrections for week 12

• Reuploaded Powerpoint to include images of the graphs created for excel

### Corrections for Week 13

• There were discrepancies in Kara's and my two network sheets as Kara's sheet included ASG1 and NDT80 but they were not attached to any other transcription factors, whereas mine had ASG1 (not NDT80) and it was connected to something.
• We both went back into our previous excel spreadsheets and work and Kara found that she had accidentally deleted the transcription factor attached to NDT80 as she was going through and altering which rows she had pruned.
• We then compared her new network and my network in the excel sheet row by row, column by column and row by row and found every single cell had matched, so we will be continuing with this network unless further changes need to be made.
• Both tried to run our networks in the GRNmodel matlab code, but experienced errors (mine was at the end, hers was at the beginning). I will upload the jpgs of the 20 figures I received to Kristen M. Horstmann Week 14 Journal.

### Create the Input Excel Workbook for the Model

1. Your file will be similar to the file "Input_4_gene_forward_correct_params.xlsx" that you used in class on Tuesday, but with your expression data and network. You should download this file, change the name, and edit it to include your data. Make sure to give it a meaningful filename that includes your last name or initials. (The file can be found in this zipped file on LionShare.)
2. The first thing you need to do is determine the transcription factors that you are including in your network. You are going to use the "transposed" Regulation Matrix that you generated from YEASTRACT in the Week 12 Assignment.
• Copy the transposed matrix from your "network" sheet and paste it into the worksheets called "network" and "network_weights".
• Note that the transcription factor names have to be in the same order and same format across the top row and first column. CIN5 does not match Cin5p, so the latter will need to be changed to CIN5 if you have not already done so.
• It may be easier for you if you put the transcription factors in alphabetical order (using the sort feature in Excel), but whether you leave your list the same as it is from the YEASTRACT assignment or in alphabetical order, make sure it is the same order for all of the worksheets.
3. The next worksheet to edit is the one called "degradation_rates".
• Paste your list of transcription factors from your "network" sheet into the column named "StandardName". You will need to look up the "SystematicName" of your genes. YEASTRACT has a feature that will allow you to paste your list of standard names in to retrieve the systematic names here.
• Next, you will need to look up the degradation rates for your list of transcription factors. These rates have been calculated from protein half-life data from a paper by Belle et al. (2006). Look up the rates for your transcription factors from this file and include them in your "degradation_rates" worksheet.
• If a transcription factor does not appear in the file above, use the value "0.027182242" for the degradation rate.
4. The next worksheet to edit is the one called "production_rates".
• Paste the "SystematicName" and "StandardName" columns rom your "degradation_rates" sheet into the "production_rates" sheet.
• The initial guesses for the production rates we are using for the model are two times the degradation rate. Compute these values from your degradation rates and paste the values into the column titled "ProductionRate".
5. Next you will input the expression data for the wild type strain and the other strain your partner is using (dcin5, dgln3, dhmo1, dzap1, spar). You need to include only the data for the genes in your network, in the same order as they appear in the other worksheets.
• Put the wild type data in the sheet called "wt".
• The sample spreadsheet has a worksheet named "dcin5". Change this name to match the strain you are using (listed above). The instructions below should be followed for each strain sheet.
• Paste the SystematicName and StandardName columns from one of your previous sheets into this one.
• This data in this sheet is the Log Fold Changes for each replicate and each timepoint from your Week 11 Assignment. We are only going to use the cold shock timepoints for the modeling. Thus your column headings for the data should be "15", "30", and "60". There will be multiple columns for each timepoint (typically 4) to represent the replicate data, but they will all have the same name. For example, you may have four columns with the header "15".
• Copy and paste the data from your Week 11 spreadsheet into this one. You need to include only the data for the genes in your network. Make sure that the genes are in the same order as in the other sheets.
6. We will only be editing parts of the "optimization_parameters" worksheet.
• For the parameter "time" (Cell A13), replace what is in the sample file with "15", "30", and "60", since these are the timepoints we have in our data.
• For the parameter "Strain" (Cell A14), replace "dcin5" with the name of the second strain you are using, making sure that the capitalizaiton and spelling is the same as what you named the worksheet containing that strain's expression data.
7. For the parameter "Deletion", leave the zero in cell B15. In cell C15, put a number corresponding to the position in the list of gene names that the gene that was deleted appears. In the sample file, CIN5 is number 3 in the list of 4 genes.
• For the parameter "simtime", you perform the forward simulation of the expression in five minute increments from 0 to 60 minutes. Thus, this row should read: "simtime", "0", "5", "10", ..., "60".
8. The last sheet you will need to modify is called "network_b".
• Paste in the list of standard names for your transcription factors from one of your previous sheets. Note that this sheet does not have a column for the systematic name.
• Cell A1 in the sample files has the text "rows genes affected/cols genes controlling". I believe you can either have this text in cell A1 or "StandardName".
• The "threshold" value for each gene should be "0".
9. When you have completed the modifications to your file, upload it to LionShare and send Dr. Dahlquist and Dr. Fitzpatrick and e-mail with a link to the file. Your assignment will not be considered complete until we have successfully downloaded the correct file from you. If you need assistance with LionShare, please ask well ahead of the assignment deadline.

#### Appendix: Full explanation of the "optimization_parameters" sheet

• alpha: Penalty term weighting (from an L-curve analysis)
• kk_max: Number of times to re-run the optimization loop: in some cases re-starting the optimization loop can improve performance of the estimation.
• MaxIter: Number of times MATLAB iterates through the optimization scheme. If this is set too low, MATLAB will stop before the parameters are optimized.
• TolFun: How different two least squares evaluations should be before it says it's not making any improvement
• MaxFunEval: maximum number of times it will evaluate the least squares cost
• TolX: How close successive least squares cost evaluations should be before MATLAB determines that it is not making any improvement.
• Sigmoid: =1 if sigmoidal model, =0 if Michaelis-Menten model
• iestimate: =1 if want to estimate parameters and =0 if the user wants to do just one forward run
• iGraphs: =1 to output graphs; =0 to not output graphs
• fix_P: =1 if the user does not want to estimate the production rate, P, parameter, use initial guess and never change; =0 to estimate
• fix_b: =1 if the user does not want to estimate the b parameter, use initial guess and never change; =0 to estimate
• time: A row containing a list of the time points when the data was collected experimentally. Should correspond to the timepoint column headers in the expression sheets.
• Strain: A row containing a list of all of the strains for which there is expression data in the workbook. Should correspond to the names of the sheets for each strain.
• Sheet: A row where each entry is the order number of the sheet (left to right) that corresponds to the list of strains above.
• Deletion: Gives the index of the gene in the network sheet that has been deleted in each strain listed above. For example, if data has been provided for the CIN5 deletion strain, then give the index number from the network sheet corresponding to CIN5.
• simtime: A list of times for which the forward simulation should be evaluated.

### Results and Notes

• "Next, you will need to look up the degradation rates for your list of transcription factors. These rates have been calculated from protein half-life data from a paper by Belle et al. (2006). Look up the rates for your transcription factors from this file and include them in your "degradation_rates" worksheet. If a transcription factor does not appear in the file above, use the value "0.027182242" for the degradation rate."
• The following transcription factors did not have listed degradation rates: CYC8, RIF1, ASG1, SNF6, and HMO1.
• Changed "dcin5" sheet name to "dzap1"
• Horstmann Week 13 Excel

### Template

Back to User: User: Kristen M. Horstmann