consensus_index

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

10 rows where inventory_id = 111345

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
330281 330281 111345 111345 23429 6 0.334284008755057
330282 330282 111345 111345 73281 1 0.167142004377529
330283 330283 111345 111345 93123 1 0.0835710021887643
330284 330284 111345 111345 122237 1 0.0557140014591762
330285 330285 111345 111345 126710 1 0.0668568017510115
330286 330286 111345 111345 154056 1 0.111428002918352
330287 330287 111345 111345 169847 1 0.0477548583935796
330288 330288 111345 111345 204157 1 0.0417855010943822
330289 330289 111345 111345 206504 1 0.0371426676394508
330290 330290 111345 111345 206511 1 0.0334284008755057 
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)
);