consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
23 rows where inchi_id = 47791
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 20341 | 20341 | 5971 5971 | 47791 | 8 | 0.9 |
| 173297 | 173297 | 61908 61908 | 47791 | 1 | 0.146008145925299 |
| 173356 | 173356 | 61933 61933 | 47791 | 8 | 0.9 |
| 237419 | 237419 | 80830 80830 | 47791 | 1 | 0.239130434782609 |
| 237514 | 237514 | 80848 80848 | 47791 | 8 | 0.625 |
| 338523 | 338523 | 114147 114147 | 47791 | 1 | 0.144045527299549 |
| 437601 | 437601 | 156878 156878 | 47791 | 1 | 0.239130434782609 |
| 437635 | 437635 | 156885 156885 | 47791 | 8 | 0.625 |
| 477413 | 477413 | 174115 174115 | 47791 | 1 | 0.307692307692308 |
| 521316 | 521316 | 208053 208053 | 47791 | 8 | 0.625 |
| 556502 | 556502 | 219260 219260 | 47791 | 8 | 0.625 |
| 708844 | 708844 | 251610 251610 | 47791 | 8 | 0.9 |
| 807340 | 807340 | 281131 281131 | 47791 | 8 | 0.9 |
| 1060406 | 1060406 | 374539 374539 | 47791 | 8 | 0.9 |
| 1060407 | 1060407 | 374540 374540 | 47791 | 8 | 0.9 |
| 1284541 | 1284541 | 422279 422279 | 47791 | 8 | 0.9 |
| 1284542 | 1284542 | 422280 422280 | 47791 | 8 | 0.9 |
| 1284543 | 1284543 | 422281 422281 | 47791 | 8 | 0.9 |
| 1284544 | 1284544 | 422282 422282 | 47791 | 8 | 0.9 |
| 1499695 | 1499695 | 463929 463929 | 47791 | 8 | 0.9 |
| 1499696 | 1499696 | 463930 463930 | 47791 | 8 | 0.9 |
| 1600338 | 1600338 | 483440 483440 | 47791 | 8 | 0.9 |
| 1624787 | 1624787 | 490623 490623 | 47791 | 8 | 0.9 |
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)
);