consensus_index

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

15 rows where inchi_id = 43790

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
280052 280052 94969 94969 43790 6 0.397802570290717
302450 302450 102357 102357 43790 2 0.132391388997052
336845 336845 113535 113535 43790 1 0.140395660497766
454079 454079 163099 163099 43790 6 0.458015267175573
463028 463028 166317 166317 43790 1 0.19047619047619
559437 559437 220090 220090 43790 8 0.467743222393851
594031 594031 231465 231465 43790 1 0.1875
965032 965032 348824 348824 43790 1 0.1875
965461 965461 349305 349305 43790 1 0.103800193390652
966720 966720 350281 350281 43790 4 0.452830188679245
1629933 1629933 492517 492517 43790 1 0.161764705882353
1645445 1645445 498139 498139 43790 7 0.45993031358885
1655876 1655876 501742 501742 43790 1 0.192307692307692
1742906 1742906 533820 533820 43790 1 0.161290322580645
1751177 1751177 536424 536424 43790 1 0.141227593699077 
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)
);