consensus_index

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

19 rows where inchi_id = 74396

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
10266 10266 3112 3112 74396 1 0.174783397772137
26926 26926 7844 7844 74396 2 0.110315501628562
87901 87901 31439 31439 74396 2 0.2313212606843
181284 181284 64766 64766 74396 3 0.0984108798035667
201928 201928 71613 71613 74396 1 0.174783397772137
229543 229543 78711 78711 74396 3 0.138460834629186
419568 419568 150289 150289 74396 1 0.174783397772137
435403 435403 156299 156299 74396 1 0.131912734652461
577721 577721 226344 226344 74396 3 0.138460834629186
685997 685997 244637 244637 74396 4 0.100099155703989
727023 727023 256732 256732 74396 5 0.199049871300636
769798 769798 269285 269285 74396 2 0.136723468990841
769804 769804 269286 269286 74396 1 0.130718954248366
769812 769812 269287 269287 74396 3 0.0984108798035667
840072 840072 291287 291287 74396 2 0.208558994496996
949587 949587 340610 340610 74396 1 0.130718954248366
1621628 1621628 489675 489675 74396 2 0.136723468990841
1652430 1652430 500478 500478 74396 5 0.199049871300636
1723555 1723555 527822 527822 74396 2 0.110315501628562 
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)
);