consensus_index

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

15 rows where inventory_id = 59792

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
167160 167160 59792 59792 50858 3 0.190343517625849
167161 167161 59792 59792 133510 8 0.140880245483152
167162 167162 59792 59792 238389 2 0.0210494115345234
167163 167163 59792 59792 238390 1 0.0216173203493773
167164 167164 59792 59792 266812 1 0.0384307917322263
167165 167165 59792 59792 274897 1 0.0345877125590037
167166 167166 59792 59792 314012 1 0.0494110179414338
167167 167167 59792 59792 314266 2 0.0893050898162869
167168 167168 59792 59792 315114 1 0.172938562795018
167169 167169 59792 59792 315569 1 0.0432346406987546
167170 167170 59792 59792 318079 1 0.0288230937991697
167171 167171 59792 59792 318108 1 0.0266059327376951
167172 167172 59792 59792 318123 1 0.0247055089707169
167173 167173 59792 59792 326533 2 0.0192451180739256
167174 167174 59792 59792 332371 1 0.0864692813975092 
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)
);