Difference between revisions of "Ajvree Week 13"
From LMU BioDB 2013
(began week 13 counting info) |
(→Week 13: some import info) |
||
| Line 23: | Line 23: | ||
*in sql, opened gmbuilder.sql | *in sql, opened gmbuilder.sql | ||
*ran query, database tables were inserted | *ran query, database tables were inserted | ||
| − | *went in to tally engine and imported files | + | *went in to tally engine and imported files |
| − | * | + | **Xml import took 5.41 min |
| + | **GOA import took 0.07 min | ||
| + | *unzipped go-xml file | ||
Revision as of 18:11, 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
