consensus_index

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

9 rows where inchi_id = 18656

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
198028 198028 70417 70417 18656 2 0.630993034743972
260909 260909 88377 88377 18656 6 0.470588235294118
338941 338941 114290 114290 18656 4 0.656703184093677
339896 339896 114641 114641 18656 2 0.305460142507605
341077 341077 115083 115083 18656 1 0.191489361702128
447123 447123 160213 160213 18656 6 0.470588235294118
477604 477604 174202 174202 18656 4 0.656703184093677
478111 478111 174483 174483 18656 2 0.305460142507605
1674275 1674275 508149 508149 18656 3 0.302128015278159 
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)
);