RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

27 rows where analysis = "diamond", bioproject = "PRJEB28589" 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

  • PRJEB28589 · 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
12467141 12467141 PRJEB28589_S_NODE_8810_length_265_cov_2.288991_g8702_i0 PRJEB28589 8810 265 2.288991 6.06582615 Luteibacter sp. Sphag1AF 2587031 Bacteria Bacteria 58.9 2.54e-8   NR WP_183421670.1 2587031 g8702 i0 67.5 0.452830188679245 40 13 45.3 0 239 120 137 176 WP_183421670.1 lipocalin family protein [Luteibacter sp. Sphag1AF] diamond 120 58.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Rhodanobacteraceae Luteibacter Luteibacter sp. Sphag1AF
26811758 26811758 PRJEB28589_S_NODE_17981_length_163_cov_1.715517_g17873_i0 PRJEB28589 17981 163 1.715517 2.79629271 Pseudomonas aeruginosa 287 Bacteria Bacteria 45.1 1.2e-4   NR WP_407594693.1 287 g17873 i0 57.5 0.736196319018405 40 17 73.6 0 163 44 1 40 WP_407594693.1 hypothetical protein [Pseudomonas aeruginosa] diamond 120 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
26938169 26938169 PRJEB28589_S_NODE_8742_length_266_cov_1.876712_g8634_i0 PRJEB28589 8742 266 1.876712 4.99205392 Musicola keenii 2884250 Bacteria Bacteria 93.6 1.08e-20   NR WP_192459055.1 2884250 g8634 i0 52 0.845864661654135 75 36 84.6 0 266 42 219 293 WP_192459055.1 jacalin-like lectin [Musicola keenii] diamond 225 93.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Pectobacteriaceae Musicola Musicola keenii
27816675 27816675 PRJEB28589_S_NODE_7024_length_292_cov_8.114286_g6916_i0 PRJEB28589 7024 292 8.114286 23.69371512 Pseudomonadota 1224 Bacteria Bacteria 147 3.959999999999999e-42   NR WP_034844511.1 171674 g6916 i0 73.3 19.4178082191781 90 24 92.5 0 270 1 131 220 WP_034844511.1 GNAT family N-acetyltransferase [Inquilinus limosus] diamond 5670 147 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Rhodospirillaceae Inquilinus Inquilinus limosus
27917574 27917574 PRJEB28589_S_NODE_4505_length_335_cov_5.902778_g4397_i0 PRJEB28589 4505 335 5.902778 19.7743063 Dickeya lacustris 2259638 Bacteria Bacteria 70.9 8.11e-12   NR WP_125258133.1 2259638 g4397 i0 52.5 1.06567164179104 59 28 52.8 0 11 187 237 295 WP_125258133.1 jacalin-like lectin [Dickeya lacustris] diamond 357 70.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Pectobacteriaceae Dickeya Dickeya lacustris
27980892 27980892 PRJEB28589_S_NODE_4085_length_343_cov_6.459459_g3977_i0 PRJEB28589 4085 343 6.459459 22.15594437 Pseudoalteromonas sp. 53249 Bacteria Bacteria 60.5 7.02e-8   NR HCV03032.1 53249 g3977 i0 43.2 0.647230320699708 74 42 64.7 0 343 122 467 540 HCV03032.1 hypothetical protein [Pseudoalteromonas sp.] diamond 222 60.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas Pseudoalteromonas sp.
28195167 28195167 PRJEB28589_S_NODE_10566_length_240_cov_5.492228_g10458_i0 PRJEB28589 10566 240 5.492228 13.1813472 Luteibacter 242605 Bacteria Bacteria 79 2.7e-16   NR WP_167124046.1 637577 g10458 i0 71.4 2.45 49 14 61.3 0 239 93 116 164 WP_167124046.1 lipocalin family protein [Luteibacter jiangsuensis] diamond 588 79.3 0.996216897856242 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Rhodanobacteraceae Luteibacter Luteibacter jiangsuensis
28549373 28549373 PRJEB28589_S_NODE_2727_length_378_cov_8.909366_g2619_i0 PRJEB28589 2727 378 8.909366 33.67740348 unclassified Achromobacter 2626865 Bacteria Bacteria 116 1.97e-30   NR WP_088597360.1 2626865 g2619 i0 58.1 3.42063492063492 86 35 68.3 1 375 118 68 152 WP_088597360.1 MULTISPECIES: cupin domain-containing protein [unclassified Achromobacter] diamond 1293 116 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Alcaligenaceae Achromobacter  
28549374 28549374 PRJEB28589_S_NODE_4167_length_342_cov_3.179661_g4059_i0 PRJEB28589 4167 342 3.179661 10.87444062 Escherichia coli 562 Bacteria Bacteria 110 3.5600000000000003e-29   NR WP_167399334.1 562 g4059 i0 98.1 0.464912280701754 53 1 46.5 0 342 184 10 62 WP_167399334.1 hypothetical protein, partial [Escherichia coli] diamond 159 110 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
28991524 28991524 PRJEB28589_S_NODE_568_length_644_cov_4.809045_g476_i0 PRJEB28589 568 644 4.809045 30.9702498 Alteriqipengyuania lutimaris 1538146 Bacteria Bacteria 78.6 7.95e-13   NR WP_147291040.1 1538146 g476 i0 27.7 1.19254658385093 256 133 95.5 9 16 630 2 256 WP_147291040.1 open beta-sheet domain-containing protein [Alteriqipengyuania lutimaris] diamond 768 78.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Erythrobacteraceae Alteriqipengyuania Alteriqipengyuania lutimaris
29370164 29370164 PRJEB28589_S_NODE_6769_length_296_cov_5.261044_g6661_i0 PRJEB28589 6769 296 5.261044 15.57269024 Spartinivicinus marinus 2994442 Bacteria Bacteria 77.8 1.36e-14   NR WP_180567848.1 2994442 g6661 i0 46.1 1.54054054054054 76 40 76 1 293 69 219 294 WP_180567848.1 jacalin-like lectin [Spartinivicinus marinus] diamond 456 77.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Zooshikellaceae Spartinivicinus Spartinivicinus marinus
29496377 29496377 PRJEB28589_S_NODE_15490_length_183_cov_1.323529_g15382_i0 PRJEB28589 15490 183 1.323529 2.42205807 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 91.3 1.37e-19   NR MBN8446259.1 1913989 g15382 i0 68.9 1 61 19 100 0 1 183 17 77 MBN8446259.1 winged helix-turn-helix domain-containing protein [Gammaproteobacteria bacterium] diamond 183 91.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
29584326 29584326 PRJEB28589_S_NODE_4710_length_331_cov_5.080986_g4602_i0 PRJEB28589 4710 331 5.080986 16.81806366 root 1 Root_unresolved Root_unresolved 55.8 9.44e-7   NR WP_250665605.1 562 g4602 i0 69.4 7.51359516616314 36 11 32.6 0 109 2 32 67 WP_250665605.1 RNA-directed DNA polymerase [Escherichia coli] diamond 2487 55.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
29584329 29584329 PRJEB28589_S_NODE_8510_length_269_cov_3.220721_g8402_i0 PRJEB28589 8510 269 3.220721 8.66373949 root 1 Root_unresolved Root_unresolved 48.9 4.94e-5   NR WP_303262480.1 446 g8402 i0 41.3 1.22676579925651 63 36 69.1 1 84 269 14 76 WP_303262480.1 hypothetical protein, partial [Legionella pneumophila] diamond 330 48.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Legionellales Legionellaceae Legionella Legionella pneumophila
29622230 29622230 PRJEB28589_S_NODE_4250_length_340_cov_5.699659_g4142_i0 PRJEB28589 4250 340 5.699659 19.3788406 Bradyrhizobium japonicum 375 Bacteria Bacteria 86.7 6.46e-18   NR WP_259225835.1 375 g4142 i0 60.6 0.582352941176471 66 26 58.2 0 227 30 13 78 WP_259225835.1 type II toxin-antitoxin system PemK/MazF family toxin [Bradyrhizobium japonicum] diamond 198 86.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Nitrobacteraceae Bradyrhizobium Bradyrhizobium japonicum
29653876 29653876 PRJEB28589_S_NODE_15010_length_187_cov_2.321429_g14902_i0 PRJEB28589 15010 187 2.321429 4.34107223 Brevundimonas sp. G8 1350776 Bacteria Bacteria 80.1 9.97e-18   NR WP_159848345.1 1350776 g14902 i0 84.4 0.72192513368984 45 7 72.2 0 2 136 57 101 WP_159848345.1 hypothetical protein [Brevundimonas sp. G8] diamond 135 80.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Brevundimonas Brevundimonas sp. G8
30854681 30854681 PRJEB28589_S_NODE_17194_length_168_cov_2.057851_g17086_i0 PRJEB28589 17194 168 2.057851 3.45718968 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 44.7 0.00282   NR HEU5297290.1 2030806 g17086 i0 51.5 0.589285714285714 33 16 58.9 0 68 166 674 706 HEU5297290.1 DUF2339 domain-containing protein [Burkholderiaceae bacterium] diamond 99 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
30949676 30949676 PRJEB28589_S_NODE_6774_length_296_cov_4.590361_g6666_i0 PRJEB28589 6774 296 4.590361 13.58746856 Klebsiella pneumoniae 573 Bacteria Bacteria 46.6 3.7e-4   NR MCP6242699.1 573 g6666 i0 60 0.405405405405405 40 16 40.5 0 170 51 10 49 MCP6242699.1 hypothetical protein [Klebsiella pneumoniae] diamond 120 46.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31297142 31297142 PRJEB28589_S_NODE_4675_length_332_cov_2.550877_g4567_i0 PRJEB28589 4675 332 2.550877 8.46891164 Rickettsia endosymbiont of Glossina mortisans submortisans 2878925 Bacteria Bacteria 48.1 0.00131   NR MCC8418596.1 2878925 g4567 i0 27.5 0.822289156626506 91 59 82.2 1 315 43 182 265 MCC8418596.1 hypothetical protein [Rickettsia endosymbiont of Glossina mortisans submortisans] diamond 273 48.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Rickettsiaceae Rickettsia Rickettsia endosymbiont of Glossina mortisans submortisans
31392242 31392242 PRJEB28589_S_NODE_7716_length_282_cov_1.961702_g7608_i0 PRJEB28589 7716 282 1.961702 5.53199964 Pseudomonas sp. PS 306 Bacteria Bacteria 169 2.0899999999999999e-47   NR WP_282358805.1 2991439 g7608 i0 98.8 0.914893617021277 86 1 91.5 0 3 260 195 280 WP_282358805.1 hypothetical protein [Pseudomonas sp. PS01303] diamond 258 169 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. PS01303
31739816 31739816 PRJEB28589_S_NODE_10877_length_236_cov_3.021164_g10769_i0 PRJEB28589 10877 236 3.021164 7.12994704 Rheinheimera sp. 1869214 Bacteria Bacteria 112 2.6e-27   NR MDZ7902260.1 1869214 g10769 i0 71.8 1.98305084745763 78 22 99.2 0 236 3 202 279 MDZ7902260.1 response regulator [Rheinheimera sp.] diamond 468 112 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Chromatiaceae Rheinheimera Rheinheimera sp.
31803102 31803102 PRJEB28589_S_NODE_4837_length_328_cov_6.843416_g4729_i0 PRJEB28589 4837 328 6.843416 22.446404480000002 Methylococcales bacterium 2304002 Bacteria Bacteria 88.6 5.08e-20   NR MEE9412403.1 2304002 g4729 i0 58.1 1.35365853658537 74 31 67.7 0 326 105 48 121 MEE9412403.1 type II toxin-antitoxin system RelE/ParE family toxin [Methylococcales bacterium] diamond 444 88.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Methylococcales     Methylococcales bacterium
31834691 31834691 PRJEB28589_S_NODE_8857_length_264_cov_4.271889_g8749_i0 PRJEB28589 8857 264 4.271889 11.27778696 Acinetobacter haemolyticus 29430 Bacteria Bacteria 42.4 0.0111   NR ATZ65962.1 29430 g8749 i0 38.6 0.647727272727273 57 32 61.4 1 100 261 7 63 ATZ65962.1 hypothetical protein BSR56_00385 [Acinetobacter haemolyticus] diamond 171 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter haemolyticus
31923247 31923247 PRJEB28589_S_NODE_2717_length_379_cov_2.117470_g2609_i0 PRJEB28589 2717 379 2.11747 8.0252113 root 1 Root_unresolved Root_unresolved 82.4 2.44e-15   NR WP_225247223.1 953 g2609 i0 40.2 5.53298153034301 107 57 82.3 3 379 68 466 568 WP_225247223.1 MULTISPECIES: tetratricopeptide repeat protein [Wolbachia] diamond 2097 82.8 0.995169082125604 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Anaplasmataceae Wolbachia  
32024758 32024758 PRJEB28589_S_NODE_5438_length_317_cov_4.011111_g5330_i0 PRJEB28589 5438 317 4.011111 12.71522187 unclassified Wolbachia 2640676 Bacteria Bacteria 70.1 2.19e-11   NR WP_153295690.1 2640676 g5330 i0 45.2 0.8801261829653 93 46 84.2 2 271 5 319 410 WP_153295690.1 MULTISPECIES: ankyrin repeat domain-containing protein [unclassified Wolbachia] diamond 279 70.1 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Anaplasmataceae Wolbachia  
32081409 32081409 PRJEB28589_S_NODE_1498_length_455_cov_4.975490_g1391_i0 PRJEB28589 1498 455 4.97549 22.6384795 Massilia 149698 Bacteria Bacteria 166 1.23e-46   NR WP_036169810.1 1500894 g1391 i0 64.8 8.85494505494506 122 42 79.8 1 455 93 298 419 WP_036169810.1 glucan 1,4-alpha-maltotetraohydrolase domain-containing protein [Massilia sp. 9096] diamond 4029 167 0.994011976047904 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Massilia Massilia sp. 9096
32246530 32246530 PRJEB28589_S_NODE_1978_length_414_cov_6.574932_g1870_i0 PRJEB28589 1978 414 6.5749320000000004 27.22021848 Stellaceae bacterium 2910174 Bacteria Bacteria 102 6.34e-24   NR HTQ33271.1 2910174 g1870 i0 62.2 2.70289855072464 74 28 53.6 0 403 182 162 235 HTQ33271.1 GNAT family protein [Stellaceae bacterium] diamond 1119 102 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales Stellaceae   Stellaceae 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);;