consensus_index

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

14 rows where inchi_id = 138963

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
317881 317881 107123 107123 138963 1 0.360937944035891
317889 317889 107126 107126 138963 1 0.307692307692308
318688 318688 107377 107377 138963 1 0.183349391974601
319022 319022 107498 107498 138963 1 0.3125
319024 319024 107499 107499 138963 1 0.3125
446383 446383 159903 159903 138963 1 0.239130434782609
469232 469232 169721 169721 138963 1 0.3
469531 469531 169850 169850 138963 1 0.187586281633667
576598 576598 225994 225994 138963 1 0.360937944035891
875612 875612 302875 302875 138963 1 0.3
887342 887342 309337 309337 138963 1 0.3
1664490 1664490 504572 504572 138963 1 0.357311516545769
1665005 1665005 504769 504769 138963 1 0.3125
1676387 1676387 508968 508968 138963 1 0.192307692307692 
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)
);