contig_metadata
12 rows where bioproject = "PRJEB55250" and tax_phylum = "Acidobacteriota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1396116 | 1396116 | PRJEB55250_P_NODE_14182_length_246_cov_0.890173_g14058_i0 | PRJEB55250 | 14182 | 246 | 0.890173 | 2.18982558 | Acidobacteriaceae | 204434 | Bacteria | Bacteria | 129 | 1.84e-32 | NR | WP_317890955.1 | 940613 | g14058 | i0 | 77.5 | 5.82926829268293 | 80 | 18 | 97.6 | 0 | 6 | 245 | 462 | 541 | WP_317890955.1 malto-oligosyltrehalose synthase [Granulicella arctica] | diamond | 1434 | 130 | 0.992307692307692 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Granulicella | Granulicella arctica | ||
| 7774346 | 7774346 | PRJEB55250_P_NODE_8547_length_272_cov_1.537688_g8423_i0 | PRJEB55250 | 8547 | 272 | 1.537688 | 4.18251136 | Tunturiibacter lichenicola | 2051959 | Bacteria | Bacteria | 200 | 8.419999999999998e-47 | NTclustered | gi|2304905231|gb|CP073696.1| | 2051959 | g8423 | i0 | 81.395 | 2.45955882352941 | 258 | 37 | 94 | 7 | 1 | 257 | 4911196 | 4911443 | Tunturiibacter lichenicola strain DSM 104462 chromosome, complete genome | blastn | 669 | 200 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Tunturiibacter | Tunturiibacter lichenicola | ||
| 16698597 | 16698597 | PRJEB55250_P_NODE_8414_length_273_cov_1.540000_g8290_i0 | PRJEB55250 | 8414 | 273 | 1.54 | 4.2042 | Bacteria | 2 | Bacteria | Bacteria | 136 | 3.4799999999999995e-35 | NR | PYS92644.1 | 1978231 | g8290 | i0 | 81.1 | 7.91208791208791 | 90 | 17 | 98.9 | 0 | 272 | 3 | 180 | 269 | PYS92644.1 MAG: GTPase HflX [Acidobacteriota bacterium] | diamond | 2160 | 137 | 0.992700729927007 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26615117 | 26615117 | PRJEB55250_P_NODE_10401_length_258_cov_1.664865_g10277_i0 | PRJEB55250 | 10401 | 258 | 1.664865 | 4.2953517 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 105 | 3.75e-24 | NR | MDQ3688301.1 | 1978231 | g10277 | i0 | 68.2 | 10.8488372093023 | 85 | 27 | 98.8 | 0 | 256 | 2 | 572 | 656 | MDQ3688301.1 heavy metal translocating P-type ATPase [Acidobacteriota bacterium] | diamond | 2799 | 105 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28928376 | 28928376 | PRJEB55250_P_NODE_9008_length_268_cov_2.548718_g8884_i0 | PRJEB55250 | 9008 | 268 | 2.548718 | 6.83056424 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 56.2 | 7.03e-7 | NR | RLE28789.1 | 1978231 | g8884 | i0 | 44.9 | 0.772388059701492 | 69 | 37 | 76.1 | 1 | 53 | 256 | 52 | 120 | RLE28789.1 MAG: hypothetical protein DRJ61_15780 [Acidobacteriota bacterium] | diamond | 207 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29149831 | 29149831 | PRJEB55250_P_NODE_8549_length_272_cov_1.527638_g8425_i0 | PRJEB55250 | 8549 | 272 | 1.527638 | 4.15517536 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 67.8 | 1.25e-11 | NR | HEY2170527.1 | 2976921 | g8425 | i0 | 45.5 | 4.22426470588235 | 77 | 39 | 82.7 | 2 | 4 | 228 | 77 | 152 | HEY2170527.1 HNH endonuclease [Candidatus Angelobacter sp.] | diamond | 1149 | 67.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 30539086 | 30539086 | PRJEB55250_P_NODE_7233_length_282_cov_1.473684_g7109_i0 | PRJEB55250 | 7233 | 282 | 1.473684 | 4.15578888 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 87.4 | 1.19e-18 | NR | HXI43857.1 | 2212468 | g7109 | i0 | 59.7 | 0.765957446808511 | 72 | 29 | 76.6 | 0 | 218 | 3 | 143 | 214 | HXI43857.1 HNH endonuclease [Bryobacteraceae bacterium] | diamond | 216 | 87.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31170777 | 31170777 | PRJEB55250_P_NODE_4615_length_325_cov_1.253968_g4491_i0 | PRJEB55250 | 4615 | 325 | 1.253968 | 4.075396 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 125 | 1.82e-33 | NR | MCE5310469.1 | 2282142 | g4491 | i0 | 55.7 | 0.978461538461538 | 106 | 46 | 96.9 | 1 | 325 | 11 | 92 | 197 | MCE5310469.1 hypothetical protein [Terriglobales bacterium] | diamond | 318 | 125 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 31676946 | 31676946 | PRJEB55250_P_NODE_12257_length_250_cov_0.870056_g12133_i0 | PRJEB55250 | 12257 | 250 | 0.870056 | 2.17514 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 107 | 2.8499999999999997e-25 | NR | HYY56722.1 | 2283092 | g12133 | i0 | 70.4 | 7.776 | 81 | 24 | 97.2 | 0 | 247 | 5 | 201 | 281 | HYY56722.1 efflux RND transporter periplasmic adaptor subunit [Pyrinomonadaceae bacterium] | diamond | 1944 | 107 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31923302 | 31923302 | PRJEB55250_P_NODE_9557_length_264_cov_2.115183_g9433_i0 | PRJEB55250 | 9557 | 264 | 2.115183 | 5.58408312 | Bacteria | 2 | Bacteria | Bacteria | 96.3 | 8.39e-22 | NR | MDQ3818857.1 | 1978231 | g9433 | i0 | 54 | 6.78409090909091 | 87 | 40 | 98.9 | 0 | 3 | 263 | 187 | 273 | MDQ3818857.1 glycosyltransferase family 4 protein [Acidobacteriota bacterium] | diamond | 1791 | 97.1 | 0.991761071060762 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31930030 | 31930030 | PRJEB55250_P_NODE_13997_length_246_cov_0.890173_g13873_i0 | PRJEB55250 | 13997 | 246 | 0.890173 | 2.18982558 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 142 | 1.02e-39 | NR | HQU84150.1 | 2283092 | g13873 | i0 | 82.7 | 3.95121951219512 | 81 | 14 | 98.8 | 0 | 245 | 3 | 75 | 155 | HQU84150.1 glycerophosphodiester phosphodiesterase [Pyrinomonadaceae bacterium] | diamond | 972 | 142 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32310119 | 32310119 | PRJEB55250_P_NODE_16599_length_241_cov_0.916667_g16475_i0 | PRJEB55250 | 16599 | 241 | 0.916667 | 2.20916747 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 63.9 | 6.31e-10 | NR | RMH19946.1 | 1978231 | g16475 | i0 | 48.8 | 0.995850622406639 | 80 | 35 | 99.6 | 3 | 241 | 2 | 120 | 193 | RMH19946.1 MAG: NAD-dependent epimerase/dehydratase family protein [Acidobacteriota bacterium] | diamond | 240 | 63.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota 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);;