consensus_index

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

24 rows where inventory_id = 42041

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
120869 120869 42041 42041 3251 1 0.0146415349429985
120870 120870 42041 42041 12441 2 0.067626353125516
120871 120871 42041 42041 78321 8 0.234264559087976
120872 120872 42041 42041 136391 1 0.0468529118175952
120873 120873 42041 42041 136469 2 0.117132279543988
120874 120874 42041 42041 137705 2 0.0780881863626587
120875 120875 42041 42041 137820 1 0.0195220465906647
120876 120876 42041 42041 160862 1 0.0468529118175952
120877 120877 42041 42041 169425 1 0.029283069885997
120878 120878 42041 42041 189264 1 0.0156176372725317
120879 120879 42041 42041 197768 1 0.0180203506990751
120880 120880 42041 42041 197770 1 0.0167331827919983
120881 120881 42041 42041 212760 1 0.0130146977271098
120882 120882 42041 42041 237386 1 0.029283069885997
120883 120883 42041 42041 238382 2 0.0442718403102129
120884 120884 42041 42041 239420 2 0.0442718403102129
120885 120885 42041 42041 259776 2 0.021940886219824
120886 120886 42041 42041 285905 2 0.0174610492946577
120887 120887 42041 42041 286488 1 0.0137802681816456
120888 120888 42041 42041 310079 1 0.0234264559087976
120889 120889 42041 42041 315679 1 0.0260293954542196
120890 120890 42041 42041 315681 1 0.0234264559087976
120891 120891 42041 42041 315682 1 0.0212967780989069
120892 120892 42041 42041 333050 1 0.0111554551946655 
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)
);