consensus_index

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

12 rows where inventory_id = 112447

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
333581 333581 112447 112447 5011 2 0.0457617202230792
333582 333582 112447 112447 25712 6 0.22543230657095
333583 333583 112447 112447 181279 2 0.0638116700934774
333584 333584 112447 112447 219342 2 0.0781530156819184
333585 333585 112447 112447 237669 3 0.0891559543814036
333586 333586 112447 112447 238515 3 0.17054920526602
333587 333587 112447 112447 248542 3 0.0469284223454328
333588 333588 112447 112447 258176 1 0.0300811097612911
333589 333589 112447 112447 272753 1 0.13536499392581
333590 333590 112447 112447 277999 3 0.0445118376615338
333591 333591 112447 112447 310007 1 0.027072998785162
333592 333592 112447 112447 315764 1 0.0338412484814525 
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)
);