consensus_index

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

10 rows where inventory_id = 38747

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
110610 110610 38747 38747 20212 3 0.0909645438858247
110611 110611 38747 38747 111280 1 0.297551054926593
110612 110612 38747 38747 168480 1 0.033061228325177
110613 110613 38747 38747 191080 1 0.0371938818658241
110614 110614 38747 38747 196011 2 0.148775527463296
110615 110615 38747 38747 198740 1 0.0297551054926593
110616 110616 38747 38747 213598 4 0.171791181659525
110617 110617 38747 38747 314187 2 0.0607373547497502
110618 110618 38747 38747 321849 2 0.0401217760614603
110619 110619 38747 38747 332551 1 0.0743877637316482 
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)
);