consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 123778
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 38224 | 38224 | 11496 11496 | 123778 | 6 | 0.22104970988403 |
| 123972 | 123972 | 43008 43008 | 123778 | 2 | 0.211941515275257 |
| 123977 | 123977 | 43009 43009 | 123778 | 7 | 0.26008532842575 |
| 183109 | 183109 | 65441 65441 | 123778 | 10 | 0.265221767278346 |
| 267526 | 267526 | 90679 90679 | 123778 | 2 | 0.212896528509838 |
| 273615 | 273615 | 92804 92804 | 123778 | 7 | 0.269933329104663 |
| 451918 | 451918 | 162190 162190 | 123778 | 4 | 0.226472944255234 |
| 563172 | 563172 | 221337 221337 | 123778 | 5 | 0.245704621173636 |
| 700363 | 700363 | 249528 249528 | 123778 | 7 | 0.258024763853849 |
| 784418 | 784418 | 274201 274201 | 123778 | 1 | 0.265578407420956 |
| 784422 | 784422 | 274202 274202 | 123778 | 2 | 0.212896528509838 |
| 794988 | 794988 | 277438 277438 | 123778 | 7 | 0.258024763853849 |
| 794996 | 794996 | 277439 277439 | 123778 | 7 | 0.258024763853849 |
| 958349 | 958349 | 344716 344716 | 123778 | 4 | 0.226472944255234 |
| 1053148 | 1053148 | 372331 372331 | 123778 | 7 | 0.258024763853849 |
| 1275681 | 1275681 | 419598 419598 | 123778 | 7 | 0.258024763853849 |
| 1494091 | 1494091 | 462227 462227 | 123778 | 7 | 0.258024763853849 |
| 1598863 | 1598863 | 482935 482935 | 123778 | 7 | 0.258024763853849 |
| 1639690 | 1639690 | 496015 496015 | 123778 | 2 | 0.212896528509838 |
| 1642708 | 1642708 | 497135 497135 | 123778 | 7 | 0.258024763853849 |
| 1734778 | 1734778 | 531392 531392 | 123778 | 6 | 0.22104970988403 |
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)
);