RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA981359 · 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
18813919 18813919 PRJNA981359_S_NODE_26375_length_338_cov_2.550943_g26275_i0 PRJNA981359 26375 338 2.550943 8.62218734 Gammaproteobacteria 1236 Bacteria Bacteria 159 1.26e-45   NR WP_110725984.1 287 g26275 i0 85.2 25.0473372781065 81 12 71.9 0 245 3 32 112 WP_110725984.1 zonular occludens toxin domain-containing protein, partial [Pseudomonas aeruginosa] diamond 8466 160 0.99375 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas aeruginosa
20088718 20088718 PRJNA981359_S_NODE_29236_length_329_cov_4.929688_g29136_i0 PRJNA981359 29236 329 4.929688 16.21867352 unclassified Sphingomonas 196159 Bacteria Bacteria 190 2.02e-53   NR WP_033965561.1 196159 g29136 i0 100 0.957446808510638 105 0 95.7 0 13 327 1 105 WP_033965561.1 MULTISPECIES: S41 family peptidase [unclassified Sphingomonas] diamond 315 190 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  
26836582 26836582 PRJNA981359_S_NODE_52181_length_276_cov_2.305419_g52081_i0 PRJNA981359 52181 276 2.305419 6.36295644 Klebsiella pneumoniae 573 Bacteria Bacteria 43.9 0.00522   NR WP_220494059.1 573 g52081 i0 32.5 0.902173913043478 83 41 80.4 2 23 244 31 107 WP_220494059.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 249 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
26994403 26994403 PRJNA981359_S_NODE_72362_length_243_cov_1.282353_g72262_i0 PRJNA981359 72362 243 1.282353 3.11611779 Candidatus Thiodiazotropha sp. 2847306 Bacteria Bacteria 47 0.00124   NR MES9976207.1 2847306 g72262 i0 58.3 1.33333333333333 36 15 44.4 0 67 174 618 653 MES9976207.1 reverse transcriptase domain-containing protein [Candidatus Thiodiazotropha sp.] diamond 324 47 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Candidatus Thiodiazotropha Candidatus Thiodiazotropha sp.
27026267 27026267 PRJNA981359_S_NODE_61442_length_258_cov_2.529730_g61342_i0 PRJNA981359 61442 258 2.52973 6.5267034 Methylobacterium gnaphalii 1010610 Bacteria Bacteria 42.7 0.0445   NR GEP08192.1 1010610 g61342 i0 40.4 1.2093023255814 52 31 60.5 0 258 103 152 203 GEP08192.1 Bcr/CflA family drug resistance efflux transporter [Methylobacterium gnaphalii] diamond 312 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium gnaphalii
27089625 27089625 PRJNA981359_S_NODE_44422_length_292_cov_3.392694_g44322_i0 PRJNA981359 44422 292 3.392694 9.90666648 Nevskiaceae bacterium 1969813 Bacteria Bacteria 43.9 0.0236   NR HEX4871458.1 1969813 g44322 i0 35.6 0.883561643835616 59 36 58.6 1 179 9 230 288 HEX4871458.1 phenylalanine--tRNA ligase subunit alpha [Nevskiaceae bacterium] diamond 258 43.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Nevskiales Nevskiaceae   Nevskiaceae bacterium
27405768 27405768 PRJNA981359_S_NODE_58303_length_264_cov_2.204188_g58203_i0 PRJNA981359 58303 264 2.204188 5.81905632 Citrobacter freundii 546 Bacteria Bacteria 180 2.1199999999999998e-53   NR WP_270612888.1 546 g58203 i0 100 2 88 0 100 0 1 264 61 148 WP_270612888.1 non-hydrolyzing UDP-N-acetylglucosamine 2-epimerase [Citrobacter freundii] diamond 528 180 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Citrobacter Citrobacter freundii
27563158 27563158 PRJNA981359_S_NODE_55024_length_270_cov_3.984772_g54924_i0 PRJNA981359 55024 270 3.984772 10.7588844 Hydrogenophaga sp. 1904254 Bacteria Bacteria 42 0.0482   NR MDZ4127723.1 1904254 g54924 i0 51.4 0.388888888888889 35 17 38.9 0 1 105 41 75 MDZ4127723.1 Tat pathway signal protein [Hydrogenophaga sp.] diamond 105 42 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Hydrogenophaga Hydrogenophaga sp.
27784671 27784671 PRJNA981359_S_NODE_15384_length_382_cov_2.860841_g15284_i0 PRJNA981359 15384 382 2.860841 10.92841262 Vreelandella massiliensis 1816686 Bacteria Bacteria 150 2.9999999999999998e-40   NR WP_075881808.1 1816686 g15284 i0 59.8 0.879581151832461 112 45 88 0 381 46 387 498 WP_075881808.1 GspE/PulE family protein [Vreelandella massiliensis] diamond 336 150 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Oceanospirillales Halomonadaceae Vreelandella Vreelandella massiliensis
27847483 27847483 PRJNA981359_S_NODE_62964_length_255_cov_3.258242_g62864_i0 PRJNA981359 62964 255 3.258242 8.3085171 Pseudomonas faucium 2740518 Bacteria Bacteria 42.7 0.0348   NR WP_236236807.1 2740518 g62864 i0 37.3 0.788235294117647 67 34 78.8 1 250 50 5 63 WP_236236807.1 type II secretion system protein N [Pseudomonas faucium] diamond 201 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas faucium
27879187 27879187 PRJNA981359_S_NODE_71045_length_245_cov_0.872093_g70945_i0 PRJNA981359 71045 245 0.872093 2.13662785 Acinetobacter baumannii 470 Bacteria Bacteria 47 2.71e-4   NR WP_270175865.1 470 g70945 i0 74.1 0.330612244897959 27 5 30.6 1 73 147 20 46 WP_270175865.1 hypothetical protein, partial [Acinetobacter baumannii] diamond 81 47 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Acinetobacter Acinetobacter baumannii
28131922 28131922 PRJNA981359_S_NODE_28425_length_332_cov_2.057915_g28325_i0 PRJNA981359 28425 332 2.057915 6.8322778 Pseudomonadota bacterium 1977087 Bacteria Bacteria 102 1.47e-22   NR MDY6929965.1 1977087 g28325 i0 48 1.82530120481928 100 50 88.6 1 1 294 351 450 MDY6929965.1 reverse transcriptase family protein [Pseudomonadota bacterium] diamond 606 102 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
28573718 28573718 PRJNA981359_S_NODE_40987_length_300_cov_1.876652_g40887_i0 PRJNA981359 40987 300 1.876652 5.629956 Roseateles puraquae 431059 Bacteria Bacteria 185 3.76e-57   NR WP_158218409.1 431059 g40887 i0 100 0.93 93 0 93 0 280 2 54 146 WP_158218409.1 DUF1109 domain-containing protein [Roseateles puraquae] diamond 279 185 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles puraquae
29363239 29363239 PRJNA981359_S_NODE_64109_length_253_cov_2.200000_g64009_i0 PRJNA981359 64109 253 2.2 5.566 Citrobacter freundii 546 Bacteria Bacteria 42.7 0.0314   NR MDU4171697.1 546 g64009 i0 50 0.403162055335968 34 17 40.3 0 203 102 101 134 MDU4171697.1 lipopolysaccharide heptosyltransferase I [Citrobacter freundii] diamond 102 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Citrobacter Citrobacter freundii
29426112 29426112 PRJNA981359_S_NODE_44849_length_291_cov_3.876147_g44749_i0 PRJNA981359 44849 291 3.876147 11.27958777 Pseudomonas citronellolis 53408 Bacteria Bacteria 103 5.75e-25   NR WP_061562452.1 53408 g44749 i0 60.3 0.804123711340206 78 31 80.4 0 291 58 3 80 WP_061562452.1 metallophosphoesterase [Pseudomonas citronellolis] diamond 234 103 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas citronellolis
29583867 29583867 PRJNA981359_S_NODE_52790_length_275_cov_1.544554_g52690_i0 PRJNA981359 52790 275 1.544554 4.2475235 Escherichia coli 562 Bacteria Bacteria 60.8 1.3e-9   NR WP_329792810.1 562 g52690 i0 60.5 0.938181818181818 43 16 45.8 1 231 106 9 51 WP_329792810.1 hypothetical protein, partial [Escherichia coli] diamond 258 60.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
30089428 30089428 PRJNA981359_S_NODE_7712_length_446_cov_0.924933_g7613_i0 PRJNA981359 7712 446 0.924933 4.12520118 Pseudomonas capeferrum 1495066 Bacteria Bacteria 73.2 2.39e-12   NR WP_339471085.1 1495066 g7613 i0 73.6 3.2085201793722 53 14 35.7 0 153 311 132 184 WP_339471085.1 reverse transcriptase family protein, partial [Pseudomonas capeferrum] diamond 1431 73.6 0.994565217391304 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas capeferrum
30190200 30190200 PRJNA981359_S_NODE_16692_length_375_cov_3.377483_g16592_i0 PRJNA981359 16692 375 3.377483 12.66556125 root 1 Root_unresolved Root_unresolved 44.3 0.0131   NR WP_318767902.1 562 g16592 i0 53.7 1.024 41 18 32 1 236 117 85 125 WP_318767902.1 reverse transcriptase domain-containing protein, partial [Escherichia coli] diamond 384 44.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
30594889 30594889 PRJNA981359_S_NODE_42753_length_296_cov_1.937220_g42653_i0 PRJNA981359 42753 296 1.93722 5.7341712 Hafnia paralvei 546367 Bacteria Bacteria 51.2 5.74e-6   NR MCE9912128.1 546367 g42653 i0 45.6 1.93581081081081 57 31 57.8 0 294 124 1 57 MCE9912128.1 hypothetical protein [Hafnia paralvei] diamond 573 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Hafniaceae Hafnia Hafnia paralvei
30632480 30632480 PRJNA981359_S_NODE_66233_length_251_cov_0.876404_g66133_i0 PRJNA981359 66233 251 0.876404 2.19977404 Gammaproteobacteria 1236 Bacteria Bacteria 167 7.019999999999999e-47   NR WP_276448529.1 584 g66133 i0 100 1.91235059760956 80 0 95.6 0 2 241 117 196 WP_276448529.1 DNA adenine methylase [Proteus mirabilis] diamond 480 167 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Morganellaceae Proteus Proteus mirabilis
30689706 30689706 PRJNA981359_S_NODE_43393_length_295_cov_1.054054_g43293_i0 PRJNA981359 43393 295 1.054054 3.1094593 Roseovarius sp. 1486281 Bacteria Bacteria 45.4 0.00606   NR WP_350158910.1 1486281 g43293 i0 41.9 0.630508474576271 62 26 55.9 4 295 131 164 222 WP_350158910.1 CDP-alcohol phosphatidyltransferase family protein [Roseovarius sp.] diamond 186 45.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Roseobacteraceae Roseovarius Roseovarius sp.
30911134 30911134 PRJNA981359_S_NODE_5774_length_480_cov_2.191646_g5675_i0 PRJNA981359 5774 480 2.191646 10.5199008 Rhizobium laguerreae 1076926 Bacteria Bacteria 56.6 1.42e-7   NR WP_204347672.1 1076926 g5675 i0 66.7 0.2625 42 14 26.3 0 329 204 20 61 WP_204347672.1 hypothetical protein, partial [Rhizobium laguerreae] diamond 126 56.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Rhizobiaceae Rhizobium Rhizobium laguerreae
31075063 31075063 PRJNA981359_S_NODE_50895_length_279_cov_1.135922_g50795_i0 PRJNA981359 50895 279 1.135922 3.16922238 Pseudomonadota 1224 Bacteria Bacteria 177 9.44e-52   NR WP_169341883.1 190721 g50795 i0 92.2 4.83870967741935 90 7 96.8 0 271 2 204 293 WP_169341883.1 hypothetical protein [Ralstonia insidiosa] diamond 1350 177 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Burkholderiaceae Ralstonia Ralstonia insidiosa
31194939 31194939 PRJNA981359_S_NODE_46615_length_288_cov_1.079070_g46515_i0 PRJNA981359 46615 288 1.07907 3.1077216 Klebsiella pneumoniae subsp. pneumoniae 72407 Bacteria Bacteria 54.3 2.76e-7   NR BDA92351.1 72407 g46515 i0 52.9 0.53125 51 24 53.1 0 188 36 1 51 BDA92351.1 hypothetical protein E3AUHO_50370 [Klebsiella pneumoniae subsp. pneumoniae] diamond 153 54.3 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31290113 31290113 PRJNA981359_S_NODE_52675_length_275_cov_2.252475_g52575_i0 PRJNA981359 52675 275 2.252475 6.19430625 Klebsiella pneumoniae 573 Bacteria Bacteria 49.7 1.45e-5   NR WP_416493070.1 573 g52575 i0 55 0.654545454545455 60 20 57.8 1 2 160 13 72 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 180 49.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31992107 31992107 PRJNA981359_S_NODE_36578_length_310_cov_3.109705_g36478_i0 PRJNA981359 36578 310 3.109705 9.6400855 Enterobacterales 91347 Bacteria Bacteria 212 1.8e-66   NR WP_337223765.1 562 g36478 i0 100 4.98387096774194 103 0 99.7 0 310 2 49 151 WP_337223765.1 replication initiation protein [Escherichia coli] diamond 1545 212 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
32870554 32870554 PRJNA981359_S_NODE_34700_length_315_cov_2.057851_g34600_i0 PRJNA981359 34700 315 2.057851 6.48223065 unclassified Sphingomonas 196159 Bacteria Bacteria 155 4.29e-43   NR WP_137903334.1 196159 g34600 i0 100 0.771428571428571 81 0 77.1 0 245 3 1 81 WP_137903334.1 MULTISPECIES: carbohydrate porin [unclassified Sphingomonas] diamond 243 155 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Sphingomonadaceae Sphingomonas  

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