consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
16 rows where inchi_id = 54042
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 28438 | 28438 | 8248 8248 | 54042 | 2 | 0.154696132596685 |
| 106464 | 106464 | 37499 37499 | 54042 | 1 | 0.173228346456693 |
| 188103 | 188103 | 66963 66963 | 54042 | 2 | 0.154696132596685 |
| 235676 | 235676 | 80367 80367 | 54042 | 1 | 0.133333333333333 |
| 236293 | 236293 | 80562 80562 | 54042 | 2 | 0.154696132596685 |
| 241015 | 241015 | 81915 81915 | 54042 | 8 | 0.9 |
| 436994 | 436994 | 156708 156708 | 54042 | 1 | 0.133333333333333 |
| 437292 | 437292 | 156804 156804 | 54042 | 2 | 0.154696132596685 |
| 551487 | 551487 | 217920 217920 | 54042 | 8 | 0.9 |
| 558002 | 558002 | 219707 219707 | 54042 | 2 | 0.154696132596685 |
| 707061 | 707061 | 251209 251209 | 54042 | 2 | 0.155844155844156 |
| 714570 | 714570 | 252931 252931 | 54042 | 12 | 0.928571428571429 |
| 804362 | 804362 | 280382 280382 | 54042 | 2 | 0.154696132596685 |
| 804365 | 804365 | 280383 280383 | 54042 | 1 | 0.173228346456693 |
| 1624310 | 1624310 | 490503 490503 | 54042 | 1 | 0.173228346456693 |
| 1725154 | 1725154 | 528257 528257 | 54042 | 1 | 0.168674698795181 |
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)
);