consensus_index

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

29 rows where inchi_id = 27556

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
6379 6379 1959 1959 27556 6 0.273204903677758
32067 32067 9419 9419 27556 6 0.384615384615385
90193 90193 32205 32205 27556 6 0.384615384615385
154094 154094 55380 55380 27556 9 0.274562584118439
249632 249632 84880 84880 27556 6 0.273204903677758
442682 442682 158674 158674 27556 3 0.375
477992 477992 174422 174422 27556 2 0.361783611861164
522435 522435 208438 208438 27556 6 0.273204903677758
533380 533380 211578 211578 27556 3 0.378378378378378
734681 734681 259178 259178 27556 9 0.274562584118439
787386 787386 275007 275007 27556 2 0.361783611861164
787391 787391 275008 275008 27556 2 0.361783611861164
798351 798351 278506 278506 27556 1 0.124473931582994
798356 798356 278507 278507 27556 1 0.0746418973224696
855846 855846 296054 296054 27556 6 0.384615384615385
855849 855849 296055 296055 27556 3 0.378378378378378
889656 889656 310810 310810 27556 2 0.361783611861164
922831 922831 327577 327577 27556 1 0.124473931582994
939161 939161 335632 335632 27556 3 0.375
963441 963441 347189 347189 27556 3 0.690983005625053
1173423 1173423 393925 393925 27556 6 0.384615384615385
1173426 1173426 393926 393926 27556 6 0.384615384615385
1428919 1428919 445550 445550 27556 6 0.384615384615385
1428922 1428922 445551 445551 27556 6 0.384615384615385
1586327 1586327 478913 478913 27556 6 0.384615384615385
1586330 1586330 478914 478914 27556 6 0.384615384615385
1606862 1606862 485466 485466 27556 6 0.384615384615385
1631273 1631273 492992 492992 27556 6 0.384615384615385
1728451 1728451 529315 529315 27556 3 0.378378378378378 
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)
);