consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 12497
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 34646 | 34646 | 10250 10250 | 12497 | 1 | 0.0639845386932987 |
| 89548 | 89548 | 31993 31993 | 12497 | 1 | 0.0639845386932987 |
| 167580 | 167580 | 59888 59888 | 12497 | 1 | 0.0639845386932987 |
| 257557 | 257557 | 87199 87199 | 12497 | 1 | 0.258956550280926 |
| 257571 | 257571 | 87204 87204 | 12497 | 8 | 0.625 |
| 257815 | 257815 | 87284 87284 | 12497 | 1 | 0.0660689119983467 |
| 445912 | 445912 | 159696 159696 | 12497 | 1 | 0.0660689119983467 |
| 523398 | 523398 | 208674 208674 | 12497 | 1 | 0.258956550280926 |
| 523400 | 523400 | 208675 208675 | 12497 | 1 | 0.258956550280926 |
| 578489 | 578489 | 226574 226574 | 12497 | 8 | 0.625 |
| 578499 | 578499 | 226578 226578 | 12497 | 1 | 0.258956550280926 |
| 685181 | 685181 | 244414 244414 | 12497 | 1 | 0.256103523663342 |
| 768102 | 768102 | 268851 268851 | 12497 | 1 | 0.258956550280926 |
| 879379 | 879379 | 305267 305267 | 12497 | 4 | 0.6 |
| 1034690 | 1034690 | 366784 366784 | 12497 | 1 | 0.0639845386932987 |
| 1253616 | 1253616 | 413059 413059 | 12497 | 1 | 0.0639845386932987 |
| 1480528 | 1480528 | 458070 458070 | 12497 | 1 | 0.0639845386932987 |
| 1595081 | 1595081 | 481446 481446 | 12497 | 1 | 0.0639845386932987 |
| 1635276 | 1635276 | 494333 494333 | 12497 | 1 | 0.0639845386932987 |
| 1731116 | 1731116 | 530091 530091 | 12497 | 1 | 0.0639845386932987 |
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)
);