home / zeropm-v0-0-4

consensus_index

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

32 rows where inchi_id = 2643

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
22421 22421 6592 6592 2643 8 0.625
45261 45261 13814 13814 2643 1 0.0442443530233641
111650 111650 39064 39064 2643 8 0.625
122070 122070 42409 42409 2643 1 0.0442443530233641
148544 148544 53417 53417 2643 12 0.636363636363636
180790 180790 64550 64550 2643 1 0.0442443530233641
221467 221467 76632 76632 2643 8 0.9
295907 295907 100133 100133 2643 1 0.0442443530233641
430180 430180 154918 154918 2643 8 0.9
524909 524909 209130 209130 2643 1 0.0442443530233641
541004 541004 214295 214295 2643 1 0.0442443530233641
593399 593399 231268 231268 2643 7 0.888888888888889
672487 672487 240589 240589 2643 8 0.625
726092 726092 256500 256500 2643 1 0.0442443530233641
744368 744368 261973 261973 2643 4 0.833333333333333
744369 744369 261974 261974 2643 8 0.625
744371 744371 261975 261975 2643 8 0.9
838459 838459 290858 290858 2643 1 0.0442443530233641
942640 942640 337478 337478 2643 4 0.833333333333333
1125749 1125749 384497 384497 2643 1 0.0442443530233641
1125758 1125758 384498 384498 2643 1 0.0442443530233641
1125767 1125767 384499 384499 2643 1 0.0442443530233641
1364413 1364413 433618 433618 2643 1 0.0442443530233641
1364422 1364422 433619 433619 2643 1 0.0442443530233641
1364431 1364431 433620 433620 2643 1 0.0442443530233641
1549584 1549584 471559 471559 2643 1 0.0442443530233641
1549593 1549593 471560 471560 2643 1 0.0442443530233641
1549602 1549602 471561 471561 2643 1 0.0442443530233641
1604127 1604127 484655 484655 2643 1 0.0442443530233641
1616864 1616864 488221 488221 2643 8 0.625
1651940 1651940 500332 500332 2643 1 0.0442443530233641
1739342 1739342 532761 532761 2643 1 0.0442443530233641
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 1727.62ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website