consensus_index

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

19 rows where inventory_id = 42073

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
121012 121012 42073 42073 48124 1 0.0135712120656163
121013 121013 42073 42073 51071 4 0.116498256932097
121014 121014 42073 42073 97999 5 0.257853029246709
121015 121015 42073 42073 175573 1 0.0234411844769736
121016 121016 42073 42073 189494 3 0.0893926524768349
121017 121017 42073 42073 230089 2 0.0859510097489031
121018 121018 42073 42073 239398 3 0.102329042469853
121019 121019 42073 42073 243478 2 0.0364659251059683
121020 121020 42073 42073 246839 2 0.0470773068798207
121021 121021 42073 42073 255497 2 0.0368361470352442
121022 121022 42073 42073 259365 2 0.0322316286558387
121023 121023 42073 42073 261043 1 0.0286503365829677
121024 121024 42073 42073 262070 1 0.0214877524372258
121025 121025 42073 42073 284350 1 0.0143251682914838
121026 121026 42073 42073 290024 1 0.019834848403593
121027 121027 42073 42073 292559 1 0.0184180735176221
121028 121028 42073 42073 309691 1 0.0171902019497806
121029 121029 42073 42073 320930 1 0.0161158143279193
121030 121030 42073 42073 326150 1 0.0151678252498064 
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)
);