consensus_index

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

10 rows where inventory_id = 392540

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1168983 1168983 392540 392540 46528 3 0.211204802174614
1168984 1168984 392540 392540 81277 5 0.185313883588293
1168985 1168985 392540 392540 142861 3 0.12088457257247
1168986 1168986 392540 392540 182554 1 0.152305017591599
1168987 1168987 392540 392540 183469 1 0.0380762543978998
1168988 1168988 392540 392540 189605 1 0.0338455594647998
1168989 1168989 392540 392540 195229 1 0.0609220070366396
1168990 1168990 392540 392540 231209 2 0.0879333429054404
1168991 1168991 392540 392540 290463 1 0.0507683391971997
1168992 1168992 392540 392540 308242 1 0.0435157193118854 
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)
);