Taur.vil Week 12

From LMU BioDB 2013
Revision as of 07:51, 14 November 2013 by Taur.vil (Talk | contribs)

Jump to: navigation, search

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