consensus_index

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

8 rows where inventory_id = 71645

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
202008 202008 71645 71645 62703 2 0.136038455159469
202009 202009 71645 71645 75243 2 0.272076910318937
202010 202010 71645 71645 106058 2 0.0906923034396458
202011 202011 71645 71645 150032 2 0.272076910318937
202012 202012 71645 71645 163507 1 0.0388681300455625
202013 202013 71645 71645 192830 1 0.0544153820637875
202014 202014 71645 71645 195136 2 0.0496742203859974
202015 202015 71645 71645 243163 2 0.0680192275797343 
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)
);