consensus_index

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

12 rows where inventory_id = 4913

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
16716 16716 4913 4913 26333 1 0.072582709106313
16717 16717 4913 4913 30714 2 0.0447990206577125
16718 16718 4913 4913 59099 1 0.072582709106313
16719 16719 4913 4913 70927 10 0.233060629059161
16720 16720 4913 4913 77174 1 0.145165418212626
16721 16721 4913 4913 136276 2 0.145165418212626
16722 16722 4913 4913 140737 1 0.0580661672850504
16723 16723 4913 4913 174262 1 0.032258981825028
16724 16724 4913 4913 188320 1 0.0580661672850504
16725 16725 4913 4913 206304 1 0.048388472737542
16726 16726 4913 4913 287391 1 0.041475833775036
16727 16727 4913 4913 323037 1 0.0362913545531565 
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)
);