Difference between revisions of "Ksherbina Project Notebook"

From LMU BioDB 2013
Jump to: navigation, search
(Import/Export of Gene Database: Added steps on configuring the database)
(Testing Report: Deleted a time. Added info on GenMAPP Builder version, database name, computer on which export was done, and name of UniProt XML file)
Line 27: Line 27:
 
====Testing Report====
 
====Testing Report====
  
Version of GenMAPP Builder:
+
Version of GenMAPP Builder: 2.0b71
  
Computer on which export was run:
+
Computer on which export was run: Personal computer
  
Postgres Database name:
+
Postgres Database name: CT_KS_20131114_gmb2b71
  
UniProt XML filename:
+
UniProt XML filename: Uniprot_XML_C.trachomatis_serovar_A_KS_20131114.xml
 
* UniProt XML version (The version information can be found at [http://uniprot.org/news the UniProt News Page]):
 
* UniProt XML version (The version information can be found at [http://uniprot.org/news the UniProt News Page]):
* Time taken to import: 1.05  min
+
* Time taken to import:  
  
 
GO OBO-XML filename:
 
GO OBO-XML filename:

Revision as of 01:26, 15 November 2013

Katrina Sherbina
Class Page    User Page
Assignment Description Week 1 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 15
Class Journal Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9
Individual Journal Week 2 Week 3 Week 4 Week 5 Week 6 Week 7 Week 8 Week 9 Week 10 Week 11
Other Week 5: Database Wiki
Final Project Team H(oo)KD Project Page Journal Club Presentation Project Individual Journal

Contents

Week 12

Setting Up the Testing Environment

  1. Downloaded the following software onto my personal computer:
  2. Created an account on SourceForge.

Import/Export of Gene Database

  1. Downloaded the UniProt XML for C. trachomatis serovar A strain HAR-13: Uniprot XML C.trachomatis serovar A KS 20131114.xml
  2. Downloaded the GOA file for C. trachomatis serovar A: 22183.C trachomatis A KS 20131114.goa
  3. Created a new database in pgAdminIII: CT_KS_20131114_gmb2b71
    • Created tables in the database by executing the script in the file gmbuilder.sql.
  4. Launched gmbuilder-32bit.bat:
  5. Configured the database in gmbuilder:
    • Host or address: localhost
    • Port number: 5432
    • Database name: CT_KS_20131114_gmb2b71
    • Username: postgres
    • Password: <password of the PostgreSQL database created above>

Testing Report

Version of GenMAPP Builder: 2.0b71

Computer on which export was run: Personal computer

Postgres Database name: CT_KS_20131114_gmb2b71

UniProt XML filename: Uniprot_XML_C.trachomatis_serovar_A_KS_20131114.xml

  • UniProt XML version (The version information can be found at the UniProt News Page):
  • Time taken to import:

GO OBO-XML filename:

  • GO OBO-XML version (The version information can be found in the file properties after the file downloaded from the GO Download page has been unzipped):
  • Time taken to import:
  • Time taken to process:

GOA filename:

  • GOA version (News on this page records past releases; current information can be found in the Last modified field on the FTP site):
  • Time taken to import:

Name of .gdb file:

  • Time taken to export .gdb:
  • Upload your file and link to it here.

Note:

Week 13

Personal tools
Namespaces

Variants
Actions
Navigation
Toolbox