consensus_index

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

10 rows where inventory_id = 374322

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1059463 1059463 374322 374322 46622 7 0.336607987619264
1059464 1059464 374322 374322 122163 1 0.042075998452408
1059465 1059465 374322 374322 141291 2 0.137419635502046
1059466 1059466 374322 374322 171103 2 0.137419635502046
1059467 1059467 374322 374322 197927 1 0.0374008875132516
1059468 1059468 374322 374322 198053 2 0.0687098177510229
1059469 1059469 374322 374322 217155 2 0.0752678342086082
1059470 1059470 374322 374322 217162 1 0.0673215975238528
1059471 1059471 374322 374322 233320 1 0.0336607987619264
1059472 1059472 374322 374322 250027 1 0.0480868553741806 
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)
);