RepoDB Query Skill
Search RepoDB records by any entity. Auto-detects type by prefix:
| Input Pattern | Detected As | Match Logic |
|---|---|---|
DB00584 |
DrugBank ID | exact on drugbank_id |
C0020538 |
UMLS CUI | exact on ind_id |
NCT00001234 |
Trial ID | exact on NCT |
| anything else | free text | substring on drug_name OR ind_name |
API
| Function | Input | Returns |
|---|---|---|
load_repodb(path) |
CSV path | DataFrame |
search(df, entity) |
single entity string | DataFrame |
search_batch(df, entities) |
list of entity strings | dict[str, DataFrame] |
summarize(hits, entity) |
DataFrame + label | compact text |
to_json(hits) |
DataFrame | list[dict] |
Usage
See if __name__ == "__main__" block in repodb_query.py for runnable examples covering: drug name, DrugBank ID, UMLS CUI, indication name, batch search, and JSON output.
Data
- Source:
full.csv(comma or tab separated, auto-detected) - Columns:
drug_name,drugbank_id,ind_name,ind_id,NCT,status,phase,DetailedStatus - Path:
DATA_PATHvariable inrepodb_query.py