consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inchi_id = 51347
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 15394 | 15394 | 4745 4745 | 51347 | 8 | 0.9 |
| 98166 | 98166 | 34803 34803 | 51347 | 8 | 0.9 |
| 173416 | 173416 | 61957 61957 | 51347 | 10 | 0.916666666666667 |
| 209846 | 209846 | 73899 73899 | 51347 | 8 | 0.625 |
| 511483 | 511483 | 205915 205915 | 51347 | 8 | 0.9 |
| 511484 | 511484 | 205916 205916 | 51347 | 8 | 0.9 |
| 553624 | 553624 | 218477 218477 | 51347 | 7 | 0.888888888888889 |
| 712571 | 712571 | 252514 252514 | 51347 | 12 | 0.636363636363636 |
| 813554 | 813554 | 282852 282852 | 51347 | 8 | 0.9 |
| 813555 | 813555 | 282853 282853 | 51347 | 8 | 0.625 |
| 1066091 | 1066091 | 375878 375878 | 51347 | 8 | 0.9 |
| 1066092 | 1066092 | 375879 375879 | 51347 | 8 | 0.9 |
| 1290334 | 1290334 | 423673 423673 | 51347 | 8 | 0.9 |
| 1290335 | 1290335 | 423674 423674 | 51347 | 8 | 0.9 |
| 1503623 | 1503623 | 464859 464859 | 51347 | 8 | 0.9 |
| 1601131 | 1601131 | 483661 483661 | 51347 | 8 | 0.9 |
| 1608467 | 1608467 | 485819 485819 | 51347 | 8 | 0.9 |
| 1715019 | 1715019 | 525441 525441 | 51347 | 5 | 0.857142857142857 |
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)
);