consensus_index

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

15 rows where inventory_id = 163805

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
455891 455891 163805 163805 50858 3 0.185357600651613
455892 455892 163805 163805 133510 10 0.164186239567609
455893 455893 163805 163805 238389 2 0.0204980367381726
455894 455894 163805 163805 238390 1 0.0210510695738751
455895 455895 163805 163805 266812 1 0.0374241236868891
455896 455896 163805 163805 274897 1 0.0336817113182002
455897 455897 163805 163805 314012 1 0.0481167304545718
455898 455898 163805 163805 314266 2 0.0869658046714369
455899 455899 163805 163805 315114 1 0.168408556591001
455900 455900 163805 163805 315569 1 0.0421021391477503
455901 455901 163805 163805 318079 1 0.0280680927651669
455902 455902 163805 163805 318108 1 0.0259090087063079
455903 455903 163805 163805 318123 1 0.0240583652272859
455904 455904 163805 163805 326533 2 0.0187410054985525
455905 455905 163805 163805 332371 1 0.0842042782955006 
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)
);