consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 78624
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 229120 | 229120 | 78624 78624 | 4140 | 1 | 0.0268510082007535 |
| 229121 | 229121 | 78624 78624 | 12457 | 8 | 0.241659073806782 |
| 229122 | 229122 | 78624 78624 | 113747 | 1 | 0.0604147684516955 |
| 229123 | 229123 | 78624 78624 | 136495 | 2 | 0.120829536903391 |
| 229124 | 229124 | 78624 78624 | 136496 | 1 | 0.0185891595235986 |
| 229125 | 229125 | 78624 78624 | 154890 | 1 | 0.0483318147613564 |
| 229126 | 229126 | 78624 78624 | 176822 | 2 | 0.0420674451087096 |
| 229127 | 229127 | 78624 78624 | 177304 | 1 | 0.0241659073806782 |
| 229128 | 229128 | 78624 78624 | 195194 | 1 | 0.0402765123011303 |
| 229129 | 229129 | 78624 78624 | 197877 | 1 | 0.0345227248295403 |
| 229130 | 229130 | 78624 78624 | 197878 | 1 | 0.0302073842258477 |
| 229131 | 229131 | 78624 78624 | 197941 | 1 | 0.0268510082007535 |
| 229132 | 229132 | 78624 78624 | 226902 | 2 | 0.0275396073577231 |
| 229133 | 229133 | 78624 78624 | 238468 | 1 | 0.0172613624147701 |
| 229134 | 229134 | 78624 78624 | 238742 | 1 | 0.0201382561505652 |
| 229135 | 229135 | 78624 78624 | 243132 | 1 | 0.0302073842258477 |
| 229136 | 229136 | 78624 78624 | 265389 | 1 | 0.0241659073806782 |
| 229137 | 229137 | 78624 78624 | 266775 | 1 | 0.0402765123011303 |
| 229138 | 229138 | 78624 78624 | 266776 | 2 | 0.0697609656572306 |
| 229139 | 229139 | 78624 78624 | 343994 | 1 | 0.0483318147613564 |
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)
);