consensus_index

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

8 rows where inventory_id = 3063

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
10092 10092 3063 3063 29467 1 0.272020725388601
10093 10093 3063 3063 63043 1 0.0453367875647668
10094 10094 3063 3063 78141 1 0.136010362694301
10095 10095 3063 3063 120350 1 0.0906735751295337
10096 10096 3063 3063 125837 4 0.272020725388601
10097 10097 3063 3063 141548 1 0.0680051813471503
10098 10098 3063 3063 144024 1 0.038860103626943
10099 10099 3063 3063 261936 1 0.0544041450777202 
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)
);