contig_metadata
18 rows where bioproject = "PRJNA1068830", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 183052 | 183052 | PRJNA1068830_P_NODE_52541_length_301_cov_1.824561_g51838_i0 | PRJNA1068830 | 52541 | 301 | 1.824561 | 5.49192861 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 556 | 4.87e-154 | NTclustered | gi|341941922|gb|JN225540.1| | 171953 | g51838 | i0 | 100 | 99.8870431893688 | 301 | 0 | 100 | 0 | 1 | 301 | 639 | 339 | Uncultured Acidobacteria bacterium clone GSY-XJ5 16S ribosomal RNA gene, partial sequence | blastn | 30066 | 556 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 183192 | 183192 | PRJNA1068830_P_NODE_58541_length_284_cov_2.213270_g57838_i0 | PRJNA1068830 | 58541 | 284 | 2.21327 | 6.2856868 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 399 | 8.129999999999998e-107 | NTclustered | gi|2874253885|emb|OY970060.1| | 171953 | g57838 | i0 | 94.318 | 97.4330985915493 | 264 | 9 | 92 | 5 | 23 | 284 | 4839641 | 4839900 | MAG: uncultured Acidobacteriota bacterium isolate MFD01916.bin.c.4 genome assembly, chromosome: 1 | blastn | 27671 | 399 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 26624091 | 26624091 | PRJNA1068830_P_NODE_50101_length_309_cov_2.546610_g49398_i0 | PRJNA1068830 | 50101 | 309 | 2.54661 | 7.8690249 | Candidatus Angelobacter sp. | 2976921 | Bacteria | Bacteria | 43.9 | 0.0305 | NR | HET9791579.1 | 2976921 | g49398 | i0 | 31.6 | 0.766990291262136 | 79 | 43 | 69.9 | 2 | 234 | 19 | 18 | 92 | HET9791579.1 aspartyl protease family protein [Candidatus Angelobacter sp.] | diamond | 237 | 43.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Angelobacter | Candidatus Angelobacter sp. | ||||
| 26655573 | 26655573 | PRJNA1068830_P_NODE_62861_length_274_cov_1.402985_g62158_i0 | PRJNA1068830 | 62861 | 274 | 1.402985 | 3.8441789 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 69.7 | 1.75e-11 | NR | MBX3294083.1 | 1978231 | g62158 | i0 | 44.3 | 0.963503649635037 | 88 | 47 | 96.4 | 1 | 7 | 270 | 153 | 238 | MBX3294083.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 264 | 69.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26782689 | 26782689 | PRJNA1068830_P_NODE_62621_length_274_cov_2.975124_g61918_i0 | PRJNA1068830 | 62621 | 274 | 2.975124 | 8.15183976 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.5 | 0.018 | NR | MEA2563057.1 | 1978231 | g61918 | i0 | 42.9 | 0.613138686131387 | 56 | 31 | 60.2 | 1 | 56 | 220 | 18 | 73 | MEA2563057.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 168 | 43.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27817214 | 27817214 | PRJNA1068830_P_NODE_74484_length_252_cov_0.871508_g73781_i0 | PRJNA1068830 | 74484 | 252 | 0.871508 | 2.19620016 | Bacteria | 2 | Bacteria | Bacteria | 157 | 2.16e-46 | NR | MBA2620847.1 | 1978231 | g73781 | i0 | 89.3 | 3 | 84 | 9 | 100 | 0 | 252 | 1 | 23 | 106 | MBA2620847.1 amidohydrolase [Acidobacteriota bacterium] | diamond | 756 | 157 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27951822 | 27951822 | PRJNA1068830_P_NODE_82805_length_246_cov_0.901734_g82102_i0 | PRJNA1068830 | 82805 | 246 | 0.901734 | 2.21826564 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 43.1 | 0.0283 | NR | MCX6615803.1 | 1978231 | g82102 | i0 | 39.1 | 0.780487804878049 | 64 | 38 | 78 | 1 | 35 | 226 | 730 | 792 | MCX6615803.1 BACON domain-containing carbohydrate-binding protein [Acidobacteriota bacterium] | diamond | 192 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28015046 | 28015046 | PRJNA1068830_P_NODE_61205_length_278_cov_1.424390_g60502_i0 | PRJNA1068830 | 61205 | 278 | 1.42439 | 3.9598042 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 43.1 | 0.0413 | NR | MEJ7617117.1 | 2283092 | g60502 | i0 | 36 | 0.928057553956835 | 86 | 39 | 77.7 | 3 | 61 | 276 | 532 | 615 | MEJ7617117.1 molybdopterin oxidoreductase family protein [Pyrinomonadaceae bacterium] | diamond | 258 | 43.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 28457057 | 28457057 | PRJNA1068830_P_NODE_49406_length_312_cov_1.305439_g48703_i0 | PRJNA1068830 | 49406 | 312 | 1.305439 | 4.07296968 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 62.4 | 1.03e-8 | NR | MEE8523483.1 | 2651171 | g48703 | i0 | 38.7 | 2.49038461538462 | 75 | 36 | 71.2 | 3 | 304 | 83 | 243 | 308 | MEE8523483.1 hypothetical protein [Thermoanaerobaculia bacterium] | diamond | 777 | 62.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28827164 | 28827164 | PRJNA1068830_P_NODE_37468_length_366_cov_1.034130_g36765_i0 | PRJNA1068830 | 37468 | 366 | 1.03413 | 3.7849158 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 86.7 | 7.92e-18 | NR | MFB3903155.1 | 1978231 | g36765 | i0 | 54.5 | 1.31147540983607 | 77 | 34 | 63.1 | 1 | 254 | 24 | 82 | 157 | MFB3903155.1 DUF542 domain-containing protein [Acidobacteriota bacterium] | diamond | 480 | 87.4 | 0.991990846681922 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29877898 | 29877898 | PRJNA1068830_P_NODE_44551_length_331_cov_1.124031_g43848_i0 | PRJNA1068830 | 44551 | 331 | 1.124031 | 3.72054261 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 144 | 1.0699999999999998e-41 | NR | MEN6537328.1 | 2212468 | g43848 | i0 | 65.4 | 0.969788519637462 | 107 | 37 | 97 | 0 | 331 | 11 | 30 | 136 | MEN6537328.1 FmdB family zinc ribbon protein [Bryobacteraceae bacterium] | diamond | 321 | 144 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29941126 | 29941126 | PRJNA1068830_P_NODE_58191_length_285_cov_1.830189_g57488_i0 | PRJNA1068830 | 58191 | 285 | 1.830189 | 5.21603865 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 56.2 | 2.39e-7 | NR | MCU0239184.1 | 2283092 | g57488 | i0 | 35.4 | 2.93684210526316 | 79 | 44 | 75.8 | 1 | 217 | 2 | 8 | 86 | MCU0239184.1 Hsp20/alpha crystallin family protein [Pyrinomonadaceae bacterium] | diamond | 837 | 56.2 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 30667638 | 30667638 | PRJNA1068830_P_NODE_69033_length_260_cov_0.855615_g68330_i0 | PRJNA1068830 | 69033 | 260 | 0.855615 | 2.224599 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 42 | 0.0482 | NR | HSL83150.1 | 2651171 | g68330 | i0 | 41.1 | 0.646153846153846 | 56 | 33 | 64.6 | 0 | 258 | 91 | 84 | 139 | HSL83150.1 FtsX-like permease family protein [Thermoanaerobaculia bacterium] | diamond | 168 | 42 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 30952179 | 30952179 | PRJNA1068830_P_NODE_44674_length_330_cov_1.821012_g43971_i0 | PRJNA1068830 | 44674 | 330 | 1.821012 | 6.0093396 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 111 | 9.5e-27 | NR | MEN6537327.1 | 2212468 | g43971 | i0 | 52.2 | 1.04545454545455 | 115 | 50 | 100 | 1 | 330 | 1 | 117 | 231 | MEN6537327.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 345 | 111 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31164444 | 31164444 | PRJNA1068830_P_NODE_60935_length_279_cov_0.878641_g60232_i0 | PRJNA1068830 | 60935 | 279 | 0.878641 | 2.45140839 | Bacteria | 2 | Bacteria | Bacteria | 54.7 | 3.36e-6 | NR | MBX3279440.1 | 1978231 | g60232 | i0 | 40.4 | 1.29032258064516 | 57 | 34 | 61.3 | 0 | 181 | 11 | 86 | 142 | MBX3279440.1 protein kinase [Acidobacteriota bacterium] | diamond | 360 | 54.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31363053 | 31363053 | PRJNA1068830_P_NODE_64136_length_271_cov_1.363636_g63433_i0 | PRJNA1068830 | 64136 | 271 | 1.363636 | 3.69545356 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 58.5 | 1.4e-7 | NR | MEM8961467.1 | 1978231 | g63433 | i0 | 36.6 | 0.907749077490775 | 82 | 49 | 87.5 | 1 | 9 | 245 | 601 | 682 | MEM8961467.1 polyprenyl synthetase family protein [Acidobacteriota bacterium] | diamond | 246 | 58.5 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 32343839 | 32343839 | PRJNA1068830_P_NODE_21379_length_513_cov_1.956818_g20678_i0 | PRJNA1068830 | 21379 | 513 | 1.956818 | 10.03847634 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 160 | 2.24e-42 | NR | MEN6608653.1 | 2212468 | g20678 | i0 | 51.2 | 1.00584795321637 | 172 | 47 | 100 | 5 | 1 | 513 | 116 | 251 | MEN6608653.1 hypothetical protein [Bryobacteraceae bacterium] | diamond | 516 | 160 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 32714062 | 32714062 | PRJNA1068830_P_NODE_78260_length_249_cov_0.886364_g77557_i0 | PRJNA1068830 | 78260 | 249 | 0.886364 | 2.20704636 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 3.65e-5 | NR | MBK6588662.1 | 1978231 | g77557 | i0 | 57.1 | 2.50602409638554 | 42 | 18 | 50.6 | 0 | 6 | 131 | 40 | 81 | MBK6588662.1 RNA-binding protein [Acidobacteriota bacterium] | diamond | 624 | 49.7 | 0.991951710261569 | 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);;