consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 20854
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 14304 | 14304 | 4406 4406 | 20854 | 1 | 0.115384615384615 |
| 65203 | 65203 | 21345 21345 | 20854 | 1 | 0.115384615384615 |
| 141483 | 141483 | 50445 50445 | 20854 | 1 | 0.116504854368932 |
| 206827 | 206827 | 73307 73307 | 20854 | 1 | 0.113207547169811 |
| 262263 | 262263 | 88833 88833 | 20854 | 7 | 0.517241379310345 |
| 374088 | 374088 | 127549 127549 | 20854 | 1 | 0.114503816793893 |
| 529869 | 529869 | 210312 210312 | 20854 | 1 | 0.114503816793893 |
| 529873 | 529873 | 210313 210313 | 20854 | 1 | 0.114503816793893 |
| 547377 | 547377 | 216498 216498 | 20854 | 1 | 0.115384615384615 |
| 664155 | 664155 | 237985 237985 | 20854 | 1 | 0.114503816793893 |
| 690835 | 690835 | 246447 246447 | 20854 | 8 | 0.413793103448276 |
| 719642 | 719642 | 254404 254404 | 20854 | 1 | 0.115384615384615 |
| 776880 | 776880 | 271700 271700 | 20854 | 8 | 0.413793103448276 |
| 776884 | 776884 | 271701 271701 | 20854 | 7 | 0.517241379310345 |
| 824815 | 824815 | 286229 286229 | 20854 | 1 | 0.115384615384615 |
| 824819 | 824819 | 286230 286230 | 20854 | 1 | 0.115384615384615 |
| 902655 | 902655 | 318024 318024 | 20854 | 1 | 0.113207547169811 |
| 1637281 | 1637281 | 495104 495104 | 20854 | 8 | 0.413793103448276 |
| 1689968 | 1689968 | 514369 514369 | 20854 | 1 | 0.115384615384615 |
| 1757935 | 1757935 | 539082 539082 | 20854 | 1 | 0.115384615384615 |
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)
);