contig_metadata
22 rows where bioproject = "PRJNA1240805", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1624079 | 1624079 | PRJNA1240805_P_NODE_1702_length_374_cov_2.495385_g1653_i0 | PRJNA1240805 | 1702 | 374 | 2.495385 | 9.3327399 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 215 | 1.22e-63 | NR | HBY62940.1 | 2026791 | g1653 | i0 | 83.5 | 4.99732620320856 | 127 | 14 | 96.3 | 1 | 374 | 15 | 207 | 333 | HBY62940.1 hypothetical protein [Bryobacterales bacterium] | diamond | 1869 | 215 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 2900287 | 2900287 | PRJNA1240805_P_NODE_5043_length_203_cov_12.311688_g4994_i0 | PRJNA1240805 | 5043 | 203 | 12.311688 | 24.99272664 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 87 | 5.49e-18 | NR | MDQ6893965.1 | 1978231 | g4994 | i0 | 67.2 | 10.9064039408867 | 64 | 14 | 94.6 | 1 | 6 | 197 | 694 | 750 | MDQ6893965.1 glucosidase [Acidobacteriota bacterium] | diamond | 2214 | 87 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 5452939 | 5452939 | PRJNA1240805_P_NODE_5285_length_198_cov_7.624161_g5236_i0 | PRJNA1240805 | 5285 | 198 | 7.624161 | 15.09583878 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 202 | 1.61e-47 | NTclustered | gi|217038899|gb|EU810989.1| | 171953 | g5236 | i0 | 94.615 | 78.459595959596 | 130 | 7 | 66 | 0 | 69 | 198 | 1 | 130 | Uncultured Acidobacteria bacterium clone 01QD9 23S ribosomal RNA gene, partial sequence | blastn | 15535 | 202 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 5452965 | 5452965 | PRJNA1240805_P_NODE_7005_length_173_cov_14.354839_g6956_i0 | PRJNA1240805 | 7005 | 173 | 14.354839 | 24.83387147 | Bacteria | 2 | Bacteria | Bacteria | 109 | 4.11e-26 | NR | MBI2685908.1 | 1978231 | g6956 | i0 | 89.3 | 7.50867052023121 | 56 | 6 | 97.1 | 0 | 169 | 2 | 163 | 218 | MBI2685908.1 acido-empty-quinoprotein group A [Acidobacteriota bacterium] | diamond | 1299 | 109 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 8002737 | 8002737 | PRJNA1240805_P_NODE_3367_length_253_cov_4.558824_g3318_i0 | PRJNA1240805 | 3367 | 253 | 4.558824 | 11.53382472 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 128 | 3.85e-32 | NR | NWF82534.1 | 2212468 | g3318 | i0 | 73.4 | 0.936758893280632 | 79 | 21 | 93.7 | 0 | 1 | 237 | 279 | 357 | NWF82534.1 TonB-dependent receptor [Bryobacteraceae bacterium] | diamond | 237 | 128 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 9978593 | 9978593 | PRJNA1240805_P_NODE_8228_length_162_cov_1.805310_g8179_i0 | PRJNA1240805 | 8228 | 162 | 1.80531 | 2.9246022 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 71.3 | 3.72e-8 | NTclustered | gi|2874253836|emb|OY969886.1| | 171953 | g8179 | i0 | 95.455 | 1.6358024691358 | 44 | 2 | 27 | 0 | 110 | 153 | 888373 | 888330 | MAG: uncultured Acidobacteriota bacterium isolate MFD10007.bin.c.1 genome assembly, chromosome: 1 | blastn | 265 | 71.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 10553468 | 10553468 | PRJNA1240805_P_NODE_1369_length_424_cov_4.376000_g1320_i0 | PRJNA1240805 | 1369 | 424 | 4.376 | 18.55424 | Bryobacterales bacterium | 2026791 | Bacteria | Bacteria | 238 | 8.38e-74 | NR | MBL8209980.1 | 2026791 | g1320 | i0 | 86.9 | 0.969339622641509 | 137 | 18 | 96.9 | 0 | 9 | 419 | 140 | 276 | MBL8209980.1 quinohemoprotein amine dehydrogenase maturation protein [Bryobacterales bacterium] | diamond | 411 | 238 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacterales bacterium | ||||
| 15078082 | 15078082 | PRJNA1240805_P_NODE_4472_length_216_cov_6.443114_g4423_i0 | PRJNA1240805 | 4472 | 216 | 6.443114 | 13.91712624 | Bacteria | 2 | Bacteria | Bacteria | 122 | 2.44e-30 | NR | MEP7352052.1 | 1978231 | g4423 | i0 | 91.4 | 1.95833333333333 | 70 | 6 | 97.2 | 0 | 2 | 211 | 463 | 532 | MEP7352052.1 efflux RND transporter permease subunit [Acidobacteriota bacterium] | diamond | 423 | 122 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 15652422 | 15652422 | PRJNA1240805_P_NODE_3573_length_244_cov_13.179487_g3524_i0 | PRJNA1240805 | 3573 | 244 | 13.179487 | 32.15794828 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 296 | 9.21e-76 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g3524 | i0 | 90.95 | 96.8196721311475 | 221 | 19 | 91 | 1 | 1 | 221 | 4648915 | 4648696 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 23624 | 296 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 18201162 | 18201162 | PRJNA1240805_P_NODE_3215_length_260_cov_2.322275_g3166_i0 | PRJNA1240805 | 3215 | 260 | 2.322275 | 6.037915 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 119 | 7.29e-29 | NR | MAM84845.1 | 1978231 | g3166 | i0 | 67.9 | 0.9 | 78 | 25 | 90 | 0 | 22 | 255 | 403 | 480 | MAM84845.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 234 | 119 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 19475504 | 19475504 | PRJNA1240805_P_NODE_6036_length_186_cov_3.204380_g5987_i0 | PRJNA1240805 | 6036 | 186 | 3.20438 | 5.9601468 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 207 | 3.21e-49 | NTclustered | gi|2874253692|emb|OY969418.1| | 171953 | g5987 | i0 | 90 | 110.123655913978 | 160 | 16 | 86 | 0 | 1 | 160 | 4233763 | 4233922 | MAG: uncultured Acidobacteriota bacterium isolate MFD09212.bin.c.1 genome assembly, chromosome: 1 | blastn | 20483 | 207 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 20751021 | 20751021 | PRJNA1240805_P_NODE_8957_length_154_cov_3.266667_g8908_i0 | PRJNA1240805 | 8957 | 154 | 3.266667 | 5.03066718 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 243 | 6.99e-60 | NTclustered | gi|1958098837|gb|CP065005.1| | 1978231 | g8908 | i0 | 95.395 | 244.253246753247 | 152 | 7 | 99 | 0 | 1 | 152 | 4649311 | 4649462 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.198_cln chromosome, complete genome | blastn | 37615 | 243 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 23301908 | 23301908 | PRJNA1240805_P_NODE_939_length_517_cov_8.277778_g892_i0 | PRJNA1240805 | 939 | 517 | 8.277778 | 42.79611226 | Bryobacter | 911113 | Bacteria | Bacteria | 207 | 4.78e-63 | NR | WP_031500241.1 | 360054 | g892 | i0 | 77.9 | 1.52030947775629 | 131 | 29 | 76 | 0 | 18 | 410 | 196 | 326 | WP_031500241.1 D-alanine--D-alanine ligase family protein [Bryobacter aggregatus] | diamond | 786 | 207 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacter | Bryobacter aggregatus | ||
| 26756873 | 26756873 | PRJNA1240805_P_NODE_3781_length_238_cov_2.179894_g3732_i0 | PRJNA1240805 | 3781 | 238 | 2.179894 | 5.18814772 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 131 | 2.05e-35 | NR | MEZ5403239.1 | 2212468 | g3732 | i0 | 85.3 | 1.89075630252101 | 75 | 11 | 94.5 | 0 | 5 | 229 | 216 | 290 | MEZ5403239.1 aldo/keto reductase [Bryobacteraceae bacterium] | diamond | 450 | 131 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28526485 | 28526485 | PRJNA1240805_P_NODE_1367_length_424_cov_4.864000_g1318_i0 | PRJNA1240805 | 1367 | 424 | 4.864 | 20.62336 | Edaphobacter sp. | 1934404 | Bacteria | Bacteria | 80.1 | 1.14e-15 | NR | HWW24172.1 | 1934404 | g1318 | i0 | 38.4 | 0.792452830188679 | 112 | 51 | 78.5 | 3 | 410 | 78 | 60 | 154 | HWW24172.1 lipocalin family protein [Edaphobacter sp.] | diamond | 336 | 80.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. | ||
| 28702402 | 28702402 | PRJNA1240805_P_NODE_5707_length_191_cov_3.978873_g5658_i0 | PRJNA1240805 | 5707 | 191 | 3.978873 | 7.59964743 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 57.8 | 5.49e-8 | NR | HXF08621.1 | 2952895 | g5658 | i0 | 77.1 | 1.09947643979058 | 35 | 8 | 55 | 0 | 4 | 108 | 200 | 234 | HXF08621.1 FHA domain-containing protein [Candidatus Acidiferrales bacterium] | diamond | 210 | 57.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 28747327 | 28747327 | PRJNA1240805_P_NODE_3447_length_250_cov_2.009950_g3398_i0 | PRJNA1240805 | 3447 | 250 | 2.00995 | 5.024875 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 132 | 9.81e-34 | NR | MBM3766664.1 | 1978231 | g3398 | i0 | 94.6 | 0.888 | 74 | 4 | 88.8 | 0 | 21 | 242 | 538 | 611 | MBM3766664.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 222 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29189518 | 29189518 | PRJNA1240805_P_NODE_69_length_1480_cov_4.575122_g58_i0 | PRJNA1240805 | 69 | 1480 | 4.575122 | 67.7118056 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 334 | 1.04e-108 | NR | MBM3761435.1 | 1978231 | g58 | i0 | 63.5 | 0.555405405405405 | 274 | 97 | 55.1 | 2 | 1180 | 365 | 1 | 273 | MBM3761435.1 RluA family pseudouridine synthase [Acidobacteriota bacterium] | diamond | 822 | 334 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29757542 | 29757542 | PRJNA1240805_P_NODE_2971_length_272_cov_15.372197_g2922_i0 | PRJNA1240805 | 2971 | 272 | 15.372197 | 41.81237584 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 85.5 | 1.23e-17 | NR | MBI4486874.1 | 1978231 | g2922 | i0 | 78 | 1.04779411764706 | 50 | 11 | 55.1 | 0 | 100 | 249 | 1 | 50 | MBI4486874.1 DUF692 domain-containing protein [Acidobacteriota bacterium] | diamond | 285 | 85.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29757546 | 29757546 | PRJNA1240805_P_NODE_7471_length_169_cov_1.783333_g7422_i0 | PRJNA1240805 | 7471 | 169 | 1.783333 | 3.01383277 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 53.1 | 6.86e-7 | NR | MCX6613524.1 | 1978231 | g7422 | i0 | 56.5 | 0.816568047337278 | 46 | 20 | 81.7 | 0 | 169 | 32 | 63 | 108 | MCX6613524.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 138 | 53.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30515891 | 30515891 | PRJNA1240805_P_NODE_7893_length_165_cov_0.879310_g7844_i0 | PRJNA1240805 | 7893 | 165 | 0.87931 | 1.4508615 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 75.5 | 2.14e-14 | NR | HEX3701708.1 | 2910147 | g7844 | i0 | 69.8 | 1.94545454545455 | 53 | 16 | 96.4 | 0 | 4 | 162 | 138 | 190 | HEX3701708.1 AAA family ATPase [Vicinamibacterales bacterium] | diamond | 321 | 75.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32350027 | 32350027 | PRJNA1240805_P_NODE_2479_length_301_cov_9.714286_g2430_i0 | PRJNA1240805 | 2479 | 301 | 9.714286 | 29.24000086 | Candidatus Polarisedimenticolia bacterium | 3069555 | Bacteria | Bacteria | 174 | 1.97e-49 | NR | MEN6527600.1 | 3069555 | g2430 | i0 | 82.8 | 1.87375415282392 | 93 | 16 | 92.7 | 0 | 15 | 293 | 127 | 219 | MEN6527600.1 portal protein [Candidatus Polarisedimenticolia bacterium] | diamond | 564 | 174 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Candidatus Polarisedimenticolia | Candidatus Polarisedimenticolia 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);;