consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inventory_id = 32
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 124 | 124 | 32 32 | 15740 | 1 | 0.0458700369642147 |
| 125 | 125 | 32 32 | 52262 | 1 | 0.021170786291176 |
| 126 | 126 | 32 32 | 65005 | 1 | 0.0172012638615805 |
| 127 | 127 | 32 32 | 66167 | 1 | 0.0161894248108993 |
| 128 | 128 | 32 32 | 67204 | 1 | 0.0152900123214049 |
| 129 | 129 | 32 32 | 74053 | 8 | 0.275220221785288 |
| 130 | 130 | 32 32 | 80608 | 1 | 0.0144852748308046 |
| 131 | 131 | 32 32 | 88275 | 1 | 0.0137610110892644 |
| 132 | 132 | 32 32 | 149161 | 1 | 0.0550440443570577 |
| 133 | 133 | 32 32 | 187800 | 1 | 0.0229350184821074 |
| 134 | 134 | 32 32 | 187958 | 1 | 0.034402527723161 |
| 135 | 135 | 32 32 | 192227 | 1 | 0.0196585872703777 |
| 136 | 136 | 32 32 | 203379 | 1 | 0.137610110892644 |
| 137 | 137 | 32 32 | 208033 | 1 | 0.0688050554463221 |
| 138 | 138 | 32 32 | 208110 | 1 | 0.0917400739284294 |
| 139 | 139 | 32 32 | 210249 | 1 | 0.0275220221785288 |
| 140 | 140 | 32 32 | 211245 | 1 | 0.0183480147856859 |
| 141 | 141 | 32 32 | 215453 | 1 | 0.0305800246428098 |
| 142 | 142 | 32 32 | 244357 | 1 | 0.0393171745407555 |
| 143 | 143 | 32 32 | 272877 | 1 | 0.0250200201622989 |
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)
);