consensus_index

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

9 rows where inventory_id = 53478

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
148788 148788 53478 53478 8015 1 0.058302291163326
148789 148789 53478 53478 51344 9 0.299875729717855
148790 148790 53478 53478 84983 2 0.116604582326652
148791 148791 53478 53478 132675 3 0.0949540597329466
148792 148792 53478 53478 181312 2 0.174906873489978
148793 148793 53478 53478 203921 1 0.058302291163326
148794 148794 53478 53478 229354 1 0.087453436744989
148795 148795 53478 53478 234974 1 0.049973392425708
148796 148796 53478 53478 335320 1 0.0437267183724945 
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)
);