consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inventory_id = 388005
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1147992 | 1147992 | 388005 388005 | 274 | 1 | 0.0229601425377309 |
| 1147993 | 1147993 | 388005 388005 | 7710 | 2 | 0.0459202850754619 |
| 1147994 | 1147994 | 388005 388005 | 12920 | 1 | 0.0918405701509237 |
| 1147995 | 1147995 | 388005 388005 | 75177 | 10 | 0.230324799016563 |
| 1147996 | 1147996 | 388005 388005 | 75665 | 1 | 0.0162071594383983 |
| 1147997 | 1147997 | 388005 388005 | 77231 | 2 | 0.0371513398585791 |
| 1147998 | 1147998 | 388005 388005 | 123602 | 1 | 0.0551043420905542 |
| 1147999 | 1147999 | 388005 388005 | 139279 | 1 | 0.0275521710452771 |
| 1148000 | 1148000 | 388005 388005 | 140716 | 1 | 0.0183681140301847 |
| 1148001 | 1148001 | 388005 388005 | 168956 | 1 | 0.0153067616918206 |
| 1148002 | 1148002 | 388005 388005 | 186046 | 1 | 0.0688804276131928 |
| 1148003 | 1148003 | 388005 388005 | 188379 | 1 | 0.0459202850754619 |
| 1148004 | 1148004 | 388005 388005 | 188380 | 1 | 0.0393602443503959 |
| 1148005 | 1148005 | 388005 388005 | 192032 | 1 | 0.0196801221751979 |
| 1148006 | 1148006 | 388005 388005 | 233012 | 1 | 0.0172201069032982 |
| 1148007 | 1148007 | 388005 388005 | 240462 | 1 | 0.137760855226386 |
| 1148008 | 1148008 | 388005 388005 | 241343 | 1 | 0.0211939777271362 |
| 1148009 | 1148009 | 388005 388005 | 261752 | 1 | 0.0459202850754619 |
| 1148010 | 1148010 | 388005 388005 | 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)
);