consensus_index

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

15 rows where inchi_id = 248540

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
11151 11151 3398 3398 248540 2 0.0919540229885057
27436 27436 7958 7958 248540 1 0.153846153846154
178465 178465 63600 63600 248540 2 0.126315789473684
204339 204339 72456 72456 248540 2 0.125560538116592
231552 231552 79227 79227 248540 1 0.153846153846154
435987 435987 156445 156445 248540 1 0.125301204819277
520984 520984 207961 207961 248540 2 0.125560538116592
520988 520988 207962 207962 248540 1 0.150943396226415
563970 563970 221580 221580 248540 1 0.153846153846154
699574 699574 249285 249285 248540 1 0.155339805825243
793798 793798 277051 277051 248540 1 0.153846153846154
793802 793802 277052 277052 248540 1 0.153846153846154
931841 931841 331874 331874 248540 1 0.150943396226415
1622537 1622537 489906 489906 248540 1 0.153846153846154
1724133 1724133 527969 527969 248540 1 0.153846153846154 
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)
);