consensus_index

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

15 rows where inventory_id = 102000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
301333 301333 102000 102000 1215 5 0.232743163138087
301334 301334 102000 102000 113012 2 0.232743163138087
301335 301335 102000 102000 139062 3 0.0888081379003604
301336 301336 102000 102000 165466 1 0.0581857907845216
301337 301337 102000 102000 216790 2 0.0496210091079107
301338 301338 102000 102000 217319 1 0.0332490233054409
301339 301339 102000 102000 217766 3 0.0482841130578931
301340 301340 102000 102000 219148 1 0.0290928953922608
301341 301341 102000 102000 237477 1 0.0232743163138087
301342 301342 102000 102000 237586 1 0.0465486326276173
301343 301343 102000 102000 261845 1 0.0387905271896811
301344 301344 102000 102000 290056 1 0.0193952635948405
301345 301345 102000 102000 292754 1 0.0179033202413913
301346 301346 102000 102000 320379 1 0.0258603514597874
301347 301347 102000 102000 330616 1 0.0465486326276173 
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)
);