consensus_index

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

12 rows where inchi_id = 47439

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
62001 62001 19932 19932 47439 4 0.416397530615761
177529 177529 63276 63276 47439 4 0.452830188679245
359743 359743 122129 122129 47439 7 0.466544195550906
359747 359747 122130 122130 47439 1 0.0972003020664177
507376 507376 202938 202938 47439 6 0.458015267175573
552797 552797 218266 218266 47439 1 0.0856370192307692
556766 556766 219345 219345 47439 1 0.0972003020664177
556771 556771 219346 219346 47439 7 0.466544195550906
708531 708531 251521 251521 47439 8 0.462908011869436
806740 806740 280963 280963 47439 8 0.462908011869436
806744 806744 280964 280964 47439 4 0.452830188679245
1682195 1682195 511303 511303 47439 8 0.462908011869436 
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)
);