consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 24942
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 10383 | 10383 | 3164 3164 | 24942 | 7 | 0.620689655172414 |
| 103780 | 103780 | 36614 36614 | 24942 | 8 | 0.625 |
| 156108 | 156108 | 56134 56134 | 24942 | 7 | 0.620689655172414 |
| 184605 | 184605 | 65920 65920 | 24942 | 1 | 0.3125 |
| 198546 | 198546 | 70592 70592 | 24942 | 4 | 0.6 |
| 332652 | 332652 | 112124 112124 | 24942 | 7 | 0.620689655172414 |
| 332654 | 332654 | 112125 112125 | 24942 | 1 | 0.3125 |
| 528676 | 528676 | 210002 210002 | 24942 | 7 | 0.620689655172414 |
| 528678 | 528678 | 210003 210003 | 24942 | 4 | 0.6 |
| 570443 | 570443 | 223644 223644 | 24942 | 1 | 0.3125 |
| 570445 | 570445 | 223645 223645 | 24942 | 5 | 0.608695652173913 |
| 693147 | 693147 | 247269 247269 | 24942 | 12 | 0.636363636363636 |
| 693149 | 693149 | 247270 247270 | 24942 | 1 | 0.317073170731707 |
| 780442 | 780442 | 272908 272908 | 24942 | 5 | 0.608695652173913 |
| 780444 | 780444 | 272909 272909 | 24942 | 8 | 0.625 |
| 780446 | 780446 | 272910 272910 | 24942 | 5 | 0.608695652173913 |
| 939326 | 939326 | 335702 335702 | 24942 | 4 | 0.6 |
| 1750142 | 1750142 | 536087 536087 | 24942 | 8 | 0.625 |
| 1766782 | 1766782 | 543986 543986 | 24942 | 1 | 0.114503816793893 |
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)
);