consensus_index

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

12 rows where inventory_id = 314003

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
894586 894586 314003 314003 14028 4 0.302781033074066
894587 894587 314003 314003 75122 1 0.0378476291342582
894588 894588 314003 314003 136242 1 0.0756952582685165
894589 894589 314003 314003 137839 1 0.0432544332962951
894590 894590 314003 314003 158402 2 0.12360983913737
894591 894591 314003 314003 168959 1 0.151390516537033
894592 894592 314003 314003 196723 1 0.0605562066148132
894593 894593 314003 314003 197793 1 0.0275255484612787
894594 894594 314003 314003 218186 2 0.0713661739004468
894595 894595 314003 314003 238170 1 0.0302781033074066
894596 894596 314003 314003 258386 1 0.0252317527561722
894597 894597 314003 314003 259502 1 0.0336423370082295 
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)
);