Jkuroda Week 14

From LMU BioDB 2015
Jump to: navigation, search

Log

  • In class on 12/01/15, I went through the rest of the Testing Report and did the SQL Queries section and manually checked the gene IDs in the .gdb file.
  • After looking at the IDs, I found that some of them were in the form "SO_A?####"
  • Upon discovering this, I went back and tweaked the pattern for the XMLPipeDB and SQL commands. I got a count of 4207 IDs for XMLPipeDB and 4196 for PostgreSQL.
  • Did a visual inspection of individual tables in the gdb file.
  • Conducted an analysis of the results collected and found that the xmlpipedb-match had 11 extra IDs because the UNIPROT XML file contained 11 entries with no gene tag.
  • Ran an export using the new genMAPP Builder given to me by Mary.
    • Started: 4:12pm
    • Finished: 5:26pm
    • Total time taken: 1 hour and 14 minutes
  • Uploaded the resulting .gdb file: new .gdb file

Josh Kuroda's page

Individual Journal Entries

Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15

Shared Journal Entries

Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15