contig_metadata
8 rows where bioproject = "PRJNA704949" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17279322 | 17279322 | PRJNA704949_P_NODE_845754_length_288_cov_1.899582_g830420_i0 | PRJNA704949 | 845754 | 288 | 1.899582 | 5.47079616 | uncultured candidate division Zixibacteria bacterium | 1664345 | Bacteria | Bacteria | 202 | 2.5e-47 | NTclustered | gi|2621704311|emb|OY760907.1| | 1664345 | g830420 | i0 | 79.928 | 54.8194444444444 | 279 | 52 | 96 | 4 | 1 | 277 | 1828176 | 1827900 | MAG: uncultured candidate division Zixibacteria bacterium isolate 2d357583-1faf-4436-89ad-6f0e4817d39a genome assembly, chromosome: 1 | blastn | 15788 | 202 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | uncultured candidate division Zixibacteria bacterium | |||||
| 27336078 | 27336078 | PRJNA704949_P_NODE_1780463_length_179_cov_1.200000_g1765124_i0 | PRJNA704949 | 1780463 | 179 | 1.2 | 2.148 | candidate division Zixibacteria bacterium SM23_81 | 1703428 | Bacteria | Bacteria | 43.1 | 0.0117 | NR | KPL18982.1 | 1703428 | g1765124 | i0 | 45.5 | 0.737430167597765 | 44 | 24 | 73.7 | 0 | 14 | 145 | 261 | 304 | KPL18982.1 MAG: hypothetical protein AMJ92_05285 [candidate division Zixibacteria bacterium SM23_81] | diamond | 132 | 43.1 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | candidate division Zixibacteria bacterium SM23_81 | |||||
| 27525797 | 27525797 | PRJNA704949_P_NODE_90883_length_817_cov_2.552083_g78708_i0 | PRJNA704949 | 90883 | 817 | 2.552083 | 20.85051811 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 246 | 1.1900000000000001e-77 | NR | MCK4632375.1 | 2053527 | g78708 | i0 | 57.1 | 2.37576499388005 | 217 | 93 | 79.7 | 0 | 1 | 651 | 34 | 250 | MCK4632375.1 glycosyltransferase family protein [Candidatus Zixiibacteriota bacterium] | diamond | 1941 | 246 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 27778485 | 27778485 | PRJNA704949_P_NODE_608484_length_348_cov_1.217391_g593161_i0 | PRJNA704949 | 608484 | 348 | 1.217391 | 4.23652068 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 61.6 | 2.88e-8 | NR | MBM3265089.1 | 2053527 | g593161 | i0 | 41.8 | 0.844827586206897 | 98 | 50 | 78.4 | 2 | 68 | 340 | 183 | 280 | MBM3265089.1 beta-propeller fold lactonase family protein [Candidatus Zixiibacteriota bacterium] | diamond | 294 | 61.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 29167674 | 29167674 | PRJNA704949_P_NODE_255449_length_527_cov_2.382845_g240867_i0 | PRJNA704949 | 255449 | 527 | 2.382845 | 12.55759315 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 241 | 2.18e-78 | NR | HET6446484.1 | 2053527 | g240867 | i0 | 64.7 | 0.984819734345351 | 173 | 61 | 98.5 | 0 | 522 | 4 | 2 | 174 | HET6446484.1 DUF1819 family protein [Candidatus Zixiibacteriota bacterium] | diamond | 519 | 241 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 29746279 | 29746279 | PRJNA704949_P_NODE_1550930_length_196_cov_2.476190_g1535591_i0 | PRJNA704949 | 1550930 | 196 | 2.47619 | 4.8533324 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 56.6 | 2.57e-7 | NR | RJP78057.1 | 2053527 | g1535591 | i0 | 46.7 | 5.34183673469388 | 60 | 32 | 91.8 | 0 | 1 | 180 | 215 | 274 | RJP78057.1 MAG: serine/threonine protein kinase [Candidatus Zixiibacteriota bacterium] | diamond | 1047 | 57 | 0.992982456140351 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 29767102 | 29767102 | PRJNA704949_P_NODE_1818671_length_176_cov_1.637795_g1803332_i0 | PRJNA704949 | 1818671 | 176 | 1.637795 | 2.8825192 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 66.6 | 8.98e-12 | NR | MDM7973688.1 | 2053527 | g1803332 | i0 | 68.2 | 1.56818181818182 | 44 | 14 | 75 | 0 | 145 | 14 | 2 | 45 | MDM7973688.1 hypothetical protein [Candidatus Zixiibacteriota bacterium] | diamond | 276 | 66.6 | 1 | Bacteria | FCB group | Pseudomonadati | Candidatus Zixiibacteriota | Candidatus Zixiibacteriota bacterium | |||||
| 31853111 | 31853111 | PRJNA704949_P_NODE_1996597_length_167_cov_0.881356_g1981258_i0 | PRJNA704949 | 1996597 | 167 | 0.881356 | 1.47186452 | Candidatus Zixiibacteriota bacterium | 2053527 | Bacteria | Bacteria | 39.7 | 0.0483 | NR | NIP42224.1 | 2053527 | g1981258 | i0 | 40 | 0.988023952095808 | 55 | 23 | 89.8 | 2 | 2 | 151 | 27 | 76 | NIP42224.1 hypothetical protein [Candidatus Zixiibacteriota bacterium] | diamond | 165 | 39.7 | 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);;