consensus_index

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

22 rows where inchi_id = 21396

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
55195 55195 17282 17282 21396 7 0.352094180021372
123151 123151 42787 42787 21396 5 0.312580113180366
171171 171171 61049 61049 21396 9 0.260024795085582
327785 327785 110492 110492 21396 7 0.383833161178803
443822 443822 159104 159104 21396 2 0.260869565217391
465262 465262 167968 167968 21396 4 0.298199747337685
473256 473256 171834 171834 21396 7 0.383833161178803
473539 473539 172009 172009 21396 1 0.272727272727273
572381 572381 224313 224313 21396 7 0.383833161178803
691089 691089 246530 246530 21396 5 0.312580113180366
777266 777266 271838 271838 21396 5 0.262254934635569
777272 777272 271839 271839 21396 5 0.312580113180366
939122 939122 335611 335611 21396 3 0.317222136314584
1040038 1040038 368483 368483 21396 5 0.312580113180366
1040042 1040042 368484 368484 21396 5 0.312580113180366
1259954 1259954 415083 415083 21396 5 0.312580113180366
1259958 1259958 415084 415084 21396 5 0.312580113180366
1484493 1484493 459374 459374 21396 5 0.312580113180366
1484497 1484497 459375 459375 21396 5 0.312580113180366
1596336 1596336 481924 481924 21396 5 0.312580113180366
1668852 1668852 506174 506174 21396 5 0.312580113180366
1749213 1749213 535801 535801 21396 3 0.317222136314584 
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)
);