re-index `drugcentral.bioactivity.action_type` field as keyword, perhaps index Chembl.drug_indications.first_approval

[colleenXu]

After discussion with Chunlei (internal lab Slack link), Chunlei suggested re-indexing drugcentral.bioactivity.action_type field as keyword (currently it's text). This is because I was having issues with unexpected partial matches (see quoted section below, pasted from Slack). I agree that this would solve my issue and seems to make sense with the data.

I also noticed that the field Chembl.drug_indications.first_approval may not be indexed at all (not showing up in metadata/fields endpoint). Maybe it should be? However, right now, BTE doesn't need this field to be indexed.

I've been querying MyChem's drugcentral.bioactivity info, and I have a question: when I ask for records where drugcentral.bioactivity.action_type:"MODULATOR" , I get some that appear to be partial matches. That's unexpected to me, since I had expected an exact match. Examples from this query: WYJAPUKIYAZSEM-RBUKOAKNSA-N: its 4 bioactivities are ALLOSTERIC MODULATOR GBBSUAFBMRNDJC-UHFFFAOYSA-N: its 8 bioactivities are POSITIVE MODULATOR LEQAKWQJCITZNK-AXHKHJLKSA-N: its 3 bioactivities are NEGATIVE MODULATOR This kind of thing is also happening if I query for action_type with other terms like AGONIST (entires that only have PARTIAL AGONIST will appear)

[DylanWelzel]

commit 3b70e704a32be82de7de9264e881bbb0838244b7 updates drugcentral.bioactivity.action_type to keyword and commit 8eb681935c6dfc6024ed249cde238604d5c59ea1 adds chembl.drug_indications.first_approval pending a new release.

[colleenXu]

Noting: want a quick review of drugcentral bioactivity x-bte annotation. Maybe can be updated if this field now behaves as keyword...(exact matching on modulator)?

[DylanWelzel]

These changes are now live with the new release.

[colleenXu]

Closing since the API changes are complete. Will open a different issue to update the x-bte annotation.