consensus_index

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

10 rows where inventory_id = 525425

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1714831 1714831 525425 525425 31914 1 0.0458280312359245
1714832 1714832 525425 525425 31916 2 0.160398109325736
1714833 1714833 525425 525425 32807 2 0.080199054662868
1714834 1714834 525425 525425 47110 1 0.053466036441912
1714835 1714835 525425 525425 50140 1 0.0641592437302944
1714836 1714836 525425 525425 51329 10 0.257516457567059
1714837 1714837 525425 525425 105472 1 0.160398109325736
1714838 1714838 525425 525425 202724 1 0.0641592437302944
1714839 1714839 525425 525425 220775 1 0.0458280312359245
1714840 1714840 525425 525425 226944 1 0.053466036441912 
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)
);