consensus_index

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

12 rows where inventory_id = 214000

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
540012 540012 214000 214000 15970 1 0.0391357532910289
540013 540013 214000 214000 30999 1 0.0684875682593006
540014 540014 214000 214000 54965 1 0.136975136518601
540015 540015 214000 214000 60357 1 0.0304389192263558
540016 540016 214000 214000 74122 1 0.0456583788395337
540017 540017 214000 214000 74123 1 0.136975136518601
540018 540018 214000 214000 74728 9 0.253643630229344
540019 540019 214000 214000 75532 1 0.0273950273037202
540020 540020 214000 214000 75571 1 0.0342437841296503
540021 540021 214000 214000 95715 1 0.0547900546074405
540022 540022 214000 214000 142188 2 0.0913167576790675
540023 540023 214000 214000 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)
);