consensus_index

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

9 rows where inventory_id = 42336

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
121837 121837 42336 42336 17547 2 0.144272540342145
121838 121838 42336 42336 92795 3 0.256050335470253
121839 121839 42336 42336 131968 3 0.168643394177971
121840 121840 42336 42336 138119 1 0.0537672012486027
121841 121841 42336 42336 219180 1 0.080650801872904
121842 121842 42336 42336 259520 1 0.040325400936452
121843 121843 42336 42336 276599 1 0.107534402497205
121844 121844 42336 42336 291074 1 0.0358448008324018
121845 121845 42336 42336 329492 1 0.0322603207491616 
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)
);