consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 31489
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 3598 | 3598 | 1003 1003 | 31489 | 2 | 0.130688482038042 |
| 4725 | 4725 | 1439 1439 | 31489 | 7 | 0.888888888888889 |
| 140530 | 140530 | 50063 50063 | 31489 | 4 | 0.833333333333333 |
| 199047 | 199047 | 70778 70778 | 31489 | 7 | 0.888888888888889 |
| 199169 | 199169 | 70835 70835 | 31489 | 2 | 0.130688482038042 |
| 230431 | 230431 | 78951 78951 | 31489 | 8 | 0.625 |
| 494292 | 494292 | 187189 187189 | 31489 | 1 | 0.0636765635057063 |
| 520737 | 520737 | 207912 207912 | 31489 | 8 | 0.625 |
| 520738 | 520738 | 207913 207913 | 31489 | 4 | 0.833333333333333 |
| 526588 | 526588 | 209503 209503 | 31489 | 2 | 0.130688482038042 |
| 536689 | 536689 | 212990 212990 | 31489 | 2 | 0.130688482038042 |
| 565874 | 565874 | 222200 222200 | 31489 | 8 | 0.625 |
| 662085 | 662085 | 237267 237267 | 31489 | 8 | 0.625 |
| 666662 | 666662 | 238630 238630 | 31489 | 2 | 0.130688482038042 |
| 697342 | 697342 | 248625 248625 | 31489 | 12 | 0.636363636363636 |
| 789723 | 789723 | 275811 275811 | 31489 | 8 | 0.625 |
| 789724 | 789724 | 275812 275812 | 31489 | 8 | 0.9 |
| 930738 | 930738 | 331372 331372 | 31489 | 4 | 0.833333333333333 |
| 1723749 | 1723749 | 527887 527887 | 31489 | 4 | 0.833333333333333 |
| 1741485 | 1741485 | 533356 533356 | 31489 | 1 | 0.150741041020006 |
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)
);