consensus_index

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

14 rows where inventory_id = 51667

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
144932 144932 51667 51667 5902 2 0.0674210640783029
144933 144933 51667 51667 8363 11 0.16514720490733
144934 144934 51667 51667 13112 4 0.16514720490733
144935 144935 51667 51667 16871 1 0.0550490683024434
144936 144936 51667 51667 106048 6 0.116776708483978
144937 144937 51667 51667 123102 5 0.0848085467689575
144938 144938 51667 51667 128293 1 0.0275245341512217
144939 144939 51667 51667 146481 1 0.0825736024536652
144940 144940 51667 51667 217741 1 0.0275245341512217
144941 144941 51667 51667 225906 1 0.0330294409814661
144942 144942 51667 51667 232459 1 0.0550490683024434
144943 144943 51667 51667 250472 1 0.0412868012268326
144944 144944 51667 51667 272600 1 0.0412868012268326
144945 144945 51667 51667 322892 1 0.0330294409814661 
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)
);