RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJNA263496" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 27 ✖

tax_kingdom 1

bioproject 1

  • PRJNA263496 · 27 ✖

analysis 1

  • diamond · 27 ✖

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
15084775 15084775 PRJNA263496_P_NODE_21452_length_167_cov_0.864407_g21199_i0 PRJNA263496 21452 167 0.864407 1.44355969 Roseateles 93681 Bacteria Bacteria 102 4.11e-26   NR HEY8879005.1 1971397 g21199 i0 98.2 2.96407185628743 55 1 98.8 0 165 1 60 114 HEY8879005.1 MFS transporter [Roseateles sp.] diamond 495 102 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp.
16946723 16946723 PRJNA263496_P_NODE_24274_length_163_cov_0.894737_g24021_i0 PRJNA263496 24274 163 0.894737 1.45842131 Pseudomonadota 1224 Bacteria Bacteria 108 7.29e-29   NR RRB80336.1 562 g24021 i0 96.3 5.96319018404908 54 2 99.4 0 1 162 33 86 RRB80336.1 hypothetical protein EIA23_28350, partial [Escherichia coli] diamond 972 108 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
26757364 26757364 PRJNA263496_P_NODE_23221_length_164_cov_0.886957_g22968_i0 PRJNA263496 23221 164 0.886957 1.45460948 Sphingomonas sp. TF3 2495580 Bacteria Bacteria 85.1 3.82e-20   NR WP_126849552.1 2495580 g22968 i0 100 0.98780487804878 54 0 98.8 0 2 163 3 56 WP_126849552.1 hypothetical protein [Sphingomonas sp. TF3] diamond 162 85.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas Sphingomonas sp. TF3
26965147 26965147 PRJNA263496_P_NODE_10262_length_246_cov_1.553299_g10009_i0 PRJNA263496 10262 246 1.553299 3.82111554 root 1 Root_unresolved Root_unresolved 139 2.22e-40   NR MFA0954788.1 573 g10009 i0 76.5 52.3292682926829 81 19 98.8 0 3 245 53 133 MFA0954788.1 NADH-quinone oxidoreductase subunit D [Klebsiella pneumoniae] diamond 12873 140 0.992857142857143 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
27326935 27326935 PRJNA263496_P_NODE_21063_length_167_cov_0.864407_g20810_i0 PRJNA263496 21063 167 0.864407 1.44355969 unclassified Sphingomonas 196159 Bacteria Bacteria 110 3.2499999999999998e-28   NR WP_137903010.1 196159 g20810 i0 100 0.988023952095808 55 0 98.8 0 167 3 33 87 WP_137903010.1 MULTISPECIES: TorF family putative porin [unclassified Sphingomonas] diamond 165 110 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
27706228 27706228 PRJNA263496_P_NODE_18784_length_179_cov_1.223077_g18531_i0 PRJNA263496 18784 179 1.223077 2.18930783 Salipiger bermudensis 344736 Bacteria Bacteria 40.8 0.0193   NR WP_222605615.1 344736 g18531 i0 41.3 0.770949720670391 46 26 75.4 1 169 35 36 81 WP_222605615.1 putative quinol monooxygenase [Salipiger bermudensis] diamond 138 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Salipiger Salipiger bermudensis
27958439 27958439 PRJNA263496_P_NODE_25345_length_161_cov_0.910714_g25092_i0 PRJNA263496 25345 161 0.910714 1.46624954 Escherichia coli 562 Bacteria Bacteria 74.7 5.9e-16   NR WP_213080762.1 562 g25092 i0 81 0.782608695652174 42 8 78.3 0 35 160 39 80 WP_213080762.1 hypothetical protein, partial [Escherichia coli] diamond 126 74.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27990110 27990110 PRJNA263496_P_NODE_8705_length_269_cov_1.381818_g8452_i0 PRJNA263496 8705 269 1.381818 3.71709042 Herbaspirillum rubrisubalbicans 80842 Bacteria Bacteria 51.2 2.88e-6   NR WP_216667441.1 80842 g8452 i0 100 0.256505576208178 23 0 25.7 0 269 201 29 51 WP_216667441.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans] diamond 69 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Herbaspirillum Herbaspirillum rubrisubalbicans
28242426 28242426 PRJNA263496_P_NODE_24906_length_162_cov_0.902655_g24653_i0 PRJNA263496 24906 162 0.902655 1.4623011 Pseudomonadota bacterium 1977087 Bacteria Bacteria 115 2.24e-29   NR MEW6596255.1 1977087 g24653 i0 100 0.981481481481482 53 0 98.1 0 161 3 219 271 MEW6596255.1 amidohydrolase family protein [Pseudomonadota bacterium] diamond 159 115 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28747781 28747781 PRJNA263496_P_NODE_25007_length_162_cov_0.902655_g24754_i0 PRJNA263496 25007 162 0.902655 1.4623011 Stellaceae bacterium 2910174 Bacteria Bacteria 72.8 2.21e-14   NR HLY58046.1 2910174 g24754 i0 64.7 3.7962962962963 51 18 94.4 0 9 161 8 58 HLY58046.1 NADH-quinone oxidoreductase subunit NuoI [Stellaceae bacterium] diamond 615 72.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Stellaceae   Stellaceae bacterium
28905414 28905414 PRJNA263496_P_NODE_20588_length_169_cov_1.625000_g20335_i0 PRJNA263496 20588 169 1.625 2.74625 Microbulbifer epialgicus 393907 Bacteria Bacteria 105 1e-25   NR WP_371837005.1 393907 g20335 i0 82.1 0.994082840236686 56 10 99.4 0 168 1 109 164 WP_371837005.1 type IV secretory system conjugative DNA transfer family protein [Microbulbifer epialgicus] diamond 168 105 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Microbulbiferaceae Microbulbifer Microbulbifer epialgicus
29252705 29252705 PRJNA263496_P_NODE_11009_length_237_cov_1.085106_g10756_i0 PRJNA263496 11009 237 1.085106 2.57170122 uncultured Deefgea sp. 1304914 Bacteria Bacteria 43.5 0.0177   NR WP_288843087.1 1304914 g10756 i0 36.1 2.73417721518987 72 35 77.2 1 207 25 156 227 WP_288843087.1 TniB family NTP-binding protein [uncultured Deefgea sp.] diamond 648 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Chitinibacteraceae Deefgea uncultured Deefgea sp.
29270526 29270526 PRJNA263496_P_NODE_19229_length_176_cov_2.267717_g18976_i0 PRJNA263496 19229 176 2.267717 3.99118192 root 1 Root_unresolved Root_unresolved 99.4 3.16e-25   NR WP_353960168.1 573 g18976 i0 100 58.3977272727273 47 0 80.1 0 1 141 70 116 WP_353960168.1 50S ribosomal protein L14 [Klebsiella pneumoniae] diamond 10278 99.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
29617657 29617657 PRJNA263496_P_NODE_23970_length_163_cov_0.894737_g23717_i0 PRJNA263496 23970 163 0.894737 1.45842131 Bacteria 2 Bacteria Bacteria 114 1.9999999999999997e-28   NR WP_349289604.1 329 g23717 i0 100 2.92638036809816 53 0 97.5 0 161 3 133 185 WP_349289604.1 flavin monoamine oxidase family protein [Ralstonia pickettii] diamond 477 114 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia Ralstonia pickettii
30060016 30060016 PRJNA263496_P_NODE_6651_length_316_cov_3.168539_g6398_i0 PRJNA263496 6651 316 3.168539 10.01258324 Pseudomonadota 1224 Bacteria Bacteria 167 2.16e-49   NR WP_147011689.1 573 g6398 i0 76.9 7.75632911392405 104 24 98.7 0 2 313 6 109 WP_147011689.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 2451 167 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
30200194 30200194 PRJNA263496_P_NODE_4712_length_389_cov_1.591176_g4459_i0 PRJNA263496 4712 389 1.591176 6.18967464 Herbaspirillum rubrisubalbicans 80842 Bacteria Bacteria 137 5.24e-39   NR WP_237742021.1 80842 g4459 i0 96.9 0.501285347043702 65 2 50.1 0 259 65 1 65 WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans] diamond 195 137 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Herbaspirillum Herbaspirillum rubrisubalbicans
30231991 30231991 PRJNA263496_P_NODE_21392_length_167_cov_0.864407_g21139_i0 PRJNA263496 21392 167 0.864407 1.44355969 Escherichia coli 562 Bacteria Bacteria 106 1.44e-27   NR WP_250909175.1 562 g21139 i0 100 5.31736526946108 49 0 88 0 20 166 1 49 WP_250909175.1 S6e family ribosomal protein, partial [Escherichia coli] diamond 888 106 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
30390407 30390407 PRJNA263496_P_NODE_23973_length_163_cov_0.894737_g23720_i0 PRJNA263496 23973 163 0.894737 1.45842131 Rhizobium 379 Bacteria Bacteria 87.4 1.59e-18   NR WP_183610910.1 379 g23720 i0 75 0.957055214723926 52 13 95.7 0 158 3 16 67 WP_183610910.1 MULTISPECIES: M20 family metallopeptidase [Rhizobium] diamond 156 87.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium  
30674232 30674232 PRJNA263496_P_NODE_14853_length_203_cov_0.954545_g14600_i0 PRJNA263496 14853 203 0.954545 1.93772635 Escherichia coli 562 Bacteria Bacteria 41.6 0.0273   NR NYY79129.1 562 g14600 i0 38.8 0.724137931034483 49 30 72.4 0 34 180 55 103 NYY79129.1 hypothetical protein [Escherichia coli] diamond 147 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
30786870 30786870 PRJNA263496_P_NODE_24694_length_162_cov_0.902655_g24441_i0 PRJNA263496 24694 162 0.902655 1.4623011 Bacteria 2 Bacteria Bacteria 60.5 6.63e-9   NR TDI55967.1 1913988 g24441 i0 76.5 96.962962962963 34 8 63 0 5 106 345 378 TDI55967.1 MAG: acyl-CoA dehydrogenase [Alphaproteobacteria bacterium] diamond 15708 60.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria       Alphaproteobacteria bacterium
30832278 30832278 PRJNA263496_P_NODE_3274_length_489_cov_3.579545_g3021_i0 PRJNA263496 3274 489 3.579545 17.50397505 Herbaspirillum rubrisubalbicans 80842 Bacteria Bacteria 97.4 6.96e-23   NR WP_237742021.1 80842 g3021 i0 84.2 0.349693251533742 57 4 31.9 1 190 35 52 108 WP_237742021.1 hypothetical protein, partial [Herbaspirillum rubrisubalbicans] diamond 171 97.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Herbaspirillum Herbaspirillum rubrisubalbicans
30927309 30927309 PRJNA263496_P_NODE_20734_length_168_cov_1.714286_g20481_i0 PRJNA263496 20734 168 1.714286 2.88000048 Serratia entomophila 42906 Bacteria Bacteria 41.2 0.047   NR WP_234590165.1 42906 g20481 i0 47.6 0.75 42 21 73.2 1 130 8 142 183 WP_234590165.1 EpsG family protein [Serratia entomophila] diamond 126 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Serratia Serratia entomophila
30990438 30990438 PRJNA263496_P_NODE_15354_length_199_cov_1.626667_g15101_i0 PRJNA263496 15354 199 1.626667 3.23706733 Pseudomonadota bacterium 1977087 Bacteria Bacteria 50.8 2.94e-5   NR MDY6930075.1 1977087 g15101 i0 49 0.738693467336683 49 25 73.9 0 19 165 200 248 MDY6930075.1 reverse transcriptase family protein [Pseudomonadota bacterium] diamond 147 50.8 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31260858 31260858 PRJNA263496_P_NODE_13815_length_210_cov_1.683230_g13562_i0 PRJNA263496 13815 210 1.68323 3.534783 Enterobacteriaceae 543 Bacteria Bacteria 104 2.76e-26   NR WP_151466001.1 573 g13562 i0 98 2.8 49 1 70 0 209 63 142 190 WP_151466001.1 translationally-controlled tumor protein, partial [Klebsiella pneumoniae] diamond 588 104 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31622577 31622577 PRJNA263496_P_NODE_22896_length_165_cov_0.879310_g22643_i0 PRJNA263496 22896 165 0.87931 1.4508615 Moraxellaceae bacterium 1889775 Bacteria Bacteria 94.7 3.97e-21   NR MBS9779046.1 1889775 g22643 i0 81.5 1.96363636363636 54 10 98.2 0 3 164 346 399 MBS9779046.1 ATP-grasp domain-containing protein [Moraxellaceae bacterium] diamond 324 94.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae   Moraxellaceae bacterium
32192182 32192182 PRJNA263496_P_NODE_25798_length_161_cov_0.910714_g25545_i0 PRJNA263496 25798 161 0.910714 1.46624954 Agrobacterium sp. Ap1 2815337 Bacteria Bacteria 88.2 2.21e-20   NR WP_206826294.1 2815337 g25545 i0 83 0.987577639751553 53 9 98.8 0 160 2 68 120 WP_206826294.1 hypothetical protein [Agrobacterium sp. Ap1] diamond 159 88.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Agrobacterium Agrobacterium sp. Ap1
32823686 32823686 PRJNA263496_P_NODE_22460_length_165_cov_0.879310_g22207_i0 PRJNA263496 22460 165 0.87931 1.4508615 Pseudomonas sp. BN414 2567888 Bacteria Bacteria 61.2 3.29e-9   NR WP_280352875.1 2567888 g22207 i0 57.4 0.981818181818182 54 19 98.2 1 4 165 215 264 WP_280352875.1 glycosyltransferase family 2 protein [Pseudomonas sp. BN414] diamond 162 61.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. BN414

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