home / zeropm-v0-0-4

consensus_index

Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website

38 rows where inchi_id = 85031

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14282 14282 4396 4396 85031 1 0.3125
20241 20241 5947 5947 85031 1 0.3125
79137 79137 28582 28582 85031 1 0.3125
135451 135451 48006 48006 85031 1 0.317073170731707
219160 219160 75954 75954 85031 1 0.206896551724138
249704 249704 84903 84903 85031 8 0.625
428486 428486 154432 154432 85031 1 0.239130434782609
515784 515784 206737 206737 85031 1 0.239130434782609
515788 515788 206738 206738 85031 1 0.201477906983203
531457 531457 210801 210801 85031 1 0.206896551724138
533318 533318 211554 211554 85031 8 0.625
736580 736580 259772 259772 85031 1 0.317073170731707
859274 859274 297247 297247 85031 1 0.3125
859276 859276 297248 297248 85031 1 0.304347826086957
859278 859278 297249 297249 85031 1 0.304347826086957
903738 903738 318576 318576 85031 1 0.3
1176538 1176538 394789 394789 85031 1 0.3125
1176540 1176540 394790 394790 85031 1 0.3125
1176542 1176542 394791 394791 85031 1 0.3125
1176544 1176544 394792 394792 85031 1 0.3125
1176546 1176546 394793 394793 85031 1 0.3125
1176548 1176548 394794 394794 85031 1 0.3125
1431998 1431998 446431 446431 85031 1 0.3125
1432000 1432000 446432 446432 85031 1 0.3125
1432002 1432002 446433 446433 85031 1 0.3125
1432004 1432004 446434 446434 85031 1 0.3125
1432006 1432006 446435 446435 85031 1 0.3125
1432008 1432008 446436 446436 85031 1 0.3125
1432010 1432010 446437 446437 85031 1 0.3125
1588530 1588530 479516 479516 85031 1 0.3125
1588532 1588532 479517 479517 85031 1 0.3125
1588534 1588534 479518 479518 85031 1 0.3125
1588536 1588536 479519 479519 85031 1 0.3125
1588538 1588538 479520 479520 85031 1 0.3125
1607449 1607449 485632 485632 85031 1 0.3125
1614135 1614135 487331 487331 85031 1 0.3125
1631310 1631310 493006 493006 85031 7 0.620689655172414
1718732 1718732 526390 526390 85031 1 0.3125
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)
);
Powered by Datasette · Queries took 1002.532ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website