consensus_index

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

10 rows where inventory_id = 41143

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
117888 117888 41143 41143 1303 1 0.0786236895159959
117889 117889 41143 41143 3314 1 0.0786236895159959
117890 117890 41143 41143 18534 5 0.178756843079347
117891 117891 41143 41143 43742 1 0.0471742137095976
117892 117892 41143 41143 73578 1 0.0336958669354268
117893 117893 41143 41143 76366 1 0.117935534273994
117894 117894 41143 41143 144143 1 0.039311844757998
117895 117895 41143 41143 144194 1 0.0589677671369969
117896 117896 41143 41143 190546 4 0.235871068547988
117897 117897 41143 41143 228445 1 0.117935534273994 
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)
);