consensus_index

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

28 rows where inchi_id = 3188

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
7836 7836 2368 2368 3188 12 0.367741935483871
22914 22914 6728 6728 3188 8 0.461538461538462
30871 30871 9028 9028 3188 1 0.259842519685039
120378 120378 41901 41901 3188 8 0.461538461538462
153545 153545 55196 55196 3188 16 0.368983957219251
188171 188171 66986 66986 3188 1 0.229007633587786
206076 206076 73034 73034 3188 12 0.367741935483871
222134 222134 76810 76810 3188 8 0.365853658536585
244008 244008 83027 83027 3188 2 0.261744966442953
252391 252391 85759 85759 3188 1 0.1875
430719 430719 155064 155064 3188 8 0.461538461538462
440445 440445 157905 157905 3188 2 0.261744966442953
517733 517733 207203 207203 3188 12 0.367741935483871
592586 592586 231036 231036 3188 12 0.367741935483871
673326 673326 240812 240812 3188 12 0.367741935483871
718008 718008 253933 253933 3188 2 0.264248704663212
746156 746156 262478 262478 3188 8 0.461538461538462
821745 821745 285306 285306 3188 1 0.259842519685039
880286 880286 305736 305736 3188 1 0.226415094339623
905445 905445 319448 319448 3188 1 0.253012048192771
988670 988670 355340 355340 3188 8 0.461538461538462
1198166 1198166 399408 399408 3188 8 0.461538461538462
1446202 1446202 449658 449658 3188 8 0.461538461538462
1590878 1590878 480212 480212 3188 8 0.461538461538462
1617410 1617410 488378 488378 3188 8 0.461538461538462
1628195 1628195 491870 491870 3188 1 0.259842519685039
1720309 1720309 526876 526876 3188 5 0.455696202531646
1727181 1727181 528907 528907 3188 1 0.259842519685039 
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)
);