consensus_index

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

12 rows where inventory_id = 123005

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
362203 362203 123005 123005 48174 1 0.047449937609623
362204 362204 123005 123005 49292 4 0.181906862595507
362205 362205 123005 123005 114184 2 0.0735091272562603
362206 362206 123005 123005 127053 5 0.284699625657738
362207 362207 123005 123005 212669 1 0.0284699625657738
362208 362208 123005 123005 212880 1 0.0406713750939625
362209 362209 123005 123005 217816 1 0.0237249688048115
362210 362210 123005 123005 230501 1 0.0258817841507034
362211 362211 123005 123005 230511 1 0.0711749064144345
362212 362212 123005 123005 230667 2 0.142349812828869
362213 362213 123005 123005 265326 1 0.0316332917397486
362214 362214 123005 123005 267308 1 0.0355874532072172 
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)
);