consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inventory_id = 388111
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1150006 | 1150006 | 388111 388111 | 274 | 1 | 0.0229601425377309 |
| 1150007 | 1150007 | 388111 388111 | 7710 | 2 | 0.0459202850754619 |
| 1150008 | 1150008 | 388111 388111 | 12920 | 1 | 0.0918405701509237 |
| 1150009 | 1150009 | 388111 388111 | 75177 | 10 | 0.230324799016563 |
| 1150010 | 1150010 | 388111 388111 | 75665 | 1 | 0.0162071594383983 |
| 1150011 | 1150011 | 388111 388111 | 77231 | 2 | 0.0371513398585791 |
| 1150012 | 1150012 | 388111 388111 | 123602 | 1 | 0.0551043420905542 |
| 1150013 | 1150013 | 388111 388111 | 139279 | 1 | 0.0275521710452771 |
| 1150014 | 1150014 | 388111 388111 | 140716 | 1 | 0.0183681140301847 |
| 1150015 | 1150015 | 388111 388111 | 168956 | 1 | 0.0153067616918206 |
| 1150016 | 1150016 | 388111 388111 | 186046 | 1 | 0.0688804276131928 |
| 1150017 | 1150017 | 388111 388111 | 188379 | 1 | 0.0459202850754619 |
| 1150018 | 1150018 | 388111 388111 | 188380 | 1 | 0.0393602443503959 |
| 1150019 | 1150019 | 388111 388111 | 192032 | 1 | 0.0196801221751979 |
| 1150020 | 1150020 | 388111 388111 | 233012 | 1 | 0.0172201069032982 |
| 1150021 | 1150021 | 388111 388111 | 240462 | 1 | 0.137760855226386 |
| 1150022 | 1150022 | 388111 388111 | 241343 | 1 | 0.0211939777271362 |
| 1150023 | 1150023 | 388111 388111 | 261752 | 1 | 0.0459202850754619 |
| 1150024 | 1150024 | 388111 388111 | 284659 | 1 | 0.0344402138065964 |
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)
);