search

eggnogdb / eggnog-mapper

Fast genome-wide functional annotation through orthology assignment
http://eggnog-mapper.embl.de
GNU Affero General Public License v3.0
561 stars 105 forks source link

get parent og from og #460

Closed matthpich closed 1 year ago

matthpich commented 1 year ago

Hi, There used to be ways to identify parent og from og ids through sqlite3 tables. Could you tell me where to find this information? I am using emapperdb version 5.0.2. Many thanks for your help. Best, Matthieu

Cantalapiedra commented 1 year ago

Hi,

I would say there is no way to do such mapping using eggnog-mapper database 5.0.2. You may try using the OG ID to retrieve the OGs to which the same protein belongs to, which should contain (all?) the parents:

select ogs from prots where ogs LIKE '%2VK9J@28216%'

But I am afraid you won't know which are parents and children unless you use NCBI taxonomy to parse the results.

Best, Carlos

matthpich commented 1 year ago

Thanks for sharing this great idea Carlos.

matthpich commented 1 year ago

Carlos's answer answers the question.