I am trying to map InChI strings to new metabolite identifiers for a plugin I am developing.
I have two TSV files of the following formats:
- A data file where column 1 contains InChI Strings, column 2 contains numerical values.
- A mapping file where column 1 contains InChI Strings, column 2 contains new identifiers.
The goal is to end up with an artifact containing a table where column 1 are the new IDs and column 2 are the corresponding numerical values
(This artifact will be the input to a visualizer)
My original idea was to define two SemanticTypes and a transformer to produce the desired result as a third SemanticType.
(e.g. InChIDataValues + InChIMapping --> transfomer --> NewID)
However, it seems that Qiime2 Metadata can also be used for mapping purposes, and I have yet to see an example of a transformer that turns two inputs into one output.
What would be the ideal way to develop this mapping pipeline?