consensus_index

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

9 rows where inventory_id = 53366

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
148426 148426 53366 53366 16362 3 0.152043269902554
148427 148427 53366 53366 117269 5 0.192402977413631
148428 148428 53366 53366 180034 2 0.0534581611004774
148429 148429 53366 53366 207277 1 0.0790656865320542
148430 148430 53366 53366 248639 3 0.120676823293999
148431 148431 53366 53366 248824 5 0.208655597699471
148432 148432 53366 53366 248952 2 0.0645568627221256
148433 148433 53366 53366 249068 1 0.0527104576880361
148434 148434 53366 53366 333499 1 0.0632525492256433 
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)
);