RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA287283" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA287283 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
2922846 2922846 PRJNA287283_P_NODE_10103_length_176_cov_0.910569_g9879_i0 PRJNA287283 10103 176 0.910569 1.60260144 Curvibacter gracilis 230310 Bacteria Bacteria 101 3.6799999999999996e-23   NR WP_051442919.1 230310 g9879 i0 96.4 0.9375 55 2 93.8 0 169 5 531 585 WP_051442919.1 hydantoinase/oxoprolinase family protein [Curvibacter gracilis] diamond 165 101 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter gracilis
26694210 26694210 PRJNA287283_P_NODE_10401_length_175_cov_0.918033_g10177_i0 PRJNA287283 10401 175 0.918033 1.60655775 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 41.2 0.018   NR WP_395587787.1 251699 g10177 i0 54.3 0.6 35 14 56.6 1 122 24 14 48 WP_395587787.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 105 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
27154587 27154587 PRJNA287283_P_NODE_7682_length_194_cov_1.985816_g7458_i0 PRJNA287283 7682 194 1.985816 3.85248304 root 1 Root_unresolved Root_unresolved 132 3.57e-38   NR WP_224642557.1 672 g7458 i0 100 24.2474226804124 56 0 86.6 0 192 25 64 119 WP_224642557.1 ubiquitin-40S ribosomal protein S27a family protein, partial [Vibrio vulnificus] diamond 4704 132 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio vulnificus
27200360 27200360 PRJNA287283_P_NODE_5762_length_243_cov_1.063158_g5538_i0 PRJNA287283 5762 243 1.063158 2.58347394 Vibrio parahaemolyticus 670 Bacteria Bacteria 86.3 1e-19   NR MDF4321764.1 670 g5538 i0 56.2 1.82716049382716 73 25 85.2 2 14 220 25 94 MDF4321764.1 hypothetical protein [Vibrio parahaemolyticus] diamond 444 86.7 0.995386389850058 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
27232171 27232171 PRJNA287283_P_NODE_3983_length_316_cov_2.034221_g3759_i0 PRJNA287283 3983 316 2.034221 6.42813836 Bradyrhizobium canariense 255045 Bacteria Bacteria 105 5.42e-27   NR WP_210190386.1 255045 g3759 i0 100 71.9525316455696 53 0 50.3 0 257 99 65 117 WP_210190386.1 NADH dehydrogenase subunit 3, partial [Bradyrhizobium canariense] diamond 22737 105 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium canariense
27295413 27295413 PRJNA287283_P_NODE_9383_length_179_cov_0.888889_g9159_i0 PRJNA287283 9383 179 0.888889 1.59111131 Phreatobacter oligotrophus 1122261 Bacteria Bacteria 54.7 5.18e-7   NR WP_108175081.1 1122261 g9159 i0 100 0.402234636871508 24 0 40.2 0 107 178 1 24 WP_108175081.1 FMN-binding negative transcriptional regulator [Phreatobacter oligotrophus] diamond 72 54.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phreatobacteraceae Phreatobacter Phreatobacter oligotrophus
27516522 27516522 PRJNA287283_P_NODE_9003_length_181_cov_0.875000_g8779_i0 PRJNA287283 9003 181 0.875 1.58375 Pigmentiphaga 152267 Bacteria Bacteria 41.6 0.0388   NR WP_279815317.1 152267 g8779 i0 43.6 0.911602209944751 55 27 89.5 2 170 9 74 125 WP_279815317.1 MULTISPECIES: ABC transporter permease [Pigmentiphaga] diamond 165 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Alcaligenaceae Pigmentiphaga  
27926994 27926994 PRJNA287283_P_NODE_8765_length_182_cov_0.868217_g8541_i0 PRJNA287283 8765 182 0.868217 1.58015494 Microvirga antarctica 2819233 Bacteria Bacteria 75.1 3.86e-16   NR WP_210497549.1 2819233 g8541 i0 94.6 4.25274725274725 37 2 61 0 2 112 32 68 WP_210497549.1 60S acidic ribosomal protein P1, partial [Microvirga antarctica] diamond 774 75.5 0.994701986754967 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Microvirga Microvirga antarctica
28039437 28039437 PRJNA287283_P_NODE_7805_length_192_cov_1.611511_g7581_i0 PRJNA287283 7805 192 1.611511 3.09410112 root 1 Root_unresolved Root_unresolved 126 3.0599999999999997e-35   NR WP_340581655.1 573 g7581 i0 98.4 1038.515625 63 1 98.4 0 190 2 48 110 WP_340581655.1 proton-conducting transporter membrane subunit, partial [Klebsiella pneumoniae] diamond 199395 126 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28039438 28039438 PRJNA287283_P_NODE_9605_length_178_cov_0.896000_g9381_i0 PRJNA287283 9605 178 0.896 1.59488 Sphingomonas 13687 Bacteria Bacteria 95.5 4.1100000000000006e-21   NR WP_019370218.1 196159 g9381 i0 67.8 1.98876404494382 59 19 99.4 0 1 177 472 530 WP_019370218.1 MULTISPECIES: alpha-N-acetylglucosaminidase [unclassified Sphingomonas] diamond 354 96.3 0.991692627206646 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
28084770 28084770 PRJNA287283_P_NODE_4485_length_293_cov_1.633333_g4261_i0 PRJNA287283 4485 293 1.633333 4.78566569 Klebsiella pneumoniae 573 Bacteria Bacteria 83.2 9.67e-19   NR WP_289465580.1 573 g4261 i0 74.6 0.686006825938567 67 17 68.6 0 45 245 1 67 WP_289465580.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 201 83.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28242554 28242554 PRJNA287283_P_NODE_9426_length_179_cov_0.888889_g9202_i0 PRJNA287283 9426 179 0.888889 1.59111131 Burkholderiales bacterium 1891238 Bacteria Bacteria 47 1.05e-4   NR HET7671815.1 1891238 g9202 i0 42.6 1.81005586592179 54 31 90.5 0 168 7 51 104 HET7671815.1 EF-hand domain-containing protein [Burkholderiales bacterium] diamond 324 47 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales     Burkholderiales bacterium
28305853 28305853 PRJNA287283_P_NODE_6746_length_215_cov_1.277778_g6522_i0 PRJNA287283 6746 215 1.277778 2.7472227 Pseudomonadota bacterium 1977087 Bacteria Bacteria 46.2 0.00158   NR MEY3013286.1 1977087 g6522 i0 50 1.15813953488372 42 19 58.6 1 128 3 122 161 MEY3013286.1 hypothetical protein [Pseudomonadota bacterium] diamond 249 46.2 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28653244 28653244 PRJNA287283_P_NODE_10287_length_176_cov_0.894309_g10063_i0 PRJNA287283 10287 176 0.894309 1.57398384 Curvibacter gracilis 230310 Bacteria Bacteria 116 2.09e-29   NR WP_027477589.1 230310 g10063 i0 93.1 0.988636363636364 58 4 98.9 0 2 175 159 216 WP_027477589.1 MFS transporter [Curvibacter gracilis] diamond 174 116 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter gracilis
28716433 28716433 PRJNA287283_P_NODE_7187_length_205_cov_1.105263_g6963_i0 PRJNA287283 7187 205 1.105263 2.26578915 Pseudomonadota bacterium 1977087 Bacteria Bacteria 40.8 0.0358   NR MEY4122111.1 1977087 g6963 i0 36.7 0.878048780487805 60 37 87.8 1 18 197 11 69 MEY4122111.1 Phthalate 4,5-dioxygenase oxygenase subunit [Pseudomonadota bacterium] diamond 180 40.8 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29207763 29207763 PRJNA287283_P_NODE_9229_length_180_cov_0.881890_g9005_i0 PRJNA287283 9229 180 0.88189 1.587402 Methylophilus 16 Bacteria Bacteria 92 2.49e-20   NR TXI38650.1 17 g9005 i0 73.8 4.06666666666667 61 14 98.3 1 3 179 20 80 TXI38650.1 MAG: hypothetical protein E6Q51_00740 [Methylophilus methylotrophus] diamond 732 92.8 0.991379310344828 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Methylophilaceae Methylophilus Methylophilus methylotrophus
29379385 29379385 PRJNA287283_P_NODE_8809_length_182_cov_0.868217_g8585_i0 PRJNA287283 8809 182 0.868217 1.58015494 Curvibacter lanceolatus 86182 Bacteria Bacteria 105 1.32e-24   NR WP_019578149.1 86182 g8585 i0 85 1.97802197802198 60 9 98.9 0 181 2 204 263 WP_019578149.1 PLP-dependent aminotransferase family protein [Curvibacter lanceolatus] diamond 360 105 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Curvibacter Curvibacter lanceolatus
29916362 29916362 PRJNA287283_P_NODE_10171_length_176_cov_0.910569_g9947_i0 PRJNA287283 10171 176 0.910569 1.60260144 Stenotrophomonas sp. 69392 Bacteria Bacteria 100 5.39e-26   NR MPS43946.1 69392 g9947 i0 89.7 1.97727272727273 58 6 98.9 0 1 174 40 97 MPS43946.1 hypothetical protein [Stenotrophomonas sp.] diamond 348 100 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Stenotrophomonas Stenotrophomonas sp.
30168746 30168746 PRJNA287283_P_NODE_9872_length_177_cov_0.903226_g9648_i0 PRJNA287283 9872 177 0.903226 1.59871002 Aquabacterium commune 70586 Bacteria Bacteria 107 3.45e-26   NR WP_133606057.1 70586 g9648 i0 94.8 1.96610169491525 58 3 98.3 0 175 2 26 83 WP_133606057.1 glycosyltransferase [Aquabacterium commune] diamond 348 107 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium commune
30484950 30484950 PRJNA287283_P_NODE_9613_length_178_cov_0.896000_g9389_i0 PRJNA287283 9613 178 0.896 1.59488 Pseudomonadota bacterium 1977087 Bacteria Bacteria 48.1 1.93e-4   NR HRI50777.1 1977087 g9389 i0 39.7 0.97752808988764 58 28 96.1 2 5 175 43 94 HRI50777.1 hypothetical protein [Pseudomonadota bacterium] diamond 174 48.1 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30548047 30548047 PRJNA287283_P_NODE_3173_length_359_cov_3.725490_g2949_i0 PRJNA287283 3173 359 3.72549 13.3745091 Bradyrhizobium canariense 255045 Bacteria Bacteria 174 3.32e-53   NR OSI97818.1 255045 g2949 i0 98.1 16.3454038997214 103 2 86.1 0 309 1 35 137 OSI97818.1 ATP synthase F0 subunit A [Bradyrhizobium canariense] diamond 5868 174 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium canariense
30579427 30579427 PRJNA287283_P_NODE_8173_length_186_cov_1.263158_g7949_i0 PRJNA287283 8173 186 1.263158 2.34947388 Bradyrhizobium sp. Ghvi 1855319 Bacteria Bacteria 45.4 0.00191   NR WP_092290710.1 1855319 g7949 i0 39.2 1.64516129032258 51 31 82.3 0 176 24 114 164 WP_092290710.1 MFS transporter [Bradyrhizobium sp. Ghvi] diamond 306 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium sp. Ghvi
30660513 30660513 PRJNA287283_P_NODE_8753_length_182_cov_0.868217_g8529_i0 PRJNA287283 8753 182 0.868217 1.58015494 Novosphingobium 165696 Bacteria Bacteria 79.3 1.1e-15   NR EGD59075.1 983920 g8529 i0 69.1 15.4285714285714 55 17 90.7 0 182 18 75 129 EGD59075.1 homocysteine S-methyltransferase [Novosphingobium nitrogenifigens DSM 19370] diamond 2808 80.1 0.990012484394507 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Novosphingobium Novosphingobium nitrogenifigens
31102705 31102705 PRJNA287283_P_NODE_8555_length_183_cov_0.861538_g8331_i0 PRJNA287283 8555 183 0.861538 1.57661454 Sphingomonadales 204457 Bacteria Bacteria 58.9 2.61e-9   NR WP_300883983.1 28211 g8331 i0 73.2 4.0983606557377 56 14 90.2 1 19 183 1 56 WP_300883983.1 MULTISPECIES: hypothetical protein [Alphaproteobacteria] diamond 750 58.9 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria        
31211117 31211117 PRJNA287283_P_NODE_2195_length_446_cov_8.203562_g1972_i0 PRJNA287283 2195 446 8.203562 36.58788652 Microvirga antarctica 2819233 Bacteria Bacteria 114 3.23e-30   NR WP_210497549.1 2819233 g1972 i0 98.2 2.01793721973094 57 1 38.3 0 173 343 13 69 WP_210497549.1 60S acidic ribosomal protein P1, partial [Microvirga antarctica] diamond 900 115 0.991304347826087 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Microvirga Microvirga antarctica
31844059 31844059 PRJNA287283_P_NODE_9577_length_178_cov_1.072000_g9353_i0 PRJNA287283 9577 178 1.072 1.90816 Klebsiella pneumoniae 573 Bacteria Bacteria 116 1.9799999999999996e-31   NR WP_159224916.1 573 g9353 i0 100 22.8707865168539 59 0 99.4 0 177 1 37 95 WP_159224916.1 nucleoside monophosphate kinase, partial [Klebsiella pneumoniae] diamond 4071 116 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
32209919 32209919 PRJNA287283_P_NODE_8438_length_183_cov_0.861538_g8214_i0 PRJNA287283 8438 183 0.861538 1.57661454 Bradyrhizobium 374 Bacteria Bacteria 43.1 0.00942   NR WP_157973342.1 28211 g8214 i0 37.5 2.09836065573771 64 31 90.2 2 169 5 86 149 WP_157973342.1 MULTISPECIES: uridine kinase family protein [Alphaproteobacteria] diamond 384 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria        
32572122 32572122 PRJNA287283_P_NODE_9019_length_181_cov_0.875000_g8795_i0 PRJNA287283 9019 181 0.875 1.58375 Pseudomonas sp. WN 306 Bacteria Bacteria 43.1 0.0113   NR PAU86082.1 2032629 g8795 i0 51.4 3.48066298342541 35 17 58 0 75 179 15 49 PAU86082.1 alpha/beta hydrolase [Pseudomonas sp. WN033] diamond 630 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. WN033

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