consensus_index

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

27 rows where inventory_id = 218314

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
553093 553093 218314 218314 51007 1 0.0339314488692327
553094 553094 218314 218314 52193 8 0.237520142084629
553095 553095 218314 218314 55057 1 0.0475040284169258
553096 553096 218314 218314 128257 1 0.0107963700947559
553097 553097 218314 218314 137481 2 0.118760071042315
553098 553098 218314 218314 137620 2 0.0593800355211573
553099 553099 218314 218314 173272 1 0.0118760071042315
553100 553100 218314 218314 181280 1 0.0215927401895117
553101 553101 218314 218314 181386 1 0.0197933451737191
553102 553102 218314 218314 181642 1 0.0296900177605786
553103 553103 218314 218314 182408 1 0.0169657244346164
553104 553104 218314 218314 185925 1 0.0148450088802893
553105 553105 218314 218314 186402 1 0.0339314488692327
553106 553106 218314 218314 189167 2 0.0559840343788112
553107 553107 218314 218314 195518 1 0.0237520142084629
553108 553108 218314 218314 199754 1 0.0158346761389753
553109 553109 218314 218314 200610 1 0.0263911268982921
553110 553110 218314 218314 205164 1 0.0182707801603561
553111 553111 218314 218314 206690 2 0.0559840343788112
553112 553112 218314 218314 208892 1 0.0131955634491461
553113 553113 218314 218314 218613 1 0.0139717730638017
553114 553114 218314 218314 231503 2 0.0183250768035652
553115 553115 218314 218314 235224 1 0.00989667258685954
553116 553116 218314 218314 241683 1 0.0125010601097173
553117 553117 218314 218314 248048 1 0.00950080568338516
553118 553118 218314 218314 308237 2 0.0165087910845099
553119 553119 218314 218314 314691 1 0.0475040284169258 
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)
);