consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
14 rows where inchi_id = 42770
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 71554 | 71554 | 24294 24294 | 42770 | 1 | 0.0529540631835156 |
| 99369 | 99369 | 35177 35177 | 42770 | 1 | 0.0529540631835156 |
| 184174 | 184174 | 65767 65767 | 42770 | 1 | 0.0552314353733913 |
| 278552 | 278552 | 94441 94441 | 42770 | 8 | 0.625 |
| 393305 | 393305 | 135682 135682 | 42770 | 1 | 0.0536491505274024 |
| 539497 | 539497 | 213848 213848 | 42770 | 1 | 0.0552314353733913 |
| 727811 | 727811 | 256943 256943 | 42770 | 1 | 0.0529540631835156 |
| 841672 | 841672 | 291786 291786 | 42770 | 1 | 0.0552314353733913 |
| 841680 | 841680 | 291787 291787 | 42770 | 1 | 0.0529540631835156 |
| 841689 | 841689 | 291788 291788 | 42770 | 1 | 0.036661256157011 |
| 895743 | 895743 | 314573 314573 | 42770 | 1 | 0.0552314353733913 |
| 905556 | 905556 | 319502 319502 | 42770 | 4 | 0.6 |
| 1708816 | 1708816 | 522636 522636 | 42770 | 1 | 0.0504923203725954 |
| 1761349 | 1761349 | 540829 540829 | 42770 | 1 | 0.0525021572889772 |
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)
);