consensus_index

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

10 rows where inventory_id = 73718

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
208579 208579 73718 73718 46097 9 0.274594154434817
208580 208580 73718 73718 57065 2 0.127954428549291
208581 208581 73718 73718 106356 1 0.0402121973822458
208582 208582 73718 73718 136413 1 0.180954888220106
208583 208583 73718 73718 140820 2 0.120636592146737
208584 208584 73718 73718 149684 1 0.0723819552880424
208585 208585 73718 73718 169069 1 0.051701396634316
208586 208586 73718 73718 172093 1 0.032900888767292
208587 208587 73718 73718 237459 1 0.0452387220550265
208588 208588 73718 73718 247645 1 0.0361909776440212 
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)
);