consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
14 rows where inventory_id = 204342
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 510010 | 510010 | 204342 204342 | 4370 | 3 | 0.109343045742926 |
| 510011 | 510011 | 204342 204342 | 92326 | 6 | 0.18272308847525 |
| 510012 | 510012 | 204342 204342 | 128324 | 3 | 0.209165721820951 |
| 510013 | 510013 | 204342 204342 | 248614 | 1 | 0.032941536979834 |
| 510014 | 510014 | 204342 204342 | 248930 | 1 | 0.0527064591677343 |
| 510015 | 510015 | 204342 204342 | 259587 | 2 | 0.0445450882172855 |
| 510016 | 510016 | 204342 204342 | 264787 | 1 | 0.0202717150645132 |
| 510017 | 510017 | 204342 204342 | 274614 | 1 | 0.0263532295838672 |
| 510018 | 510018 | 204342 204342 | 289350 | 1 | 0.0439220493064453 |
| 510019 | 510019 | 204342 204342 | 291463 | 4 | 0.119064155267863 |
| 510020 | 510020 | 204342 204342 | 292764 | 2 | 0.0658830739596679 |
| 510021 | 510021 | 204342 204342 | 309451 | 1 | 0.0239574814398792 |
| 510022 | 510022 | 204342 204342 | 310068 | 2 | 0.0310575789081974 |
| 510023 | 510023 | 204342 204342 | 320993 | 1 | 0.0292813662042968 |
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)
);