consensus_index

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

15 rows where inchi_id = 34346

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
21264 21264 6270 6270 34346 1 0.3125
219828 219828 76128 76128 34346 1 0.3125
345809 345809 116797 116797 34346 8 0.625
346889 346889 117140 117140 34346 1 0.173913043478261
456849 456849 164161 164161 34346 1 0.17873150710345
480377 480377 175953 175953 34346 8 0.625
596453 596453 232202 232202 34346 1 0.3125
669451 669451 239785 239785 34346 1 0.3125
738440 738440 260279 260279 34346 1 0.304347826086957
738442 738442 260280 260280 34346 1 0.3125
738444 738444 260281 260281 34346 1 0.165745856353591
902025 902025 317678 317678 34346 1 0.168674698795181
907208 907208 320237 320237 34346 4 0.6
959450 959450 345245 345245 34346 1 0.3
1614618 1614618 487486 487486 34346 1 0.3125 
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)
);