consensus_index

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

10 rows where inventory_id = 5065

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
17312 17312 5065 5065 44305 1 0.0298924279927298
17313 17313 5065 5065 75450 6 0.239139423941839
17314 17314 5065 5065 115141 2 0.239139423941839
17315 17315 5065 5065 173469 1 0.0398565706569731
17316 17316 5065 5065 206515 1 0.0797131413139462
17317 17317 5065 5065 215016 2 0.0976282610067686
17318 17318 5065 5065 215017 1 0.119569711970919
17319 17319 5065 5065 238920 1 0.0597848559854596
17320 17320 5065 5065 243840 1 0.0478278847883677
17321 17321 5065 5065 284021 1 0.0341627748488341 
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)
);