consensus_index

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

7 rows where inventory_id = 42325

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
121787 121787 42325 42325 7320 5 0.307774168679234
121788 121788 42325 42325 76627 1 0.088384920318104
121789 121789 42325 42325 137056 3 0.280604630982168
121790 121790 42325 42325 139374 1 0.117846560424139
121791 121791 42325 42325 173191 1 0.0589232802120693
121792 121792 42325 42325 195733 1 0.0707079362544832
121793 121793 42325 42325 266539 1 0.0505056687532023 
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)
);