consensus_index

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

12 rows where inventory_id = 74444

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
213989 213989 74444 74444 15970 1 0.0391357532910289
213990 213990 74444 74444 30999 1 0.0684875682593006
213991 213991 74444 74444 54965 1 0.136975136518601
213992 213992 74444 74444 60357 1 0.0304389192263558
213993 213993 74444 74444 74122 1 0.0456583788395337
213994 213994 74444 74444 74123 1 0.136975136518601
213995 213995 74444 74444 74728 9 0.253643630229344
213996 213996 74444 74444 75532 1 0.0273950273037202
213997 213997 74444 74444 75571 1 0.0342437841296503
213998 213998 74444 74444 95715 1 0.0547900546074405
213999 213999 74444 74444 142188 2 0.0913167576790675
214000 214000 74444 74444 226665 1 0.0684875682593006 
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)
);