consensus_index

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

19 rows where inventory_id = 273849

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
783337 783337 273849 273849 27169 2 0.0854961530041894
783338 783338 273849 273849 35027 1 0.0123403067379116
783339 783339 273849 273849 64734 1 0.0164537423172154
783340 783340 273849 273849 92940 1 0.0185104601068673
783341 783341 273849 273849 101402 1 0.0148083680854939
783342 783342 273849 273849 101859 1 0.0370209202137347
783343 783343 273849 273849 107340 1 0.0740418404274693
783344 783344 273849 273849 128527 1 0.148083680854939
783345 783345 273849 273849 134415 1 0.0493612269516462
783346 783346 273849 273849 134757 1 0.0246806134758231
783347 783347 273849 273849 138820 1 0.0296167361709877
783348 783348 273849 273849 229467 1 0.0296167361709877
783349 783349 273849 273849 229506 2 0.148083680854939
783350 783350 273849 273849 229512 1 0.0740418404274693
783351 783351 273849 273849 230005 1 0.0134621528049944
783352 783352 273849 273849 237367 1 0.148083680854939
783353 783353 273849 273849 255589 1 0.0211548115507055
783354 783354 273849 273849 270905 1 0.0370209202137347
783355 783355 273849 273849 295284 1 0.0113910523734568 
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)
);