consensus_index

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

12 rows where inventory_id = 387885

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
1146412 1146412 387885 387885 9682 1 0.0317137071401604
1146413 1146413 387885 387885 12877 1 0.158568535700802
1146414 1146414 387885 387885 37672 1 0.026428089283467
1146415 1146415 387885 387885 75174 8 0.317137071401604
1146416 1146416 387885 387885 110401 1 0.0288306428546913
1146417 1146417 387885 387885 131076 1 0.105712357133868
1146418 1146418 387885 387885 147185 1 0.035237452377956
1146419 1146419 387885 387885 149213 1 0.052856178566934
1146420 1146420 387885 387885 149223 1 0.0453052959145148
1146421 1146421 387885 387885 153052 1 0.0634274142803208
1146422 1146422 387885 387885 179842 1 0.079284267850401
1146423 1146423 387885 387885 201475 1 0.0396421339252005 
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)
);