consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
16 rows where inchi_id = 2023
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 14690 | 14690 | 4540 4540 | 2023 | 8 | 0.42368278109723 |
| 48474 | 48474 | 14908 14908 | 2023 | 8 | 0.42368278109723 |
| 181236 | 181236 | 64747 64747 | 2023 | 5 | 0.225216750388142 |
| 213870 | 213870 | 74401 74401 | 2023 | 1 | 0.135594215259183 |
| 513517 | 513517 | 206167 206167 | 2023 | 1 | 0.135594215259183 |
| 540368 | 540368 | 214124 214124 | 2023 | 1 | 0.135594215259183 |
| 594059 | 594059 | 231479 231479 | 2023 | 8 | 0.42368278109723 |
| 671355 | 671355 | 240304 240304 | 2023 | 8 | 0.42368278109723 |
| 727143 | 727143 | 256763 256763 | 2023 | 1 | 0.136475418941735 |
| 741964 | 741964 | 261339 261339 | 2023 | 8 | 0.42368278109723 |
| 741969 | 741969 | 261340 261340 | 2023 | 4 | 0.417633410672854 |
| 974855 | 974855 | 353093 353093 | 2023 | 8 | 0.42368278109723 |
| 1185054 | 1185054 | 397144 397144 | 2023 | 8 | 0.42368278109723 |
| 1438269 | 1438269 | 448167 448167 | 2023 | 8 | 0.42368278109723 |
| 1590036 | 1590036 | 479974 479974 | 2023 | 8 | 0.42368278109723 |
| 1716663 | 1716663 | 525730 525730 | 2023 | 1 | 0.236842105263158 |
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)
);