consensus_index

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

21 rows where inchi_id = 38894

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
11141 11141 3397 3397 38894 26 0.422355766713345
11147 11147 3398 3398 38894 1 0.137931034482759
38717 38717 11647 11647 38894 9 0.475465080365154
42329 42329 12880 12880 38894 1 0.27136432631101
115927 115927 40446 40446 38894 9 0.475465080365154
178440 178440 63593 63593 38894 25 0.453612641557976
187151 187151 66660 66660 38894 1 0.27136432631101
204331 204331 72455 72455 38894 6 0.461173577395733
275747 275747 93488 93488 38894 11 0.44980399651108
452550 452550 162435 162435 38894 7 0.467094915407966
524290 524290 208969 208969 38894 11 0.44980399651108
524295 524295 208970 208970 38894 11 0.44980399651108
524300 524300 208971 208971 38894 11 0.44980399651108
561704 561704 220877 220877 38894 17 0.431888801524544
662484 662484 237482 237482 38894 10 0.390280172436289
701922 701922 250005 250005 38894 14 0.475264951182598
797508 797508 278232 278232 38894 6 0.461173577395733
797513 797513 278233 278233 38894 9 0.475465080365154
931864 931864 331883 331883 38894 5 0.453281772390335
1643663 1643663 497447 497447 38894 8 0.471727583668059
1735188 1735188 531518 531518 38894 9 0.475465080365154 
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)
);