consensus_index

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

10 rows where inventory_id = 309501

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
887703 887703 309501 309501 11497 4 0.221069311619987
887704 887704 309501 309501 18558 1 0.0625278437434939
887705 887705 309501 309501 136433 2 0.104213072905823
887706 887706 309501 309501 139586 2 0.31263921871747
887707 887707 309501 309501 167856 1 0.0781598046793674
887708 887708 309501 309501 168935 1 0.0347376909686077
887709 887709 309501 309501 169093 1 0.031263921871747
887710 887710 309501 309501 218705 1 0.0446627455310671
887711 887711 309501 309501 258495 1 0.0521065364529116
887712 887712 309501 309501 279939 1 0.0390799023396837 
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)
);