consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
15 rows where inventory_id = 418099
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 1270230 | 1270230 | 418099 418099 | 30575 | 8 | 0.270162403645047 |
| 1270231 | 1270231 | 418099 418099 | 46499 | 2 | 0.110293339435698 |
| 1270232 | 1270232 | 418099 418099 | 63043 | 1 | 0.135081201822523 |
| 1270233 | 1270233 | 418099 418099 | 120237 | 1 | 0.0192973145460748 |
| 1270234 | 1270234 | 418099 418099 | 139934 | 1 | 0.0900541345483488 |
| 1270235 | 1270235 | 418099 418099 | 216509 | 1 | 0.0540324807290093 |
| 1270236 | 1270236 | 418099 418099 | 256376 | 1 | 0.0385946290921495 |
| 1270237 | 1270237 | 418099 418099 | 256829 | 1 | 0.0675406009112616 |
| 1270238 | 1270238 | 418099 418099 | 274146 | 1 | 0.0270162403645047 |
| 1270239 | 1270239 | 418099 418099 | 274224 | 1 | 0.0450270672741744 |
| 1270240 | 1270240 | 418099 418099 | 274347 | 1 | 0.0300180448494496 |
| 1270241 | 1270241 | 418099 418099 | 288980 | 1 | 0.0245602185131861 |
| 1270242 | 1270242 | 418099 418099 | 289755 | 1 | 0.0225135336370872 |
| 1270243 | 1270243 | 418099 418099 | 322818 | 1 | 0.0337703004556308 |
| 1270244 | 1270244 | 418099 418099 | 322830 | 1 | 0.0207817233573113 |
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)
);