home / zeropm-v0-0-4

consensus_index

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

33 rows where inchi_id = 42365

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
14429 14429 4457 4457 42365 8 0.396600566572238
22138 22138 6508 6508 42365 1 0.0700583819849875
27679 27679 8035 8035 42365 8 0.396600566572238
81792 81792 29449 29449 42365 8 0.396600566572238
94802 94802 33645 33645 42365 1 0.0700583819849875
171446 171446 61177 61177 42365 2 0.0965710385063796
182669 182669 65172 65172 42365 12 0.399113082039911
221111 221111 76525 76525 42365 2 0.112956193772745
233280 233280 79769 79769 42365 8 0.320815039282519
354923 354923 120167 120167 42365 1 0.148571428571429
429877 429877 154830 154830 42365 2 0.112956193772745
560214 560214 220349 220349 42365 8 0.320815039282519
593812 593812 231402 231402 42365 2 0.112956193772745
671962 671962 240448 240448 42365 1 0.0700583819849875
692391 692391 246923 246923 42365 2 0.197396136013803
703558 703558 250540 250540 42365 8 0.396600566572238
743291 743291 261673 261673 42365 1 0.0839160839160839
743296 743296 261674 261674 42365 1 0.0700583819849875
743302 743302 261675 261675 42365 1 0.0839160839160839
743307 743307 261676 261676 42365 1 0.0839160839160839
800342 800342 279209 279209 42365 8 0.396600566572238
800348 800348 279210 279210 42365 8 0.320815039282519
944676 944676 338324 338324 42365 1 0.193548387096774
953759 953759 342404 342404 42365 1 0.0835266821345708
977761 977761 353453 353453 42365 1 0.084736556219446
1186137 1186137 397408 397408 42365 1 0.084736556219446
1186142 1186142 397409 397409 42365 1 0.084736556219446
1186147 1186147 397410 397410 42365 1 0.084736556219446
1439098 1439098 448358 448358 42365 1 0.084736556219446
1590259 1590259 480026 480026 42365 1 0.084736556219446
1615518 1615518 487775 487775 42365 8 0.396600566572238
1616553 1616553 488124 488124 42365 1 0.084736556219446
1719645 1719645 526670 526670 42365 1 0.0835266821345708
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)
);
Powered by Datasette · Queries took 1115.521ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website