Gmail Calendar Documents Reader Web more »
Recently Visited Groups | Help | Sign in
Google Groups Home
Setting up a local Blast2GO database
There are currently too many topics in this group that display first. To make this topic appear first, remove this option from another topic.
There was an error processing your request. Please try again.
flag
  1 message - Collapse all  -  Translate all to Translated (View all originals)
The group you are posting to is a Usenet group. Messages posted to this group will make your email address visible to anyone on the Internet.
Your reply message has not been sent.
Your post was successful
 
From:
To:
Cc:
Followup To:
Add Cc | Add Followup-to | Edit Subject
Subject:
Validation:
For verification purposes please type the characters you see in the picture below or the numbers you hear by clicking the accessibility icon. Listen and type the numbers you hear
 
JP  
View profile  
 More options Feb 24 2008, 10:26 am
From: JP <jpope...@gmail.com>
Date: Sun, 24 Feb 2008 07:26:15 -0800 (PST)
Local: Sun, Feb 24 2008 10:26 am
Subject: Setting up a local Blast2GO database
Hey all,
I set up a local blast2go database for our internal uses and came
across some "tricks n' tips" I wanted to share.

There's a document detailing the setup for a local b2g at
http://bioinfo.cipf.es/blast2go --> Downloads --> Local B2G database
installation guide (howto_v1.3.tar.gz).

I followed all of the steps in the document (v1.3 - 29.08.2007) with
the following changes:

1.  Step 5c of Importing the data used for the mapping:
        Got the following error using the sun-java6-jdk on Ubuntu 7.10:
                $ javac -classpath . ImportPIR.java
                Note: ImportPIR.java uses unchecked or unsafe operations.
                Note: Recompile with -Xlint:unchecked for details.

After some searching online, this is because of how newer versions of
JDK handle Generics.  By running javac -Xlint:unchecked -classpath .
ImportPIR.java, I was able to compile the java class (with a warning).

2.  A new file from www.geneontology.org/external2go/ec2go was
downloaded (Feb 23, 2008).
When attempting to import the file (Step 3), the following error
occurs:
        mysqlimport: Error: Duplicate entry 'EC:3.6.3.14        GO:00469-'
for key 1, when using table: ec2go

Checking the following:
$ cat ec2go | grep 3.6.3.14
EC:3.6.3.14     GO:0046961
EC:3.6.3.14     GO:0046933

These GO terms are both for "hydrogen ion transporting ATP(ase)
(synthase) activity, rotational mechanism  -- the differences are in
parentheses.

Upon closer inspection of the ec2go file, there are other duplicates.
They are:
EC:2.5.1.46     GO:0034038
EC:2.5.1.46     GO:0050983

EC:2.7.1.119    GO:0008904
EC:2.7.1.119    GO:0034071

EC:3.5.99.7     GO:0008660
EC:3.5.99.7     GO:0034100

EC:3.6.3.15     GO:0046962
EC:3.6.3.15     GO:0046932

EC:3.6.5.1      GO:0003924
EC:3.6.5.1      GO:0005834

EC:3.6.5.3      GO:0003924
EC:3.6.5.3      GO:0006412

EC:3.6.5.4      GO:0003924
EC:3.6.5.4      GO:0005786

After manually comparing the 2 GO terms for each EC, I selectively
removed/deleted one of them.  (WARNING:  doing so may break previous
mappings.)  Once this was accomplished, the ec2go file could be
imported into database (Step 3).

3.  When importing the annex file to the database, a similar error of
duplicates was thrown.  I decided to leave this as is and stopped
there.  For accomplishing the Annex, I will just reset the database
connection to default.

General:
Fixes for the guide (Importing data for the Enzyme Code retrieval):
        In Step 2a, instead of replacing all ">" with ";", replace " > " as
well as " ; " with ";" (remove white space).
        Additonally, in Step 2c, remove the 2nd COLUMN (not row), as well as
the header information.

Hope that helps others.
JP


    Reply to author    Forward  
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.
End of messages
« Back to Discussions « Newer topic     Older topic »

Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
©2009 Google