consensus_index

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

15 rows where inchi_id = 42677

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
35299 35299 10482 10482 42677 1 0.0875729774812344
150318 150318 53888 53888 42677 1 0.0875729774812344
260459 260459 88228 88228 42677 1 0.0875729774812344
278319 278319 94380 94380 42677 8 0.502113490128201
504665 504665 201863 201863 42677 1 0.0875729774812344
560061 560061 220297 220297 42677 12 0.357508386568083
574377 574377 225040 225040 42677 1 0.0875729774812344
689092 689092 245737 245737 42677 1 0.0875729774812344
703718 703718 250587 250587 42677 12 0.507421472766888
774122 774122 270787 270787 42677 1 0.0875729774812344
778558 778558 272271 272271 42677 1 0.307692307692308
800588 800588 279279 279279 42677 8 0.625
1636462 1636462 494798 494798 42677 1 0.0875729774812344
1644726 1644726 497868 497868 42677 8 0.625
1731652 1731652 530290 530290 42677 1 0.0875729774812344 
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)
);