consensus_index

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

12 rows where inventory_id = 57287

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
159101 159101 57287 57287 46225 4 0.306727961209581
159102 159102 57287 57287 63056 1 0.0766819903023952
159103 159103 57287 57287 209159 1 0.0511213268682635
159104 159104 57287 57287 253909 2 0.0484979489741025
159105 159105 57287 57287 254564 2 0.0473291519416809
159106 159106 57287 57287 259503 2 0.102242653736527
159107 159107 57287 57287 266074 2 0.0685864571864542
159108 159108 57287 57287 274305 2 0.033466764285771
159109 159109 57287 57287 276357 2 0.15336398060479
159110 159110 57287 57287 283628 1 0.0340808845788423
159111 159111 57287 57287 289607 2 0.0342932285932271
159112 159112 57287 57287 320931 2 0.030827320001299 
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)
);