consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inchi_id = 47035
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 84845 | 84845 | 30532 30532 | 47035 | 8 | 0.413793103448276 |
| 167270 | 167270 | 59798 59798 | 47035 | 13 | 0.405120753554776 |
| 212232 | 212232 | 74176 74176 | 47035 | 8 | 0.325745913486962 |
| 277761 | 277761 | 94180 94180 | 47035 | 1 | 0.0764331210191083 |
| 423815 | 423815 | 153259 153259 | 47035 | 8 | 0.325745913486962 |
| 546686 | 546686 | 216226 216226 | 47035 | 12 | 0.25695894831942 |
| 703337 | 703337 | 250461 250461 | 47035 | 1 | 0.0818852513650408 |
| 720599 | 720599 | 254753 254753 | 47035 | 8 | 0.413793103448276 |
| 799904 | 799904 | 279042 279042 | 47035 | 1 | 0.084736556219446 |
| 799909 | 799909 | 279043 279043 | 47035 | 1 | 0.0845070422535211 |
| 826400 | 826400 | 286826 286826 | 47035 | 8 | 0.413793103448276 |
| 826404 | 826404 | 286827 286827 | 47035 | 7 | 0.620689655172414 |
| 826406 | 826406 | 286828 286828 | 47035 | 5 | 0.608695652173913 |
| 910105 | 910105 | 321430 321430 | 47035 | 1 | 0.0835266821345708 |
| 1609562 | 1609562 | 485977 485977 | 47035 | 8 | 0.413793103448276 |
| 1644500 | 1644500 | 497773 497773 | 47035 | 1 | 0.084736556219446 |
| 1715921 | 1715921 | 525588 525588 | 47035 | 8 | 0.325745913486962 |
CREATE TABLE [consensus_index] (
[inventory_id] integer,
[inchi_id] text,
[consensus_score] text,
[consensus_count] integer,
FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);