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

Revision as of 21:57, 13 December 2013

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:
- [1] [2] [3]

Used XMLPipeDB Match in order to search Uniprot XML file for species IDs with format SP_[0-9][0-9][0-9][0-9] and got 2126 results.

first search in xmlmatch:

This was saved as a text file in order to make compatible for Excel. This file and exceptions file were put in adjacent columns and Excel match function was used. All results found to be #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

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?

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?

@@ Line 12: / Line 12: @@
 **[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==
+===XML/Exception File Comparison===
-*first search in xmlmatch:
+*Used XMLPipeDB Match in order to search Uniprot XML file for species IDs with format SP_[0-9][0-9][0-9][0-9] and got 2126 results.
-**searched for SP_[0-9][0-9][0-9][0-9] in uniprot file
+first search in xmlmatch:
-**got 2126 match results
+*This was saved as a text file in order to make compatible for Excel. This file and exceptions file were put in adjacent columns and Excel match function was used. All results found to be #N/A.
-**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]]