consensus_index

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

9 rows where inventory_id = 117483

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
347877 347877 117483 117483 32609 1 0.0399655840306011
347878 347878 117483 117483 35856 5 0.279759088214207
347879 347879 117483 117483 51344 1 0.0310843431349119
347880 347880 117483 117483 121900 1 0.279759088214207
347881 347881 117483 117483 147008 3 0.0881185910351192
347882 347882 117483 117483 147381 1 0.0559518176428415
347883 347883 117483 117483 242750 2 0.0932530294047358
347884 347884 117483 117483 253035 1 0.0466265147023679
347885 347885 117483 117483 289347 2 0.0699397720535519 
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)
);