RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA902515" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 21 ✖

tax_kingdom 1

bioproject 1

  • PRJNA902515 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
5984427 5984427 PRJNA902515_P_NODE_12485_length_250_cov_0.881356_g12462_i0 PRJNA902515 12485 250 0.881356 2.20339 Brevundimonas sp. UBA2416 1946124 Bacteria Bacteria 167 7.18e-51   NR WP_292030970.1 1946124 g12462 i0 98.8 0.996 83 1 99.6 0 1 249 32 114 WP_292030970.1 helix-turn-helix domain-containing protein [Brevundimonas sp. UBA2416] diamond 249 167 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Brevundimonas Brevundimonas sp. UBA2416
5984487 5984487 PRJNA902515_P_NODE_14445_length_246_cov_0.901734_g14422_i0 PRJNA902515 14445 246 0.901734 2.21826564 Sphaerotilaceae 2975441 Bacteria Bacteria 104 7.15e-26   NR WP_316640339.1 452440 g14422 i0 63 5.36585365853659 73 27 89 0 1 219 130 202 WP_316640339.1 NAD(P)H-dependent oxidoreductase [uncultured Roseateles sp.] diamond 1320 105 0.990476190476191 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles uncultured Roseateles sp.
7259240 7259240 PRJNA902515_P_NODE_11746_length_252_cov_0.871508_g11723_i0 PRJNA902515 11746 252 0.871508 2.19620016 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 160 1.34e-46   NR MBY0365440.1 2030806 g11723 i0 98.8 1 84 1 100 0 252 1 145 228 MBY0365440.1 HAMP domain-containing histidine kinase [Burkholderiaceae bacterium] diamond 252 160 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
8534091 8534091 PRJNA902515_P_NODE_12827_length_249_cov_0.886364_g12804_i0 PRJNA902515 12827 249 0.886364 2.20704636 Herbaspirillum sp. CAH-3 2605746 Bacteria Bacteria 176 3.38e-51   NR WP_154133254.1 2605746 g12804 i0 100 0.987951807228916 82 0 98.8 0 2 247 131 212 WP_154133254.1 NAD(P)/FAD-dependent oxidoreductase [Herbaspirillum sp. CAH-3] diamond 246 176 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Oxalobacteraceae Herbaspirillum Herbaspirillum sp. CAH-3
21283175 21283175 PRJNA902515_P_NODE_14637_length_245_cov_0.906977_g14614_i0 PRJNA902515 14637 245 0.906977 2.22209365 Novosphingobium nitrogenifigens 378548 Bacteria Bacteria 88.2 3.9e-18   NR WP_008071639.1 378548 g14614 i0 97.8 0.551020408163265 45 1 55.1 0 109 243 1 45 WP_008071639.1 translocation/assembly module TamB domain-containing protein [Novosphingobium nitrogenifigens] diamond 135 88.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Novosphingobium Novosphingobium nitrogenifigens
27095028 27095028 PRJNA902515_P_NODE_9382_length_272_cov_1.879397_g9359_i0 PRJNA902515 9382 272 1.879397 5.11195984 Enterobacterales 91347 Bacteria Bacteria 64.3 1.19e-9   NR WP_261865223.1 82979 g9359 i0 66 1.55514705882353 47 16 51.8 0 2 142 313 359 WP_261865223.1 DUF3383 domain-containing protein [Budvicia aquatica] diamond 423 64.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Budviciaceae Budvicia Budvicia aquatica
27221217 27221217 PRJNA902515_P_NODE_14262_length_246_cov_0.901734_g14239_i0 PRJNA902515 14262 246 0.901734 2.21826564 Hyphomicrobiales 356 Bacteria Bacteria 116 5.279999999999999e-28   NR WP_072374010.1 1892846 g14239 i0 73.8 4.91463414634146 80 21 97.6 0 241 2 263 342 WP_072374010.1 efflux RND transporter permease subunit [Hyphomicrobium sp. NDB2Meth4] diamond 1209 116 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Hyphomicrobiaceae Hyphomicrobium Hyphomicrobium sp. NDB2Meth4
27845373 27845373 PRJNA902515_P_NODE_14464_length_246_cov_0.901734_g14441_i0 PRJNA902515 14464 246 0.901734 2.21826564 Nitrosomonas sp. 42353 Bacteria Bacteria 99.8 1.25e-24   NR WP_300284097.1 42353 g14441 i0 97.9 0.585365853658537 48 1 58.5 0 145 2 1 48 WP_300284097.1 glycine zipper family protein [Nitrosomonas sp.] diamond 144 99.8 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Nitrosomonadaceae Nitrosomonas Nitrosomonas sp.
27940374 27940374 PRJNA902515_P_NODE_14325_length_246_cov_0.901734_g14302_i0 PRJNA902515 14325 246 0.901734 2.21826564 Burkholderiaceae bacterium 2030806 Bacteria Bacteria 105 7.6e-25   NR MEQ1806283.1 2030806 g14302 i0 57.5 0.975609756097561 80 34 97.6 0 4 243 32 111 MEQ1806283.1 diguanylate cyclase [Burkholderiaceae bacterium] diamond 240 105 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae   Burkholderiaceae bacterium
28477039 28477039 PRJNA902515_P_NODE_11966_length_251_cov_0.876404_g11943_i0 PRJNA902515 11966 251 0.876404 2.19977404 Betaproteobacteria bacterium 1891241 Bacteria Bacteria 163 6.93e-49   NR MDI3512508.1 1891241 g11943 i0 97.6 0.99203187250996006 83 2 99.2 0 3 251 59 141 MDI3512508.1 hypothetical protein [Betaproteobacteria bacterium] diamond 249 163 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria       Betaproteobacteria bacterium
28516273 28516273 PRJNA902515_P_NODE_12227_length_251_cov_0.876404_g12204_i0 PRJNA902515 12227 251 0.876404 2.19977404 Burkholderiales 80840 Bacteria Bacteria 157 2.0699999999999998e-42   NR MBE0546473.1 50259 g12204 i0 92.8 9.90836653386454 83 6 99.2 0 250 2 70 152 MBE0546473.1 AAA family ATPase [Rubrivivax sp.] diamond 2487 157 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Rubrivivax Rubrivivax sp.
28737249 28737249 PRJNA902515_P_NODE_11307_length_253_cov_0.866667_g11284_i0 PRJNA902515 11307 253 0.866667 2.19266751 Caulobacteraceae 76892 Bacteria Bacteria 131 1.1e-34   NR WP_088410889.1 293 g11284 i0 74.7 1.96837944664032 83 21 98.4 0 3 251 180 262 WP_088410889.1 hypothetical protein [Brevundimonas diminuta] diamond 498 132 0.992424242424242 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Caulobacterales Caulobacteraceae Brevundimonas Brevundimonas diminuta
29045484 29045484 PRJNA902515_P_NODE_11228_length_253_cov_0.866667_g11205_i0 PRJNA902515 11228 253 0.866667 2.19266751 Aquabacterium sp. 1872578 Bacteria Bacteria 72.4 1.55e-12   NR MFT3857556.1 1872578 g11205 i0 46.1 1.77865612648221 76 41 90.1 0 14 241 408 483 MFT3857556.1 hypothetical protein [Aquabacterium sp.] diamond 450 72.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium sp.
29108622 29108622 PRJNA902515_P_NODE_11288_length_253_cov_0.866667_g11265_i0 PRJNA902515 11288 253 0.866667 2.19266751 Uliginosibacterium flavum 1396831 Bacteria Bacteria 73.9 4.25e-13   NR WP_354602763.1 1396831 g11265 i0 50.6 0.960474308300395 81 37 96 1 252 10 299 376 WP_354602763.1 O-antigen ligase family protein [Uliginosibacterium flavum] diamond 243 73.9 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Rhodocyclales Zoogloeaceae Uliginosibacterium Uliginosibacterium flavum
29329476 29329476 PRJNA902515_P_NODE_13329_length_248_cov_0.891429_g13306_i0 PRJNA902515 13329 248 0.891429 2.21074392 Pseudomonadota bacterium 1977087 Bacteria Bacteria 52 3.22e-6   NR MFM2447738.1 1977087 g13306 i0 31.7 0.991935483870968 82 51 98 2 5 247 19 96 MFM2447738.1 hypothetical protein [Pseudomonadota bacterium] diamond 246 52 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
29431578 29431578 PRJNA902515_P_NODE_10549_length_258_cov_2.059459_g10526_i0 PRJNA902515 10549 258 2.059459 5.31340422 root 1 Root_unresolved Root_unresolved 99 5.4e-22   NR WP_029093203.1 82979 g10526 i0 60 4.97674418604651 85 34 98.8 0 258 4 293 377 WP_029093203.1 baseplate J/gp47 family protein [Budvicia aquatica] diamond 1284 99.8 0.991983967935872 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Budviciaceae Budvicia Budvicia aquatica
29557982 29557982 PRJNA902515_P_NODE_14630_length_245_cov_0.906977_g14607_i0 PRJNA902515 14630 245 0.906977 2.22209365 Rhodoferax 28065 Bacteria Bacteria 86.7 1.35e-17   NR MBC7620526.1 50421 g14607 i0 48.8 1.93469387755102 80 41 98 0 243 4 41 120 MBC7620526.1 hypothetical protein [Rhodoferax sp.] diamond 474 86.7 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Rhodoferax Rhodoferax sp.
29707993 29707993 PRJNA902515_P_NODE_12170_length_251_cov_0.876404_g12147_i0 PRJNA902515 12170 251 0.876404 2.19977404 Rubrivivax rivuli 1862385 Bacteria Bacteria 74.3 3.07e-13   NR WP_164884983.1 1862385 g12147 i0 47 0.99203187250996006 83 44 99.2 0 3 251 255 337 WP_164884983.1 alpha/beta hydrolase family protein [Rubrivivax rivuli] diamond 249 74.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Rubrivivax Rubrivivax rivuli
30592863 30592863 PRJNA902515_P_NODE_9933_length_265_cov_2.104167_g9910_i0 PRJNA902515 9933 265 2.104167 5.57604255 Limnobaculum 2172100 Bacteria Bacteria 73.2 1.94e-13   NR WP_218466289.1 2172100 g9910 i0 60 1.64150943396226 65 24 71.3 1 5 193 126 190 WP_218466289.1 MULTISPECIES: Gp138 family membrane-puncturing spike protein [Limnobaculum] diamond 435 73.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Budviciaceae Limnobaculum  
31074564 31074564 PRJNA902515_P_NODE_11055_length_253_cov_1.300000_g11032_i0 PRJNA902515 11055 253 1.3 3.289 root 1 Root_unresolved Root_unresolved 128 4.37e-33   NR WP_307639178.1 34073 g11032 i0 75 3.98418972332016 84 21 99.6 0 252 1 116 199 WP_307639178.1 P22 phage major capsid protein family protein [Variovorax paradoxus] diamond 1008 128 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Variovorax Variovorax paradoxus
31288060 31288060 PRJNA902515_P_NODE_12175_length_251_cov_0.876404_g12152_i0 PRJNA902515 12175 251 0.876404 2.19977404 Aquabacterium sp. 1872578 Bacteria Bacteria 54.3 2.65e-6   NR MCK6434421.1 1872578 g12152 i0 96.6 0.346613545816733 29 1 34.7 0 1 87 234 262 MCK6434421.1 site-specific integrase [Aquabacterium sp.] diamond 87 54.3 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales   Aquabacterium Aquabacterium sp.

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