Hi, I have a list of GO gene IDs. Now, I want to map this to corresponding MetaCyc pathways. I mean, I want to know which gene is found in which pathways. It will look like this table where 0 represents absent and 1 is for present:

    Pathway1    Pathway2    Pathway3 Pathway4 Pathway5          Pathway6
GO:1    1   0   0   1   1   0
GO:2    0   0   1   1   0   0
GO:3    1   0   1   1   0   1
GO:4    0   1   1   0   0   1
GO:5    0   1   1   1   0   0
GO:6    0   1   1   0   0   0
GO:7    1   1   0   0   1   0
GO:8    1   0   0   0   0   1

So, can anyone please help me with how can I retrieve the information?

Many thanks in advance, dpc