consensus_index

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

8 rows where inventory_id = 42993

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
123945 123945 42993 42993 14203 1 0.0390838467051538
123946 123946 42993 42993 52393 1 0.0781676934103076
123947 123947 42993 42993 77807 2 0.127647308817046
123948 123948 42993 42993 79622 4 0.31267077364123
123949 123949 42993 42993 185614 1 0.156335386820615
123950 123950 42993 42993 239024 1 0.062534154728246
123951 123951 42993 42993 250944 1 0.0521117956068717
123952 123952 42993 42993 308360 1 0.0446672533773186 
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)
);