Difference between revisions of "Alina's Assessment and Reflection"

From LMU BioDB 2013
Jump to: navigation, search
(Updating of Gene Database Testing Reports)
(Updating of Gene Database Testing Reports: excel comparison info)
Line 4: Line 4:
  
 
===Updating of Gene Database Testing Reports===
 
===Updating of Gene Database Testing Reports===
**Was responsible for running counts (XMLPipeDB Match, Tally Engine, SQL)
+
*Was responsible for running counts (XMLPipeDB Match, Tally Engine, SQL)
**Performed visual inspections within gdb files
+
*Performed visual inspections within gdb files
**Provided screenshots when necessary
+
*Provided screenshots when necessary
**(Did not update GenMAPP aspects, left to Kevin)
+
*(Did not update GenMAPP aspects, left to Kevin)
**Compared found Gene ID formats with corresponding online resources (UniProt, RefSeq)
+
*Compared found Gene ID formats with corresponding online resources (UniProt, RefSeq)
**Export Reports contributed to:
+
*Export Reports contributed to:
***[https://xmlpipedb.cs.lmu.edu/biodb/fall2013/index.php/TATK_E4:_TIGR4_Testing_Report#Compare_Gene_Database_to_Outside_Resource|E4] [https://xmlpipedb.cs.lmu.edu/biodb/fall2013/index.php/TATK_E3:_TIGR4_Testing_Report|E3] [https://xmlpipedb.cs.lmu.edu/biodb/fall2013/index.php/TATK_Export_One:_TIGR4_Testing_Report|E1]
+
**[https://xmlpipedb.cs.lmu.edu/biodb/fall2013/index.php/TATK_E4:_TIGR4_Testing_Report#Compare_Gene_Database_to_Outside_Resource|E4] [https://xmlpipedb.cs.lmu.edu/biodb/fall2013/index.php/TATK_E3:_TIGR4_Testing_Report|E3] [https://xmlpipedb.cs.lmu.edu/biodb/fall2013/index.php/TATK_Export_One:_TIGR4_Testing_Report|E1]
 +
 
 +
==XML/Exception File Comparison==
 +
*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: [[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]]
  
  

Revision as of 21:46, 13 December 2013

Contents

Statement of Work

  • Describe exactly what you did on the project.

Updating of Gene Database Testing Reports

  • Was responsible for running counts (XMLPipeDB Match, Tally Engine, SQL)
  • Performed visual inspections within gdb files
  • Provided screenshots when necessary
  • (Did not update GenMAPP aspects, left to Kevin)
  • Compared found Gene ID formats with corresponding online resources (UniProt, RefSeq)
  • Export Reports contributed to:

XML/Exception File Comparison

  • 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: [[4]]
  • NO Matches found, all results were N/A
  • Excel File: ID Comparison


  • Provide references or links to artifacts of your work, such as:
    • Wiki pages
    • Other files or documents
    • Code or scripts

Assessment of Project

  • Give an objective assessment of the success of your project workflow and teamwork.
  • What worked and what didn't work?
  • What would you do differently if you could do it all over again?
  • Evaluate the Gene Database Project and Group Report in the following areas:
    1. Content: What is the quality of the work?
    2. Organization: Comment on the organization of the project and of your group's wiki pages.
    3. Completeness: Did your team achieve all of the project objectives? Why or why not?

Reflection on the Process

  • What did you learn?
    • With your head (biological or computer science principles)
    • With your heart (personal qualities and teamwork qualities that make things work or not work)?
    • With your hands (technical skills)?
  • What lesson will you take away from this project that you will still use a year from now?
Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox