Difference between revisions of "Ajvree Week 13"
From LMU BioDB 2013
(→Week 13) |
|||
| Line 27: | Line 27: | ||
**GOA import took 0.07 min | **GOA import took 0.07 min | ||
*unzipped go-xml file | *unzipped go-xml file | ||
| + | |||
| + | |||
| + | '''XMLpipedb Match''' | ||
| + | *downloaded program from sourceforge | ||
Revision as of 18:28, 19 November 2013
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
