consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
16 rows where inchi_id = 85195
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 79441 | 79441 | 28664 28664 | 85195 | 6 | 0.315789473684211 |
| 148174 | 148174 | 53290 53290 | 85195 | 2 | 0.630993034743972 |
| 193570 | 193570 | 68808 68808 | 85195 | 1 | 0.317073170731707 |
| 217906 | 217906 | 75575 75575 | 85195 | 6 | 0.249745158554402 |
| 427585 | 427585 | 154158 154158 | 85195 | 5 | 0.260304909858814 |
| 533147 | 533147 | 211489 211489 | 85195 | 6 | 0.315789473684211 |
| 580176 | 580176 | 227035 227035 | 85195 | 1 | 0.315789473684211 |
| 734974 | 734974 | 259270 259270 | 85195 | 9 | 0.250527258177098 |
| 765303 | 765303 | 268132 268132 | 85195 | 1 | 0.310344827586207 |
| 856430 | 856430 | 296272 296272 | 85195 | 6 | 0.315789473684211 |
| 856435 | 856435 | 296273 296273 | 85195 | 6 | 0.315789473684211 |
| 856441 | 856441 | 296274 296274 | 85195 | 6 | 0.249745158554402 |
| 856448 | 856448 | 296275 296275 | 85195 | 3 | 0.31304347826087 |
| 960776 | 960776 | 345765 345765 | 85195 | 3 | 0.311688311688312 |
| 1613107 | 1613107 | 487019 487019 | 85195 | 6 | 0.315789473684211 |
| 1718146 | 1718146 | 526203 526203 | 85195 | 6 | 0.315789473684211 |
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)
);