*I download the UniProt XML, GOA, and GO OBO-XML files for ''Bordetella Pertussis'' along with the GenMAPP Builder program.

*I download the UniProt XML, GOA, and GO OBO-XML files for ''Bordetella Pertussis'' along with the GenMAPP Builder program.

**All files were saved to the folder ''Bklein7_CW\bpertussis_cw20151203'' on my computer's ThawSpace.

**All files were saved to the folder ''Bklein7_CW\bpertussis_cw20151210'' on my computer's ThawSpace.

**Files that required extraction were unzipped using [http://www.7-zip.org/ 7-zip].

**Files that required extraction were unzipped using [http://www.7-zip.org/ 7-zip].

**Data files that remained in a folder after unzipping were removed from their folders to facilitate organization and command line processing.

**Data files that remained in a folder after unzipping were removed from their folders to facilitate organization and command line processing.

====Downloaded GenMAPP Builder====

====Downloaded GenMAPP Builder====

# I downloaded the custom version of GenMAPP Builder including the ''Bordetella pertussis'' custom class expanded to include ORF listings in exports (Version 3.0.0 Build 5 - cw20151203): [[File:Dist cw20151203.zip]].

# I downloaded the custom version of GenMAPP Builder including the most recent version of the ''Bordetella pertussis'' custom class (Version 3.0.0 Build 5 - cw20151210): [[File:Dist cw20151210.zip]].

# I extracted the GenMAPP Builder folder using [http://www.7-zip.org/ 7-zip].

# I extracted the GenMAPP Builder folder using [http://www.7-zip.org/ 7-zip].

* I launched ''pgAdmin III'' and connected to the PostgreSQL 9.4 server (localhost:5432).

* I launched ''pgAdmin III'' and connected to the PostgreSQL 9.4 server (localhost:5432).

** On this server, I created a new database: ''bpertussis_cw20151201_gmb3build5''.

** On this server, I created a new database: ''bpertussis_cw20151210_gmb3build5''.

** I opened the SQL Editor tab to use an XMLPipeDB query to create the tables in the database.

** I opened the SQL Editor tab to use an XMLPipeDB query to create the tables in the database.

*** I clicked on the Open File icon and selected the file ''gmbuilder.sql''. This imported a series of SQL commands into the editor tab.

*** I clicked on the Open File icon and selected the file ''gmbuilder.sql''. This imported a series of SQL commands into the editor tab.

** Host or address: localhost

** Host or address: localhost

** Port number: 5432

** Port number: 5432

** Database name: bpertussis_cw20151201_gmb3build5

** Database name: bpertussis_cw20151210_gmb3build5

** Username: postgres

** Username: postgres

** Password: Welcome1

** Password: Welcome1

===Export Information===

===Export Information===

Version of GenMAPP Builder: Version 3.0.0 Build 5 - cw20151203

Version of GenMAPP Builder: Version 3.0.0 Build 5 - cw20151210

Computer on which export was run: Seaver 120- Last computer on the right in the row farthest from the front of the room

Computer on which export was run: Seaver 120- Last computer on the right in the row farthest from the front of the room

Postgres Database name: bpertussis_cw20151201_gmb3build5

Postgres Database name: bpertussis_cw20151210_gmb3build5

UniProt XML filename: [[File:Uniprot-proteome-UP000002676 cw20151201.zip]]

UniProt XML filename: [[]]

* UniProt XML version (The version information was found at [http://uniprot.org/news the UniProt News Page]): 2015_11

* UniProt XML version (The version information was found at [http://uniprot.org/news the UniProt News Page]): 2015_12

* UniProt XML download link: [http://www.uniprot.org/proteomes/UP000002676 Bordetella pertussis (strain Tohama I / ATCC BAA-589 / NCTC 13251)]

* UniProt XML download link: [http://www.uniprot.org/proteomes/UP000002676 Bordetella pertussis (strain Tohama I / ATCC BAA-589 / NCTC 13251)]

* Time taken to import: 2.59 minutes

* Time taken to import: 2.59 minutes

** Note: The import time was nearly equivalent to that when creating the previous "Bordetella pertussis" gene database: bpertussis-std_cw20151119.gdb (2.60 minute). No interruptions occurred during this process.

** Note: The import time was nearly equivalent to that when creating the previous "Bordetella pertussis" gene database: bpertussis-std_cw20151119.gdb (2.60 minute). No interruptions occurred during this process.