Dahlquist:Notebook/Nutrigenomics/2010/01/27: Difference between revisions

From OpenWetWare
Jump to navigationJump to search
(→‎Dr. Dahlquist: visible label for link)
Line 18: Line 18:
** MOE430B Orthologs/Homologs, CSV Format, Release 30 (3.4 MB, 11/15/09), MOE430B.na30.ortholog.csv.zip
** MOE430B Orthologs/Homologs, CSV Format, Release 30 (3.4 MB, 11/15/09), MOE430B.na30.ortholog.csv.zip


==Combining experimental data and affymetrix data==
#Opened the affymetrix data
#Removed the header and the controls
#Opened the experimental data
#Removed the header and the controls and sorted it so that it would allign with the affymetrix data
#Pasted the two sets of data into one excel document so that they matched up


<!-- ##### DO NOT edit below this line unless you know what you are doing. ##### -->
<!-- ##### DO NOT edit below this line unless you know what you are doing. ##### -->

Revision as of 12:52, 27 January 2010

Nutrigenomics <html><img src="/images/9/94/Report.png" border="0" /></html> Main project page
<html><img src="/images/c/c3/Resultset_previous.png" border="0" /></html>Previous entry<html>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</html>Next entry<html><img src="/images/5/5c/Resultset_next.png" border="0" /></html>

1/27/10

Dr. Dahlquist

  • Downloaded annotation files from Affymetrix web site here.
    • MOE430A Annotations, CSV format, Release 30 (9.7 MB, 11/15/09), MOE430A.na30.annot.csv.zip
    • MOE430B Annotations, CSV format, Release 30 (6.1 MB, 11/15/09), MOE430B.na30.annot.csv.zip
    • From ReadMe, file format described at this web site
  • Also downloaded ortholog files
    • MOE430A Orthologs/Homologs, CSV Format, Release 30 (6.3 MB, 11/15/09), MOE430A.na30.ortholog.csv.zip
    • MOE430B Orthologs/Homologs, CSV Format, Release 30 (3.4 MB, 11/15/09), MOE430B.na30.ortholog.csv.zip

Combining experimental data and affymetrix data

  1. Opened the affymetrix data
  2. Removed the header and the controls
  3. Opened the experimental data
  4. Removed the header and the controls and sorted it so that it would allign with the affymetrix data
  5. Pasted the two sets of data into one excel document so that they matched up