consensus_index

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

15 rows where inventory_id = 97897

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
289054 289054 97897 97897 44722 1 0.0848562769767655
289055 289055 97897 97897 45328 1 0.0848562769767655
289056 289056 97897 97897 58494 8 0.254568830930297
289057 289057 97897 97897 132347 1 0.0212140692441914
289058 289058 97897 97897 137195 2 0.127284415465148
289059 289059 97897 97897 138046 1 0.0509137661860593
289060 289060 97897 97897 146519 1 0.0231426209936633
289061 289061 97897 97897 147583 1 0.0636422077325742
289062 289062 97897 97897 155021 1 0.0509137661860593
289063 289063 97897 97897 177001 1 0.0254568830930297
289064 289064 97897 97897 189471 1 0.0363669758471852
289065 289065 97897 97897 195211 1 0.0318211038662871
289066 289066 97897 97897 197754 1 0.0424281384883828
289067 289067 97897 97897 200006 1 0.0282854256589218
289068 289068 97897 97897 232173 1 0.0636422077325742 
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)
);