consensus_index

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

8 rows where inventory_id = 77697

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
225302 225302 77697 77697 6834 7 0.359666024405909
225303 225303 77697 77697 12515 1 0.0899165061014772
225304 225304 77697 77697 176383 1 0.0513808606294155
225305 225305 77697 77697 210363 1 0.0449582530507386
225306 225306 77697 77697 210364 1 0.0719332048811818
225307 225307 77697 77697 210620 2 0.179833012202954
225308 225308 77697 77697 245536 1 0.11988867480197
225309 225309 77697 77697 266906 1 0.0599443374009848 
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)
);