consensus_index

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

17 rows where inchi_id = 117393

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
50925 50925 15804 15804 117393 1 0.225500214148194
107806 107806 37891 37891 117393 1 0.225500214148194
115096 115096 40149 40149 117393 6 0.315789473684211
300688 300688 101792 101792 117393 1 0.226028350389533
311249 311249 105080 105080 117393 6 0.280661560087575
462141 462141 166018 166018 117393 1 0.226028350389533
467087 467087 168717 168717 117393 6 0.280661560087575
526934 526934 209579 209579 117393 1 0.226028350389533
526938 526938 209580 209580 117393 1 0.226028350389533
527859 527859 209792 209792 117393 7 0.295410812285077
581180 581180 227368 227368 117393 3 0.311688311688312
595430 595430 231907 231907 117393 1 0.226028350389533
739086 739086 260466 260466 117393 1 0.226028350389533
763645 763645 267734 267734 117393 3 0.311688311688312
763650 763650 267735 267735 117393 5 0.31413612565445
933268 933268 332506 332506 117393 3 0.311688311688312
1661700 1661700 503670 503670 117393 6 0.315789473684211 
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)
);