Difference between revisions of "Ajvree Week 13"
From LMU BioDB 2013
(→Week 13: some import info) |
|||
| Line 1: | Line 1: | ||
==Week 12 Information== | ==Week 12 Information== | ||
| − | Export Counting: -open Access, open file (remember to change all to all files) TIGR4 file: | + | Export Counting: -open Access, open file (remember to change all to all files) TIGR4 file:<br> |
| − | ids used: SP_#### | + | ids used: SP_####<br> |
| − | orderedlocusnames count total: 2126 entries | + | orderedlocusnames count total: 2126 entries<br> |
| − | R6 file: | + | R6 file:<br> |
| − | orderedlocusnames count total: 2115 entries | + | orderedlocusnames count total: 2115 entries<br> |
| − | ids used: SPG_#### | + | ids used: SPG_####<br> |
| − | G54 file: | + | G54 file:<br> |
| − | ids used: SPG_#### | + | ids used: SPG_####<br> |
| − | orderedlocusnames count total: 2115 entries | + | orderedlocusnames count total: 2115 entries<br> |
| − | 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) | + | 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)<br> |
| − | First try on Tally Engine for TIGR4: | + | First try on Tally Engine for TIGR4:<br> |
| − | XML Count: | + | XML Count:<br> |
| − | orderedlocus: 2127 | + | orderedlocus: 2127<br> |
| − | refseq: 2106 | + | refseq: 2106<br> |
| − | Database Count: | + | Database Count:<br> |
| − | ordered locus: 3831 | + | ordered locus: 3831<br> |
| − | refseq: 3403 | + | refseq: 3403<br> |
==Week 13== | ==Week 13== | ||
Revision as of 18:12, 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
