consensus_index

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

22 rows where inventory_id = 251177

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
706938 706938 251177 251177 45318 10 0.229709935592347
706939 706939 251177 251177 137417 4 0.174087577434678
706940 706940 251177 251177 154251 1 0.035171001864114
706941 706941 251177 251177 181759 1 0.0273552236720887
706942 706942 251177 251177 186517 2 0.0502547548472406
706943 706943 251177 251177 189075 2 0.0550513257034516
706944 706944 251177 251177 191995 2 0.0174964598488718
706945 706945 251177 251177 195326 1 0.0164131342032532
706946 706946 251177 251177 195359 1 0.0153873133155499
706947 706947 251177 251177 203926 1 0.0144821772381646
706948 706948 251177 251177 205707 1 0.0246197013048798
706949 706949 251177 251177 206754 1 0.0189382317729845
706950 706950 251177 251177 206755 1 0.017585500932057
706951 706951 251177 251177 206978 2 0.0189945119320452
706952 706952 251177 251177 206979 1 0.0136776118360443
706953 706953 251177 251177 207048 1 0.0223815466407998
706954 706954 251177 251177 207049 1 0.0205164177540665
706955 706955 251177 251177 218161 2 0.0550513257034516
706956 706956 251177 251177 230879 1 0.0820656710162661
706957 706957 251177 251177 232159 1 0.041032835508133
706958 706958 251177 251177 284913 2 0.0208074453079644
706959 706959 251177 251177 288249 2 0.0230584629275298 
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)
);