consensus_index

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

10 rows where inventory_id = 417634

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1268843 1268843 417634 417634 29376 2 0.136440310003946
1268844 1268844 417634 417634 119856 3 0.216585491631131
1268845 1268845 417634 417634 186567 2 0.272880620007891
1268846 1268846 417634 417634 192674 1 0.0454801033346485
1268847 1268847 417634 417634 239282 1 0.0303200688897657
1268848 1268848 417634 417634 253591 1 0.038982945715413
1268849 1268849 417634 417634 270914 2 0.111403046618941
1268850 1268850 417634 417634 271362 2 0.0704574731195545
1268851 1268851 417634 417634 292673 1 0.0341100775009864
1268852 1268852 417634 417634 340451 1 0.0272880620007891 
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)
);