home / zeropm-v0-0-4

consensus_index

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

14 rows where inventory_id = 287587

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
829007 829007 287587 287587 35027 1 0.018268022645091
829008 829008 287587 287587 64734 1 0.0243573635267879
829009 829009 287587 287587 92940 1 0.0274020339676364
829010 829010 287587 287587 101402 1 0.0219216271741091
829011 829011 287587 287587 101859 1 0.0548040679352729
829012 829012 287587 287587 107340 1 0.109608135870546
829013 829013 287587 287587 134415 1 0.0730720905803638
829014 829014 287587 287587 134757 1 0.0365360452901819
829015 829015 287587 287587 229467 1 0.0438432543482183
829016 829016 287587 287587 229572 2 0.219216271741091
829017 829017 287587 287587 230005 1 0.0199287519764629
829018 829018 287587 287587 237367 1 0.219216271741091
829019 829019 287587 287587 255589 1 0.0313166102487273
829020 829020 287587 287587 295284 1 0.0168627901339301
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 1207.667ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website