consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
17 rows where inchi_id = 456
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 47608 | 47608 | 14653 14653 | 456 | 9 | 0.468500230127396 |
| 120976 | 120976 | 42058 42058 | 456 | 9 | 0.468500230127396 |
| 174705 | 174705 | 62404 62404 | 456 | 4 | 0.429562869784401 |
| 300371 | 300371 | 101706 101706 | 456 | 8 | 0.390019756252689 |
| 309460 | 309460 | 104540 104540 | 456 | 1 | 0.191995986290638 |
| 461948 | 461948 | 165964 165964 | 456 | 8 | 0.390019756252689 |
| 465251 | 465251 | 167963 167963 | 456 | 7 | 0.6785179801036 |
| 466481 | 466481 | 168483 168483 | 456 | 1 | 0.191995986290638 |
| 582502 | 582502 | 227755 227755 | 456 | 1 | 0.191995986290638 |
| 595854 | 595854 | 232022 232022 | 456 | 8 | 0.390019756252689 |
| 669444 | 669444 | 239783 239783 | 456 | 9 | 0.468500230127396 |
| 685651 | 685651 | 244545 244545 | 456 | 3 | 0.291077036889524 |
| 934035 | 934035 | 332880 332880 | 456 | 4 | 0.429562869784401 |
| 950227 | 950227 | 340849 340849 | 456 | 2 | 0.196824938177046 |
| 950240 | 950240 | 340855 340855 | 456 | 1 | 0.101632929513084 |
| 1654717 | 1654717 | 501374 501374 | 456 | 9 | 0.468500230127396 |
| 1742143 | 1742143 | 533616 533616 | 456 | 9 | 0.410738213162092 |
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)
);