consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
16 rows where inchi_id = 1897
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 7017 | 7017 | 2144 2144 | 1897 | 1 | 0.122994652406417 |
| 21856 | 21856 | 6456 6456 | 1897 | 8 | 0.625 |
| 202174 | 202174 | 71690 71690 | 1897 | 1 | 0.122994652406417 |
| 220780 | 220780 | 76435 76435 | 1897 | 7 | 0.476190476190476 |
| 577747 | 577747 | 226349 226349 | 1897 | 1 | 0.137931034482759 |
| 594228 | 594228 | 231523 231523 | 1897 | 7 | 0.476190476190476 |
| 660948 | 660948 | 236621 236621 | 1897 | 1 | 0.122448979591837 |
| 660953 | 660953 | 236622 236622 | 1897 | 2 | 0.13953488372093 |
| 671420 | 671420 | 240323 240323 | 1897 | 9 | 0.628571428571429 |
| 685965 | 685965 | 244629 244629 | 1897 | 1 | 0.139130434782609 |
| 742254 | 742254 | 261378 261378 | 1897 | 4 | 0.6 |
| 742256 | 742256 | 261379 261379 | 1897 | 8 | 0.625 |
| 769741 | 769741 | 269266 269266 | 1897 | 1 | 0.137931034482759 |
| 903637 | 903637 | 318523 318523 | 1897 | 4 | 0.6 |
| 1616251 | 1616251 | 488045 488045 | 1897 | 8 | 0.625 |
| 1723539 | 1723539 | 527818 527818 | 1897 | 1 | 0.137931034482759 |
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)
);