Search Mailing List Archives


Limit search to: Subject & Body Subject Author
Sort by: Reverse Sort
Limit to: All This Week Last Week This Month Last Month
Select Date Range     through    

[go-friends] GO database table to ER

Zhiliang hu at animalgenome.org
Thu Oct 20 14:31:26 PDT 2011


Chris - How nice you have all sorts of these amazing tricks!

Thanks a bundle - you made my day :)

Zhiliang


On Thu, 20 Oct 2011, Chris Mungall wrote:

> Date: Thu, 20 Oct 2011 09:43:22 -0700
> From: Chris Mungall <cjmungall at lbl.gov>
> To: Zhiliang <hu at animalgenome.org>
> Cc: gofriends at genome.stanford.edu
> Subject: Re: [go-friends] GO database table to ER
> 
> Hi Zhiliang!
>
> For historic reasons, you have to run the source sql through the 'compiledb'
> script. Do you already have the sql/ directory checked out from the go-dev
> project?
>
> ./compiledb go-tables-FULL.sql
>
> You can browse the dir here:
> http://geneontology.svn.sourceforge.net/viewvc/geneontology/go-dev/trunk/sql/
>
>
>
> On Oct 17, 2011, at 8:02 PM, Zhiliang wrote:
>
>> I wish to have an ER digram for the GO database tables so that I can build
> customized queries more easily.  However my attempts by connecting the MySQL
> Workbench to a local copy of a GO db, and by importing all SQL scripts ('cat'
> all into one) into MySQL Workbench, all failed.  I am not sure but wonder is
> there a different copy of SQL scripts that can be used for this purpose? (e.g.
> I have successfully use Ensembl SQL scripts to port into MySQL Workbench for
> ER diagrams).
>>
>> I know there is already an ER at the GO site
>> http://www.geneontology.org/GO.database.shtml#diagram but I wish to have one
> in the MySQL Workbench for details.
>>
>> Any help will be appreciated.  Thanks in advance!
>>
>> Zhiliang
>>
>> _______________________________________________
>> go-friends mailing list
>> go-friends at lists.stanford.edu
>> https://mailman.stanford.edu/mailman/listinfo/go-friends
>



More information about the go-friends mailing list