RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA796639" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 23 ✖

bioproject 1

  • PRJNA796639 · 23 ✖

analysis 1

  • diamond · 23 ✖
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
16083075 16083075 PRJNA796639_P_NODE_6933_length_245_cov_0.895349_g6808_i0 PRJNA796639 6933 245 0.895349 2.19360505 Bradyrhizobium sp. 376 Bacteria Bacteria 116 7.01e-30   NR HEY3681296.1 376 g6808 i0 80 0.979591836734694 80 16 98 0 245 6 16 95 HEY3681296.1 SDR family oxidoreductase [Bradyrhizobium sp.] diamond 240 116 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp.
26927273 26927273 PRJNA796639_P_NODE_5162_length_260_cov_1.058824_g5037_i0 PRJNA796639 5162 260 1.058824 2.7529424 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 45.1 0.00658   NR MDP3703451.1 2035772 g5037 i0 32.1 0.934615384615385 81 47 93.5 3 12 254 217 289 MDP3703451.1 COX15/CtaA family protein [Candidatus Omnitrophota bacterium] diamond 243 45.1 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
27022248 27022248 PRJNA796639_P_NODE_7362_length_243_cov_0.905882_g7237_i0 PRJNA796639 7362 243 0.905882 2.20129326 Acidisoma sp. 1872115 Bacteria Bacteria 68.6 3.09e-11   NR WP_325355589.1 1872115 g7237 i0 42.5 0.987654320987654 80 46 98.8 0 1 240 435 514 WP_325355589.1 tetratricopeptide repeat protein [Acidisoma sp.] diamond 240 68.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acidocellaceae Acidisoma Acidisoma sp.
27306834 27306834 PRJNA796639_P_NODE_7543_length_242_cov_0.911243_g7418_i0 PRJNA796639 7543 242 0.911243 2.20520806 Thermoanaerobaculia bacterium 2651171 Bacteria Bacteria 52.8 1.01e-5   NR HEX2122551.1 2651171 g7418 i0 41.7 1.48760330578512 60 33 74.4 1 186 7 66 123 HEX2122551.1 serine/threonine-protein kinase [Thermoanaerobaculia bacterium] diamond 360 52.8 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27338412 27338412 PRJNA796639_P_NODE_7283_length_243_cov_1.441176_g7158_i0 PRJNA796639 7283 243 1.441176 3.50205768 Acidobacteriaceae bacterium 2052142 Bacteria Bacteria 43.1 0.0262   NR HWG18504.1 2052142 g7158 i0 31.9 0.851851851851852 69 33 67.9 1 26 190 70 138 HWG18504.1 hypothetical protein [Acidobacteriaceae bacterium] diamond 207 43.1 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Terriglobales Acidobacteriaceae   Acidobacteriaceae bacterium
27527748 27527748 PRJNA796639_P_NODE_6443_length_247_cov_0.885057_g6318_i0 PRJNA796639 6443 247 0.885057 2.18609079 Deltaproteobacteria bacterium 2026735 Bacteria Bacteria 42.7 0.0375   NR RME19351.1 2026735 g6318 i0 48 0.607287449392713 50 23 57.1 1 36 176 204 253 RME19351.1 MAG: hypothetical protein D6806_18445, partial [Deltaproteobacteria bacterium] diamond 150 42.7 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria bacterium
28064525 28064525 PRJNA796639_P_NODE_3985_length_287_cov_0.714953_g3860_i0 PRJNA796639 3985 287 0.714953 2.05191511 Mesorhizobium caraganae 483206 Bacteria Bacteria 41.6 0.036   NR WP_352583011.1 483206 g3860 i0 46.3 0.564459930313589 54 24 53.3 2 129 281 38 89 WP_352583011.1 hypothetical protein [Mesorhizobium caraganae] diamond 162 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Mesorhizobium Mesorhizobium caraganae
28727650 28727650 PRJNA796639_P_NODE_5007_length_264_cov_1.209424_g4882_i0 PRJNA796639 5007 264 1.209424 3.19287936 Bradyrhizobium sp. sGM-13 2831781 Bacteria Bacteria 42 0.0294   NR WP_213286996.1 2831781 g4882 i0 47.5 0.454545454545455 40 19 43.2 1 84 197 57 96 WP_213286996.1 hypothetical protein [Bradyrhizobium sp. sGM-13] diamond 120 42 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. sGM-13
28790612 28790612 PRJNA796639_P_NODE_6567_length_247_cov_0.885057_g6442_i0 PRJNA796639 6567 247 0.885057 2.18609079 Planctomycetota bacterium 2026780 Bacteria Bacteria 54.3 3.3e-6   NR MFC1792019.1 2026780 g6442 i0 38.3 0.983805668016194 81 47 98.4 3 5 247 40 117 MFC1792019.1 kelch repeat-containing protein [Planctomycetota bacterium] diamond 243 54.3 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
29106599 29106599 PRJNA796639_P_NODE_7668_length_241_cov_1.595238_g7543_i0 PRJNA796639 7668 241 1.595238 3.84452358 Falsiroseomonas oryzae 2766473 Bacteria Bacteria 40.8 0.0415   NR WP_270936135.1 2766473 g7543 i0 38.2 0.684647302904564 55 30 64.7 2 231 76 34 87 WP_270936135.1 (2Fe-2S)-binding protein [Falsiroseomonas oryzae] diamond 165 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Roseomonadaceae Falsiroseomonas Falsiroseomonas oryzae
29399760 29399760 PRJNA796639_P_NODE_2729_length_341_cov_0.940299_g2604_i0 PRJNA796639 2729 341 0.940299 3.20641959 Sphingobacterium 28453 Bacteria Bacteria 44.7 0.0221   NR WP_038699358.1 976 g2604 i0 39 1.03812316715543 59 36 51.9 0 136 312 20 78 WP_038699358.1 MULTISPECIES: Na+/H+ antiporter NhaA [Bacteroidota] diamond 354 44.7 1 Bacteria FCB group Pseudomonadati Bacteroidota          
29516815 29516815 PRJNA796639_P_NODE_6710_length_246_cov_0.890173_g6585_i0 PRJNA796639 6710 246 0.890173 2.18982558 Flavobacteriaceae bacterium 1871037 Bacteria Bacteria 130 1.93e-35   NR MDR2204690.1 1871037 g6585 i0 72.2 0.963414634146341 79 22 96.3 0 238 2 104 182 MDR2204690.1 hypothetical protein [Flavobacteriaceae bacterium] diamond 237 130 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae   Flavobacteriaceae bacterium
29611366 29611366 PRJNA796639_P_NODE_2590_length_349_cov_3.514493_g2465_i0 PRJNA796639 2590 349 3.514493 12.26558057 Vicinamibacterales bacterium 2910147 Bacteria Bacteria 46.6 0.00535   NR MEQ1729317.1 2910147 g2465 i0 28.3 0.790830945558739 92 52 71.3 2 56 304 268 354 MEQ1729317.1 glycosyltransferase family 39 protein [Vicinamibacterales bacterium] diamond 276 46.6 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria Vicinamibacterales     Vicinamibacterales bacterium
29674484 29674484 PRJNA796639_P_NODE_4730_length_270_cov_1.152284_g4605_i0 PRJNA796639 4730 270 1.152284 3.1111668 Verrucomicrobiota bacterium 2026799 Bacteria Bacteria 44.7 0.0107   NR MCX6910854.1 2026799 g4605 i0 26.4 0.588888888888889 53 39 58.9 0 23 181 301 353 MCX6910854.1 O-antigen ligase family protein [Verrucomicrobiota bacterium] diamond 159 44.7 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota         Verrucomicrobiota bacterium
30085322 30085322 PRJNA796639_P_NODE_4572_length_274_cov_0.791045_g4447_i0 PRJNA796639 4572 274 0.791045 2.1674633 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 43.5 0.0283   NR MEE9139708.1 1913988 g4447 i0 47.6 0.45985401459854 42 17 40.5 2 46 156 142 183 MEE9139708.1 MFS transporter [Alphaproteobacteria bacterium] diamond 126 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
30275288 30275288 PRJNA796639_P_NODE_4172_length_283_cov_0.909524_g4047_i0 PRJNA796639 4172 283 0.909524 2.57395292 Chthoniobacteraceae bacterium 2811408 Bacteria Bacteria 43.1 0.0426   NR HEV7868427.1 2811408 g4047 i0 45.5 0.583038869257951 55 29 58.3 1 191 27 341 394 HEV7868427.1 DNA mismatch repair endonuclease MutL [Chthoniobacteraceae bacterium] diamond 165 43.1 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Spartobacteria Chthoniobacterales Chthoniobacteraceae   Chthoniobacteraceae bacterium
30527721 30527721 PRJNA796639_P_NODE_6733_length_246_cov_0.890173_g6608_i0 PRJNA796639 6733 246 0.890173 2.18982558 Chitinophagales bacterium 2448779 Bacteria Bacteria 42.7 0.0384   NR MCS6934666.1 2448779 g6608 i0 32.6 1.04878048780488 86 45 89 2 231 13 4 89 MCS6934666.1 ABC transporter ATP-binding protein [Chitinophagales bacterium] diamond 258 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales     Chitinophagales bacterium
30843838 30843838 PRJNA796639_P_NODE_6134_length_249_cov_0.875000_g6009_i0 PRJNA796639 6134 249 0.875 2.17875 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 41.2 0.0365   NR MBU6506961.1 1913988 g6009 i0 32.2 0.710843373493976 59 36 69.9 2 75 248 21 76 MBU6506961.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 177 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
31222672 31222672 PRJNA796639_P_NODE_3875_length_289_cov_1.083333_g3750_i0 PRJNA796639 3875 289 1.083333 3.13083237 Myxococcales bacterium 2026763 Bacteria Bacteria 43.1 0.0492   NR MCB9548317.1 2026763 g3750 i0 36.7 0.934256055363322 90 52 89.3 3 289 32 600 688 MCB9548317.1 hypothetical protein [Myxococcales bacterium] diamond 270 43.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Myxococcales bacterium
31254469 31254469 PRJNA796639_P_NODE_5455_length_252_cov_1.435754_g5330_i0 PRJNA796639 5455 252 1.435754 3.61810008 Pseudomonadaceae bacterium 1914538 Bacteria Bacteria 48.9 1.85e-4   NR HHX83143.1 1914538 g5330 i0 62.5 0.857142857142857 32 12 38.1 0 24 119 149 180 HHX83143.1 hypothetical protein [Pseudomonadaceae bacterium] diamond 216 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae   Pseudomonadaceae bacterium
32172104 32172104 PRJNA796639_P_NODE_5538_length_251_cov_0.865169_g5413_i0 PRJNA796639 5538 251 0.865169 2.17157419 Andreprevotia sp. IGB-42 2497473 Bacteria Bacteria 42.7 0.0417   NR WP_201800025.1 2497473 g5413 i0 43.5 0.549800796812749 46 24 55 1 11 148 55 98 WP_201800025.1 type VI secretion system Vgr family protein [Andreprevotia sp. IGB-42] diamond 138 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Andreprevotia Andreprevotia sp. IGB-42
32362008 32362008 PRJNA796639_P_NODE_5199_length_259_cov_0.956989_g5074_i0 PRJNA796639 5199 259 0.956989 2.47860151 Verrucomicrobiales bacterium 2026801 Bacteria Bacteria 43.5 0.0147   NR MCI0541350.1 2026801 g5074 i0 33.3 0.590733590733591 51 33 59.1 1 52 204 72 121 MCI0541350.1 cation transporting ATPase C-terminal domain-containing protein [Verrucomicrobiales bacterium] diamond 153 43.5 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales     Verrucomicrobiales bacterium
32677363 32677363 PRJNA796639_P_NODE_7840_length_241_cov_0.916667_g7715_i0 PRJNA796639 7840 241 0.916667 2.20916747 Sphingomonas lenta 1141887 Bacteria Bacteria 42.4 0.0284   NR WP_095999663.1 1141887 g7715 i0 48.5 0.410788381742739 33 17 41.1 0 127 29 94 126 WP_095999663.1 hypothetical protein [Sphingomonas lenta] diamond 99 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas lenta

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;