contig_metadata
7 rows where bioproject = "PRJNA1046144", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26655092 | 26655092 | PRJNA1046144_P_NODE_58321_length_234_cov_0.872727_g58026_i0 | PRJNA1046144 | 58321 | 234 | 0.872727 | 2.04218118 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 129 | 1.55e-33 | NR | MEE2793068.1 | 1978231 | g58026 | i0 | 76.6 | 3.93589743589744 | 77 | 18 | 98.7 | 0 | 231 | 1 | 189 | 265 | MEE2793068.1 glutamate-5-semialdehyde dehydrogenase [Acidobacteriota bacterium] | diamond | 921 | 129 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 27564058 | 27564058 | PRJNA1046144_P_NODE_61124_length_232_cov_0.883436_g60829_i0 | PRJNA1046144 | 61124 | 232 | 0.883436 | 2.04957152 | Bacteria | 2 | Bacteria | Bacteria | 95.1 | 7.379999999999999e-23 | NR | MCU1288975.1 | 1978231 | g60829 | i0 | 82 | 3.23275862068966 | 50 | 9 | 64.7 | 0 | 2 | 151 | 97 | 146 | MCU1288975.1 GCN5-related N-acetyltransferase [Acidobacteriota bacterium] | diamond | 750 | 95.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 28827077 | 28827077 | PRJNA1046144_P_NODE_26208_length_324_cov_3.945098_g25913_i0 | PRJNA1046144 | 26208 | 324 | 3.945098 | 12.78211752 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 77.4 | 6.34e-14 | NR | MDY7094683.1 | 1978231 | g25913 | i0 | 42.6 | 3.88888888888889 | 108 | 58 | 96.3 | 1 | 6 | 317 | 445 | 552 | MDY7094683.1 type I polyketide synthase [Acidobacteriota bacterium] | diamond | 1260 | 77.8 | 0.994858611825193 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 29079948 | 29079948 | PRJNA1046144_P_NODE_50968_length_245_cov_3.005682_g50673_i0 | PRJNA1046144 | 50968 | 245 | 3.005682 | 7.3639209 | Terriglobia | 204432 | Bacteria | Bacteria | 56.6 | 4.1e-7 | NR | HEX3744568.1 | 2212468 | g50673 | i0 | 61.7 | 1.64081632653061 | 47 | 15 | 53.9 | 2 | 244 | 113 | 249 | 295 | HEX3744568.1 SGNH/GDSL hydrolase family protein [Bryobacteraceae bacterium] | diamond | 402 | 57 | 0.992982456140351 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 29845718 | 29845718 | PRJNA1046144_P_NODE_57071_length_234_cov_2.218182_g56776_i0 | PRJNA1046144 | 57071 | 234 | 2.218182 | 5.19054588 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 119 | 4.59e-32 | NR | MFI5168967.1 | 2910147 | g56776 | i0 | 72.7 | 3.94871794871795 | 77 | 21 | 98.7 | 0 | 233 | 3 | 38 | 114 | MFI5168967.1 asparaginase domain-containing protein [Vicinamibacterales bacterium] | diamond | 924 | 119 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 30762029 | 30762029 | PRJNA1046144_P_NODE_39114_length_274_cov_1.312195_g38819_i0 | PRJNA1046144 | 39114 | 274 | 1.312195 | 3.5954143 | Thermoanaerobaculia bacterium | 2651171 | Bacteria | Bacteria | 95.1 | 2.19e-20 | NR | HEX5715372.1 | 2651171 | g38819 | i0 | 50.5 | 3.93065693430657 | 91 | 45 | 99.6 | 0 | 1 | 273 | 2043 | 2133 | HEX5715372.1 SDR family NAD(P)-dependent oxidoreductase [Thermoanaerobaculia bacterium] | diamond | 1077 | 95.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Thermoanaerobaculia | Thermoanaerobaculia bacterium | |||||
| 32501575 | 32501575 | PRJNA1046144_P_NODE_53359_length_240_cov_1.684211_g53064_i0 | PRJNA1046144 | 53359 | 240 | 1.684211 | 4.0421064 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 42.4 | 0.0496 | NR | HKN61173.1 | 2952895 | g53064 | i0 | 43.9 | 0.5125 | 41 | 23 | 51.3 | 0 | 184 | 62 | 510 | 550 | HKN61173.1 TonB-dependent receptor [Candidatus Acidiferrales bacterium] | diamond | 123 | 42.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales 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);;