consensus_index

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

21 rows where inchi_id = 201483

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
33520 33520 9878 9878 201483 3 0.375078661386657
112814 112814 39406 39406 201483 1 0.0992283361915932
112816 112816 39407 39407 201483 3 0.375078661386657
161818 161818 58061 58061 201483 3 0.138461165498034
255536 255536 86727 86727 201483 1 0.258620689655172
303679 303679 102703 102703 201483 1 0.0992283361915932
444838 444838 159430 159430 201483 1 0.258620689655172
463632 463632 166564 166564 201483 1 0.0992283361915932
584172 584172 228267 228267 201483 3 0.375078661386657
591368 591368 230708 230708 201483 1 0.0992283361915932
680419 680419 243095 243095 201483 4 0.309862390124858
759009 759009 266423 266423 201483 1 0.258620689655172
759014 759014 266424 266424 201483 2 0.13579648178934
759017 759017 266425 266425 201483 3 0.375078661386657
948544 948544 340099 340099 201483 1 0.253012048192771
1017637 1017637 362724 362724 201483 3 0.375078661386657
1232494 1232494 408214 408214 201483 3 0.375078661386657
1467763 1467763 455070 455070 201483 3 0.375078661386657
1593539 1593539 481006 481006 201483 3 0.375078661386657
1634136 1634136 493958 493958 201483 3 0.375078661386657
1730001 1730001 529800 529800 201483 1 0.253012048192771 
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)
);