consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 68123
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 191634 | 191634 | 68123 68123 | 695 | 1 | 0.053200800899871 |
| 191635 | 191635 | 68123 68123 | 2054 | 1 | 0.0133002002249678 |
| 191636 | 191636 | 68123 68123 | 2595 | 1 | 0.035467200599914 |
| 191637 | 191637 | 68123 68123 | 4065 | 1 | 0.0193457457817713 |
| 191638 | 191638 | 68123 68123 | 51044 | 1 | 0.0709344011998281 |
| 191639 | 191639 | 68123 68123 | 54379 | 1 | 0.0709344011998281 |
| 191640 | 191640 | 68123 68123 | 60355 | 16 | 0.212803203599484 |
| 191641 | 191641 | 68123 68123 | 63043 | 2 | 0.0300949176646834 |
| 191642 | 191642 | 68123 68123 | 120281 | 1 | 0.017733600299957 |
| 191643 | 191643 | 68123 68123 | 147746 | 1 | 0.0425606407198968 |
| 191644 | 191644 | 68123 68123 | 149874 | 1 | 0.035467200599914 |
| 191645 | 191645 | 68123 68123 | 169840 | 1 | 0.0304004576570692 |
| 191646 | 191646 | 68123 68123 | 192411 | 1 | 0.0266004004499355 |
| 191647 | 191647 | 68123 68123 | 204914 | 1 | 0.053200800899871 |
| 191648 | 191648 | 68123 68123 | 208139 | 1 | 0.0163694771999603 |
| 191649 | 191649 | 68123 68123 | 220244 | 1 | 0.0236448003999427 |
| 191650 | 191650 | 68123 68123 | 232023 | 1 | 0.106401601799742 |
| 191651 | 191651 | 68123 68123 | 253780 | 1 | 0.0141868802399656 |
| 191652 | 191652 | 68123 68123 | 255399 | 1 | 0.0152002288285346 |
| 191653 | 191653 | 68123 68123 | 296183 | 1 | 0.106401601799742 |
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)
);