contig_metadata
11 rows where bioproject = "PRJNA1073183" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 16764123 | 16764123 | PRJNA1073183_P_NODE_22794_length_274_cov_1.487562_g22699_i0 | PRJNA1073183 | 22794 | 274 | 1.487562 | 4.07591988 | uncultured Acidobacteriota bacterium | 171953 | Bacteria | Bacteria | 484 | 2.0899999999999994e-132 | NTclustered | gi|76574293|gb|DQ139441.1| | 171953 | g22699 | i0 | 98.54 | 137.638686131387 | 274 | 4 | 100 | 0 | 1 | 274 | 1782 | 1509 | Uncultured Acidobacteria bacterium clone CAL1 23S ribosomal RNA gene, partial sequence | blastn | 37713 | 484 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | uncultured Acidobacteriota bacterium | ||||||
| 17593813 | 17593813 | PRJNA1073183_P_NODE_13834_length_349_cov_1.115942_g13739_i0 | PRJNA1073183 | 13834 | 349 | 1.115942 | 3.89463758 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 135 | 3.18e-27 | NTclustered | gi|2874253710|emb|OY969475.1| | 2283092 | g13739 | i0 | 75.427 | 24.5730659025788 | 293 | 64 | 82 | 8 | 62 | 348 | 4925134 | 4925424 | MAG: Pyrinomonadaceae bacterium isolate MFD01916.bin.c.1 genome assembly, chromosome: 1 | blastn | 8576 | 135 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26624175 | 26624175 | PRJNA1073183_P_NODE_28021_length_249_cov_0.875000_g27926_i0 | PRJNA1073183 | 28021 | 249 | 0.875 | 2.17875 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 55.8 | 8.96e-7 | NR | MBA3356142.1 | 2283092 | g27926 | i0 | 40 | 1.80722891566265 | 75 | 45 | 90.4 | 0 | 247 | 23 | 181 | 255 | MBA3356142.1 tetratricopeptide repeat protein [Pyrinomonadaceae bacterium] | diamond | 450 | 55.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 26972398 | 26972398 | PRJNA1073183_P_NODE_26142_length_252_cov_1.363128_g26047_i0 | PRJNA1073183 | 26142 | 252 | 1.363128 | 3.43508256 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 82.8 | 4.15e-17 | NR | HEX6648633.1 | 2283092 | g26047 | i0 | 50.7 | 1.72619047619048 | 75 | 37 | 89.3 | 0 | 18 | 242 | 89 | 163 | HEX6648633.1 hypothetical protein [Pyrinomonadaceae bacterium] | diamond | 435 | 82.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae bacterium | |||
| 27130193 | 27130193 | PRJNA1073183_P_NODE_27982_length_249_cov_0.875000_g27887_i0 | PRJNA1073183 | 27982 | 249 | 0.875 | 2.17875 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 48.9 | 2.58e-4 | NR | HSL84189.1 | 2651171 | g27887 | i0 | 46.6 | 0.698795180722892 | 58 | 31 | 69.9 | 0 | 71 | 244 | 26 | 83 | HSL84189.1 matrixin family metalloprotease [Thermoanaerobaculia bacterium] | diamond | 174 | 48.9 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 28614909 | 28614909 | PRJNA1073183_P_NODE_16067_length_326_cov_1.177866_g15972_i0 | PRJNA1073183 | 16067 | 326 | 1.177866 | 3.83984316 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 107 | 1.35e-27 | NR | MDQ7008654.1 | 1978231 | g15972 | i0 | 86.8 | 0.625766871165644 | 68 | 8 | 62.6 | 1 | 2 | 205 | 45 | 111 | MDQ7008654.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 204 | 107 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28764148 | 28764148 | PRJNA1073183_P_NODE_4227_length_614_cov_2.316081_g4136_i0 | PRJNA1073183 | 4227 | 614 | 2.316081 | 14.22073734 | Bacteria | 2 | Bacteria | Bacteria | 243 | 8.66e-78 | NR | MBS1831214.1 | 1978231 | g4136 | i0 | 61 | 13.3387622149837 | 195 | 72 | 95.3 | 1 | 607 | 23 | 42 | 232 | MBS1831214.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 8190 | 244 | 0.995901639344262 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29814580 | 29814580 | PRJNA1073183_P_NODE_28111_length_249_cov_0.875000_g28016_i0 | PRJNA1073183 | 28111 | 249 | 0.875 | 2.17875 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 59.7 | 3.51e-8 | NR | HYD46757.1 | 2282142 | g28016 | i0 | 56.8 | 0.530120481927711 | 44 | 19 | 53 | 0 | 2 | 133 | 82 | 125 | HYD46757.1 hypothetical protein [Terriglobales bacterium] | diamond | 132 | 59.7 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 30004310 | 30004310 | PRJNA1073183_P_NODE_32151_length_244_cov_0.900585_g32056_i0 | PRJNA1073183 | 32151 | 244 | 0.900585 | 2.1974274 | Edaphobacter sp. | 1934404 | Bacteria | Bacteria | 42.4 | 0.0498 | NR | HSY69586.1 | 1934404 | g32056 | i0 | 37.1 | 1.09426229508197 | 89 | 37 | 87.3 | 4 | 242 | 30 | 212 | 299 | HSY69586.1 multicopper oxidase domain-containing protein [Edaphobacter sp.] | diamond | 267 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Edaphobacter | Edaphobacter sp. | ||
| 31109878 | 31109878 | PRJNA1073183_P_NODE_23995_length_266_cov_1.595855_g23900_i0 | PRJNA1073183 | 23995 | 266 | 1.595855 | 4.2449743 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 72 | 2.39e-12 | NR | MCB1044792.1 | 1978231 | g23900 | i0 | 44.8 | 2.04135338345865 | 87 | 44 | 93.6 | 3 | 10 | 258 | 344 | 430 | MCB1044792.1 hypothetical protein [Acidobacteriota bacterium] | diamond | 543 | 72 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31710913 | 31710913 | PRJNA1073183_P_NODE_19517_length_296_cov_1.067265_g19422_i0 | PRJNA1073183 | 19517 | 296 | 1.067265 | 3.1591044 | Pyrinomonadaceae bacterium | 2283092 | Bacteria | Bacteria | 44.3 | 0.0144 | NR | HYX28426.1 | 2283092 | g19422 | i0 | 33.3 | 0.547297297297297 | 54 | 34 | 54.7 | 1 | 115 | 276 | 154 | 205 | HYX28426.1 saposin domain-containing protein [Pyrinomonadaceae bacterium] | diamond | 162 | 44.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Blastocatellia | Blastocatellales | Pyrinomonadaceae | Pyrinomonadaceae 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);;