consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inventory_id = 41789
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 120018 | 120018 | 41789 41789 | 9632 | 1 | 0.0194107741160394 |
| 120019 | 120019 | 41789 41789 | 17929 | 1 | 0.0226459031353793 |
| 120020 | 120020 | 41789 41789 | 19343 | 1 | 0.0452918062707586 |
| 120021 | 120021 | 41789 41789 | 22324 | 1 | 0.0679377094061379 |
| 120022 | 120022 | 41789 41789 | 31086 | 1 | 0.0169844273515345 |
| 120023 | 120023 | 41789 41789 | 35116 | 1 | 0.0905836125415172 |
| 120024 | 120024 | 41789 41789 | 39109 | 1 | 0.0301945375138391 |
| 120025 | 120025 | 41789 41789 | 49848 | 1 | 0.0543501675249103 |
| 120026 | 120026 | 41789 41789 | 50165 | 1 | 0.0181167225083034 |
| 120027 | 120027 | 41789 41789 | 50166 | 1 | 0.0150972687569195 |
| 120028 | 120028 | 41789 41789 | 50742 | 8 | 0.271750837624552 |
| 120029 | 120029 | 41789 41789 | 55080 | 1 | 0.0339688547030689 |
| 120030 | 120030 | 41789 41789 | 55098 | 1 | 0.024704621602232 |
| 120031 | 120031 | 41789 41789 | 73292 | 1 | 0.0388215482320788 |
| 120032 | 120032 | 41789 41789 | 141671 | 1 | 0.020903910586504 |
| 120033 | 120033 | 41789 41789 | 149325 | 1 | 0.0135875418812276 |
| 120034 | 120034 | 41789 41789 | 157383 | 1 | 0.135875418812276 |
| 120035 | 120035 | 41789 41789 | 161775 | 1 | 0.0271750837624552 |
| 120036 | 120036 | 41789 41789 | 167434 | 1 | 0.0159853433896795 |
| 120037 | 120037 | 41789 41789 | 167920 | 1 | 0.0143026756644501 |
| 120038 | 120038 | 41789 41789 | 168292 | 1 | 0.0129405160773596 |
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)
);