consensus_index

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

12 rows where inchi_id = 23170

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
217259 217259 75385 75385 23170 2 0.145374713429071
264079 264079 89457 89457 23170 6 0.615384615384615
264641 264641 89657 89657 23170 1 0.310344827586207
427172 427172 154036 154036 23170 2 0.145374713429071
692572 692572 247040 247040 23170 1 0.241379310344828
742003 742003 261352 261352 23170 1 0.00232036430154418
779478 779478 272582 272582 23170 1 0.239130434782609
779481 779481 272583 272583 23170 1 0.3
786170 786170 274706 274706 23170 1 0.00236990324588375
834666 834666 289659 289659 23170 1 0.00267723057853082
894781 894781 314090 314090 23170 1 0.3
1638228 1638228 495455 495455 23170 1 0.239130434782609 
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)
);