consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 47021
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 132358 | 132358 | 47021 47021 | 10980 | 16 | 0.266683259046865 |
| 132359 | 132359 | 47021 47021 | 41654 | 1 | 0.0533366518093729 |
| 132360 | 132360 | 47021 47021 | 48400 | 1 | 0.133341629523432 |
| 132361 | 132361 | 47021 47021 | 66784 | 1 | 0.0296314732274294 |
| 132362 | 132362 | 47021 47021 | 84329 | 1 | 0.0266683259046865 |
| 132363 | 132363 | 47021 47021 | 173343 | 1 | 0.0148157366137147 |
| 132364 | 132364 | 47021 47021 | 174733 | 1 | 0.0190488042176332 |
| 132365 | 132365 | 47021 47021 | 174884 | 1 | 0.0205140968497588 |
| 132366 | 132366 | 47021 47021 | 174913 | 2 | 0.0666708147617162 |
| 132367 | 132367 | 47021 47021 | 176064 | 1 | 0.0666708147617162 |
| 132368 | 132368 | 47021 47021 | 176469 | 1 | 0.0888944196822882 |
| 132369 | 132369 | 47021 47021 | 176955 | 1 | 0.0242439326406241 |
| 132370 | 132370 | 47021 47021 | 186957 | 1 | 0.0380976084352664 |
| 132371 | 132371 | 47021 47021 | 187035 | 1 | 0.0222236049205721 |
| 132372 | 132372 | 47021 47021 | 187061 | 1 | 0.0177788839364576 |
| 132373 | 132373 | 47021 47021 | 187569 | 1 | 0.0444472098411441 |
| 132374 | 132374 | 47021 47021 | 188036 | 1 | 0.0156872505321685 |
| 132375 | 132375 | 47021 47021 | 188622 | 1 | 0.0133341629523432 |
| 132376 | 132376 | 47021 47021 | 223390 | 1 | 0.016667703690429 |
| 132377 | 132377 | 47021 47021 | 248607 | 1 | 0.0140359610024666 |
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)
);