consensus_index

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

11 rows where inventory_id = 4781

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15719 15719 4781 4781 54009 7 0.301098081014614
15720 15720 4781 4781 101864 1 0.0831098084588857
15721 15721 4781 4781 176673 1 0.0369376926483936
15722 15722 4781 4781 232270 2 0.0725441882392619
15723 15723 4781 4781 261595 1 0.0554065389725905
15724 15724 4781 4781 262660 1 0.0415549042294429
15725 15725 4781 4781 314248 2 0.235070036577573
15726 15726 4781 4781 315467 1 0.0664878467671086
15727 15727 4781 4781 317246 1 0.0332439233835543
15728 15728 4781 4781 317270 1 0.0302217485305039
15729 15729 4781 4781 320650 1 0.0277032694862952 
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)
);