home / zeropm-v0-0-4

consensus_index

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

14 rows where inchi_id = 1071

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
47990 47990 14768 14768 1071 8 0.9
109699 109699 38394 38394 1071 8 0.9
142452 142452 50755 50755 1071 8 0.9
250169 250169 85065 85065 1071 1 0.310344827586207
301195 301195 101956 101956 1071 5 0.857142857142857
505802 505802 202294 202294 1071 5 0.857142857142857
670163 670163 239985 239985 1071 8 0.9
739881 739881 260688 260688 1071 8 0.9
856655 856655 296344 296344 1071 1 0.3125
856657 856657 296345 296345 1071 1 0.236842105263158
888012 888012 309631 309631 1071 4 0.833333333333333
948036 948036 339896 339896 1071 1 0.3
1655239 1655239 501530 501530 1071 8 0.9
1742505 1742505 533709 533709 1071 8 0.9
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 900.439ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website