consensus_index

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

10 rows where inventory_id = 392516

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1168743 1168743 392516 392516 46528 3 0.211204802174614
1168744 1168744 392516 392516 81277 5 0.185313883588293
1168745 1168745 392516 392516 142861 3 0.12088457257247
1168746 1168746 392516 392516 182554 1 0.152305017591599
1168747 1168747 392516 392516 183469 1 0.0380762543978998
1168748 1168748 392516 392516 189605 1 0.0338455594647998
1168749 1168749 392516 392516 195229 1 0.0609220070366396
1168750 1168750 392516 392516 231209 2 0.0879333429054404
1168751 1168751 392516 392516 290463 1 0.0507683391971997
1168752 1168752 392516 392516 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)
);