home / zeropm-v0-0-4

consensus_index

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

25 rows where inchi_id = 38903

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
3670 3670 1039 1039 38903 2 0.184491978609626
132948 132948 47212 47212 38903 2 0.0872337476961725
175459 175459 62620 62620 38903 1 0.207920792079208
205432 205432 72814 72814 38903 1 0.182926829268293
223191 223191 77102 77102 38903 1 0.206896551724138
351545 351545 118836 118836 38903 7 0.45993031358885
518724 518724 207405 207405 38903 1 0.182926829268293
518729 518729 207406 207406 38903 1 0.182242990654206
591016 591016 230596 230596 38903 1 0.182242990654206
598587 598587 235693 235693 38903 1 0.182926829268293
674925 674925 241230 241230 38903 1 0.183206106870229
742516 742516 261454 261454 38903 1 0.253012048192771
749198 749198 263413 263413 38903 1 0.20625
749202 749202 263414 263414 38903 1 0.206896551724138
749206 749206 263415 263415 38903 1 0.182242990654206
829272 829272 287666 287666 38903 1 0.253012048192771
829814 829814 287926 287926 38903 1 0.253012048192771
830746 830746 288310 288310 38903 1 0.253012048192771
830749 830749 288311 288311 38903 1 0.253012048192771
831364 831364 288500 288500 38903 1 0.170454545454545
832108 832108 288782 288782 38903 1 0.169014084507042
832139 832139 288805 288805 38903 1 0.253012048192771
832166 832166 288813 288813 38903 1 0.253012048192771
854962 854962 295737 295737 38903 1 0.169014084507042
934061 934061 332889 332889 38903 4 0.452830188679245
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)
);
Powered by Datasette · Queries took 906.168ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website