RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1066877" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJNA1066877 · 20 ✖

analysis 1

  • diamond · 20 ✖
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
180309 180309 PRJNA1066877_S_NODE_10721_length_171_cov_1.254098_g10686_i0 PRJNA1066877 10721 171 1.254098 2.14450758 Enterobacter mori 539813 Bacteria Bacteria 107 6.16e-29   NR PWG67911.1 539813 g10686 i0 100 0.982456140350877 56 0 98.2 0 169 2 8 63 PWG67911.1 hypothetical protein DEM28_26025, partial [Enterobacter mori] diamond 168 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter mori
5283205 5283205 PRJNA1066877_S_NODE_4145_length_245_cov_1.301020_g4110_i0 PRJNA1066877 4145 245 1.30102 3.187499 Rufibacter ruber 1783499 Bacteria Bacteria 82.8 2.94e-16   NR WP_066833853.1 1783499 g4110 i0 50.6 4.37142857142857 89 29 90.6 1 3 224 114 202 WP_066833853.1 mercury(II) reductase [Rufibacter ruber] diamond 1071 82.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Hymenobacteraceae Rufibacter Rufibacter ruber
26908977 26908977 PRJNA1066877_S_NODE_12182_length_164_cov_0.886957_g12147_i0 PRJNA1066877 12182 164 0.886957 1.45460948 Lysobacterales bacterium CG17_big_fil_post_rev_8_21_14_2_5 2006849 Bacteria Bacteria 41.2 0.045   NR PIQ37167.1 1974109 g12147 i0 51.1 0.859756097560976 47 17 86 1 22 162 97 137 PIQ37167.1 MAG: hypothetical protein COW59_08640 [Lysobacterales bacterium CG17_big_fil_post_rev_8_21_14_2_50_64_11] diamond 141 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales     Lysobacterales bacterium CG17_big_fil_post_rev_8_21_14_2_50_64_11
27383321 27383321 PRJNA1066877_S_NODE_3743_length_254_cov_2.282927_g3708_i0 PRJNA1066877 3743 254 2.282927 5.79863458 Candidatus Omnitrophota bacterium 2035772 Bacteria Bacteria 42.7 0.0398   NR HEO64127.1 2035772 g3708 i0 35.8 0.791338582677165 67 42 79.1 1 207 7 110 175 HEO64127.1 GTPase Era [Candidatus Omnitrophota bacterium] diamond 201 42.7 1 Bacteria PVC group Pseudomonadati Candidatus Omnitrophota         Candidatus Omnitrophota bacterium
27509643 27509643 PRJNA1066877_S_NODE_3623_length_257_cov_2.644231_g3588_i0 PRJNA1066877 3623 257 2.644231 6.79567367 Sorangium cellulosum 56 Bacteria Bacteria 49.7 2.07e-5   NR WP_104977321.1 56 g3588 i0 56 0.583657587548638 50 22 58.4 0 1 150 2 51 WP_104977321.1 CsbD family protein [Sorangium cellulosum] diamond 150 49.7 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae Sorangium Sorangium cellulosum
27564127 27564127 PRJNA1066877_S_NODE_11824_length_165_cov_1.258621_g11789_i0 PRJNA1066877 11824 165 1.258621 2.07672465 root 1 Root_unresolved Root_unresolved 92 2.9300000000000004e-21   NR WP_266333533.1 562 g11789 i0 75.9 93.2727272727273 54 13 98.2 0 2 163 90 143 WP_266333533.1 hypothetical protein [Escherichia coli] diamond 15390 92 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28141257 28141257 PRJNA1066877_S_NODE_4245_length_243_cov_1.051546_g4210_i0 PRJNA1066877 4245 243 1.051546 2.55525678 Escherichia coli 562 Bacteria Bacteria 112 1.6799999999999999e-29   NR WP_230509318.1 562 g4210 i0 100 0.728395061728395 59 0 72.8 0 3 179 86 144 WP_230509318.1 hypothetical protein, partial [Escherichia coli] diamond 177 112 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28417031 28417031 PRJNA1066877_S_NODE_12666_length_162_cov_0.902655_g12631_i0 PRJNA1066877 12666 162 0.902655 1.4623011 Porphyromonas 836 Bacteria Bacteria 111 1.19e-27   NR MFC2631995.1 1583331 g12631 i0 100 3 54 0 100 0 1 162 95 148 MFC2631995.1 SusF/SusE family outer membrane protein [Porphyromonas pasteri] diamond 486 111 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Porphyromonadaceae Porphyromonas Porphyromonas pasteri
28456876 28456876 PRJNA1066877_S_NODE_2706_length_287_cov_4.852941_g2671_i0 PRJNA1066877 2706 287 4.852941 13.92794067 Campylobacter sp. 2 205 Bacteria Bacteria 86.7 3.5e-19   NR WP_214120692.1 2836735 g2671 i0 53.8 1.08710801393728 104 36 96.2 1 283 8 32 135 WP_214120692.1 hypothetical protein, partial [Campylobacter sp. 2018MI01] diamond 312 86.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. 2018MI01
28583194 28583194 PRJNA1066877_S_NODE_10907_length_170_cov_1.090909_g10872_i0 PRJNA1066877 10907 170 1.090909 1.8545453 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 88.6 9.81e-19   NR MCQ2966745.1 1913988 g10872 i0 76 0.882352941176471 50 12 88.2 0 154 5 4 53 MCQ2966745.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 150 88.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
29214762 29214762 PRJNA1066877_S_NODE_12449_length_163_cov_0.894737_g12414_i0 PRJNA1066877 12449 163 0.894737 1.45842131 Methylobacterium sp. V23 2044878 Bacteria Bacteria 52.8 9.37e-7   NR WP_103711710.1 2044878 g12414 i0 78.1 0.588957055214724 32 7 58.9 0 1 96 110 141 WP_103711710.1 DUF1810 domain-containing protein [Methylobacterium sp. V23] diamond 96 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium sp. V23
29277491 29277491 PRJNA1066877_S_NODE_12689_length_162_cov_0.902655_g12654_i0 PRJNA1066877 12689 162 0.902655 1.4623011 Neisseriaceae bacterium PsAf 2815356 Bacteria Bacteria 62.8 8.34e-11   NR MBN3860240.1 2815356 g12654 i0 51.9 1.92592592592593 52 25 96.3 0 3 158 19 70 MBN3860240.1 RNA-binding protein [Neisseriaceae bacterium PsAf] diamond 312 62.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae   Neisseriaceae bacterium PsAf
29877722 29877722 PRJNA1066877_S_NODE_10191_length_175_cov_1.214286_g10156_i0 PRJNA1066877 10191 175 1.214286 2.1250005 Alphaproteobacteria bacterium 1913988 Bacteria Bacteria 89.7 3.01e-19   NR MCQ2966752.1 1913988 g10156 i0 74.1 0.994285714285714 58 15 99.4 0 2 175 50 107 MCQ2966752.1 hypothetical protein [Alphaproteobacteria bacterium] diamond 174 89.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
29972349 29972349 PRJNA1066877_S_NODE_12251_length_163_cov_2.026316_g12216_i0 PRJNA1066877 12251 163 2.026316 3.30289508 Bacteroides uniformis 820 Bacteria Bacteria 51.6 5.14e-7   NR WP_208081217.1 820 g12216 i0 100 0.496932515337423 27 0 49.7 0 2 82 26 52 WP_208081217.1 hypothetical protein, partial [Bacteroides uniformis] diamond 81 51.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia Bacteroidales Bacteroidaceae Bacteroides Bacteroides uniformis
30090301 30090301 PRJNA1066877_S_NODE_12672_length_162_cov_0.902655_g12637_i0 PRJNA1066877 12672 162 0.902655 1.4623011 Pseudomonadota 1224 Bacteria Bacteria 100 5.519999999999999e-23   NR MDO5687027.1 192066 g12637 i0 79.2 5.88888888888889 53 11 98.1 0 161 3 232 284 MDO5687027.1 acyl-CoA dehydrogenase [Neisseria sp.] diamond 954 100 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Neisseria Neisseria sp.
30604173 30604173 PRJNA1066877_S_NODE_9033_length_184_cov_1.044444_g8998_i0 PRJNA1066877 9033 184 1.044444 1.92177696 Bergeyella zoohelcum 1015 Bacteria Bacteria 125 1.95e-34   NR WP_260199964.1 1015 g8998 i0 100 0.978260869565217 60 0 97.8 0 182 3 77 136 WP_260199964.1 hypothetical protein [Bergeyella zoohelcum] diamond 180 125 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Weeksellaceae Bergeyella Bergeyella zoohelcum
31046884 31046884 PRJNA1066877_S_NODE_6535_length_206_cov_4.000000_g6500_i0 PRJNA1066877 6535 206 4 8.24 Porphyrobacter sp. 1113 Bacteria Bacteria 40.8 0.029   NR MBA4766075.1 1113 g6500 i0 41.3 0.669902912621359 46 27 67 0 59 196 24 69 MBA4766075.1 hypothetical protein [Porphyrobacter sp.] diamond 138 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Erythrobacteraceae Porphyrobacter Porphyrobacter sp.
31070113 31070113 PRJNA1066877_S_NODE_11935_length_165_cov_0.879310_g11900_i0 PRJNA1066877 11935 165 0.87931 1.4508615 Bacteria 2 Bacteria Bacteria 87.8 3.27e-21   NR MCP5809999.1 573 g11900 i0 100 1.96363636363636 54 0 98.2 0 2 163 19 72 MCP5809999.1 hypothetical protein [Klebsiella pneumoniae] diamond 324 87.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31742152 31742152 PRJNA1066877_S_NODE_11897_length_165_cov_0.879310_g11862_i0 PRJNA1066877 11897 165 0.87931 1.4508615 Candidatus Kapaibacteriota bacterium 3377422 Bacteria Bacteria 47 3.37e-5   NR MFN3782156.1 3377422 g11862 i0 65.6 0.581818181818182 32 11 58.2 0 97 2 8 39 MFN3782156.1 flagellar assembly protein FliW [Candidatus Kapaibacteriota bacterium] diamond 96 47 1 Bacteria FCB group Pseudomonadati Candidatus Kapaibacteriota         Candidatus Kapaibacteriota bacterium
32248821 32248821 PRJNA1066877_S_NODE_10198_length_175_cov_1.214286_g10163_i0 PRJNA1066877 10198 175 1.214286 2.1250005 Pseudomonas aeruginosa 287 Bacteria Bacteria 51.2 1.48e-5   NR WP_074202395.1 287 g10163 i0 47.3 0.942857142857143 55 28 92.6 1 9 170 558 612 WP_074202395.1 TraM recognition domain-containing protein [Pseudomonas aeruginosa] diamond 165 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa

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