consensus_index

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

16 rows where inventory_id = 202018

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
505021 505021 202018 202018 27859 1 0.0199556299971477
505022 505022 202018 202018 35681 6 0.213341342209702
505023 505023 202018 202018 48098 3 0.190065528300963
505024 505024 202018 202018 84939 2 0.0325874073258598
505025 505025 202018 202018 114589 1 0.119733779982886
505026 505026 202018 202018 119911 1 0.0184205815358287
505027 505027 202018 202018 136277 2 0.0478935119931546
505028 505028 202018 202018 139024 2 0.0798225199885909
505029 505029 202018 202018 147391 1 0.0342096514236818
505030 505030 202018 202018 153429 2 0.0598668899914432
505031 505031 202018 202018 169028 2 0.0239467559965773
505032 505032 202018 202018 190420 1 0.0342096514236818
505033 505033 202018 202018 231816 1 0.0399112599942955
505034 505034 202018 202018 240518 2 0.0299334449957216
505035 505035 202018 202018 260209 1 0.0266075066628636
505036 505036 202018 202018 309990 2 0.0217697781787066 
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)
);