consensus_index

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

11 rows where inventory_id = 213990

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
539989 539989 213990 213990 43801 2 0.0410467741556827
539990 539990 213990 213990 43802 3 0.121417995371945
539991 539991 213990 213990 74743 9 0.24283599074389
539992 539992 213990 213990 115267 3 0.24283599074389
539993 539993 213990 213990 137984 2 0.0572369919237194
539994 539994 213990 213990 159133 2 0.0809453302479633
539995 539995 213990 213990 173839 1 0.0607089976859725
539996 539996 213990 213990 185927 1 0.0269817767493211
539997 539997 213990 213990 195871 1 0.0303544988429862
539998 539998 213990 213990 198566 2 0.0383957414307129
539999 539999 213990 213990 228312 1 0.048567198148778 
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)
);