home / zeropm-v0-0-4

consensus_index

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

20 rows where inchi_id = 43378

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
34954 34954 10355 10355 43378 1 0.206896551724138
39635 39635 11982 11982 43378 8 0.519685039370079
108377 108377 37992 37992 43378 1 0.206896551724138
108380 108380 37993 37993 43378 8 0.519685039370079
198103 198103 70446 70446 43378 12 0.528497409326425
259000 259000 87702 87702 43378 1 0.182242990654206
279544 279544 94796 94796 43378 8 0.523489932885906
446413 446413 159917 159917 43378 1 0.182242990654206
559694 559694 220169 220169 43378 8 0.519685039370079
575930 575930 225624 225624 43378 1 0.182242990654206
687479 687479 245169 245169 43378 1 0.209016393442623
704105 704105 250708 250708 43378 8 0.519685039370079
771804 771804 270049 270049 43378 1 0.206896551724138
771808 771808 270050 270050 43378 1 0.258620689655172
801256 801256 279513 279513 43378 8 0.519685039370079
801259 801259 279514 279514 43378 8 0.523489932885906
951964 951964 341531 341531 43378 1 0.253012048192771
1635784 1635784 494536 494536 43378 1 0.259842519685039
1645247 1645247 498062 498062 43378 7 0.517241379310345
1735926 1735926 531786 531786 43378 8 0.519685039370079
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 1046.666ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website