consensus_index

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

27 rows where inchi_id = 423

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
47560 47560 14640 14640 423 2 0.265245510952746
122258 122258 42470 42470 423 2 0.415239576400731
122260 122260 42471 42471 423 4 0.288079907960716
157872 157872 56819 56819 423 4 0.288079907960716
162274 162274 58173 58173 423 1 0.203780232622157
300297 300297 101683 101683 423 2 0.265245510952746
595920 595920 232043 232043 423 2 0.267852720763324
669362 669362 239767 239767 423 4 0.288079907960716
738261 738261 260243 260243 423 4 0.229078161828922
738267 738267 260244 260244 423 3 0.249193761175683
738273 738273 260245 260245 423 2 0.267852720763324
738278 738278 260246 260246 423 4 0.231599126469273
738284 738284 260247 260247 423 4 0.288079907960716
949127 949127 340357 340357 423 2 0.270432647249802
969752 969752 351833 351833 423 4 0.288079907960716
969757 969757 351834 351834 423 4 0.288079907960716
1180290 1180290 395880 395880 423 4 0.288079907960716
1180295 1180295 395881 395881 423 4 0.288079907960716
1180300 1180300 395882 395882 423 4 0.288079907960716
1180305 1180305 395883 395883 423 4 0.288079907960716
1180310 1180310 395884 395884 423 4 0.288079907960716
1180315 1180315 395885 395885 423 4 0.288079907960716
1180320 1180320 395886 395886 423 4 0.288079907960716
1435032 1435032 447306 447306 423 4 0.288079907960716
1589371 1589371 479786 479786 423 4 0.288079907960716
1654665 1654665 501359 501359 423 4 0.288079907960716
1742089 1742089 533603 533603 423 4 0.288079907960716 
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)
);