Hello I have a file like
ENTRY EC 22.214.171.124 Enzyme NAME alcohol dehydrogenase; CLASS Oxidoreductases; SYSNAME alcohol:NAD+ oxidoreductase REACTION (1) a primary alcohol + NAD+ = an aldehyde + NADH + H+ [RN:R00623]; ALL_REAC R00623 > R00754 R02124 R02878 R04805 R04880 R05233 R05234 R06917 R06927 R08281 R08306 R08557 R08558 R10783; SUBSTRATE primary alcohol [CPD:C00226]; PRODUCT aldehyde [CPD:C00071]; ENTRY EC 126.96.36.199 Enzyme NAME 3-hydroxybutyryl-CoA dehydrogenase; CLASS Oxidoreductases; SYSNAME (S)-3-hydroxybutanoyl-CoA:NADP+ oxidoreductase REACTION (S)-3-hydroxybutanoyl-CoA + NADP+ = 3-acetoacetyl-CoA + NADPH + H+ [RN:R01976] ALL_REAC R01976; SUBSTRATE (S)-3-hydroxybutanoyl-CoA [CPD:C01144]; PRODUCT 3-acetoacetyl-CoA [CPD:C00332];
and i need to convert it to
ENTRY NAME CLASS SYSNAME REACTION ALL_REAC SUBSTRATE PRODUCT
and the corresponding values in rows. can anybody help me writing a script for this purpose.