consensus_index

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

12 rows where inchi_id = 111956

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
31385 31385 9212 9212 111956 1 0.192307692307692
186975 186975 66592 66592 111956 1 0.109826589595376
245994 245994 83715 83715 111956 1 0.161764705882353
381959 381959 130722 130722 111956 5 0.301346080410281
441285 441285 158194 158194 111956 1 0.191489361702128
543855 543855 215118 215118 111956 1 0.161764705882353
723228 723228 255638 255638 111956 1 0.16304347826087
832918 832918 289083 289083 111956 1 0.192307692307692
832921 832921 289084 289084 111956 1 0.1875
891167 891167 312400 312400 111956 1 0.1875
1629748 1629748 492449 492449 111956 1 0.192307692307692
1696987 1696987 517321 517321 111956 6 0.311447331534448 
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)
);