Difference between revisions of "Jkuroda Week 14"
From LMU BioDB 2015
(logging) |
(more log) |
||
| Line 3: | Line 3: | ||
* After looking at the IDs, I found that some of them were in the form "SO_A?####" | * After looking at the IDs, I found that some of them were in the form "SO_A?####" | ||
* Upon discovering this, I went back and tweaked the pattern for the XMLPipeDB and SQL commands. I got a count of ''4207'' IDs for XMLPipeDB and ''4196'' for PostgreSQL. | * Upon discovering this, I went back and tweaked the pattern for the XMLPipeDB and SQL commands. I got a count of ''4207'' IDs for XMLPipeDB and ''4196'' for PostgreSQL. | ||
| + | * Did a visual inspection of individual tables in the gdb file. | ||
| + | * Conducted an analysis of the results collected and found that the xmlpipedb-match had 11 extra IDs because the UNIPROT XML file contained 11 entries with no gene tag. | ||
| + | * Ran an export using the new genMAPP Builder given to me by Mary. | ||
| + | ** Started: 4:12pm | ||
| + | ** Finished: 5:26pm | ||
| + | ** Total time taken: 1 hour and 14 minutes | ||
| + | * Uploaded the resulting .gdb file: [[Media:So-Std 20151201special.zip | new .gdb file]] | ||
{{Template:Journal Template}} | {{Template:Journal Template}} | ||
Latest revision as of 01:43, 2 December 2015
Log
- In class on 12/01/15, I went through the rest of the Testing Report and did the SQL Queries section and manually checked the gene IDs in the .gdb file.
- After looking at the IDs, I found that some of them were in the form "SO_A?####"
- Upon discovering this, I went back and tweaked the pattern for the XMLPipeDB and SQL commands. I got a count of 4207 IDs for XMLPipeDB and 4196 for PostgreSQL.
- Did a visual inspection of individual tables in the gdb file.
- Conducted an analysis of the results collected and found that the xmlpipedb-match had 11 extra IDs because the UNIPROT XML file contained 11 entries with no gene tag.
- Ran an export using the new genMAPP Builder given to me by Mary.
- Started: 4:12pm
- Finished: 5:26pm
- Total time taken: 1 hour and 14 minutes
- Uploaded the resulting .gdb file: new .gdb file
Individual Journal Entries
- Week 2
- Week 3
- Week 4
- Week 5
- Week 6
- Week 7
- Week 8
- Week 9
- Week 10
- Week 11
- Week 12
- Week 13
- Week 14
- Week 15
