home / zeropm-v0-0-4

consensus_index

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

14 rows where inventory_id = 158837

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
443096 443096 158837 158837 4979 2 0.0604189118785989
443097 443097 158837 158837 85121 1 0.0591982019666995
443098 443098 158837 158837 91391 7 0.295991009833497
443099 443099 158837 158837 137103 1 0.0295991009833497
443100 443100 158837 158837 138275 2 0.0854452446025395
443101 443101 158837 158837 213450 1 0.026908273621227
443102 443102 158837 158837 232049 1 0.0739977524583744
443103 443103 158837 158837 234168 1 0.0246659174861248
443104 443104 158837 158837 238102 2 0.0559370430235934
443105 443105 158837 158837 239098 2 0.0936005758007148
443106 443106 158837 158837 248015 1 0.0986636699444991
443107 443107 158837 158837 264393 1 0.021142214988107
443108 443108 158837 158837 276362 2 0.0402792745857326
443109 443109 158837 158837 309509 1 0.0227685392179613
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)
);
Powered by Datasette · Queries took 1138.991ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website