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, goa