consensus_index

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

16 rows where inchi_id = 18702

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
97873 97873 34718 34718 18702 8 0.237221123976278
134221 134221 47644 47644 18702 1 0.253012048192771
168600 168600 60139 60139 18702 1 0.150943396226415
260926 260926 88383 88383 18702 8 0.304054054054054
278391 278391 94405 94405 18702 1 0.259842519685039
279069 279069 94627 94627 18702 1 0.198300283286119
509395 509395 203933 203933 18702 1 0.153846153846154
689547 689547 245900 245900 18702 8 0.237221123976278
703958 703958 250661 250661 18702 1 0.198300283286119
774843 774843 271036 271036 18702 8 0.237221123976278
774856 774856 271037 271037 18702 4 0.392156862745098
894906 894906 314148 314148 18702 1 0.150943396226415
905844 905844 319642 319642 18702 1 0.1281286833983
907337 907337 320299 320299 18702 1 0.196078431372549
1636706 1636706 494884 494884 18702 8 0.237221123976278
1645053 1645053 497991 497991 18702 1 0.198300283286119 
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)
);