consensus_index

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

15 rows where inventory_id = 122219

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
359973 359973 122219 122219 47570 8 0.284345378132414
359974 359974 122219 122219 48275 2 0.116083514523859
359975 359975 122219 122219 136728 1 0.0473908963554024
359976 359976 122219 122219 139756 2 0.0410417201518938
359977 359977 122219 122219 186080 2 0.0580417572619294
359978 359978 122219 122219 190428 2 0.0899179037040264
359979 359979 122219 122219 199503 1 0.0258495798302195
359980 359980 122219 122219 199808 1 0.0284345378132414
359981 359981 122219 122219 199809 1 0.0947817927108047
359982 359982 122219 122219 207308 1 0.0315939309036016
359983 359983 122219 122219 208206 1 0.0203103841523153
359984 359984 122219 122219 231941 1 0.0406207683046306
359985 359985 122219 122219 240112 1 0.0406207683046306
359986 359986 122219 122219 280585 2 0.0352687035083221
359987 359987 122219 122219 318638 1 0.0355431722665518 
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)
);