consensus_index

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

12 rows where inventory_id = 46518

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
130804 130804 46518 46518 3518 1 0.0791209687250609
130805 130805 46518 46518 9593 1 0.0296703632718978
130806 130806 46518 46518 16880 1 0.0237362906175183
130807 130807 46518 46518 39760 2 0.237362906175183
130808 130808 46518 46518 130149 1 0.0395604843625304
130809 130809 46518 46518 130357 6 0.0923664181786765
130810 130810 46518 46518 150869 4 0.0447436650556864
130811 130811 46518 46518 191902 3 0.0446734093261508
130812 130812 46518 46518 207633 4 0.237362906175183
130813 130813 46518 46518 223139 3 0.0941975317401785
130814 130814 46518 46518 256451 1 0.0339089865964547
130815 130815 46518 46518 264761 2 0.0353839729029742 
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)
);