RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJEB27957" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJEB27957 · 28 ✖

analysis 1

  • diamond · 28 ✖
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
26906621 26906621 PRJEB27957_P_NODE_53262_length_226_cov_1.372881_g53152_i0 PRJEB27957 53262 226 1.372881 3.10271106 Pseudomonas sp. M3 690137 Bacteria Bacteria 43.1 0.0226   NR WP_087515756.1 1981174 g53152 i0 38.9 0.716814159292035 54 30 71.7 1 41 202 369 419 WP_087515756.1 ATP-binding protein [Pseudomonas sp. M30-35] diamond 162 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp. M30-35
27222608 27222608 PRJEB27957_P_NODE_68583_length_205_cov_0.910256_g68473_i0 PRJEB27957 68583 205 0.910256 1.8660248 Serratia marcescens 615 Bacteria Bacteria 40 0.0451   NR WP_309159585.1 615 g68473 i0 69.2 0.380487804878049 26 8 38 0 2 79 5 30 WP_309159585.1 hypothetical protein, partial [Serratia marcescens] diamond 78 40 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Serratia Serratia marcescens
27412670 27412670 PRJEB27957_P_NODE_67003_length_206_cov_2.649682_g66893_i0 PRJEB27957 67003 206 2.649682 5.45834492 Dasania marina 471499 Bacteria Bacteria 42 0.0424   NR WP_019530997.1 471499 g66893 i0 42.9 0.91747572815534 63 33 88.8 2 1 183 304 365 WP_019530997.1 acetylornithine transaminase [Dasania marina] diamond 189 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Spongiibacteraceae Dasania Dasania marina
27980820 27980820 PRJEB27957_P_NODE_28665_length_287_cov_3.495798_g28555_i0 PRJEB27957 28665 287 3.495798 10.03294026 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 43.1 0.0471   NR RYY02594.1 1913989 g28555 i0 40.5 0.825783972125436 79 44 81.5 2 276 43 165 241 RYY02594.1 MAG: hypothetical protein EOO53_13530 [Gammaproteobacteria bacterium] diamond 237 43.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
28012545 28012545 PRJEB27957_P_NODE_9745_length_425_cov_1.468085_g9636_i0 PRJEB27957 9745 425 1.468085 6.23936125 Pelagibacteraceae bacterium 2026775 Bacteria Bacteria 47 0.00739   NR MDC6482345.1 2026775 g9636 i0 37.7 0.430588235294118 61 34 43.1 1 400 218 233 289 MDC6482345.1 succinyl-diaminopimelate desuccinylase [Pelagibacteraceae bacterium] diamond 183 47 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Candidatus Pelagibacterales Candidatus Pelagibacteraceae   Pelagibacteraceae bacterium
28170230 28170230 PRJEB27957_P_NODE_49866_length_232_cov_1.136612_g49756_i0 PRJEB27957 49866 232 1.136612 2.63693984 endosymbiont of Tevnia jerichonana 94785 Bacteria Bacteria 54.7 1.04e-7   NR WP_240991764.1 94785 g49756 i0 43.4 0.685344827586207 53 30 68.5 0 177 19 17 69 WP_240991764.1 hypothetical protein, partial [endosymbiont of Tevnia jerichonana] diamond 159 54.7 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       endosymbiont of Tevnia jerichonana
28485981 28485981 PRJEB27957_P_NODE_109107_length_167_cov_0.881356_g108997_i0 PRJEB27957 109107 167 0.881356 1.47186452 Klebsiella pneumoniae 573 Bacteria Bacteria 42.7 0.00209   NR WP_416493070.1 573 g108997 i0 56.8 0.790419161676647 44 17 75.4 1 167 42 31 74 WP_416493070.1 hypothetical protein, partial [Klebsiella pneumoniae] diamond 132 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
28517612 28517612 PRJEB27957_P_NODE_102887_length_169_cov_1.300000_g102777_i0 PRJEB27957 102887 169 1.3 2.197 Rhodospirillales bacterium 2026786 Bacteria Bacteria 41.2 0.0488   NR NQW50795.1 2026786 g102777 i0 66.7 0.479289940828402 27 9 47.9 0 114 34 151 177 NQW50795.1 ATP-binding protein [Rhodospirillales bacterium] diamond 81 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodospirillales     Rhodospirillales bacterium
28580800 28580800 PRJEB27957_P_NODE_467_length_1142_cov_2.238792_g432_i0 PRJEB27957 467 1142 2.238792 25.56700464 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 85.9 5.2e-14   NR MCP3852634.1 1913989 g432 i0 44.1 1.53415061295972 93 46 23.1 3 657 920 654 745 MCP3852634.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 1752 85.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
28643997 28643997 PRJEB27957_P_NODE_22547_length_315_cov_1.530075_g22437_i0 PRJEB27957 22547 315 1.530075 4.81973625 Serratia marcescens 615 Bacteria Bacteria 45.1 0.00161   NR WP_309159585.1 615 g22437 i0 50 0.457142857142857 48 22 43.8 1 120 257 25 72 WP_309159585.1 hypothetical protein, partial [Serratia marcescens] diamond 144 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Serratia Serratia marcescens
28959799 28959799 PRJEB27957_P_NODE_121028_length_163_cov_1.245614_g120918_i0 PRJEB27957 121028 163 1.245614 2.03035082 Roseateles sp. 1971397 Bacteria Bacteria 42.4 0.0177   NR HEU6456564.1 1971397 g120918 i0 50 1.49079754601227 38 19 69.9 0 156 43 19 56 HEU6456564.1 hypothetical protein [Roseateles sp.] diamond 243 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Sphaerotilaceae Roseateles Roseateles sp.
28991460 28991460 PRJEB27957_P_NODE_94668_length_176_cov_103.236220_g94558_i0 PRJEB27957 94668 176 103.23622 181.6957472 Porphyrobacter sp. GA68 2883480 Bacteria Bacteria 54.3 1.24e-6   NR WP_228244238.1 2883480 g94558 i0 96.3 0.460227272727273 27 1 46 0 39 119 57 83 WP_228244238.1 alpha/beta fold hydrolase [Porphyrobacter sp. GA68] diamond 81 54.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Sphingomonadales Erythrobacteraceae Porphyrobacter Porphyrobacter sp. GA68
29023075 29023075 PRJEB27957_P_NODE_66308_length_207_cov_1.974684_g66198_i0 PRJEB27957 66308 207 1.974684 4.08759588 Neoroseomonas marina 1232220 Bacteria Bacteria 41.2 0.0162   NR WP_211187730.1 1232220 g66198 i0 68.2 0.318840579710145 22 7 31.9 0 99 34 57 78 WP_211187730.1 hypothetical protein, partial [Neoroseomonas marina] diamond 66 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae Neoroseomonas Neoroseomonas marina
29212336 29212336 PRJEB27957_P_NODE_91969_length_179_cov_1.600000_g91859_i0 PRJEB27957 91969 179 1.6 2.864 Gammaproteobacteria bacterium 1913989 Bacteria Bacteria 41.2 0.0241   NR MFV2061392.1 1913989 g91859 i0 54.3 0.58659217877095 35 14 55.3 1 130 32 25 59 MFV2061392.1 hypothetical protein [Gammaproteobacteria bacterium] diamond 105 41.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Gammaproteobacteria bacterium
29370089 29370089 PRJEB27957_P_NODE_86089_length_185_cov_1.529412_g85979_i0 PRJEB27957 86089 185 1.529412 2.8294122 Kangiella japonica 647384 Bacteria Bacteria 41.6 0.0437   NR WP_343987644.1 647384 g85979 i0 35.3 1.1027027027027 68 35 95.7 3 183 7 160 227 WP_343987644.1 aminoglycoside phosphotransferase family protein [Kangiella japonica] diamond 204 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Kangiellales Kangiellaceae Kangiella Kangiella japonica
29559353 29559353 PRJEB27957_P_NODE_83170_length_188_cov_1.496403_g83060_i0 PRJEB27957 83170 188 1.496403 2.81323764 Wigglesworthia glossinidia endosymbiont of Glossina brevipalpis 36870 Bacteria Bacteria 42 0.0342   NR BAC24274.1 36870 g83060 i0 40.5 0.670212765957447 42 25 67 0 179 54 273 314 BAC24274.1 plsB [Wigglesworthia glossinidia endosymbiont of Glossina brevipalpis] diamond 126 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Erwiniaceae Wigglesworthia Wigglesworthia glossinidia
29590690 29590690 PRJEB27957_P_NODE_51550_length_229_cov_1.155556_g51440_i0 PRJEB27957 51550 229 1.155556 2.64622324 Marilutibacter maris 1605891 Bacteria Bacteria 44.7 0.00324   NR WP_141482401.1 1605891 g51440 i0 31 0.930131004366812 71 44 93 1 215 3 34 99 WP_141482401.1 hypothetical protein [Marilutibacter maris] diamond 213 44.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Marilutibacter Marilutibacter maris
29780469 29780469 PRJEB27957_P_NODE_72571_length_200_cov_1.033113_g72461_i0 PRJEB27957 72571 200 1.033113 2.066226 Rickettsia canadensis 788 Bacteria Bacteria 40.8 0.0323   NR WP_014363743.1 788 g72461 i0 46.5 0.645 43 20 64.5 1 14 142 12 51 WP_014363743.1 ankyrin repeat domain-containing protein [Rickettsia canadensis] diamond 129 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rickettsiales Rickettsiaceae Rickettsia Rickettsia canadensis
30381139 30381139 PRJEB27957_P_NODE_92173_length_179_cov_1.384615_g92063_i0 PRJEB27957 92173 179 1.384615 2.47846085 Vibrio parahaemolyticus 670 Bacteria Bacteria 42.7 0.00235   NR MDG2633082.1 670 g92063 i0 66.7 1.20670391061453 24 8 40.2 0 132 61 21 44 MDG2633082.1 hypothetical protein [Vibrio parahaemolyticus] diamond 216 42.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
30823067 30823067 PRJEB27957_P_NODE_124834_length_162_cov_0.920354_g124724_i0 PRJEB27957 124834 162 0.920354 1.49097348 Pseudomonadota bacterium 1977087 Bacteria Bacteria 42 0.0233   NR MCX5895044.1 1977087 g124724 i0 51.5 0.611111111111111 33 16 61.1 0 56 154 454 486 MCX5895044.1 tetratricopeptide repeat protein [Pseudomonadota bacterium] diamond 99 42 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30854616 30854616 PRJEB27957_P_NODE_99554_length_172_cov_1.268293_g99444_i0 PRJEB27957 99554 172 1.268293 2.18146396 Hyphomicrobiaceae bacterium 2015799 Bacteria Bacteria 40.4 0.0313   NR HKD57141.1 2015799 g99444 i0 45.5 0.767441860465116 44 23 76.7 1 172 41 59 101 HKD57141.1 M20/M25/M40 family metallo-hydrolase [Hyphomicrobiaceae bacterium] diamond 132 40.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Hyphomicrobiaceae   Hyphomicrobiaceae bacterium
30949627 30949627 PRJEB27957_P_NODE_22594_length_315_cov_1.078947_g22484_i0 PRJEB27957 22594 315 1.078947 3.39868305 Serratia marcescens 615 Bacteria Bacteria 48.1 1.05e-4   NR WP_309159585.1 615 g22484 i0 55 0.666666666666667 40 17 37.1 1 315 199 1 40 WP_309159585.1 hypothetical protein, partial [Serratia marcescens] diamond 210 48.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Serratia Serratia marcescens
31170371 31170371 PRJEB27957_P_NODE_84235_length_187_cov_1.507246_g84125_i0 PRJEB27957 84235 187 1.507246 2.81855002 Serratia marcescens 615 Bacteria Bacteria 46.2 1.39e-4   NR WP_309159585.1 615 g84125 i0 40.6 1.02673796791444 64 31 91.4 1 171 1 2 65 WP_309159585.1 hypothetical protein, partial [Serratia marcescens] diamond 192 46.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Yersiniaceae Serratia Serratia marcescens
31581921 31581921 PRJEB27957_P_NODE_91436_length_180_cov_1.190840_g91326_i0 PRJEB27957 91436 180 1.19084 2.143512 Hyphomicrobiales bacterium 1909294 Bacteria Bacteria 41.6 0.0403   NR MBN9022720.1 1909294 g91326 i0 40 0.666666666666667 40 22 66.7 1 38 157 162 199 MBN9022720.1 Gfo/Idh/MocA family oxidoreductase [Hyphomicrobiales bacterium] diamond 120 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales     Hyphomicrobiales bacterium
31606969 31606969 PRJEB27957_P_NODE_101736_length_170_cov_1.289256_g101626_i0 PRJEB27957 101736 170 1.289256 2.1917352 Pseudomonadati 3379134 Bacteria Bacteria 43.5 0.00742   NR WP_138980361.1 573 g101626 i0 79.2 21.6 24 5 42.4 0 2 73 172 195 WP_138980361.1 RNA-directed DNA polymerase, partial [Klebsiella pneumoniae] diamond 3672 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Klebsiella Klebsiella pneumoniae
31961312 31961312 PRJEB27957_P_NODE_87038_length_184_cov_1.540741_g86928_i0 PRJEB27957 87038 184 1.540741 2.83496344 Kangiellaceae bacterium 2026751 Bacteria Bacteria 43.5 0.00931   NR MEE4247332.1 2026751 g86928 i0 60 1.71195652173913 35 14 57.1 0 115 11 447 481 MEE4247332.1 reverse transcriptase family protein [Kangiellaceae bacterium] diamond 315 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Kangiellales Kangiellaceae   Kangiellaceae bacterium
32176604 32176604 PRJEB27957_P_NODE_109038_length_167_cov_0.881356_g108928_i0 PRJEB27957 109038 167 0.881356 1.47186452 Methylobacterium 407 Bacteria Bacteria 112 1.72e-29   NR WP_009867628.1 107400 g108928 i0 92.6 1.94011976047904 54 4 97 0 165 4 61 114 WP_009867628.1 c-type cytochrome [Methylobacterium fujisawaense] diamond 324 112 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Methylobacteriaceae Methylobacterium Methylobacterium fujisawaense
32625416 32625416 PRJEB27957_P_NODE_115820_length_165_cov_0.896552_g115710_i0 PRJEB27957 115820 165 0.896552 1.4793108 Vibrio parahaemolyticus 670 Bacteria Bacteria 40.8 0.0314   NR MDG2595057.1 670 g115710 i0 54.8 1.12727272727273 31 14 56.4 0 73 165 3 33 MDG2595057.1 transposase [Vibrio parahaemolyticus] diamond 186 40.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus

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