consensus_index

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

20 rows where inchi_id = 77801

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
55530 55530 17395 17395 77801 1 0.206896551724138
137525 137525 48972 48972 77801 1 0.206896551724138
247824 247824 84336 84336 77801 5 0.380952380952381
247835 247835 84339 84339 77801 1 0.175145954962469
351215 351215 118718 118718 77801 3 0.415239576400731
536408 536408 212885 212885 77801 5 0.380952380952381
561804 561804 220907 220907 77801 2 0.408628001184222
691727 691727 246732 246732 77801 1 0.206896551724138
731206 731206 257883 257883 77801 6 0.342857142857143
849357 849357 293831 293831 77801 6 0.342857142857143
865199 865199 298733 298733 77801 1 0.262020410288673
868265 868265 299528 299528 77801 1 0.3
880152 880152 305674 305674 77801 1 0.112
1169772 1169772 392872 392872 77801 6 0.342857142857143
1425350 1425350 444455 444455 77801 6 0.342857142857143
1583926 1583926 478178 478178 77801 6 0.342857142857143
1606159 1606159 485233 485233 77801 6 0.342857142857143
1630611 1630611 492777 492777 77801 6 0.342857142857143
1669228 1669228 506308 506308 77801 1 0.206896551724138
1749487 1749487 535887 535887 77801 1 0.206896551724138 
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)
);