consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
16 rows where inventory_id = 5231
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 17871 | 17871 | 5231 5231 | 77512 | 7 | 0.29233534781019 |
| 17872 | 17872 | 5231 5231 | 136304 | 3 | 0.146167673905095 |
| 17873 | 17873 | 5231 5231 | 137695 | 1 | 0.0974451159367301 |
| 17874 | 17874 | 5231 5231 | 158886 | 1 | 0.0584670695620381 |
| 17875 | 17875 | 5231 5231 | 160457 | 1 | 0.0224873344469377 |
| 17876 | 17876 | 5231 5231 | 173370 | 1 | 0.0417621925443129 |
| 17877 | 17877 | 5231 5231 | 186066 | 1 | 0.0365419184762738 |
| 17878 | 17878 | 5231 5231 | 188273 | 1 | 0.0487225579683651 |
| 17879 | 17879 | 5231 5231 | 216247 | 1 | 0.0182709592381369 |
| 17880 | 17880 | 5231 5231 | 235151 | 1 | 0.0730838369525476 |
| 17881 | 17881 | 5231 5231 | 240699 | 1 | 0.0324817053122434 |
| 17882 | 17882 | 5231 5231 | 255024 | 1 | 0.029233534781019 |
| 17883 | 17883 | 5231 5231 | 275429 | 1 | 0.0265759407100173 |
| 17884 | 17884 | 5231 5231 | 284912 | 1 | 0.0243612789841825 |
| 17885 | 17885 | 5231 5231 | 320888 | 1 | 0.0208810962721565 |
| 17886 | 17886 | 5231 5231 | 324632 | 1 | 0.019489023187346 |
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)
);