This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to find category names of Gene Ontoloy based on category ID

Dear All,

I have a data set that has category IDs as below:

    Category
1  GO:0016021
2  GO:0044425
3  GO:0031224
4  GO:0004872

I want to find what category they belong to (Molecular function, cellular component and biological process)

Any idea about that?

rna-seq gene rna-seq
• 2,514 views • link
updated by Pierre Lindenbaum Pierre Lindenbaum • written by Mehmet Mehmet

2 answers

Hey Mehmet,

Look at the links below:

GO:0016021

GO:0044425

GO:0031224

GO:0004872

Best regards,

Leite

• 0 views • link
written by Leite Leite

Hi Leite,

Thanks. but I have a lot of GO Ids, so I need a way to put all Ids and get results.Do you have any idea for this?

• 0 views • link
written by Mehmet Mehmet

using mysql:

$ mysql --user=genome --host=genome-mysql.soe.ucsc.edu -A -D go -e 'select acc,term_type,name from term where  acc in ("GO:0016021","GO:0044425","GO:0031224","GO:0004872");'
+------------+--------------------+---------------------------------+
| acc        | term_type          | name                            |
+------------+--------------------+---------------------------------+
| GO:0004872 | molecular_function | receptor activity               |
| GO:0016021 | cellular_component | integral component of membrane  |
| GO:0031224 | cellular_component | intrinsic component of membrane |
| GO:0044425 | cellular_component | membrane part                   |
+------------+--------------------+---------------------------------+

or

cat list_of_acn |\
awk '{printf("select acc,term_type,name from term where  acc=\"%s\";\n",$1);}' | \
mysql --user=genome --host=genome-mysql.soe.ucsc.edu -A -D go -N
GO:0016021  cellular_component  integral component of membrane
GO:0044425  cellular_component  membrane part
GO:0031224  cellular_component  intrinsic component of membrane
GO:0004872  molecular_function  receptor activity
• 0 views • link
written by Pierre Lindenbaum Pierre Lindenbaum

Log in to answer this question.

More posts like this