consensus_index

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

9 rows where inventory_id = 1207

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
4146 4146 1207 1207 6832 19 0.285960923899153
4147 4147 1207 1207 34999 1 0.0408515605570218
4148 4148 1207 1207 84624 1 0.142980461949576
4149 4149 1207 1207 115791 1 0.0714902309747881
4150 4150 1207 1207 195550 2 0.0583715291606479
4151 4151 1207 1207 200792 1 0.0571921847798305
4152 4152 1207 1207 224970 1 0.0953203079663842
4153 4153 1207 1207 232118 1 0.0953203079663842
4154 4154 1207 1207 247839 2 0.142980461949576 
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)
);