consensus_index

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

9 rows where inventory_id = 42351

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
121902 121902 42351 42351 15089 1 0.0777281203643529
121903 121903 42351 42351 15929 2 0.139044288718383
121904 121904 42351 42351 97140 1 0.0444160687796302
121905 121905 42351 42351 123777 5 0.270665035868545
121906 121906 42351 42351 131969 2 0.219848323994072
121907 121907 42351 42351 248432 1 0.0518187469095686
121908 121908 42351 42351 257689 1 0.103637493819137
121909 121909 42351 42351 295045 1 0.0388640601821764
121910 121910 42351 42351 335231 1 0.0345458312730457 
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)
);