consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inventory_id = 87116
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 257280 | 257280 | 87116 87116 | 11858 | 8 | 0.255252329149342 |
| 257281 | 257281 | 87116 87116 | 47316 | 4 | 0.044840700540085 |
| 257282 | 257282 | 87116 87116 | 108509 | 2 | 0.0380507706262053 |
| 257283 | 257283 | 87116 87116 | 137097 | 4 | 0.127626164574671 |
| 257284 | 257284 | 87116 87116 | 144687 | 2 | 0.0213452720786837 |
| 257285 | 257285 | 87116 87116 | 169284 | 4 | 0.0850841097164473 |
| 257286 | 257286 | 87116 87116 | 174079 | 2 | 0.0260515817530345 |
| 257287 | 257287 | 87116 87116 | 181335 | 2 | 0.0269059579391637 |
| 257288 | 257288 | 87116 87116 | 184244 | 1 | 0.0141806849527412 |
| 257289 | 257289 | 87116 87116 | 192358 | 2 | 0.036464618449906 |
| 257290 | 257290 | 87116 87116 | 196020 | 3 | 0.0557458620808262 |
| 257291 | 257291 | 87116 87116 | 196023 | 4 | 0.0360262931392911 |
| 257292 | 257292 | 87116 87116 | 208046 | 3 | 0.0420294500693776 |
| 257293 | 257293 | 87116 87116 | 217187 | 2 | 0.02433735466617 |
| 257294 | 257294 | 87116 87116 | 251382 | 1 | 0.0319065411436677 |
| 257295 | 257295 | 87116 87116 | 266547 | 2 | 0.0245616668242752 |
| 257296 | 257296 | 87116 87116 | 288013 | 2 | 0.015984520886938 |
| 257297 | 257297 | 87116 87116 | 288128 | 2 | 0.021887706651721 |
| 257298 | 257298 | 87116 87116 | 298060 | 2 | 0.0319065411436677 |
| 257299 | 257299 | 87116 87116 | 309732 | 2 | 0.0182789989537053 |
| 257300 | 257300 | 87116 87116 | 310008 | 2 | 0.017054763622373 |
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)
);