consensus_index

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

38 rows where inchi_id = 75470

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14422 14422 4455 4455 75470 7 0.45993031358885
17369 17369 5079 5079 75470 7 0.45993031358885
109348 109348 38257 38257 75470 7 0.45993031358885
182611 182611 65150 65150 75470 9 0.442807964882833
214490 214490 74567 74567 75470 8 0.376681614349776
539136 539136 213772 213772 75470 10 0.377952755905512
729433 729433 257382 257382 75470 7 0.45993031358885
845294 845294 292794 292794 75470 7 0.45993031358885
845298 845298 292795 292795 75470 8 0.376681614349776
947704 947704 339739 339739 75470 4 0.452830188679245
1163474 1163474 390742 390742 75470 8 0.461538461538462
1163478 1163478 390743 390743 75470 8 0.461538461538462
1163482 1163482 390744 390744 75470 8 0.461538461538462
1418305 1418305 442011 442011 75470 8 0.461538461538462
1418309 1418309 442012 442012 75470 8 0.461538461538462
1418313 1418313 442013 442013 75470 8 0.461538461538462
1418317 1418317 442014 442014 75470 8 0.461538461538462
1418321 1418321 442015 442015 75470 8 0.461538461538462
1418325 1418325 442016 442016 75470 8 0.461538461538462
1418329 1418329 442017 442017 75470 8 0.461538461538462
1418333 1418333 442018 442018 75470 8 0.461538461538462
1418337 1418337 442019 442019 75470 8 0.461538461538462
1418341 1418341 442020 442020 75470 8 0.461538461538462
1418345 1418345 442021 442021 75470 8 0.461538461538462
1418349 1418349 442022 442022 75470 8 0.461538461538462
1418353 1418353 442023 442023 75470 8 0.461538461538462
1418357 1418357 442024 442024 75470 8 0.461538461538462
1418361 1418361 442025 442025 75470 8 0.461538461538462
1418365 1418365 442026 442026 75470 8 0.461538461538462
1418369 1418369 442027 442027 75470 8 0.461538461538462
1418373 1418373 442028 442028 75470 8 0.461538461538462
1418377 1418377 442029 442029 75470 8 0.461538461538462
1579314 1579314 476433 476433 75470 8 0.461538461538462
1579318 1579318 476434 476434 75470 8 0.461538461538462
1579322 1579322 476435 476435 75470 8 0.461538461538462
1605631 1605631 485039 485039 75470 8 0.461538461538462
1610838 1610838 486239 486239 75470 8 0.461538461538462
1716923 1716923 525815 525815 75470 7 0.45993031358885 
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)
);