contig_metadata
19 rows where bioproject = "PRJNA812001", tax_kingdom = "Pseudomonadati" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2086139 | 2086139 | PRJNA812001_P_NODE_18642_length_388_cov_1.676190_g18396_i0 | PRJNA812001 | 18642 | 388 | 1.67619 | 6.5036172 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 143 | 5.999999999999998e-39 | NR | HVT14704.1 | 2651171 | g18396 | i0 | 58.8 | 2.80670103092783 | 119 | 49 | 92 | 0 | 24 | 380 | 30 | 148 | HVT14704.1 P-type conjugative transfer ATPase TrbB [Thermoanaerobaculia bacterium] | diamond | 1089 | 143 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 6328494 | 6328494 | PRJNA812001_P_NODE_54085_length_283_cov_2.109524_g53839_i0 | PRJNA812001 | 54085 | 283 | 2.109524 | 5.96995292 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 116 | 6.269999999999999e-31 | NR | HEV8268601.1 | 2651171 | g53839 | i0 | 78.1 | 0.678445229681979 | 64 | 14 | 67.8 | 0 | 258 | 67 | 93 | 156 | HEV8268601.1 phosphatidate cytidylyltransferase [Thermoanaerobaculia bacterium] | diamond | 192 | 116 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 12289545 | 12289545 | PRJNA812001_P_NODE_119710_length_243_cov_1.429412_g119464_i0 | PRJNA812001 | 119710 | 243 | 1.429412 | 3.47347116 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 60.8 | 5.96e-10 | NR | HEX7955401.1 | 2283092 | g119464 | i0 | 90.6 | 0.395061728395062 | 32 | 3 | 39.5 | 0 | 98 | 3 | 1 | 32 | HEX7955401.1 tRNA-guanine transglycosylase [Pyrinomonadaceae bacterium] | diamond | 96 | 60.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 13563989 | 13563989 | PRJNA812001_P_NODE_137991_length_199_cov_24.555556_g137745_i0 | PRJNA812001 | 137991 | 199 | 24.555556 | 48.86555644 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 171 | 4.57e-38 | NTclustered | gi|2621706021|emb|OY764083.1| | 1978231 | g137745 | i0 | 94.545 | 56.8994974874372 | 110 | 6 | 55 | 0 | 23 | 132 | 662604 | 662713 | MAG: Acidobacteriota bacterium isolate 715e7d27-e149-44c2-9d7f-aa5f8d263fc4 genome assembly, chromosome: 1 | blastn | 11323 | 171 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 13564523 | 13564523 | PRJNA812001_P_NODE_63811_length_270_cov_1.345178_g63565_i0 | PRJNA812001 | 63811 | 270 | 1.345178 | 3.6319806 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 129 | 1.39e-33 | NR | HEV2852868.1 | 2651171 | g63565 | i0 | 90.8 | 3.61111111111111 | 65 | 6 | 72.2 | 0 | 1 | 195 | 312 | 376 | HEV2852868.1 FemAB family XrtA/PEP-CTERM system-associated protein [Thermoanaerobaculia bacterium] | diamond | 975 | 129 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 14838381 | 14838381 | PRJNA812001_P_NODE_107372_length_246_cov_0.890173_g107126_i0 | PRJNA812001 | 107372 | 246 | 0.890173 | 2.18982558 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 169 | 7.08e-49 | NR | MBV8856821.1 | 1978231 | g107126 | i0 | 97.6 | 3 | 82 | 2 | 100 | 0 | 246 | 1 | 276 | 357 | MBV8856821.1 beta-lactamase family protein [Acidobacteriota bacterium] | diamond | 738 | 169 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 16112879 | 16112879 | PRJNA812001_P_NODE_16333_length_406_cov_1.750751_g16087_i0 | PRJNA812001 | 16333 | 406 | 1.750751 | 7.10804906 | Edaphobacter flagellatus | 1933044 | Bacteria | Bacteria | 726 | 0 | NTclustered | gi|2304905232|gb|CP073697.1| | 1933044 | g16087 | i0 | 99.499 | 2.76600985221675 | 399 | 2 | 98 | 0 | 1 | 399 | 2488918 | 2489316 | Edaphobacter flagellatus strain HZ411 chromosome, complete genome | blastn | 1123 | 726 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter flagellatus | ||
| 19075930 | 19075930 | PRJNA812001_P_NODE_11575_length_465_cov_2.747449_g11329_i0 | PRJNA812001 | 11575 | 465 | 2.747449 | 12.77563785 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 106 | 1.32e-25 | NR | MCW5961576.1 | 2283092 | g11329 | i0 | 82.1 | 0.729032258064516 | 56 | 10 | 36.1 | 0 | 26 | 193 | 119 | 174 | MCW5961576.1 DNA starvation/stationary phase protection protein [Pyrinomonadaceae bacterium] | diamond | 339 | 106 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26705832 | 26705832 | PRJNA812001_P_NODE_120521_length_243_cov_0.905882_g120275_i0 | PRJNA812001 | 120521 | 243 | 0.905882 | 2.20129326 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 95.5 | 2.26e-21 | NR | MEQ1728612.1 | 2910147 | g120275 | i0 | 66.2 | 2.62962962962963 | 71 | 24 | 87.7 | 0 | 2 | 214 | 256 | 326 | MEQ1728612.1 NAD(P)H-quinone oxidoreductase [Vicinamibacterales bacterium] | diamond | 639 | 95.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 27591594 | 27591594 | PRJNA812001_P_NODE_93044_length_248_cov_1.765714_g92798_i0 | PRJNA812001 | 93044 | 248 | 1.765714 | 4.37897072 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 44.3 | 0.0113 | NR | HVP14815.1 | 2282142 | g92798 | i0 | 30.7 | 7.77822580645161 | 75 | 44 | 85.9 | 2 | 5 | 217 | 155 | 225 | HVP14815.1 ATP-binding protein [Terriglobales bacterium] | diamond | 1929 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 27654695 | 27654695 | PRJNA812001_P_NODE_2144_length_1027_cov_7.640461_g1956_i0 | PRJNA812001 | 2144 | 1027 | 7.640461 | 78.46753447 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 262 | 1.01e-82 | NR | HZT37293.1 | 2212468 | g1956 | i0 | 54.4 | 0.72444011684518 | 248 | 111 | 71.9 | 1 | 763 | 26 | 5 | 252 | HZT37293.1 IPT/TIG domain-containing protein [Bryobacteraceae bacterium] | diamond | 744 | 262 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 27686443 | 27686443 | PRJNA812001_P_NODE_104964_length_246_cov_0.890173_g104718_i0 | PRJNA812001 | 104964 | 246 | 0.890173 | 2.18982558 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 159 | 1.94e-47 | NR | HEV2828927.1 | 2283092 | g104718 | i0 | 88.9 | 0.98780487804878 | 81 | 9 | 98.8 | 0 | 244 | 2 | 99 | 179 | HEV2828927.1 redoxin domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 243 | 159 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28285804 | 28285804 | PRJNA812001_P_NODE_123746_length_243_cov_0.905882_g123500_i0 | PRJNA812001 | 123746 | 243 | 0.905882 | 2.20129326 | Acidobacteria bacterium RIFCSPLOWO2_ | 1797182 | Bacteria | Bacteria | 92 | 8.75e-21 | NR | OFW17594.1 | 1797182 | g123500 | i0 | 82.1 | 2.08641975308642 | 56 | 10 | 69.1 | 0 | 242 | 75 | 169 | 224 | OFW17594.1 MAG: 1-(5-phosphoribosyl)-5-((5-phosphoribosylamino)methylideneamino)imidazole-4-carboxamide isomerase [Acidobacteria bacterium RIFCSPLOWO2_02_FULL_65_29] | diamond | 507 | 92 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteria bacterium RIFCSPLOWO2_02_FULL_65_29 | ||||||
| 28326217 | 28326217 | PRJNA812001_P_NODE_134666_length_241_cov_0.916667_g134420_i0 | PRJNA812001 | 134666 | 241 | 0.916667 | 2.20916747 | Bryobacterales | 332160 | Bacteria | Bacteria | 67 | 9.63e-11 | NR | HEY3840184.1 | 2212468 | g134420 | i0 | 39.5 | 1.87966804979253 | 76 | 44 | 94.6 | 1 | 236 | 9 | 172 | 245 | HEY3840184.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 453 | 67 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 28444040 | 28444040 | PRJNA812001_P_NODE_826_length_1500_cov_11.819902_g724_i0 | PRJNA812001 | 826 | 1500 | 11.819902 | 177.29853 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 426 | 1.21e-140 | NR | HLH00567.1 | 2212468 | g724 | i0 | 49.3 | 2.884 | 475 | 232 | 95 | 5 | 10 | 1434 | 80 | 545 | HLH00567.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 4326 | 426 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 30180577 | 30180577 | PRJNA812001_P_NODE_96972_length_248_cov_0.880000_g96726_i0 | PRJNA812001 | 96972 | 248 | 0.88 | 2.1824 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 142 | 1.1099999999999999e-39 | NR | HMC77707.1 | 2910147 | g96726 | i0 | 76.5 | 0.979838709677419 | 81 | 19 | 98 | 0 | 247 | 5 | 120 | 200 | HMC77707.1 metallophosphoesterase [Vicinamibacterales bacterium] | diamond | 243 | 142 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30370694 | 30370694 | PRJNA812001_P_NODE_71672_length_259_cov_2.354839_g71426_i0 | PRJNA812001 | 71672 | 259 | 2.354839 | 6.09903301 | Blastocatellia bacterium | 2052146 | Bacteria | Bacteria | 179 | 3.6e-50 | NR | MCS6818293.1 | 2052146 | g71426 | i0 | 94.2 | 0.996138996138996 | 86 | 5 | 99.6 | 0 | 258 | 1 | 379 | 464 | MCS6818293.1 carboxypeptidase-like regulatory domain-containing protein [Blastocatellia bacterium] | diamond | 258 | 179 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellia bacterium | |||||
| 30844263 | 30844263 | PRJNA812001_P_NODE_115434_length_244_cov_0.900585_g115188_i0 | PRJNA812001 | 115434 | 244 | 0.900585 | 2.1974274 | Edaphobacter aggregans | 570835 | Bacteria | Bacteria | 136 | 1.1800000000000001e-36 | NR | WP_051979169.1 | 570835 | g115188 | i0 | 86.1 | 1.77049180327869 | 72 | 10 | 88.5 | 0 | 242 | 27 | 293 | 364 | WP_051979169.1 PQQ-dependent sugar dehydrogenase [Edaphobacter aggregans] | diamond | 432 | 136 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter aggregans | ||
| 31096832 | 31096832 | PRJNA812001_P_NODE_7835_length_554_cov_1.120582_g7590_i0 | PRJNA812001 | 7835 | 554 | 1.120582 | 6.20802428 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 113 | 8.19e-29 | NR | HEY1218840.1 | 2212468 | g7590 | i0 | 45.6 | 0.736462093862816 | 136 | 46 | 73.6 | 1 | 411 | 4 | 1 | 108 | HEY1218840.1 MmcQ/YjbR family DNA-binding protein [Bryobacteraceae bacterium] | diamond | 408 | 113 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae 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);;