Difference between revisions of "Taur.vil Week 12"

From LMU BioDB 2013
Jump to: navigation, search
(G54: finished through export)
(Lab Journal: R6 strain as well)
Line 15: Line 15:
 
**Extracted files using 7zip and imported extracted file into gmbuilder
 
**Extracted files using 7zip and imported extracted file into gmbuilder
 
**Took 12.64 minutes to import and 10.63 minutes to process
 
**Took 12.64 minutes to import and 10.63 minutes to process
*Exported file to title: 20131113 G45export tATK TPV.gdb
+
*Exported file to title: 20131113_G45export_tATK_TPV.gdb
 
**Took less than 2h
 
**Took less than 2h
 
*Uploaded export to wiki: [[Media:20131113 G45export tATK TPV.gdb]]
 
*Uploaded export to wiki: [[Media:20131113 G45export tATK TPV.gdb]]
  
 
+
===R6===
 
+
*Created new database in pgAdminIII titled: tATK_R6_20131113
 +
*Ran SQL, opened gmbuilder.sql and executed
 +
**Produced the expect 159 tables
 +
*Configured gmbuilder-32bit.bat to connect with the database
 +
*Imported the XML file 20131105_UniProtXML_tATK_R6_AJV.xml which can be found on our [[Streptococcus pneumoniae|team page]].
 +
**Import took 5.16 minutes
 +
*Imported go-obo file extracted during G54
 +
**Took 12.67min to upload and 10.06min to process.
 +
*Imported goa file 20131107_UniProtXML_tATK_R6_AJV.goa
 +
**Import took 0.04min
 +
*Exported file to 20131113_R6export_tATK_TPV.gdb
 +
**Took less than an hour
 +
*Uploaded export to wiki: [[Media:20131113 R6export tATK TPV.gdb]]
  
 
{{Taur.vil}}
 
{{Taur.vil}}

Revision as of 07:51, 14 November 2013

Week 12 Individual Journal

Lab Journal

G54

  • Downloaded GM Builder 2.0b71 for my personal computer from [1]
  • On my personal computer created new database in PgAdminIII titled: tATK_G54_20131113
  • Ran SQL, opened gmbuilder.sql and executed
    • Produced the expect 159 tables
  • Configured gmbuilder-32bit.bat to connect with the database
  • Imported the XML file 20131107_UniProtXML_tATK_G54_AJV.xml which can be found on our team page.
    • Took 2.98 minutes
  • Imported the goa file 20131107_UniProtXML_tATK_G54_AJV.goa (also on our team page)
    • Took 0.05 minutes
  • Downloaded the compressed go-obo file 20131107_GO-OBO_tATK_KM.gz from the team page.
    • Extracted files using 7zip and imported extracted file into gmbuilder
    • Took 12.64 minutes to import and 10.63 minutes to process
  • Exported file to title: 20131113_G45export_tATK_TPV.gdb
    • Took less than 2h
  • Uploaded export to wiki: Media:20131113 G45export tATK TPV.gdb

R6

  • Created new database in pgAdminIII titled: tATK_R6_20131113
  • Ran SQL, opened gmbuilder.sql and executed
    • Produced the expect 159 tables
  • Configured gmbuilder-32bit.bat to connect with the database
  • Imported the XML file 20131105_UniProtXML_tATK_R6_AJV.xml which can be found on our team page.
    • Import took 5.16 minutes
  • Imported go-obo file extracted during G54
    • Took 12.67min to upload and 10.06min to process.
  • Imported goa file 20131107_UniProtXML_tATK_R6_AJV.goa
    • Import took 0.04min
  • Exported file to 20131113_R6export_tATK_TPV.gdb
    • Took less than an hour
  • Uploaded export to wiki: Media:20131113 R6export tATK TPV.gdb

By Tauras Vilgalys

As part of Biological Databases


Please Remember the Harassing of Deities is Strictly Prohibited

Never Forget Samson

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox