Go Back   SEQanswers > Bioinformatics > Bioinformatics

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question about editing a tabbed text file.. shyam_la Bioinformatics 24 06-14-2012 10:06 PM
Editing the content of an ab1 file thedamian Sanger/Dye Terminator 3 04-12-2012 08:14 AM
PubMed: Metagenomic Analysis of the Viral Community in Fermented Foods. Newsbot! Literature Watch 0 12-25-2010 03:06 AM
PubMed: A framework for analysis of metagenomic sequencing data. Newsbot! Literature Watch 0 12-02-2010 03:00 AM

Thread Tools
Old 11-19-2012, 12:49 PM   #1
Giorgio C
Location: ITALY

Join Date: Oct 2010
Posts: 89
Default Editing a Kegg Ortholgy file for metagenomic analysis in Qiime

Hi all,

I'm trying to link a metagenomic analysis done with Qiime tools and a KO file obtained with Picrust. It's actually an editing text problem and
I guess someone here could help me.

I have this file (attached):

In the Column A there is a list od ID (often present in multiple time), every ID is associated with a number in column B.
The same numbers in column B correspond to the number of column D that is associeted with a functions (colum E,F,...).
So in other words the ID in column A should be associated with his function (in colum E,F..). The ID column and the functions columns are linked by the numbers in column B and D.

At the end I need to have something like this so:

K00001 Metabolism Enzyme Families Peptidases <tab> Organismal Systems Immune System Antigen processing and presentation <tab> .... (when mulitple entry)
K0009 Metabolism Enzyme Families Peptidases

Acutally the column A should become in single entry ID only but without loosing the associated functions. As you can see some time there are single ID entry so it will have an only function associated like K0009 in the example.
Other time the ID entry are multiple like K0001 and so the function will be multiple and it need to be reported in the same raws tab separeted as shown up.

I know is a little bit tricky and complicated, I really hope to have been clear and that someone could help me.

Thanks a lot in advance,
Attached Files
File Type: zip (79.4 KB, 3 views)
Giorgio C is offline   Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT -8. The time now is 02:38 PM.

Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2021, vBulletin Solutions, Inc.
Single Sign On provided by vBSSO