consensus_index

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

22 rows where inventory_id = 293147

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
846431 846431 293147 293147 76716 4 0.223872673701101
846432 846432 293147 293147 235057 1 0.0172209749000847
846433 846433 293147 293147 243268 1 0.011782772300058
846434 846434 293147 293147 248549 5 0.156448295534231
846435 846435 293147 293147 248617 2 0.0527672952321373
846436 846436 293147 293147 248621 1 0.0559681684252753
846437 846437 293147 293147 248650 2 0.0299162444018057
846438 846438 293147 293147 248694 2 0.111936336850551
846439 846439 293147 293147 248722 1 0.0447745347402203
846440 846440 293147 293147 248794 2 0.0345443035170503
846441 846441 293147 293147 248922 1 0.0203520612455547
846442 846442 293147 293147 248925 2 0.0289018378971764
846443 846443 293147 293147 248926 2 0.0135493905936085
846444 846444 293147 293147 249033 1 0.0203520612455547
846445 846445 293147 293147 249094 1 0.0223872673701101
846446 846446 293147 293147 249112 1 0.0248747415223446
846447 846447 293147 293147 250834 1 0.0149248449134068
846448 846448 293147 293147 279014 2 0.0166864838900097
846449 846449 293147 293147 291679 2 0.0180990329482172
846450 846450 293147 293147 310144 2 0.039575471424103
846451 846451 293147 293147 326148 2 0.0144509189485882
846452 846452 293147 293147 331553 2 0.0211539792841509 
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)
);