consensus_index

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

22 rows where inventory_id = 289665

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
834870 834870 289665 289665 58325 1 0.0134074324991519
834871 834871 289665 289665 60357 1 0.134074324991519
834872 834872 289665 289665 69414 4 0.268148649983037
834873 834873 289665 289665 148787 1 0.0335185812478796
834874 834874 289665 289665 158520 1 0.0243771499984579
834875 834875 289665 289665 158522 1 0.0223457208319198
834876 834876 289665 289665 158737 1 0.0167592906239398
834877 834877 289665 289665 158768 1 0.0141130868412125
834878 834878 289665 289665 158795 1 0.0268148649983037
834879 834879 289665 289665 158836 1 0.0157734499990022
834880 834880 289665 289665 160221 1 0.0148971472212798
834881 834881 289665 289665 160366 1 0.0178765766655358
834882 834882 289665 289665 160790 1 0.0191534749987884
834883 834883 289665 289665 160914 1 0.0383069499975767
834884 834884 289665 289665 167331 1 0.0297942944425597
834885 834885 289665 289665 169827 1 0.089382883327679
834886 834886 289665 289665 169829 1 0.0670371624957593
834887 834887 289665 289665 172030 1 0.0206268192294644
834888 834888 289665 289665 221141 1 0.0536297299966074
834889 834889 289665 289665 237861 1 0.0127689833325256
834890 834890 289665 289665 240508 1 0.0446914416638395
834891 834891 289665 289665 335233 1 0.012188574999229 
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)
);