contig_metadata
7 rows where bioproject = "PRJNA744060", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | analysis_used | target | taxid | gene | allele | pident | sumperc_cov | alnlen | mismatch | qcov | gapopen | qstart | qend | tstart | tend | target_title | analysis | sumalnlen | maxbits | bits_percmax | tax_superkingdom | tax_clade | tax_kingdom | tax_phylum | tax_class | tax_order | tax_family | tax_genus | tax_species |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27873910 | 27873910 | PRJNA744060_P_NODE_12665_length_450_cov_1.909814_g12337_i0 | PRJNA744060 | 12665 | 450 | 1.909814 | 8.594163 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 222 | 2.76e-69 | NR | MCJ7801978.1 | 2026760 | g12337 | i0 | 67.6 | 0.986666666666667 | 148 | 45 | 98 | 2 | 9 | 449 | 37 | 182 | MCJ7801978.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 444 | 222 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30557990 | 30557990 | PRJNA744060_P_NODE_113_length_2512_cov_3.787618_g85_i0 | PRJNA744060 | 113 | 2512 | 3.787618 | 95.14496416 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 129 | 1.39e-26 | NR | MDC0235026.1 | 2026760 | g85 | i0 | 28.4 | 1.76751592356688 | 493 | 300 | 56.5 | 16 | 40 | 1458 | 122 | 581 | MDC0235026.1 Ig-like domain-containing protein [Fidelibacterota bacterium] | diamond | 4440 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 30567933 | 30567933 | PRJNA744060_P_NODE_41593_length_258_cov_3.718919_g41264_i0 | PRJNA744060 | 41593 | 258 | 3.718919 | 9.59481102 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 107 | 1.18e-25 | NR | HIM53365.1 | 2026760 | g41264 | i0 | 60 | 2.94186046511628 | 85 | 32 | 98.8 | 1 | 2 | 256 | 222 | 304 | HIM53365.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 759 | 108 | 0.990740740740741 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31126621 | 31126621 | PRJNA744060_P_NODE_975_length_1366_cov_5.298531_g843_i0 | PRJNA744060 | 975 | 1366 | 5.298531 | 72.37793346 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 418 | 6.189999999999998e-132 | NR | MBH49514.1 | 2026760 | g843 | i0 | 51.4 | 3.80819912152269 | 434 | 193 | 92.7 | 7 | 1296 | 31 | 3 | 430 | MBH49514.1 hypothetical protein [Fidelibacterota bacterium] | diamond | 5202 | 418 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31506647 | 31506647 | PRJNA744060_P_NODE_8036_length_562_cov_4.008180_g7711_i0 | PRJNA744060 | 8036 | 562 | 4.00818 | 22.5259716 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 212 | 1.35e-61 | NR | MBC8197018.1 | 2026760 | g7711 | i0 | 52.7 | 8.61565836298932 | 186 | 88 | 99.3 | 0 | 561 | 4 | 49 | 234 | MBC8197018.1 DUF2817 domain-containing protein [Fidelibacterota bacterium] | diamond | 4842 | 212 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 31632870 | 31632870 | PRJNA744060_P_NODE_42416_length_256_cov_2.584699_g42087_i0 | PRJNA744060 | 42416 | 256 | 2.584699 | 6.61682944 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 95.9 | 8.88e-22 | NR | MCJ7802071.1 | 2026760 | g42087 | i0 | 61.1 | 0.84375 | 72 | 27 | 83.2 | 1 | 250 | 38 | 198 | 269 | MCJ7802071.1 lipase family protein [Fidelibacterota bacterium] | diamond | 216 | 95.9 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium | |||||
| 32265921 | 32265921 | PRJNA744060_P_NODE_16918_length_391_cov_3.333333_g16589_i0 | PRJNA744060 | 16918 | 391 | 3.333333 | 13.03333203 | Fidelibacterota bacterium | 2026760 | Bacteria | Bacteria | 66.6 | 9.31e-10 | NR | MFL3050136.1 | 2026760 | g16589 | i0 | 35.8 | 1.84143222506394 | 120 | 72 | 90.5 | 3 | 1 | 354 | 1877 | 1993 | MFL3050136.1 cadherin domain-containing protein [Fidelibacterota bacterium] | diamond | 720 | 66.6 | 1 | Bacteria | FCB group | Pseudomonadati | Fidelibacterota | Fidelibacterota bacterium |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;