consensus_index

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

12 rows where inventory_id = 1800

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
5888 5888 1800 1800 11441 12 0.317977424979352
5889 5889 1800 1800 20811 1 0.0264981187482793
5890 5890 1800 1800 27768 1 0.039747178122419
5891 5891 1800 1800 58558 1 0.0317977424979352
5892 5892 1800 1800 149080 1 0.0353308249977058
5893 5893 1800 1800 149087 1 0.158988712489676
5894 5894 1800 1800 171277 1 0.105992474993117
5895 5895 1800 1800 171278 1 0.079494356244838
5896 5896 1800 1800 171279 1 0.0635954849958704
5897 5897 1800 1800 171280 1 0.0529962374965587
5898 5898 1800 1800 171281 1 0.0454253464256217
5899 5899 1800 1800 325972 1 0.0289070386344866 
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)
);