consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 42970
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 16759 | 16759 | 4920 4920 | 42970 | 1 | 0.179053683786617 |
| 27717 | 27717 | 8048 8048 | 42970 | 4 | 0.282313866592859 |
| 196288 | 196288 | 69637 69637 | 42970 | 1 | 0.179053683786617 |
| 213417 | 213417 | 74324 74324 | 42970 | 1 | 0.179053683786617 |
| 233622 | 233622 | 79840 79840 | 42970 | 3 | 0.184390369584357 |
| 424541 | 424541 | 153338 153338 | 42970 | 1 | 0.179053683786617 |
| 436415 | 436415 | 156573 156573 | 42970 | 3 | 0.184390369584357 |
| 541836 | 541836 | 214524 214524 | 42970 | 2 | 0.230137326977483 |
| 703946 | 703946 | 250658 250658 | 42970 | 4 | 0.234480115722379 |
| 725546 | 725546 | 256341 256341 | 42970 | 1 | 0.179053683786617 |
| 801009 | 801009 | 279426 279426 | 42970 | 4 | 0.234480115722379 |
| 801018 | 801018 | 279427 279427 | 42970 | 4 | 0.271800679501699 |
| 837437 | 837437 | 290544 290544 | 42970 | 2 | 0.234424142563167 |
| 837454 | 837454 | 290546 290546 | 42970 | 1 | 0.179053683786617 |
| 915285 | 915285 | 324239 324239 | 42970 | 2 | 0.294599018003273 |
| 1610169 | 1610169 | 486060 486060 | 42970 | 1 | 0.179053683786617 |
| 1623201 | 1623201 | 490160 490160 | 42970 | 4 | 0.234480115722379 |
| 1716504 | 1716504 | 525668 525668 | 42970 | 1 | 0.179053683786617 |
| 1724457 | 1724457 | 528066 528066 | 42970 | 4 | 0.282313866592859 |
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)
);