Ajvree Week 13

Week 12 Information

Export Counting: -open Access, open file (remember to change all to all files) TIGR4 file:
ids used: SP_####
orderedlocusnames count total: 2126 entries
R6 file:
orderedlocusnames count total: 2115 entries
ids used: SPG_####
G54 file:
ids used: SPG_####
orderedlocusnames count total: 2115 entries
After finding identical results for R6 and G54 files, realized that R6 file was actually for the G54 strain. Checked a few times (reopened files multiple times to confirm)
First try on Tally Engine for TIGR4:
XML Count:
orderedlocus: 2127
refseq: 2106
Database Count:
ordered locus: 3831
refseq: 3403

Week 13

Tally Engine:

• created new database in pgadmin III
• in sql, opened gmbuilder.sql
• ran query, database tables were inserted
• went in to tally engine and imported files
  • Xml import took 5.41 min
  • GOA import took 0.07 min
• unzipped go-xml file

XMLpipedb Match

• downloaded program from sourceforge