consensus_index

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

11 rows where inventory_id = 533829

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1742936 1742936 533829 533829 1631 1 0.043748444456241
1742937 1742937 533829 533829 2185 4 0.154674108706855
1742938 1742938 533829 533829 111030 2 0.218742222281205
1742939 1742939 533829 533829 111218 1 0.0364570370468675
1742940 1742940 533829 533829 132427 1 0.031248888897315
1742941 1742941 533829 533829 188291 1 0.0243046913645784
1742942 1742942 533829 533829 188293 1 0.0729140740937351
1742943 1742943 533829 533829 220424 1 0.0273427777851507
1742944 1742944 533829 533829 229749 3 0.137798965176437
1742945 1742945 533829 533829 230325 1 0.218742222281205
1742946 1742946 533829 533829 295033 1 0.0218742222281205 
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)
);