contig_metadata
13 rows where bioproject = "PRJNA971676", tax_phylum = "Acidobacteriota" and tax_superkingdom = "Bacteria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4773140 | 4773140 | PRJNA971676_P_NODE_7244_length_324_cov_1.605578_g7155_i0 | PRJNA971676 | 7244 | 324 | 1.605578 | 5.20207272 | Telmatobacter sp. DSM 110680 | 3036704 | Bacteria | Bacteria | 52.8 | 0.03 | NTclustered | gi|2737773779|gb|CP121196.1| | 3036704 | g7155 | i0 | 100 | 0.0864197530864197 | 28 | 0 | 9 | 0 | 221 | 248 | 3282243 | 3282216 | Telmatobacter sp. DSM 110680 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Acidobacteriaceae | Telmatobacter | Telmatobacter sp. DSM 110680 | ||
| 9872976 | 9872976 | PRJNA971676_P_NODE_6528_length_336_cov_1.171103_g6439_i0 | PRJNA971676 | 6528 | 336 | 1.171103 | 3.93490608 | Terriglobales bacterium | 2282142 | Bacteria | Bacteria | 164 | 2.3099999999999994e-48 | NR | HEY6182722.1 | 2282142 | g6439 | i0 | 65.8 | 7.41964285714286 | 111 | 38 | 99.1 | 0 | 3 | 335 | 74 | 184 | HEY6182722.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Terriglobales bacterium] | diamond | 2493 | 164 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Terriglobales | Terriglobales bacterium | ||||
| 16247572 | 16247572 | PRJNA971676_P_NODE_273_length_1275_cov_2.513311_g220_i0 | PRJNA971676 | 273 | 1275 | 2.513311 | 32.04471525 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 92.4 | 6.99e-16 | NR | PYP99840.1 | 1978231 | g220 | i0 | 32.6 | 0.548235294117647 | 233 | 132 | 52.7 | 6 | 1108 | 437 | 174 | 390 | PYP99840.1 MAG: hypothetical protein DMF83_29675, partial [Acidobacteriota bacterium] | diamond | 699 | 92.4 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26652111 | 26652111 | PRJNA971676_P_NODE_3501_length_423_cov_1.017143_g3412_i0 | PRJNA971676 | 3501 | 423 | 1.017143 | 4.30251489 | Pseudomonadati | 3379134 | Bacteria | Bacteria | 65.1 | 4.52e-9 | NR | MBI3424410.1 | 1978231 | g3412 | i0 | 41.9 | 5.63829787234043 | 117 | 58 | 76.6 | 4 | 52 | 375 | 1071 | 1186 | MBI3424410.1 HYR domain-containing protein [Acidobacteriota bacterium] | diamond | 2385 | 65.1 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 26715286 | 26715286 | PRJNA971676_P_NODE_23041_length_241_cov_0.916667_g22952_i0 | PRJNA971676 | 23041 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 49.3 | 1.77e-4 | NR | MEP7362009.1 | 1978231 | g22952 | i0 | 47.1 | 1.71784232365145 | 51 | 26 | 63.5 | 1 | 232 | 80 | 472 | 521 | MEP7362009.1 ankyrin repeat domain-containing protein [Acidobacteriota bacterium] | diamond | 414 | 49.3 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30089096 | 30089096 | PRJNA971676_P_NODE_11552_length_272_cov_0.924623_g11463_i0 | PRJNA971676 | 11552 | 272 | 0.924623 | 2.51497456 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 139 | 6.17e-36 | NR | MBV9185802.1 | 1978231 | g11463 | i0 | 71.1 | 4.83088235294118 | 90 | 25 | 98.2 | 1 | 271 | 5 | 94 | 183 | MBV9185802.1 DDE-type integrase/transposase/recombinase [Acidobacteriota bacterium] | diamond | 1314 | 139 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30120621 | 30120621 | PRJNA971676_P_NODE_18872_length_246_cov_0.890173_g18783_i0 | PRJNA971676 | 18872 | 246 | 0.890173 | 2.18982558 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 122 | 1.1999999999999999e-32 | NR | HYK87887.1 | 1978231 | g18783 | i0 | 70.9 | 2.89024390243902 | 79 | 23 | 96.3 | 0 | 239 | 3 | 11 | 89 | HYK87887.1 BREX system ATP-binding domain-containing protein [Acidobacteriota bacterium] | diamond | 711 | 122 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30468612 | 30468612 | PRJNA971676_P_NODE_6113_length_344_cov_0.852399_g6024_i0 | PRJNA971676 | 6113 | 344 | 0.852399 | 2.93225256 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 116 | 3.7099999999999996e-31 | NR | MDQ7008653.1 | 1978231 | g6024 | i0 | 71.7 | 0.802325581395349 | 92 | 26 | 80.2 | 0 | 67 | 342 | 8 | 99 | MDQ7008653.1 NFYB/HAP3 family transcription factor subunit [Acidobacteriota bacterium] | diamond | 276 | 116 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 30499954 | 30499954 | PRJNA971676_P_NODE_18633_length_246_cov_0.890173_g18544_i0 | PRJNA971676 | 18633 | 246 | 0.890173 | 2.18982558 | Candidatus Acidiferrales bacterium | 2952895 | Bacteria | Bacteria | 66.6 | 1.51e-10 | NR | HUI31363.1 | 2952895 | g18544 | i0 | 42.5 | 3.90243902439024 | 80 | 46 | 97.6 | 0 | 246 | 7 | 518 | 597 | HUI31363.1 mucoidy inhibitor MuiA family protein [Candidatus Acidiferrales bacterium] | diamond | 960 | 66.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Candidatus Acidiferrales | Candidatus Acidiferrales bacterium | ||||
| 30720960 | 30720960 | PRJNA971676_P_NODE_14394_length_251_cov_0.865169_g14305_i0 | PRJNA971676 | 14394 | 251 | 0.865169 | 2.17157419 | Acidobacteriota bacterium | 1978231 | Bacteria | Bacteria | 77.8 | 1.59e-14 | NR | MBI2837641.1 | 1978231 | g14305 | i0 | 46.1 | 0.908366533864542 | 76 | 41 | 90.8 | 0 | 19 | 246 | 225 | 300 | MBI2837641.1 glycosyltransferase [Acidobacteriota bacterium] | diamond | 228 | 77.8 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Acidobacteriota bacterium | ||||||
| 31068824 | 31068824 | PRJNA971676_P_NODE_775_length_812_cov_1.906631_g700_i0 | PRJNA971676 | 775 | 812 | 1.906631 | 15.48184372 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 66.6 | 3.09e-8 | NR | HLK47220.1 | 2212468 | g700 | i0 | 37.6 | 0.461822660098522 | 125 | 61 | 45.8 | 4 | 775 | 404 | 2190 | 2298 | HLK47220.1 LamG-like jellyroll fold domain-containing protein [Bryobacteraceae bacterium] | diamond | 375 | 66.6 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Terriglobia | Bryobacterales | Bryobacteraceae | Bryobacteraceae bacterium | |||
| 31637706 | 31637706 | PRJNA971676_P_NODE_1476_length_612_cov_2.903525_g1389_i0 | PRJNA971676 | 1476 | 612 | 2.903525 | 17.769573 | Vicinamibacterales bacterium | 2910147 | Bacteria | Bacteria | 104 | 4.89e-22 | NR | HYT66950.1 | 2910147 | g1389 | i0 | 51.9 | 0.519607843137255 | 106 | 49 | 51.5 | 2 | 3 | 317 | 245 | 349 | HYT66950.1 DUF4394 domain-containing protein [Vicinamibacterales bacterium] | diamond | 318 | 104 | 1 | Bacteria | Pseudomonadati | Acidobacteriota | Vicinamibacteria | Vicinamibacterales | Vicinamibacterales bacterium | ||||
| 32870207 | 32870207 | PRJNA971676_P_NODE_11960_length_268_cov_1.184615_g11871_i0 | PRJNA971676 | 11960 | 268 | 1.184615 | 3.1747682 | Bryobacteraceae bacterium | 2212468 | Bacteria | Bacteria | 75.1 | 4.08e-14 | NR | MFN0164913.1 | 2212468 | g11871 | i0 | 53.2 | 2.78731343283582 | 77 | 33 | 86.2 | 2 | 255 | 25 | 25 | 98 | MFN0164913.1 DUF4397 domain-containing protein [Bryobacteraceae bacterium] | diamond | 747 | 75.1 | 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);;