consensus_index

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

22 rows where inchi_id = 119344

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
55190 55190 17280 17280 119344 2 0.384615384615385
89786 89786 32061 32061 119344 2 0.384615384615385
157675 157675 56716 56716 119344 2 0.384615384615385
327762 327762 110483 110483 119344 2 0.382978723404255
473243 473243 171826 171826 119344 2 0.382978723404255
528503 528503 209953 209953 119344 2 0.287298094316321
528869 528869 210048 210048 119344 1 0.299688908435756
568737 568737 223098 223098 119344 1 0.299688908435756
572401 572401 224318 224318 119344 2 0.378378378378378
691073 691073 246523 246523 119344 3 0.385964912280702
777242 777242 271828 271828 119344 2 0.378378378378378
777245 777245 271829 271829 119344 2 0.384615384615385
777248 777248 271830 271830 119344 2 0.378378378378378
1039999 1039999 368471 368471 119344 2 0.384615384615385
1040002 1040002 368472 368472 119344 2 0.384615384615385
1259922 1259922 415072 415072 119344 2 0.384615384615385
1259925 1259925 415073 415073 119344 2 0.384615384615385
1484469 1484469 459366 459366 119344 2 0.384615384615385
1484472 1484472 459367 459367 119344 2 0.384615384615385
1596322 1596322 481919 481919 119344 2 0.384615384615385
1668838 1668838 506168 506168 119344 2 0.384615384615385
1749203 1749203 535797 535797 119344 2 0.384615384615385 
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)
);