consensus_index

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

9 rows where inventory_id = 214461

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
541686 541686 214461 214461 72781 10 0.117351849901922
541687 541687 214461 214461 178274 1 0.0382709612174055
541688 541688 214461 214461 204449 2 0.220957497610148
541689 541689 214461 214461 223492 3 0.120545974093799
541690 541690 214461 214461 239134 2 0.0956774030435139
541691 541691 214461 214461 249087 2 0.171152941692754
541692 541692 214461 214461 270986 2 0.0590533752211497
541693 541693 214461 214461 274704 2 0.069872895853928
541694 541694 214461 214461 333397 2 0.0347917829249141 
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)
);