consensus_index

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

9 rows where inventory_id = 12907

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
42442 42442 12907 12907 19399 4 0.17766635026209
42443 42443 12907 12907 53474 1 0.0330674337705674
42444 42444 12907 12907 75466 2 0.116911033278026
42445 42445 12907 12907 99489 6 0.330674337705674
42446 42446 12907 12907 213190 2 0.134997233068611
42447 42447 12907 12907 272348 3 0.0591181918881636
42448 42448 12907 12907 284949 2 0.0551123896176123
42449 42449 12907 12907 319535 1 0.0413342922132092
42450 42450 12907 12907 323512 1 0.0367415930784082 
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)
);