AmiGO Manual: GOOSE: Difference between revisions

From GO Wiki
Jump to navigation Jump to search
No edit summary
 
(3 intermediate revisions by the same user not shown)
Line 1: Line 1:
= GO Online SQL Environment (GOOSE) =
=What is GOOSE?=


Input SQL queries directly into one of the GO database mirrors. Includes templates, different results formats, and multiple mirrors.
The [http://amigo.geneontology.org/goose GO Online SQL Environment (GOOSE)] allows the user to input SQL queries directly into one of the GO database mirrors. It is intended for advanced users, or users who can't get their queries answered by AmiGO. The interface includes [[Example_Queries | templates]] from the GO wiki, different result formats, multiple mirrors, and links into AmiGO for some result types.


For most users and purposes, the main online [http://berkeleybop.org/goose GOOSE] is probably sufficient. For local installation, GOOSE is available as part of the go-dev repository (installed using the "-g" flag).
=Right...but how do I use it?=


While one can use the templates to get pretty far in GOOSE just by changing some of the inputs, the most important thing for getting the full functionality from GOOSE is some knowledge of the SQL language. There are [http://en.wikibooks.org/wiki/MySQL/Language many] [http://en.wikipedia.org/wiki/Select_(SQL) online] [http://en.wikipedia.org/wiki/SQL#Queries resources] to help you get started.
Another critical piece of information is the layout and contents of the GO database. The most useful resource for this if the automatically generated [http://www.geneontology.org/GO.database.shtml GO database schema] documentation.
Please keep in mind that for security reason, some commands and functions are not available to the user. In some edge cases, this may cause unexpected results.
[[Category:AmiGO_Manual]]
[[Category:AmiGO]]
[[Category:AmiGO]]
[[Category:AmiGO_Manual]]

Latest revision as of 16:19, 1 October 2014

What is GOOSE?

The GO Online SQL Environment (GOOSE) allows the user to input SQL queries directly into one of the GO database mirrors. It is intended for advanced users, or users who can't get their queries answered by AmiGO. The interface includes templates from the GO wiki, different result formats, multiple mirrors, and links into AmiGO for some result types.

Right...but how do I use it?

While one can use the templates to get pretty far in GOOSE just by changing some of the inputs, the most important thing for getting the full functionality from GOOSE is some knowledge of the SQL language. There are many online resources to help you get started.

Another critical piece of information is the layout and contents of the GO database. The most useful resource for this if the automatically generated GO database schema documentation.

Please keep in mind that for security reason, some commands and functions are not available to the user. In some edge cases, this may cause unexpected results.