consensus_index

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

10 rows where inventory_id = 18695

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
59077 59077 18695 18695 33755 5 0.289161088646871
59078 59078 18695 18695 64876 2 0.191772011194079
59079 59079 18695 18695 193633 1 0.0553598111429688
59080 59080 18695 18695 226273 1 0.0415198583572266
59081 59081 18695 18695 227349 1 0.0369065407619792
59082 59082 18695 18695 247439 1 0.0664317733715625
59083 59083 18695 18695 255319 1 0.0332158866857813
59084 59084 18695 18695 259862 2 0.135603289557116
59085 59085 18695 18695 292772 1 0.0474512666939732
59086 59086 18695 18695 326427 1 0.0830397167144532 
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)
);