consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 287178
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 827571 | 827571 | 287178 287178 | 8150 | 1 | 0.0139282808911841 |
| 827572 | 827572 | 287178 287178 | 45278 | 1 | 0.016713937069421 |
| 827573 | 827573 | 287178 287178 | 63494 | 3 | 0.16713937069421 |
| 827574 | 827574 | 287178 287178 | 107914 | 1 | 0.16713937069421 |
| 827575 | 827575 | 287178 287178 | 127988 | 1 | 0.0185710411882455 |
| 827576 | 827576 | 287178 287178 | 160363 | 1 | 0.0238770529563157 |
| 827577 | 827577 | 287178 287178 | 178931 | 1 | 0.0208924213367762 |
| 827578 | 827578 | 287178 287178 | 182665 | 1 | 0.0278565617823683 |
| 827579 | 827579 | 287178 287178 | 182666 | 1 | 0.0417848426735524 |
| 827580 | 827580 | 287178 287178 | 183864 | 1 | 0.0128568746687854 |
| 827581 | 827581 | 287178 287178 | 190318 | 1 | 0.16713937069421 |
| 827582 | 827582 | 287178 287178 | 192104 | 1 | 0.0835696853471049 |
| 827583 | 827583 | 287178 287178 | 193158 | 1 | 0.0835696853471049 |
| 827584 | 827584 | 287178 287178 | 205015 | 1 | 0.0104462106683881 |
| 827585 | 827585 | 287178 287178 | 206188 | 1 | 0.00983172768789469 |
| 827586 | 827586 | 287178 287178 | 218600 | 1 | 0.0111426247129473 |
| 827587 | 827587 | 287178 287178 | 233551 | 1 | 0.0557131235647366 |
| 827588 | 827588 | 287178 287178 | 253834 | 1 | 0.0334278741388419 |
| 827589 | 827589 | 287178 287178 | 262180 | 1 | 0.0119385264781578 |
| 827590 | 827590 | 287178 287178 | 293174 | 1 | 0.0151944882449282 |
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)
);