consensus_index

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

14 rows where inventory_id = 78601

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
228872 228872 78601 78601 12217 4 0.128089002860433
228873 228873 78601 78601 77510 1 0.0677188153936889
228874 228874 78601 78601 94639 6 0.270875261574756
228875 228875 78601 78601 206730 2 0.0428291394185058
228876 228876 78601 78601 229954 2 0.0781949525934977
228877 228877 78601 78601 230248 2 0.110584362466846
228878 228878 78601 78601 232275 1 0.0451458769291259
228879 228879 78601 78601 235234 1 0.0541750523149511
228880 228880 78601 78601 255502 1 0.0451458769291259
228881 228881 78601 78601 288083 2 0.034127075164113
228882 228882 78601 78601 291284 2 0.036197229405911
228883 228883 78601 78601 307921 1 0.0270875261574756
228884 228884 78601 78601 309530 2 0.027223988110086
228885 228885 78601 78601 321315 2 0.02357666529566 
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)
);