consensus_index

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

17 rows where inchi_id = 42903

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27707 27707 8047 8047 42903 6 0.190661591674748
110451 110451 38694 38694 42903 6 0.190661591674748
169110 169110 60308 60308 42903 9 0.115220985985898
233574 233574 79829 79829 42903 4 0.157986534549381
240189 240189 81648 81648 42903 2 0.170984455958549
286910 286910 97191 97191 42903 2 0.286685332312075
436402 436402 156571 156571 42903 4 0.157986534549381
438706 438706 157234 157234 42903 2 0.170984455958549
456557 456557 164052 164052 42903 1 0.3125
458962 458962 164999 164999 42903 1 0.113636363636364
559942 559942 220262 220262 42903 8 0.132556930995562
703881 703881 250637 250637 42903 6 0.190661591674748
800865 800865 279376 279376 42903 3 0.165098789755493
800873 800873 279377 279377 42903 6 0.190661591674748
894988 894988 314185 314185 42903 3 0.165098789755493
1623188 1623188 490158 490158 42903 6 0.190661591674748
1626021 1626021 491011 491011 42903 2 0.171806167400881 
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)
);