consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
22 rows where inventory_id = 77118
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 223231 | 223231 | 77118 77118 | 2662 | 1 | 0.0447529824424275 |
| 223232 | 223232 | 77118 77118 | 3331 | 1 | 0.0134258947327282 |
| 223233 | 223233 | 77118 77118 | 3489 | 1 | 0.0335647368318206 |
| 223234 | 223234 | 77118 77118 | 3709 | 1 | 0.089505964884855 |
| 223235 | 223235 | 77118 77118 | 3728 | 1 | 0.0383596992363664 |
| 223236 | 223236 | 77118 77118 | 4045 | 8 | 0.268517894654565 |
| 223237 | 223237 | 77118 77118 | 4103 | 1 | 0.053703578930913 |
| 223238 | 223238 | 77118 77118 | 6183 | 1 | 0.0122053588479348 |
| 223239 | 223239 | 77118 77118 | 7017 | 1 | 0.134258947327282 |
| 223240 | 223240 | 77118 77118 | 11441 | 1 | 0.0671294736636412 |
| 223241 | 223241 | 77118 77118 | 20697 | 1 | 0.029835321628285 |
| 223242 | 223242 | 77118 77118 | 73287 | 1 | 0.0127865664121221 |
| 223243 | 223243 | 77118 77118 | 179751 | 1 | 0.0141325207712929 |
| 223244 | 223244 | 77118 77118 | 187187 | 1 | 0.0244107176958695 |
| 223245 | 223245 | 77118 77118 | 222032 | 1 | 0.0191798496181832 |
| 223246 | 223246 | 77118 77118 | 232485 | 1 | 0.0268517894654565 |
| 223247 | 223247 | 77118 77118 | 261389 | 1 | 0.0206552226657358 |
| 223248 | 223248 | 77118 77118 | 261390 | 1 | 0.0223764912212137 |
| 223249 | 223249 | 77118 77118 | 291790 | 1 | 0.0157951702737979 |
| 223250 | 223250 | 77118 77118 | 323543 | 1 | 0.0149176608141425 |
| 223251 | 223251 | 77118 77118 | 326803 | 1 | 0.017901192976971 |
| 223252 | 223252 | 77118 77118 | 326829 | 1 | 0.0167823684159103 |
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)
);