consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inchi_id = 116797
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 33617 | 33617 | 9909 9909 | 116797 | 3 | 0.432136581898648 |
| 80855 | 80855 | 29161 29161 | 116797 | 3 | 0.432136581898648 |
| 137970 | 137970 | 49118 49118 | 116797 | 3 | 0.432136581898648 |
| 242844 | 242844 | 82587 82587 | 116797 | 1 | 0.239130434782609 |
| 255699 | 255699 | 86768 86768 | 116797 | 2 | 0.234049095855053 |
| 439582 | 439582 | 157564 157564 | 116797 | 6 | 0.738796125036259 |
| 716167 | 716167 | 253375 253375 | 116797 | 6 | 0.738796125036259 |
| 759359 | 759359 | 266522 266522 | 116797 | 1 | 0.40847646066685 |
| 759362 | 759362 | 266523 266523 | 116797 | 3 | 0.432136581898648 |
| 759365 | 759365 | 266524 266524 | 116797 | 1 | 0.40847646066685 |
| 759369 | 759369 | 266525 266525 | 116797 | 1 | 0.297965672868055 |
| 769765 | 769765 | 269275 269275 | 116797 | 1 | 0.174418604651163 |
| 818939 | 818939 | 284293 284293 | 116797 | 6 | 0.738796125036259 |
| 818940 | 818940 | 284294 284294 | 116797 | 5 | 0.725708114822568 |
| 883559 | 883559 | 307393 307393 | 116797 | 3 | 0.690983005625053 |
| 1634224 | 1634224 | 493985 493985 | 116797 | 3 | 0.432136581898648 |
| 1730103 | 1730103 | 529839 529839 | 116797 | 3 | 0.432136581898648 |
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)
);