contig_metadata
9 rows where bioproject = "PRJNA884104" and tax_phylum = "Candidatus Zixiibacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5963690 | 5963690 | PRJNA884104_S_NODE_24145_length_412_cov_1.589971_g23402_i0 | PRJNA884104 | 24145 | 412 | 1.589971 | 6.55068052 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 56.5 | 0.003 | NTclustered | gi|2107809231|gb|CP070824.1| | 2053527 | g23402 | i0 | 94.444 | 0.087378640776699 | 36 | 2 | 9 | 0 | 118 | 153 | 66648 | 66613 | MAG: Candidatus Zixiibacteriota bacterium isolate bin1124 chromosome | blastn | 36 | 56.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 29392347 | 29392347 | PRJNA884104_S_NODE_46989_length_305_cov_0.784483_g46246_i0 | PRJNA884104 | 46989 | 305 | 0.784483 | 2.39267315 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 45.1 | 0.0116 | NR | HET6447148.1 | 2053527 | g46246 | i0 | 43.9 | 0.560655737704918 | 57 | 32 | 56.1 | 0 | 9 | 179 | 229 | 285 | HET6447148.1 amidohydrolase [Candidatus Zixiibacteriota bacterium] | diamond | 171 | 45.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30592429 | 30592429 | PRJNA884104_S_NODE_24293_length_411_cov_1.437870_g23550_i0 | PRJNA884104 | 24293 | 411 | 1.43787 | 5.9096457 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 63.5 | 1.2e-8 | NR | MFQ5452986.1 | 2053527 | g23550 | i0 | 30.5 | 2.53284671532847 | 118 | 78 | 86.1 | 1 | 47 | 400 | 133 | 246 | MFQ5452986.1 CHRD domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 1041 | 63.5 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 30718855 | 30718855 | PRJNA884104_S_NODE_73274_length_248_cov_1.760000_g72531_i0 | PRJNA884104 | 73274 | 248 | 1.76 | 4.3648 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 54.7 | 2.43e-6 | NR | MCH7689527.1 | 2053527 | g72531 | i0 | 37.3 | 1.99596774193548 | 83 | 48 | 96.8 | 2 | 9 | 248 | 447 | 528 | MCH7689527.1 CHRD domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 495 | 54.7 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31105852 | 31105852 | PRJNA884104_S_NODE_27595_length_387_cov_1.671975_g26852_i0 | PRJNA884104 | 27595 | 387 | 1.671975 | 6.47054325 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 52.8 | 4.77e-5 | NR | MCH9031851.1 | 2053527 | g26852 | i0 | 33.3 | 1.71317829457364 | 96 | 62 | 72.9 | 1 | 87 | 368 | 146 | 241 | MCH9031851.1 CHRD domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 663 | 52.8 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31445889 | 31445889 | PRJNA884104_S_NODE_3976_length_1011_cov_1.719616_g3492_i0 | PRJNA884104 | 3976 | 1011 | 1.719616 | 17.38531776 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 129 | 4.08e-29 | NR | MDX9857468.1 | 2053527 | g3492 | i0 | 29.5 | 1.89614243323442 | 322 | 205 | 92.3 | 7 | 1 | 933 | 150 | 460 | MDX9857468.1 CHRD domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 1917 | 129 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31509298 | 31509298 | PRJNA884104_S_NODE_36736_length_340_cov_1.149813_g35993_i0 | PRJNA884104 | 36736 | 340 | 1.149813 | 3.9093642 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 83.2 | 7.52e-16 | NR | MBM3263898.1 | 2053527 | g35993 | i0 | 45.3 | 0.758823529411765 | 86 | 45 | 74.1 | 1 | 34 | 285 | 20 | 105 | MBM3263898.1 S9 family peptidase [Candidatus Zixiibacteriota bacterium] | diamond | 258 | 83.2 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31856961 | 31856961 | PRJNA884104_S_NODE_21797_length_433_cov_1.383333_g21054_i0 | PRJNA884104 | 21797 | 433 | 1.383333 | 5.98983189 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 81.3 | 1.04e-14 | NR | MDH3890273.1 | 2053527 | g21054 | i0 | 34.8 | 4.6420323325635104 | 135 | 86 | 92.1 | 1 | 399 | 1 | 207 | 341 | MDH3890273.1 CHRD domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 2010 | 81.3 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 32458369 | 32458369 | PRJNA884104_S_NODE_2359_length_1290_cov_2.239113_g2033_i0 | PRJNA884104 | 2359 | 1290 | 2.239113 | 28.8845577 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 158 | 1.6099999999999996e-38 | NR | MDH3890273.1 | 2053527 | g2033 | i0 | 28.2 | 1.02325581395349 | 440 | 285 | 99.5 | 8 | 6 | 1289 | 162 | 582 | MDH3890273.1 CHRD domain-containing protein [Candidatus Zixiibacteriota bacterium] | diamond | 1320 | 158 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota 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);;