consensus_index

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

10 rows where inventory_id = 101211

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
299482 299482 101211 101211 46528 3 0.211204802174614
299483 299483 101211 101211 81277 5 0.185313883588293
299484 299484 101211 101211 142861 3 0.12088457257247
299485 299485 101211 101211 182554 1 0.152305017591599
299486 299486 101211 101211 183469 1 0.0380762543978998
299487 299487 101211 101211 189605 1 0.0338455594647998
299488 299488 101211 101211 195229 1 0.0609220070366396
299489 299489 101211 101211 231209 2 0.0879333429054404
299490 299490 101211 101211 290463 1 0.0507683391971997
299491 299491 101211 101211 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)
);