consensus_index
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
46 rows where inchi_id = 147865
Download this data as a CSV Spreadsheet (All Rows)
| Link | rowid ▼ | inventory_id | inchi_id | consensus_score | consensus_count |
|---|---|---|---|---|---|
| 20028 | 20028 | 5881 5881 | 147865 | 1 | 0.173228346456693 |
| 116919 | 116919 | 40792 40792 | 147865 | 1 | 0.173228346456693 |
| 144049 | 144049 | 51361 51361 | 147865 | 1 | 0.173228346456693 |
| 218854 | 218854 | 75851 75851 | 147865 | 1 | 0.137931034482759 |
| 428246 | 428246 | 154359 154359 | 147865 | 1 | 0.137931034482759 |
| 515573 | 515573 | 206679 206679 | 147865 | 1 | 0.137931034482759 |
| 515577 | 515577 | 206680 206680 | 147865 | 1 | 0.137931034482759 |
| 531971 | 531971 | 210996 210996 | 147865 | 1 | 0.173228346456693 |
| 667349 | 667349 | 239127 239127 | 147865 | 1 | 0.137931034482759 |
| 736228 | 736228 | 259659 259659 | 147865 | 1 | 0.175 |
| 858535 | 858535 | 296993 296993 | 147865 | 1 | 0.173228346456693 |
| 858538 | 858538 | 296994 296994 | 147865 | 1 | 0.172413793103448 |
| 858541 | 858541 | 296995 296995 | 147865 | 1 | 0.173228346456693 |
| 885173 | 885173 | 308221 308221 | 147865 | 1 | 0.168674698795181 |
| 1175859 | 1175859 | 394543 394543 | 147865 | 1 | 0.173228346456693 |
| 1175862 | 1175862 | 394544 394544 | 147865 | 1 | 0.173228346456693 |
| 1175865 | 1175865 | 394545 394545 | 147865 | 1 | 0.173228346456693 |
| 1175868 | 1175868 | 394546 394546 | 147865 | 1 | 0.173228346456693 |
| 1175871 | 1175871 | 394547 394547 | 147865 | 1 | 0.173228346456693 |
| 1175874 | 1175874 | 394548 394548 | 147865 | 1 | 0.173228346456693 |
| 1175877 | 1175877 | 394549 394549 | 147865 | 1 | 0.173228346456693 |
| 1175880 | 1175880 | 394550 394550 | 147865 | 1 | 0.173228346456693 |
| 1431436 | 1431436 | 446235 446235 | 147865 | 1 | 0.173228346456693 |
| 1431439 | 1431439 | 446236 446236 | 147865 | 1 | 0.173228346456693 |
| 1431442 | 1431442 | 446237 446237 | 147865 | 1 | 0.173228346456693 |
| 1431445 | 1431445 | 446238 446238 | 147865 | 1 | 0.173228346456693 |
| 1431448 | 1431448 | 446239 446239 | 147865 | 1 | 0.173228346456693 |
| 1431451 | 1431451 | 446240 446240 | 147865 | 1 | 0.173228346456693 |
| 1431454 | 1431454 | 446241 446241 | 147865 | 1 | 0.173228346456693 |
| 1431457 | 1431457 | 446242 446242 | 147865 | 1 | 0.173228346456693 |
| 1431460 | 1431460 | 446243 446243 | 147865 | 1 | 0.173228346456693 |
| 1431463 | 1431463 | 446244 446244 | 147865 | 1 | 0.173228346456693 |
| 1431466 | 1431466 | 446245 446245 | 147865 | 1 | 0.173228346456693 |
| 1431469 | 1431469 | 446246 446246 | 147865 | 1 | 0.173228346456693 |
| 1431472 | 1431472 | 446247 446247 | 147865 | 1 | 0.173228346456693 |
| 1588123 | 1588123 | 479370 479370 | 147865 | 1 | 0.173228346456693 |
| 1588126 | 1588126 | 479371 479371 | 147865 | 1 | 0.173228346456693 |
| 1588129 | 1588129 | 479372 479372 | 147865 | 1 | 0.173228346456693 |
| 1588132 | 1588132 | 479373 479373 | 147865 | 1 | 0.173228346456693 |
| 1588135 | 1588135 | 479374 479374 | 147865 | 1 | 0.173228346456693 |
| 1588138 | 1588138 | 479375 479375 | 147865 | 1 | 0.173228346456693 |
| 1588141 | 1588141 | 479376 479376 | 147865 | 1 | 0.173228346456693 |
| 1588144 | 1588144 | 479377 479377 | 147865 | 1 | 0.173228346456693 |
| 1607343 | 1607343 | 485598 485598 | 147865 | 1 | 0.173228346456693 |
| 1613880 | 1613880 | 487244 487244 | 147865 | 1 | 0.173228346456693 |
| 1718561 | 1718561 | 526336 526336 | 147865 | 1 | 0.173228346456693 |
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)
);