Difference between revisions of "Ajvree Week 15"

From LMU BioDB 2013
Jump to: navigation, search
(record of compiling work)
Line 5: Line 5:
 
**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  
 
**got 2126 match results
 
**got 2126 match results
*saved to text file
+
**saved to text file
*used match in excel to compare lists
+
*used excel to compare lists
 +
**to convert match id's from SP_#### to SP####, used control F (search/replace function) to replace underscore with a 'no space'
 
*link to instructions for excel match comparison found here: [[http://xmlpipedb.sourceforge.net/wiki/index.php/Using_Microsoft_Excel_to_Compare_ID_Lists]]
 
*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
 
*NO Matches found, all results were N/A
Line 16: Line 17:
 
*Finished in-class 12/3/13
 
*Finished in-class 12/3/13
 
[[Image:TATK tree.png]]
 
[[Image:TATK tree.png]]
 +
 +
 +
'''Compilation of Counting Totals/Visual Information'''
 +
*Began word document with all visual counting results in one place
 +
*still missing information regarding comparisons to microarray data and MOD
 +
*File: (uploaded as pdf since wiki refused to upload it as a .doc) [[Media:20131203 CompiledCounts tATK TIGR4 AJV.pdf|PDF]]

Revision as of 22:39, 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 excel to compare lists
    • to convert match id's from SP_#### to SP####, used control F (search/replace function) to replace underscore with a 'no space'
  • 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


Visual Representation of Data Information

  • Finished in-class 12/3/13

TATK tree.png


Compilation of Counting Totals/Visual Information

  • Began word document with all visual counting results in one place
  • still missing information regarding comparisons to microarray data and MOD
  • File: (uploaded as pdf since wiki refused to upload it as a .doc) PDF
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox