contig_metadata
18 rows where bioproject = "PRJNA446034" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 438296 | 438296 | PRJNA446034_S_NODE_56161_length_178_cov_8.758865_g56124_i0 | PRJNA446034 | 56161 | 178 | 8.758865 | 15.5907797 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 193 | 8.5e-45 | NTclustered | gi|1958085512|gb|CP065000.1| | 1978231 | g56124 | i0 | 86.592 | 31.8820224719101 | 179 | 19 | 99 | 4 | 1 | 176 | 3298366 | 3298190 | Acidobacteria bacterium isolate Kalu_18-Q3-R12-55_MAXAC.078_cln chromosome, complete genome | blastn | 5675 | 193 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 10641896 | 10641896 | PRJNA446034_S_NODE_106269_length_153_cov_2.301724_g106232_i0 | PRJNA446034 | 106269 | 153 | 2.301724 | 3.52163772 | Acidobacteriota | 57723 | Bacteria | Bacteria | 99.4 | 1.23e-22 | NR | MBL8180107.1 | 2052146 | g106232 | i0 | 90 | 5.88235294117647 | 50 | 5 | 98 | 0 | 152 | 3 | 423 | 472 | MBL8180107.1 sigma 54-interacting transcriptional regulator [Blastocatellia bacterium] | diamond | 900 | 99.8 | 0.995991983967936 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 11916749 | 11916749 | PRJNA446034_S_NODE_106430_length_153_cov_2.060345_g106393_i0 | PRJNA446034 | 106430 | 153 | 2.060345 | 3.15232785 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 101 | 3.61e-24 | NR | MBX7171873.1 | 2283092 | g106393 | i0 | 94 | 1.96078431372549 | 50 | 3 | 98 | 0 | 4 | 153 | 242 | 291 | MBX7171873.1 SDR family oxidoreductase [Pyrinomonadaceae bacterium] | diamond | 300 | 101 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 17015528 | 17015528 | PRJNA446034_S_NODE_42194_length_191_cov_1.779221_g42157_i0 | PRJNA446034 | 42194 | 191 | 1.779221 | 3.39831211 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 80.9 | 1.89e-18 | NR | HNU07124.1 | 2283092 | g42157 | i0 | 55.6 | 0.989528795811518 | 63 | 28 | 99 | 0 | 190 | 2 | 1 | 63 | HNU07124.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 189 | 80.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 24664336 | 24664336 | PRJNA446034_S_NODE_25300_length_214_cov_4.519774_g25263_i0 | PRJNA446034 | 25300 | 214 | 4.519774 | 9.67231636 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 357 | 3.5699999999999996e-94 | NTclustered | gi|399532232|gb|JQ627516.1| | 171953 | g25263 | i0 | 97.156 | 98.5467289719626 | 211 | 6 | 99 | 0 | 1 | 211 | 18 | 228 | Uncultured Acidobacteria bacterium clone B1_6_1B_104 small subunit ribosomal RNA gene, partial sequence | blastn | 21089 | 357 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 27076012 | 27076012 | PRJNA446034_S_NODE_36642_length_197_cov_3.850000_g36605_i0 | PRJNA446034 | 36642 | 197 | 3.85 | 7.5845 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 115 | 3.65e-28 | NR | MCY7346853.1 | 2283092 | g36605 | i0 | 86.2 | 3.95939086294416 | 65 | 9 | 99 | 0 | 1 | 195 | 224 | 288 | MCY7346853.1 diguanylate cyclase [Pyrinomonadaceae bacterium] | diamond | 780 | 115 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28497313 | 28497313 | PRJNA446034_S_NODE_52907_length_181_cov_3.173611_g52870_i0 | PRJNA446034 | 52907 | 181 | 3.173611 | 5.7442359099999996 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 120 | 5.83e-30 | NR | MCY7377390.1 | 2283092 | g52870 | i0 | 98.3 | 1.98895027624309 | 60 | 1 | 99.4 | 0 | 180 | 1 | 46 | 105 | MCY7377390.1 type VI secretion system baseplate subunit TssF [Pyrinomonadaceae bacterium] | diamond | 360 | 120 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28528936 | 28528936 | PRJNA446034_S_NODE_111667_length_151_cov_3.263158_g111630_i0 | PRJNA446034 | 111667 | 151 | 3.263158 | 4.9273685800000004 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 90.9 | 9.96e-20 | NR | HEY7161854.1 | 1978231 | g111630 | i0 | 90 | 0.993377483443709 | 50 | 5 | 99.3 | 0 | 1 | 150 | 164 | 213 | HEY7161854.1 iron chelate uptake ABC transporter family permease subunit [Acidobacteriota bacterium] | diamond | 150 | 90.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29034192 | 29034192 | PRJNA446034_S_NODE_14908_length_240_cov_6.443350_g14871_i0 | PRJNA446034 | 14908 | 240 | 6.44335 | 15.46404 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 68.6 | 1.25e-11 | NR | MEJ7847183.1 | 2283092 | g14871 | i0 | 48.6 | 0.9 | 72 | 36 | 88.8 | 1 | 1 | 213 | 57 | 128 | MEJ7847183.1 ankyrin repeat domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 216 | 68.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 29381277 | 29381277 | PRJNA446034_S_NODE_32529_length_203_cov_1.385542_g32492_i0 | PRJNA446034 | 32529 | 203 | 1.385542 | 2.81265026 | Terracidiphilus sp. | 1964191 | Bacteria | Bacteria | 59.3 | 1.33e-9 | NR | HZL53773.1 | 1964191 | g32492 | i0 | 73 | 0.54679802955665 | 37 | 10 | 54.7 | 0 | 142 | 32 | 50 | 86 | HZL53773.1 hypothetical protein [Terracidiphilus sp.] | diamond | 111 | 59.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Terracidiphilus | Terracidiphilus sp. | ||
| 30123739 | 30123739 | PRJNA446034_S_NODE_19412_length_227_cov_3.015789_g19375_i0 | PRJNA446034 | 19412 | 227 | 3.015789 | 6.84584103 | Bacteria | 2 | Bacteria | Bacteria | 132 | 5.619999999999999e-38 | NR | MDQ3374934.1 | 1978231 | g19375 | i0 | 80 | 3.93832599118943 | 75 | 15 | 99.1 | 0 | 225 | 1 | 29 | 103 | MDQ3374934.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 894 | 132 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30202185 | 30202185 | PRJNA446034_S_NODE_83532_length_162_cov_3.512000_g83495_i0 | PRJNA446034 | 83532 | 162 | 3.512 | 5.68944 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 88.6 | 4.63e-19 | NR | HVD91225.1 | 2910147 | g83495 | i0 | 69.8 | 0.981481481481482 | 53 | 16 | 98.1 | 0 | 160 | 2 | 117 | 169 | HVD91225.1 hypothetical protein [Vicinamibacterales bacterium] | diamond | 159 | 88.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30518370 | 30518370 | PRJNA446034_S_NODE_7793_length_277_cov_6.450000_g7756_i0 | PRJNA446034 | 7793 | 277 | 6.45 | 17.8665 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 64.3 | 1.46e-9 | NR | HEY3040394.1 | 2283092 | g7756 | i0 | 57.4 | 0.660649819494585 | 61 | 23 | 62.8 | 1 | 183 | 10 | 160 | 220 | HEY3040394.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 183 | 64.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30834317 | 30834317 | PRJNA446034_S_NODE_20094_length_225_cov_5.154255_g20057_i0 | PRJNA446034 | 20094 | 225 | 5.154255 | 11.59707375 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 91.7 | 9.49e-21 | NR | HEX9961491.1 | 2283092 | g20057 | i0 | 64.5 | 1.98666666666667 | 76 | 20 | 92 | 2 | 208 | 2 | 7 | 82 | HEX9961491.1 YceI family protein [Pyrinomonadaceae bacterium] | diamond | 447 | 91.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 31023949 | 31023949 | PRJNA446034_S_NODE_83395_length_162_cov_4.000000_g83358_i0 | PRJNA446034 | 83395 | 162 | 4 | 6.48 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 101 | 1.58e-25 | NR | MEO8073315.1 | 1978231 | g83358 | i0 | 90.7 | 1 | 54 | 5 | 100 | 0 | 1 | 162 | 72 | 125 | MEO8073315.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 162 | 101 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31687853 | 31687853 | PRJNA446034_S_NODE_27737_length_210_cov_3.213873_g27700_i0 | PRJNA446034 | 27737 | 210 | 3.213873 | 6.7491333 | Candidatus Sulfopaludibacter sp. SbA4 | 2043165 | Bacteria | Bacteria | 66.2 | 1.06e-10 | NR | SPF49530.1 | 2043165 | g27700 | i0 | 86.5 | 1.05714285714286 | 37 | 5 | 52.9 | 0 | 209 | 99 | 140 | 176 | SPF49530.1 conserved hypothetical protein [Candidatus Sulfopaludibacter sp. SbA4] | diamond | 222 | 66.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Solibacteraceae | Candidatus Sulfopaludibacter | Candidatus Sulfopaludibacter sp. SbA4 | ||
| 31845945 | 31845945 | PRJNA446034_S_NODE_31457_length_204_cov_4.215569_g31420_i0 | PRJNA446034 | 31457 | 204 | 4.215569 | 8.59976076 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 117 | 1.77e-32 | NR | MEO7508862.1 | 2283092 | g31420 | i0 | 91 | 0.985294117647059 | 67 | 6 | 98.5 | 0 | 4 | 204 | 30 | 96 | MEO7508862.1 threonine/serine exporter family protein [Pyrinomonadaceae bacterium] | diamond | 201 | 117 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 32574050 | 32574050 | PRJNA446034_S_NODE_86759_length_161_cov_1.314516_g86722_i0 | PRJNA446034 | 86759 | 161 | 1.314516 | 2.11637076 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 81.3 | 2.43e-16 | NR | MBA3631497.1 | 1978231 | g86722 | i0 | 85.1 | 3.50310559006211 | 47 | 7 | 87.6 | 0 | 3 | 143 | 310 | 356 | MBA3631497.1 PQQ-dependent sugar dehydrogenase [Acidobacteriota bacterium] | diamond | 564 | 81.3 | 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);;