home / zeropm-v0-0-4

consensus_index

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

40 rows where inchi_id = 49242

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
23482 23482 6869 6869 49242 1 0.192307692307692
28992 28992 8387 8387 49242 8 0.519685039370079
111765 111765 39103 39103 49242 8 0.519685039370079
122621 122621 42619 42619 49242 1 0.192307692307692
158524 158524 57109 57109 49242 2 0.194805194805195
198233 198233 70476 70476 49242 8 0.519685039370079
222857 222857 76989 76989 49242 1 0.192307692307692
238411 238411 81125 81125 49242 8 0.519685039370079
418408 418408 149101 149101 49242 6 0.875
431335 431335 155210 155210 49242 1 0.192307692307692
437924 437924 156984 156984 49242 4 0.506024096385542
555472 555472 218962 218962 49242 7 0.517241379310345
591766 591766 230822 230822 49242 1 0.192307692307692
596247 596247 232137 232137 49242 6 0.875
674218 674218 241021 241021 49242 2 0.194805194805195
709931 709931 251888 251888 49242 8 0.519685039370079
747812 747812 262960 262960 49242 1 0.192307692307692
808905 808905 281627 281627 49242 8 0.414893617021277
808909 808909 281628 281628 49242 5 0.51063829787234
808912 808912 281629 281629 49242 8 0.519685039370079
885067 885067 308157 308157 49242 1 0.1875
915570 915570 324416 324416 49242 2 0.630993034743972
994073 994073 356266 356266 49242 1 0.192307692307692
994076 994076 356267 356267 49242 1 0.192307692307692
1061863 1061863 374936 374936 49242 8 0.519685039370079
1061866 1061866 374937 374937 49242 8 0.519685039370079
1204417 1204417 400391 400391 49242 1 0.192307692307692
1204420 1204420 400392 400392 49242 1 0.192307692307692
1285722 1285722 422641 422641 49242 8 0.519685039370079
1285725 1285725 422642 422642 49242 8 0.519685039370079
1285728 1285728 422643 422643 49242 8 0.519685039370079
1450265 1450265 450291 450291 49242 1 0.192307692307692
1500435 1500435 464158 464158 49242 8 0.519685039370079
1500438 1500438 464159 464159 49242 8 0.519685039370079
1591348 1591348 480320 480320 49242 1 0.192307692307692
1600551 1600551 483503 483503 49242 8 0.519685039370079
1618054 1618054 488548 488548 49242 1 0.192307692307692
1625259 1625259 490777 490777 49242 8 0.519685039370079
1720708 1720708 526997 526997 49242 1 0.192307692307692
1725707 1725707 528388 528388 49242 8 0.519685039370079
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 1009.693ms · Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website