consensus_index

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

10 rows where inventory_id = 33115

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
93116 93116 33115 33115 1066 3 0.13021541002377
93117 93117 33115 33115 99498 1 0.26043082004754
93118 93118 33115 33115 139059 6 0.12546156885875
93119 93119 33115 33115 139060 3 0.0788723676860911
93120 93120 33115 33115 248390 3 0.0993729563027544
93121 93121 33115 33115 287407 1 0.02893675778306
93122 93122 33115 33115 314231 1 0.13021541002377
93123 93123 33115 33115 317031 1 0.0651077050118851
93124 93124 33115 33115 326156 1 0.026043082004754
93125 93125 33115 33115 332771 2 0.0440208431251231 
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)
);