home / zeropm-v0-0-4

consensus_index

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

34 rows where inchi_id = 54597

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
15865 15865 4808 4808 54597 1 0.037774416570601
22896 22896 6723 6723 54597 1 0.170984455958549
42277 42277 12864 12864 54597 6 0.341968911917098
87913 87913 31442 31442 54597 6 0.341968911917098
89395 89395 31944 31944 54597 1 0.170984455958549
92602 92602 32987 32987 54597 1 0.037774416570601
186101 186101 66372 66372 54597 1 0.037774416570601
193768 193768 68859 68859 54597 6 0.341968911917098
193851 193851 68885 68885 54597 1 0.170984455958549
211452 211452 74069 74069 54597 1 0.0467845189171906
222101 222101 76805 76805 54597 1 0.170984455958549
287065 287065 97233 97233 54597 6 0.341968911917098
423424 423424 153210 153210 54597 1 0.046356918308136597
430693 430693 155060 155060 54597 1 0.170984455958549
456587 456587 164066 164066 54597 6 0.341968911917098
517683 517683 207195 207195 54597 1 0.170984455958549
517687 517687 207196 207196 54597 1 0.170984455958549
551037 551037 217768 217768 54597 6 0.341968911917098
592621 592621 231041 231041 54597 1 0.170984455958549
598038 598038 235569 235569 54597 1 0.171806167400881
673300 673300 240805 240805 54597 1 0.172131147540984
715176 715176 253098 253098 54597 6 0.341968911917098
716528 716528 253453 253453 54597 1 0.037774416570601
746083 746083 262464 262464 54597 1 0.170984455958549
746087 746087 262465 262465 54597 1 0.169014084507042
746091 746091 262466 262466 54597 1 0.16671349196457
817497 817497 283840 283840 54597 6 0.341968911917098
817501 817501 283841 283841 54597 3 0.336
819476 819476 284432 284432 54597 1 0.037774416570601
819489 819489 284433 284433 54597 1 0.0448005454047827
909906 909906 321351 321351 54597 1 0.0462838509098984
927067 927067 329723 329723 54597 1 0.168
1609136 1609136 485918 485918 54597 1 0.037774416570601
1617392 1617392 488373 488373 54597 1 0.170454545454545
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 1500.267ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website