RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where bioproject = "PRJNA796639" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJNA796639 · 25 ✖

tax_clade 0

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
3331624 3331624 PRJNA796639_P_NODE_6563_length_247_cov_0.885057_g6438_i0 PRJNA796639 6563 247 0.885057 2.18609079 Comamonadaceae bacterium OS-1 2993872 Bacteria Bacteria 52.8 0.022   NTclustered gi|2328124537|dbj|AP026969.1| 2993872 g6438 i0 94.286 0.1417004048583 35 1 14 1 22 55 4878262 4878228 Comamonadaceae bacterium OS-1 DNA, nearly complete genome blastn 35 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae   Comamonadaceae bacterium OS-1
4608871 4608871 PRJNA796639_P_NODE_3244_length_312_cov_1.288703_g3119_i0 PRJNA796639 3244 312 1.288703 4.02075336 Stenotrophomonas maltophilia 40324 Bacteria Bacteria 56.5 0.002   NTclustered gi|1192692663|gb|CP015612.1| 40324 g3119 i0 96.97 0.208333333333333 33 1 11 0 254 286 4433301 4433269 Stenotrophomonas maltophilia strain OUC_Est10, complete genome blastn 65 56.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas maltophilia
5044753 5044753 PRJNA796639_P_NODE_5444_length_252_cov_2.547486_g5319_i0 PRJNA796639 5444 252 2.547486 6.41966472 Comamonadaceae 80864 Bacteria Bacteria 436 5.4e-118   NTclustered gi|1373249612|gb|CP028292.1| 80867 g5319 i0 98.008 222.480158730159 251 5 99 0 1 251 5231218 5230968 Paracidovorax avenae strain INDB2 chromosome blastn 56065 436 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Paracidovorax Paracidovorax avenae
7594742 7594742 PRJNA796639_P_NODE_2726_length_341_cov_1.156716_g2601_i0 PRJNA796639 2726 341 1.156716 3.94440156 Comamonadaceae 80864 Bacteria Bacteria 595 1.1899999999999999e-165   NTclustered gi|1586158954|gb|CP031395.1| 80880 g2601 i0 98.235 199.718475073314 340 6 99 0 1 340 392931 392592 Hylemonella gracilis strain NS1 chromosome blastn 68104 601 0.990016638935108 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Hylemonella Hylemonella gracilis
7594752 7594752 PRJNA796639_P_NODE_5386_length_254_cov_1.309392_g5261_i0 PRJNA796639 5386 254 1.309392 3.32585568 Enterobacteriaceae 543 Bacteria Bacteria 459 1.1599999999999999e-124   NTclustered gi|2650988455|gb|CP142548.1| 562 g5261 i0 99.213 665.775590551181 254 2 100 0 1 254 186540 186287 Escherichia coli strain ExPEC_A382 chromosome, complete genome blastn 169107 459 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
8433618 8433618 PRJNA796639_P_NODE_5327_length_255_cov_2.318681_g5202_i0 PRJNA796639 5327 255 2.318681 5.91263655 Pseudomonas congelans 200452 Bacteria Bacteria 54.7 0.006   NTclustered gi|2045689390|gb|CP053030.1| 200452 g5202 i0 100 0.227450980392157 29 0 11 0 171 199 2688761 2688733 Pseudomonas congelans strain 508 chromosome, complete genome blastn 58 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas congelans
8433639 8433639 PRJNA796639_P_NODE_6267_length_248_cov_0.880000_g6142_i0 PRJNA796639 6267 248 0.88 2.1824 Candidatus Nasuia deltocephalincola 1160784 Bacteria Bacteria 60.2 1.34e-4   NTclustered gi|2293493133|gb|CP094186.1| 1160784 g6142 i0 94.872 0.157258064516129 39 1 15 1 201 238 61594 61556 Candidatus Nasuia deltocephalinicola strain KIMY chromosome, complete genome blastn 39 60.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria     Candidatus Nasuia Candidatus Nasuia deltocephalincola
8433660 8433660 PRJNA796639_P_NODE_7567_length_242_cov_0.911243_g7442_i0 PRJNA796639 7567 242 0.911243 2.20520806 Acinetobacter johnsonii 40214 Bacteria Bacteria 448 2.3799999999999995e-121   NTclustered gi|1995442560|gb|CP070867.1| 40214 g7442 i0 100 193.342975206612 242 0 100 0 1 242 26696 26455 Acinetobacter johnsonii strain XY27 plasmid plas1, complete sequence blastn 46789 448 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter johnsonii
10984486 10984486 PRJNA796639_P_NODE_6509_length_247_cov_0.885057_g6384_i0 PRJNA796639 6509 247 0.885057 2.18609079 Vibrio misgurnus 2993714 Bacteria Bacteria 446 8.759999999999998e-121   NTclustered gi|2482491404|gb|CP113242.1| 2993714 g6384 i0 99.19 2 247 2 100 0 1 247 139655 139409 Vibrio sp. gvc chromosome 2, complete sequence blastn 494 446 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio misgurnus
12260031 12260031 PRJNA796639_P_NODE_5630_length_251_cov_0.865169_g5505_i0 PRJNA796639 5630 251 0.865169 2.17157419 Agrobacterium tumefaciens 358 Bacteria Bacteria 348 2.5900000000000005e-91   NTclustered gi|1633808627|gb|CP039889.1| 358 g5505 i0 91.633 75.800796812749 251 21 100 0 1 251 1906224 1906474 Agrobacterium tumefaciens strain CFBP5499 chromosome linear, complete sequence blastn 19026 348 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Agrobacterium Agrobacterium tumefaciens
12260044 12260044 PRJNA796639_P_NODE_6210_length_248_cov_0.880000_g6085_i0 PRJNA796639 6210 248 0.88 2.1824 Vibrio misgurnus 2993714 Bacteria Bacteria 459 1.13e-124   NTclustered gi|2482491403|gb|CP113241.1| 2993714 g6085 i0 100 2.1008064516129 248 0 100 0 1 248 1286190 1285943 Vibrio sp. gvc chromosome 1, complete sequence blastn 521 459 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio misgurnus
15245050 15245050 PRJNA796639_P_NODE_5992_length_249_cov_0.875000_g5867_i0 PRJNA796639 5992 249 0.875 2.17875 root 1 Root_unresolved Root_unresolved 449 6.840000000000001e-122   NTclustered gi|2499340541|gb|CP123918.1| 106648 g5867 i0 99.197 671.951807228916 249 2 100 0 1 249 24997 25245 Acinetobacter bereziniae strain UCO-554 chromosome, complete genome blastn 167316 449 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter bereziniae
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.
19907318 19907318 PRJNA796639_P_NODE_4576_length_273_cov_2.100000_g4451_i0 PRJNA796639 4576 273 2.1 5.733 Buchnera aphidicola 9 Bacteria Bacteria 56.5 0.002   NTclustered gi|2736164353|gb|CP140035.1| 3093910 g4451 i0 100 0.10989010989011 30 0 11 0 49 78 431365 431336 MAG: Buchnera aphidicola (Nurudea shiraii) isolate R20 chromosome, complete genome blastn 30 56.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Buchnera Buchnera aphidicola
22894247 22894247 PRJNA796639_P_NODE_5398_length_254_cov_1.000000_g5273_i0 PRJNA796639 5398 254 1 2.54 Acinetobacter 469 Bacteria Bacteria 470 5.37e-128   NTclustered gi|1958425625|gb|CP068206.1| 40214 g5273 i0 100 631.090551181102 254 0 100 0 1 254 1095934 1095681 Acinetobacter johnsonii strain FDAARGOS_1092 chromosome, complete genome blastn 160297 470 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter johnsonii
25006944 25006944 PRJNA796639_P_NODE_4520_length_275_cov_1.311881_g4395_i0 PRJNA796639 4520 275 1.311881 3.60767275 Aurantimonas sp. HBX-1 2906072 Bacteria Bacteria 183 8.59e-42   NTclustered gi|2174753144|gb|CP090066.1| 2906072 g4395 i0 78.986 3.42545454545455 276 53 100 4 1 275 3054616 3054345 Aurantimonas sp. HBX-1 chromosome, complete genome blastn 942 183 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Aurantimonadaceae Aurantimonas Aurantimonas sp. HBX-1
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.
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
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
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
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
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
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);;