Support multiple participant ID columns in tabular data

[alyssadai]

We keep encountering TSVs that have a participant ID column without the sub- prefix required for BIDS subdirectories. This makes sense, as most likely the phenotypic/tabular data will have preceded the BIDS conversion step for most datasets.

Right now, the only option for these kinds of tabular data to work with the Neurobagel CLI is if the data owner adds another column for the BIDS participant IDs, or modifies their existing participant ID column. This is probably not ideal, and also means that we are sometimes creating extra work for data owners only if they have imaging data in addition to phenotypic data.

We should consider having the CLI handle this work by automatically prepending sub- onto a given participant ID column if the prefixes don't already exist, before doing the imaging-tabular subject matching check.

[alyssadai]

We need to think about the scenario where some subjects in the tabular file have BIDS data, but not all.

[github-actions[bot]]

We want to keep our issues up to date and active. This issue hasn't seen any activity in the last 75 days. We have applied the _flag:stale label to indicate that this issue should be reviewed again. When you review, please reread the spec and then apply one of these three options:

• prioritize: apply the flag:schedule label to suggest moving this issue into the backlog now
• close: if the issue is no longer relevant, explain why (give others a chance to reply) and then close.
• archive: sometimes an issue has important information or ideas but we won't work on it soon. In this case apply the someday label to show that this won't be prioritized. The stalebot will ignore issues with this label in the future. Use sparingly!