Difference between revisions of "Ajvree Week 15"

From LMU BioDB 2013
Jump to: navigation, search
(excel comparison info)
 
(excel comparison info 2)
Line 1: Line 1:
 
==12/3/13==
 
==12/3/13==
  
Comparing gene id's in excel:
+
'''Comparing gene id's in excel:'''
 
*first search in xmlmatch:
 
*first search in xmlmatch:
 
**searched for SP_[0-9][0-9][0-9][0-9] in uniprot file  
 
**searched for SP_[0-9][0-9][0-9][0-9] in uniprot file  
Line 7: Line 7:
 
*saved to text file
 
*saved to text file
 
*used match in excel to compare lists
 
*used match in excel to compare lists
*NO Matches found
+
*link to instructions for excel match comparison found here: [[http://xmlpipedb.sourceforge.net/wiki/index.php/Using_Microsoft_Excel_to_Compare_ID_Lists]]
 +
*NO Matches found, all results were N/A
 +
*'''Excel File:'''[[Media:20131203_IDExcelcomparison_tATK_TIGR4_AJV.xls|ID Comparison]]
 +
**Out of all 333 Gene ID's, none were found in original XML file, so those errors cannot be fixed

Revision as of 22:17, 4 December 2013

12/3/13

Comparing gene id's in excel:

  • first search in xmlmatch:
    • searched for SP_[0-9][0-9][0-9][0-9] in uniprot file
    • got 2126 match results
  • saved to text file
  • used match in excel to compare lists
  • link to instructions for excel match comparison found here: [[1]]
  • NO Matches found, all results were N/A
  • Excel File:ID Comparison
    • Out of all 333 Gene ID's, none were found in original XML file, so those errors cannot be fixed
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox