consensus_index

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

27 rows where inchi_id = 83768

✎ View and edit SQL

Download this data as a CSV Spreadsheet (All Rows)

Link rowid ▼ inventory_id inchi_id consensus_score consensus_count
18930 18930 5554 5554 83768 8 0.467743222393851
57237 57237 17981 17981 83768 5 0.697268785702643
87465 87465 31308 31308 83768 8 0.467743222393851
159148 159148 57292 57292 83768 8 0.419610364925448
181994 181994 64987 64987 83768 2 0.108113027381255
216686 216686 75208 75208 83768 8 0.419610364925448
337511 337511 113765 113765 83768 6 0.458015267175573
503321 503321 201442 201442 83768 8 0.419610364925448
688302 688302 245461 245461 83768 1 0.0683012259194396
733453 733453 258651 258651 83768 8 0.467743222393851
773019 773019 270422 270422 83768 1 0.0683012259194396
773025 773025 270423 270423 83768 1 0.0681818181818182
853038 853038 295115 295115 83768 8 0.467743222393851
853042 853042 295116 295116 83768 8 0.375903614457831
894584 894584 314002 314002 83768 4 0.452830188679245
1037747 1037747 367720 367720 83768 1 0.0683012259194396
1171485 1171485 393451 393451 83768 8 0.467743222393851
1257329 1257329 414192 414192 83768 1 0.0683012259194396
1427185 1427185 445121 445121 83768 8 0.467743222393851
1427189 1427189 445122 445122 83768 8 0.467743222393851
1482878 1482878 458805 458805 83768 1 0.0683012259194396
1585118 1585118 478611 478611 83768 8 0.467743222393851
1595715 1595715 481677 481677 83768 1 0.0683012259194396
1606509 1606509 485353 485353 83768 8 0.467743222393851
1612244 1612244 486709 486709 83768 8 0.467743222393851
1673056 1673056 507707 507707 83768 5 0.697268785702643
1717764 1717764 526080 526080 83768 8 0.467743222393851 
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)
);