consensus_index

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

10 rows where inchi_id = 3500

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
23338 23338 6845 6845 3500 8 0.413793103448276
185721 185721 66251 66251 3500 8 0.413793103448276
222685 222685 76957 76957 3500 7 0.620689655172414
431184 431184 155184 155184 3500 7 0.620689655172414
673993 673993 240975 240975 3500 8 0.413793103448276
747400 747400 262857 262857 3500 8 0.413793103448276
747404 747404 262858 262858 3500 8 0.625
747406 747406 262859 262859 3500 7 0.620689655172414
938072 938072 335155 335155 3500 4 0.6
1617894 1617894 488517 488517 3500 8 0.413793103448276 
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)
);