consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 11972
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 5664 | 5664 | 1720 1720 | 11972 | 8 | 0.625 |
| 9696 | 9696 | 2938 2938 | 11972 | 1 | 0.116288956398103 |
| 26703 | 26703 | 7790 7790 | 11972 | 8 | 0.9 |
| 147749 | 147749 | 53202 53202 | 11972 | 12 | 0.636363636363636 |
| 147754 | 147754 | 53204 53204 | 11972 | 1 | 0.113953469704384 |
| 203110 | 203110 | 71978 71978 | 11972 | 8 | 0.625 |
| 203378 | 203378 | 72061 72061 | 11972 | 1 | 0.116288956398103 |
| 211691 | 211691 | 74113 74113 | 11972 | 1 | 0.116288956398103 |
| 228766 | 228766 | 78584 78584 | 11972 | 8 | 0.625 |
| 511995 | 511995 | 205989 205989 | 11972 | 1 | 0.116288956398103 |
| 512001 | 512001 | 205990 205990 | 11972 | 1 | 0.116288956398103 |
| 520398 | 520398 | 207833 207833 | 11972 | 8 | 0.625 |
| 520400 | 520400 | 207834 207834 | 11972 | 8 | 0.625 |
| 549346 | 549346 | 217137 217137 | 11972 | 1 | 0.116288956398103 |
| 578863 | 578863 | 226697 226697 | 11972 | 8 | 0.625 |
| 684887 | 684887 | 244331 244331 | 11972 | 8 | 0.9 |
| 767587 | 767587 | 268715 268715 | 11972 | 8 | 0.9 |
| 1621333 | 1621333 | 489607 489607 | 11972 | 8 | 0.9 |
| 1723343 | 1723343 | 527777 527777 | 11972 | 4 | 0.833333333333333 |
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)
);