RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJNA1047551" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1047551 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
10377941 10377941 PRJNA1047551_S_NODE_6789_length_193_cov_1.626582_g6662_i0 PRJNA1047551 6789 193 1.626582 3.13930326 root 1 Root_unresolved Root_unresolved 110 2.92e-30   NR WP_256818290.1 562 g6662 i0 96 5.67357512953368 50 2 77.7 0 42 191 1 50 WP_256818290.1 hypothetical protein, partial [Escherichia coli] diamond 1095 111 0.990990990990991 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
14203267 14203267 PRJNA1047551_S_NODE_2012_length_316_cov_3.398577_g1885_i0 PRJNA1047551 2012 316 3.398577 10.73950332 root 1 Root_unresolved Root_unresolved 117 3.05e-32   NR WP_256423637.1 670 g1885 i0 76.1 43.8892405063291 67 16 63.6 0 312 112 7 73 WP_256423637.1 hypothetical protein, partial [Vibrio parahaemolyticus] diamond 13869 118 0.991525423728814 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
18026514 18026514 PRJNA1047551_S_NODE_7075_length_190_cov_1.580645_g6948_i0 PRJNA1047551 7075 190 1.580645 3.0032255 Aquisalimonas lutea 1327750 Bacteria Bacteria 98.2 3.919999999999999e-23   NR WP_353959903.1 1327750 g6948 i0 78.7 0.963157894736842 61 13 96.3 0 5 187 13 73 WP_353959903.1 phosphonate ABC transporter ATP-binding protein [Aquisalimonas lutea] diamond 183 98.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Ectothiorhodospiraceae Aquisalimonas Aquisalimonas lutea
27256499 27256499 PRJNA1047551_S_NODE_5843_length_204_cov_2.082840_g5716_i0 PRJNA1047551 5843 204 2.08284 4.2489936 Sphingomonas albertensis 2762591 Bacteria Bacteria 117 2.58e-30   NR WP_187503071.1 2762591 g5716 i0 96.8 0.911764705882353 62 2 91.2 0 202 17 177 238 WP_187503071.1 hypothetical protein [Sphingomonas albertensis] diamond 186 117 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas albertensis
27383059 27383059 PRJNA1047551_S_NODE_6763_length_193_cov_2.056962_g6636_i0 PRJNA1047551 6763 193 2.056962 3.96993666 Aquabacterium sp. 1872578 Bacteria Bacteria 93.2 1.04e-21   NR WP_374590176.1 1872578 g6636 i0 73.4 0.994818652849741 64 17 99.5 0 2 193 70 133 WP_374590176.1 class I SAM-dependent methyltransferase [Aquabacterium sp.] diamond 192 93.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium sp.
27848309 27848309 PRJNA1047551_S_NODE_10284_length_166_cov_1.732824_g10157_i0 PRJNA1047551 10284 166 1.732824 2.87648784 Bacteria 2 Bacteria Bacteria 40.8 0.0244   NR MBS0449542.1 1977087 g10157 i0 75 1.68072289156627 24 6 43.4 0 149 78 92 115 MBS0449542.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Pseudomonadota bacterium] diamond 279 41.2 0.990291262135922 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28140990 28140990 PRJNA1047551_S_NODE_1645_length_346_cov_5.726688_g1518_i0 PRJNA1047551 1645 346 5.726688 19.81434048 Shimia sp. 1954381 Bacteria Bacteria 49.7 1.04e-4   NR WP_348399962.1 1954381 g1518 i0 34.6 1.36127167630058 78 47 67.6 1 44 277 49 122 WP_348399962.1 hypothetical protein [Shimia sp.] diamond 471 49.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Shimia Shimia sp.
28456630 28456630 PRJNA1047551_S_NODE_8126_length_181_cov_1.472603_g7999_i0 PRJNA1047551 8126 181 1.472603 2.66541143 Aliidiomarina sanyensis 1249555 Bacteria Bacteria 117 6.15e-29   NR WP_126777348.1 1249555 g7999 i0 98.3 0.994475138121547 60 1 99.4 0 181 2 292 351 WP_126777348.1 penicillin-binding protein 1B [Aliidiomarina sanyensis] diamond 180 117 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Idiomarinaceae Aliidiomarina Aliidiomarina sanyensis
28456632 28456632 PRJNA1047551_S_NODE_9486_length_171_cov_1.808824_g9359_i0 PRJNA1047551 9486 171 1.808824 3.09308904 Bradyrhizobium sp. SZCCHNR1 376 Bacteria Bacteria 41.2 0.0374   NR WP_316230582.1 3057355 g9359 i0 42.3 0.912280701754386 52 29 91.2 1 165 10 43 93 WP_316230582.1 tannase/feruloyl esterase family alpha/beta hydrolase [Bradyrhizobium sp. SZCCHNR1051] diamond 156 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. SZCCHNR1051
28519754 28519754 PRJNA1047551_S_NODE_13767_length_150_cov_1.226087_g13640_i0 PRJNA1047551 13767 150 1.226087 1.8391305 Pseudomonadales bacterium 1891229 Bacteria Bacteria 59.3 1e-9   NR MDP6264638.1 1891229 g13640 i0 58.7 2.76 46 19 92 0 139 2 18 63 MDP6264638.1 50S ribosomal protein L21 [Pseudomonadales bacterium] diamond 414 59.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales     Pseudomonadales bacterium
28898355 28898355 PRJNA1047551_S_NODE_13528_length_151_cov_1.137931_g13401_i0 PRJNA1047551 13528 151 1.137931 1.71827581 Parvularculales bacterium 3107534 Bacteria Bacteria 41.6 0.00587   NR MEG9863015.1 3107534 g13401 i0 52.4 0.834437086092715 42 16 75.5 1 2 115 20 61 MEG9863015.1 ankyrin repeat domain-containing protein [Parvularculales bacterium] diamond 126 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Parvularculales     Parvularculales bacterium
29182847 29182847 PRJNA1047551_S_NODE_10329_length_166_cov_1.396947_g10202_i0 PRJNA1047551 10329 166 1.396947 2.31893202 Paracoccus sanguinis 1545044 Bacteria Bacteria 97.8 8.039999999999999e-23   NR WP_036704346.1 1545044 g10202 i0 96.3 0.975903614457831 54 2 97.6 0 3 164 46 99 WP_036704346.1 LysR family transcriptional regulator [Paracoccus sanguinis] diamond 162 97.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus sanguinis
29403714 29403714 PRJNA1047551_S_NODE_12409_length_155_cov_1.825000_g12282_i0 PRJNA1047551 12409 155 1.825 2.82875 Paracoccus aeridis 1966466 Bacteria Bacteria 99.8 2.89e-24   NR WP_201740526.1 1966466 g12282 i0 100 0.987096774193548 51 0 98.7 0 2 154 6 56 WP_201740526.1 phage holin family protein [Paracoccus aeridis] diamond 153 99.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus aeridis
29750763 29750763 PRJNA1047551_S_NODE_11711_length_158_cov_2.869919_g11584_i0 PRJNA1047551 11711 158 2.869919 4.53447202 Granulosicoccus sp. 1943584 Bacteria Bacteria 41.6 0.0303   NR MFK7855044.1 1943584 g11584 i0 46.7 0.854430379746835 45 23 85.4 1 142 8 98 141 MFK7855044.1 gamma-glutamyltransferase family protein [Granulosicoccus sp.] diamond 135 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Granulosicoccaceae Granulosicoccus Granulosicoccus sp.
29782576 29782576 PRJNA1047551_S_NODE_7391_length_187_cov_1.467105_g7264_i0 PRJNA1047551 7391 187 1.467105 2.74348635 Paracoccus aeridis 1966466 Bacteria Bacteria 48.5 9.93e-5   NR WP_136652447.1 1966466 g7264 i0 95.7 0.368983957219251 23 1 36.9 0 69 137 173 195 WP_136652447.1 hypothetical protein [Paracoccus aeridis] diamond 69 48.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus aeridis
30572188 30572188 PRJNA1047551_S_NODE_4673_length_221_cov_3.790323_g4546_i0 PRJNA1047551 4673 221 3.790323 8.37661383 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 41.6 0.0305   NR MBI3343807.1 1913989 g4546 i0 41.8 0.746606334841629 55 29 73.3 2 55 216 32 84 MBI3343807.1 PAS domain S-box protein [Gammaproteobacteria bacterium] diamond 165 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
30572192 30572192 PRJNA1047551_S_NODE_8373_length_179_cov_1.715278_g8246_i0 PRJNA1047551 8373 179 1.715278 3.07034762 Brucella anthropi 529 Bacteria Bacteria 41.6 0.0331   NR WP_259030153.1 529 g8246 i0 40.9 0.737430167597765 44 26 73.7 0 134 3 132 175 WP_259030153.1 hypothetical protein [Brucella anthropi] diamond 132 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Brucellaceae Brucella Brucella anthropi
30595732 30595732 PRJNA1047551_S_NODE_3613_length_247_cov_1.183962_g3486_i0 PRJNA1047551 3613 247 1.183962 2.92438614 Neorhizobium 1525371 Bacteria Bacteria 68.2 3.09e-11   NR WP_046847863.1 356 g3486 i0 51.5 1.61538461538462 66 32 80.2 0 205 8 1 66 WP_046847863.1 MULTISPECIES: NAD-dependent epimerase/dehydratase family protein [Hyphomicrobiales] diamond 399 68.6 0.994169096209913 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales      
30698705 30698705 PRJNA1047551_S_NODE_7754_length_184_cov_1.442953_g7627_i0 PRJNA1047551 7754 184 1.442953 2.65503352 Rhizobium sp. CC-YZS 391 Bacteria Bacteria 119 1.61e-32   NR WP_323106202.1 3042153 g7627 i0 100 0.994565217391304 61 0 99.5 0 1 183 54 114 WP_323106202.1 cupin [Rhizobium sp. CC-YZS058] diamond 183 119 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium Rhizobium sp. CC-YZS058
30762060 30762060 PRJNA1047551_S_NODE_2514_length_287_cov_1.940476_g2387_i0 PRJNA1047551 2514 287 1.940476 5.56916612 Paracoccus sanguinis 1545044 Bacteria Bacteria 174 6.85e-52   NR WP_036704346.1 1545044 g2387 i0 93.7 0.993031358885017 95 6 99.3 0 285 1 196 290 WP_036704346.1 LysR family transcriptional regulator [Paracoccus sanguinis] diamond 285 174 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus sanguinis
30920153 30920153 PRJNA1047551_S_NODE_9494_length_171_cov_1.617647_g9367_i0 PRJNA1047551 9494 171 1.617647 2.76617637 Burkholderia reimsis 2234132 Bacteria Bacteria 42.4 0.0198   NR WP_113045870.1 2234132 g9367 i0 36.8 1 57 36 100 0 171 1 49 105 WP_113045870.1 hypothetical protein [Burkholderia reimsis] diamond 171 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Burkholderia Burkholderia reimsis
31140705 31140705 PRJNA1047551_S_NODE_7935_length_182_cov_2.197279_g7808_i0 PRJNA1047551 7935 182 2.197279 3.99904778 Azotobacter chroococcum 353 Bacteria Bacteria 69.3 4.64e-12   NR WP_198867466.1 353 g7808 i0 56.1 2.76923076923077 57 25 94 0 1 171 164 220 WP_198867466.1 electron transfer flavoprotein subunit alpha/FixB family protein [Azotobacter chroococcum] diamond 504 69.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Azotobacter Azotobacter chroococcum
31172408 31172408 PRJNA1047551_S_NODE_4895_length_218_cov_1.704918_g4768_i0 PRJNA1047551 4895 218 1.704918 3.71672124 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 125 1.57e-34   NR MCF6235298.1 1913989 g4768 i0 72.9 3.88073394495413 70 19 96.3 0 9 218 118 187 MCF6235298.1 superoxide dismutase [Fe] [Gammaproteobacteria bacterium] diamond 846 125 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
31299180 31299180 PRJNA1047551_S_NODE_8275_length_180_cov_1.268966_g8148_i0 PRJNA1047551 8275 180 1.268966 2.2841388 Paracoccus aeridis 1966466 Bacteria Bacteria 104 4.61e-26   NR WP_201740526.1 1966466 g8148 i0 100 0.983333333333333 59 0 98.3 0 179 3 57 115 WP_201740526.1 phage holin family protein [Paracoccus aeridis] diamond 177 104 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus aeridis
31520765 31520765 PRJNA1047551_S_NODE_7176_length_189_cov_1.512987_g7049_i0 PRJNA1047551 7176 189 1.512987 2.85954543 Magnetococcales bacterium 2026759 Bacteria Bacteria 40.4 0.0449   NR MBF0179998.1 2026759 g7049 i0 44.9 0.777777777777778 49 27 77.8 0 31 177 62 110 MBF0179998.1 hypothetical protein [Magnetococcales bacterium] diamond 147 40.4 1 Bacteria   Pseudomonadati Pseudomonadota Magnetococcia Magnetococcales     Magnetococcales bacterium
32248550 32248550 PRJNA1047551_S_NODE_10538_length_165_cov_1.061538_g10411_i0 PRJNA1047551 10538 165 1.061538 1.7515377 Francisella sp. 2047875 Bacteria Bacteria 101 3.37e-24   NR PZU04902.1 2047875 g10411 i0 100 0.927272727272727 51 0 92.7 0 12 164 1 51 PZU04902.1 MAG: phosphate starvation-inducible protein PhoH [Francisella sp.] diamond 153 101 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Francisellaceae Francisella Francisella sp.
32311819 32311819 PRJNA1047551_S_NODE_10479_length_165_cov_1.430769_g10352_i0 PRJNA1047551 10479 165 1.430769 2.36076885 Halomonas sp. 1486246 Bacteria Bacteria 51.2 1.25e-5   NR MEC9483338.1 1486246 g10352 i0 63.9 2.94545454545455 36 13 65.5 0 33 140 263 298 MEC9483338.1 acyl-CoA dehydrogenase C-terminal domain-containing protein [Halomonas sp.] diamond 486 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae Halomonas Halomonas sp.
32627469 32627469 PRJNA1047551_S_NODE_5880_length_204_cov_1.082840_g5753_i0 PRJNA1047551 5880 204 1.08284 2.2089936 Paracoccus aeridis 1966466 Bacteria Bacteria 129 2.8399999999999997e-37   NR WP_201740580.1 1966466 g5753 i0 100 0.970588235294118 66 0 97.1 0 200 3 1 66 WP_201740580.1 hypothetical protein [Paracoccus aeridis] diamond 198 129 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus aeridis
32650752 32650752 PRJNA1047551_S_NODE_2800_length_274_cov_2.937238_g2673_i0 PRJNA1047551 2800 274 2.937238 8.04803212 Alphaproteobacteria 28211 Bacteria Bacteria 49.3 2.15e-4   NR WP_188908270.1 690164 g2673 i0 75.9 3.45985401459854 29 7 31.8 0 16 102 221 249 WP_188908270.1 electron transfer flavoprotein subunit beta/FixA family protein [Salinarimonas ramus] diamond 948 49.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Salinarimonadaceae Salinarimonas Salinarimonas ramus
32808429 32808429 PRJNA1047551_S_NODE_4440_length_226_cov_1.340314_g4313_i0 PRJNA1047551 4440 226 1.340314 3.02910964 Bacteria 2 Bacteria Bacteria 115 1.22e-28   NR QRN41785.1 2014784 g4313 i0 70.7 2.98672566371681 75 22 99.6 0 226 2 299 373 QRN41785.1 MAG: O-succinylhomoserine sulfhydrylase [Neisseriaceae bacterium] diamond 675 116 0.991379310344828 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae   Neisseriaceae bacterium
32816486 32816486 PRJNA1047551_S_NODE_5360_length_211_cov_1.852273_g5233_i0 PRJNA1047551 5360 211 1.852273 3.90829603 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 41.6 0.00871   NR MCG8543327.1 1913988 g5233 i0 36.5 0.739336492890995 52 33 73.9 0 3 158 11 62 MCG8543327.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 156 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium

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