consensus_index

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

21 rows where inchi_id = 226009

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
36278 36278 10829 10829 226009 1 0.3125
90248 90248 32234 32234 226009 1 0.3125
153939 153939 55320 55320 226009 2 0.317073170731707
265268 265268 89886 89886 226009 1 0.307692307692308
448613 448613 160825 160825 226009 1 0.307692307692308
570438 570438 223642 223642 226009 2 0.310344827586207
693158 693158 247273 247273 226009 1 0.3125
780459 780459 272916 272916 226009 1 0.3125
780461 780461 272917 272917 226009 1 0.3
1042601 1042601 369236 369236 226009 2 0.310344827586207
1042603 1042603 369237 369237 226009 2 0.310344827586207
1042605 1042605 369238 369238 226009 2 0.310344827586207
1263014 1263014 415941 415941 226009 2 0.310344827586207
1263016 1263016 415942 415942 226009 2 0.310344827586207
1263018 1263018 415943 415943 226009 2 0.310344827586207
1263020 1263020 415944 415944 226009 2 0.310344827586207
1486306 1486306 459915 459915 226009 2 0.310344827586207
1486308 1486308 459916 459916 226009 2 0.310344827586207
1596772 1596772 482113 482113 226009 2 0.310344827586207
1638510 1638510 495568 495568 226009 2 0.310344827586207
1732645 1732645 530656 530656 226009 1 0.3 
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)
);