consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
24 rows where inventory_id = 423461
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1288991 | 1288991 | 423461 423461 | 11206 | 1 | 0.0125146388963393 |
| 1288992 | 1288992 | 423461 423461 | 27582 | 10 | 0.217892518813115 |
| 1288993 | 1288993 | 423461 423461 | 44780 | 1 | 0.0417154629877976 |
| 1288994 | 1288994 | 423461 423461 | 51571 | 1 | 0.0500585555853571 |
| 1288995 | 1288995 | 423461 423461 | 54871 | 1 | 0.0500585555853571 |
| 1288996 | 1288996 | 423461 423461 | 55090 | 1 | 0.0417154629877976 |
| 1288997 | 1288997 | 423461 423461 | 79969 | 1 | 0.017878055566199 |
| 1288998 | 1288998 | 423461 423461 | 103730 | 1 | 0.0834309259755952 |
| 1288999 | 1288999 | 423461 423461 | 106090 | 1 | 0.0357561111323979 |
| 1289000 | 1289000 | 423461 423461 | 107261 | 1 | 0.016686185195119 |
| 1289001 | 1289001 | 423461 423461 | 122318 | 1 | 0.0227538889024351 |
| 1289002 | 1289002 | 423461 423461 | 124647 | 1 | 0.0278103086585317 |
| 1289003 | 1289003 | 423461 423461 | 136317 | 1 | 0.0131733041014098 |
| 1289004 | 1289004 | 423461 423461 | 139148 | 1 | 0.0834309259755952 |
| 1289005 | 1289005 | 423461 423461 | 169484 | 1 | 0.0625731944816964 |
| 1289006 | 1289006 | 423461 423461 | 169851 | 1 | 0.0312865972408482 |
| 1289007 | 1289007 | 423461 423461 | 170929 | 1 | 0.0119187037107993 |
| 1289008 | 1289008 | 423461 423461 | 184397 | 1 | 0.0192532906097527 |
| 1289009 | 1289009 | 423461 423461 | 194422 | 1 | 0.0250292777926786 |
| 1289010 | 1289010 | 423461 423461 | 205106 | 1 | 0.0208577314938988 |
| 1289011 | 1289011 | 423461 423461 | 205254 | 1 | 0.0147231045839286 |
| 1289012 | 1289012 | 423461 423461 | 207810 | 1 | 0.0156432986204241 |
| 1289013 | 1289013 | 423461 423461 | 215818 | 1 | 0.0139051543292659 |
| 1289014 | 1289014 | 423461 423461 | 223503 | 1 | 0.0625731944816964 |
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)
);