consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 31781
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 15043 | 15043 | 4699 4699 | 31781 | 1 | 0.259842519685039 |
| 96790 | 96790 | 34321 34321 | 31781 | 8 | 0.9 |
| 208634 | 208634 | 73725 73725 | 31781 | 1 | 0.206896551724138 |
| 270203 | 270203 | 91616 91616 | 31781 | 8 | 0.9 |
| 340702 | 340702 | 114950 114950 | 31781 | 1 | 0.25 |
| 382805 | 382805 | 131069 131069 | 31781 | 1 | 0.130000982269227 |
| 421844 | 421844 | 153042 153042 | 31781 | 1 | 0.206896551724138 |
| 478542 | 478542 | 174719 174719 | 31781 | 1 | 0.25 |
| 830574 | 830574 | 288213 288213 | 31781 | 1 | 0.129032258064516 |
| 830578 | 830578 | 288214 288214 | 31781 | 1 | 0.130000982269227 |
| 922227 | 922227 | 327303 327303 | 31781 | 4 | 0.833333333333333 |
| 931727 | 931727 | 331827 331827 | 31781 | 1 | 0.129032258064516 |
| 1111406 | 1111406 | 382029 382029 | 31781 | 1 | 0.130000982269227 |
| 1111410 | 1111410 | 382030 382030 | 31781 | 1 | 0.130000982269227 |
| 1345161 | 1345161 | 430737 430737 | 31781 | 1 | 0.130000982269227 |
| 1345165 | 1345165 | 430738 430738 | 31781 | 1 | 0.130000982269227 |
| 1537458 | 1537458 | 469537 469537 | 31781 | 1 | 0.130000982269227 |
| 1537462 | 1537462 | 469538 469538 | 31781 | 1 | 0.130000982269227 |
| 1603306 | 1603306 | 484342 484342 | 31781 | 1 | 0.130000982269227 |
| 1607877 | 1607877 | 485725 485725 | 31781 | 1 | 0.259842519685039 |
| 1697901 | 1697901 | 517738 517738 | 31781 | 1 | 0.130000982269227 |
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)
);