consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 69708
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 196425 | 196425 | 69708 69708 | 4642 | 4 | 0.167391043560902 |
| 196426 | 196426 | 69708 69708 | 8150 | 1 | 0.0139492536300752 |
| 196427 | 196427 | 69708 69708 | 45278 | 1 | 0.0167391043560902 |
| 196428 | 196428 | 69708 69708 | 127988 | 1 | 0.0185990048401002 |
| 196429 | 196429 | 69708 69708 | 135265 | 6 | 0.167391043560902 |
| 196430 | 196430 | 69708 69708 | 160363 | 1 | 0.023913006222986 |
| 196431 | 196431 | 69708 69708 | 178931 | 1 | 0.0209238804451127 |
| 196432 | 196432 | 69708 69708 | 182665 | 1 | 0.0278985072601503 |
| 196433 | 196433 | 69708 69708 | 182666 | 1 | 0.0418477608902255 |
| 196434 | 196434 | 69708 69708 | 183864 | 1 | 0.0128762341200694 |
| 196435 | 196435 | 69708 69708 | 185673 | 1 | 0.083695521780451 |
| 196436 | 196436 | 69708 69708 | 190318 | 1 | 0.167391043560902 |
| 196437 | 196437 | 69708 69708 | 192104 | 1 | 0.083695521780451 |
| 196438 | 196438 | 69708 69708 | 205015 | 1 | 0.0104619402225564 |
| 196439 | 196439 | 69708 69708 | 206188 | 1 | 0.0098465319741707 |
| 196440 | 196440 | 69708 69708 | 218600 | 1 | 0.0111594029040601 |
| 196441 | 196441 | 69708 69708 | 233551 | 1 | 0.0557970145203006 |
| 196442 | 196442 | 69708 69708 | 253834 | 1 | 0.0334782087121804 |
| 196443 | 196443 | 69708 69708 | 262180 | 1 | 0.011956503111493 |
| 196444 | 196444 | 69708 69708 | 293174 | 1 | 0.0152173675964456 |
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)
);