consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inchi_id = 147017
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 14189 | 14189 | 4366 4366 | 147017 | 1 | 0.192307692307692 |
| 60053 | 60053 | 19072 19072 | 147017 | 1 | 0.192307692307692 |
| 116820 | 116820 | 40747 40747 | 147017 | 1 | 0.192307692307692 |
| 170591 | 170591 | 60838 60838 | 147017 | 1 | 0.1875 |
| 187513 | 187513 | 66777 66777 | 147017 | 1 | 0.174457630187009 |
| 348589 | 348589 | 117761 117761 | 147017 | 4 | 0.231829390334425 |
| 349766 | 349766 | 118168 118168 | 147017 | 1 | 0.191489361702128 |
| 481289 | 481289 | 176551 176551 | 147017 | 4 | 0.23956442831216 |
| 481703 | 481703 | 176802 176802 | 147017 | 1 | 0.189189189189189 |
| 529360 | 529360 | 210178 210178 | 147017 | 1 | 0.1875 |
| 562535 | 562535 | 221157 221157 | 147017 | 1 | 0.189189189189189 |
| 701050 | 701050 | 249731 249731 | 147017 | 1 | 0.192307692307692 |
| 796024 | 796024 | 277761 277761 | 147017 | 1 | 0.1875 |
| 796027 | 796027 | 277762 277762 | 147017 | 1 | 0.192307692307692 |
| 880921 | 880921 | 306033 306033 | 147017 | 1 | 0.1875 |
| 1678204 | 1678204 | 509650 509650 | 147017 | 1 | 0.192307692307692 |
| 1754003 | 1754003 | 537420 537420 | 147017 | 1 | 0.192307692307692 |
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)
);