consensus_index

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

10 rows where inventory_id = 77793

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
225721 225721 77793 77793 7155 3 0.232784064868347
225722 225722 77793 77793 75935 1 0.116392032434173
225723 225723 77793 77793 137682 4 0.0884388197690025
225724 225724 77793 77793 140144 2 0.0548677302735257
225725 225725 77793 77793 153721 1 0.0290980081085433
225726 225726 77793 77793 161528 3 0.0923804173633618
225727 225727 77793 77793 169273 3 0.0465568129736694
225728 225728 77793 77793 173345 3 0.0559554529217975
225729 225729 77793 77793 196518 4 0.232784064868347
225730 225730 77793 77793 207923 4 0.0427155596996347 
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)
);