home / zeropm-v0-0-4

consensus_index

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

28 rows where inchi_id = 40664

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
27767 27767 8062 8062 40664 2 0.0679625557060328
29043 29043 8407 8407 40664 1 0.198300283286119
171133 171133 61042 61042 40664 1 0.198300283286119
172314 172314 61548 61548 40664 3 0.0553792476070172
209859 209859 73903 73903 40664 1 0.0688732770039947
233060 233060 79697 79697 40664 4 0.457271055267315
234029 234029 79972 79972 40664 2 0.0348597625078719
238498 238498 81154 81154 40664 1 0.197869101978691
422436 422436 153115 153115 40664 1 0.0688732770039947
436305 436305 156546 156546 40664 3 0.452223123060018
436501 436501 156599 156599 40664 2 0.0348597625078719
437964 437964 156999 156999 40664 1 0.183328132441087
437970 437970 157000 157000 40664 1 0.197869101978691
553617 553617 218476 218476 40664 1 0.0617387720686252
702795 702795 250289 250289 40664 5 0.281868995186329
704334 704334 250766 250766 40664 2 0.0428693091610018
710067 710067 251927 251927 40664 3 0.164684457060587
799003 799003 278731 278731 40664 5 0.281868995186329
799007 799007 278732 278732 40664 3 0.315789473684211
801589 801589 279612 279612 40664 2 0.0428693091610018
801599 801599 279613 279613 40664 1 0.0241734752431176
809119 809119 281712 281712 40664 1 0.198300283286119
809125 809125 281713 281713 40664 1 0.196078431372549
865192 865192 298730 298730 40664 1 0.180751565775787
915076 915076 324111 324111 40664 1 0.0309427504474893
917659 917659 325282 325282 40664 1 0.196078431372549
1623401 1623401 490227 490227 40664 1 0.0302400175541439
1725750 1725750 528409 528409 40664 1 0.198300283286119
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)
);
Powered by Datasette · Queries took 498.092ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website