consensus_index

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

10 rows where inventory_id = 89780

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
264984 264984 89780 89780 16669 3 0.105710413135575
264985 264985 89780 89780 23203 5 0.135765790024281
264986 264986 89780 89780 23932 1 0.0345737758578543
264987 264987 89780 89780 24443 1 0.24201643100498
264988 264988 89780 89780 161242 2 0.0441859528494401
264989 264989 89780 89780 174635 4 0.24201643100498
264990 264990 89780 89780 198239 1 0.060504107751245
264991 264991 89780 89780 257079 2 0.0403360718341633
264992 264992 89780 89780 257892 2 0.0541165191399023
264993 264993 89780 89780 290989 1 0.0302520538756225 
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)
);