RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA532380" and tax_phylum = "Pseudomonadota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Pseudomonadota · 26 ✖

tax_kingdom 1

bioproject 1

  • PRJNA532380 · 26 ✖

analysis 1

  • diamond · 26 ✖
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
26950873 26950873 PRJNA532380_P_NODE_18102_length_212_cov_0.932515_g17777_i0 PRJNA532380 18102 212 0.932515 1.9769318 Candidatus Pelagibacter bacterium 2024849 Bacteria Bacteria 42 0.0456   NR MDA8539039.1 2780116 g17777 i0 39 0.834905660377358 59 30 75 2 40 198 154 212 MDA8539039.1 cysteine desulfurase [Candidatus Pelagibacter bacterium] diamond 177 42 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Candidatus Pelagibacterales Candidatus Pelagibacteraceae Candidatus Pelagibacter Candidatus Pelagibacter bacterium
27267228 27267228 PRJNA532380_P_NODE_28263_length_168_cov_0.873950_g27938_i0 PRJNA532380 28263 168 0.87395 1.468236 Plasticicumulans sp. 2307179 Bacteria Bacteria 39.7 0.0493   NR WP_347279756.1 2307179 g27938 i0 45 1.07142857142857 60 24 100 3 168 1 18 72 WP_347279756.1 hypothetical protein [Plasticicumulans sp.] diamond 180 39.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria   Candidatus Competibacteraceae Plasticicumulans Plasticicumulans sp.
27345740 27345740 PRJNA532380_P_NODE_21723_length_192_cov_2.181818_g21398_i0 PRJNA532380 21723 192 2.181818 4.18909056 Pseudomonadota 1224 Bacteria Bacteria 58.9 3.76e-8   NR MBT6539633.1 1902406 g21398 i0 43.8 9 64 36 100 0 192 1 401 464 MBT6539633.1 choline dehydrogenase [Francisellaceae bacterium] diamond 1728 59.3 0.993254637436762 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Thiotrichales Francisellaceae   Francisellaceae bacterium
27961978 27961978 PRJNA532380_P_NODE_8225_length_330_cov_6.960854_g7900_i0 PRJNA532380 8225 330 6.960854 22.9708182 Bathymodiolus azoricus thioautotrophic gill symbiont 235205 Bacteria Bacteria 58.2 1.04e-8   NR WP_206599462.1 235205 g7900 i0 66 0.427272727272727 47 16 42.7 0 106 246 8 54 WP_206599462.1 hypothetical protein, partial [Bathymodiolus azoricus thioautotrophic gill symbiont] diamond 141 58.2 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus azoricus thioautotrophic gill symbiont
28593581 28593581 PRJNA532380_P_NODE_31027_length_165_cov_0.896552_g30702_i0 PRJNA532380 31027 165 0.896552 1.4793108 Methyloversatilis sp. 2569862 Bacteria Bacteria 94.4 1.79e-22   NR WP_374339900.1 2569862 g30702 i0 96.1 1.85454545454545 51 2 92.7 0 164 12 139 189 WP_374339900.1 hypothetical protein [Methyloversatilis sp.] diamond 306 94.4 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Nitrosomonadales Sterolibacteriaceae Methyloversatilis Methyloversatilis sp.
28941005 28941005 PRJNA532380_P_NODE_33108_length_162_cov_0.920354_g32783_i0 PRJNA532380 33108 162 0.920354 1.49097348 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 42 0.00458   NR WP_395585452.1 251699 g32783 i0 48.1 0.962962962962963 52 20 96.3 2 4 159 5 49 WP_395585452.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 156 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
29082256 29082256 PRJNA532380_P_NODE_12728_length_255_cov_1.009709_g12403_i0 PRJNA532380 12728 255 1.009709 2.57475795 Alphaproteobacteria 28211 Bacteria Bacteria 70.5 9.35e-13   NR WP_211865584.1 424799 g12403 i0 46.3 3.75294117647059 80 43 94.1 0 1 240 27 106 WP_211865584.1 ubiquinol-cytochrome c reductase iron-sulfur subunit [Neoroseomonas terrae] diamond 957 70.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae Neoroseomonas Neoroseomonas terrae
29082264 29082264 PRJNA532380_P_NODE_30608_length_165_cov_0.896552_g30283_i0 PRJNA532380 30608 165 0.896552 1.4793108 root 1 Root_unresolved Root_unresolved 53.1 1.29e-7   NR MDG2682245.1 670 g30283 i0 100 176.272727272727 24 0 43.6 0 74 3 10 33 MDG2682245.1 hypothetical protein [Vibrio parahaemolyticus] diamond 29085 53.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Vibrionales Vibrionaceae Vibrio Vibrio parahaemolyticus
29130417 29130417 PRJNA532380_P_NODE_15369_length_230_cov_1.812155_g15044_i0 PRJNA532380 15369 230 1.812155 4.1679565 Bathymodiolus thermophilus thioautotrophic gill symbiont 2360 Bacteria Bacteria 54.3 1.35e-7   NR WP_237731691.1 2360 g15044 i0 65.8 0.939130434782609 38 13 49.6 0 191 78 1 38 WP_237731691.1 hypothetical protein, partial [Bathymodiolus thermophilus thioautotrophic gill symbiont] diamond 216 54.3 1 Bacteria sulfur-oxidizing symbionts Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus thermophilus thioautotrophic gill symbiont
29572139 29572139 PRJNA532380_P_NODE_31630_length_164_cov_0.904348_g31305_i0 PRJNA532380 31630 164 0.904348 1.48313072 uncultured Gammaproteobacteria bacterium 86473 Bacteria Bacteria 50.8 1.88e-6   NR CAC9628179.1 86473 g31305 i0 55.8 0.951219512195122 52 21 95.1 1 161 6 7 56 CAC9628179.1 hypothetical protein [uncultured Gammaproteobacteria bacterium] diamond 156 50.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       uncultured Gammaproteobacteria bacterium
29951242 29951242 PRJNA532380_P_NODE_8551_length_323_cov_1.328467_g8226_i0 PRJNA532380 8551 323 1.328467 4.29094841 Comamonadaceae bacterium 1871071 Bacteria Bacteria 45.1 0.0148   NR RYX91824.1 1871071 g8226 i0 38.9 0.668730650154799 72 40 65.9 2 241 29 195 263 RYX91824.1 MAG: maltose alpha-D-glucosyltransferase [Comamonadaceae bacterium] diamond 216 45.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae   Comamonadaceae bacterium
30045837 30045837 PRJNA532380_P_NODE_30431_length_165_cov_1.629310_g30106_i0 PRJNA532380 30431 165 1.62931 2.6883615 Sedimenticola sp. 1940285 Bacteria Bacteria 65.1 1.66e-10   NR MES9879516.1 1940285 g30106 i0 56.6 0.963636363636364 53 23 96.4 0 163 5 420 472 MES9879516.1 reverse transcriptase family protein [Sedimenticola sp.] diamond 159 65.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Chromatiales Sedimenticolaceae Sedimenticola Sedimenticola sp.
30172289 30172289 PRJNA532380_P_NODE_27472_length_169_cov_0.866667_g27147_i0 PRJNA532380 27472 169 0.866667 1.46466723 Phyllobacterium myrsinacearum 28101 Bacteria Bacteria 105 2.42e-25   NR WP_105733033.1 28101 g27147 i0 98.2 0.976331360946746 55 1 97.6 0 167 3 15 69 WP_105733033.1 DUF459 domain-containing protein [Phyllobacterium myrsinacearum] diamond 165 105 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Phyllobacteriaceae Phyllobacterium Phyllobacterium myrsinacearum
30503473 30503473 PRJNA532380_P_NODE_22513_length_189_cov_1.471429_g22188_i0 PRJNA532380 22513 189 1.471429 2.78100081 Bacteria 2 Bacteria Bacteria 47 5.6e-4   NR CAC9527309.1 86473 g22188 i0 56.8 1.76190476190476 37 16 58.7 0 125 15 318 354 CAC9527309.1 hypothetical protein [uncultured Gammaproteobacteria bacterium] diamond 333 47 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       uncultured Gammaproteobacteria bacterium
30804247 30804247 PRJNA532380_P_NODE_16914_length_219_cov_0.964706_g16589_i0 PRJNA532380 16914 219 0.964706 2.11270614 Roseibium hamelinense 150831 Bacteria Bacteria 43.5 0.0136   NR WP_145343385.1 150831 g16589 i0 45.5 0.602739726027397 44 24 60.3 0 73 204 24 67 WP_145343385.1 cobalt-precorrin-6A reductase [Roseibium hamelinense] diamond 132 43.5 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Hyphomicrobiales Stappiaceae Roseibium Roseibium hamelinense
30804249 30804249 PRJNA532380_P_NODE_20474_length_199_cov_0.786667_g20149_i0 PRJNA532380 20474 199 0.786667 1.56546733 Pseudomonadota bacterium 1977087 Bacteria Bacteria 42.4 0.0283   NR MEW6641764.1 1977087 g20149 i0 33.3 0.994974874371859 66 38 90.5 1 7 186 122 187 MEW6641764.1 branched-chain amino acid ABC transporter permease [Pseudomonadota bacterium] diamond 198 42.4 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
30993900 30993900 PRJNA532380_P_NODE_27374_length_169_cov_0.866667_g27049_i0 PRJNA532380 27374 169 0.866667 1.46466723 Pseudomonas syringae group genomosp. 7 251699 Bacteria Bacteria 42 0.0222   NR WP_395585829.1 251699 g27049 i0 50 0.603550295857988 34 12 51.5 1 77 163 38 71 WP_395585829.1 hypothetical protein, partial [Pseudomonas syringae group genomosp. 7] diamond 102 42 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas syringae group genomosp. 7
31261791 31261791 PRJNA532380_P_NODE_29835_length_166_cov_0.888889_g29510_i0 PRJNA532380 29835 166 0.888889 1.47555574 Pseudomonadati 3379134 Bacteria Bacteria 84 2.05e-17   NR WP_012073625.1 67854 g29510 i0 76.7 30.289156626506 43 10 77.7 0 35 163 148 190 WP_012073625.1 galactose-1-phosphate uridylyltransferase [Actinobacillus succinogenes] diamond 5028 84.3 0.99644128113879 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Actinobacillus Actinobacillus succinogenes
31404933 31404933 PRJNA532380_P_NODE_14596_length_237_cov_1.106383_g14271_i0 PRJNA532380 14596 237 1.106383 2.62212771 Porticoccus sp. 2024853 Bacteria Bacteria 67 6.76e-11   NR MAD57955.1 2024853 g14271 i0 63.3 0.620253164556962 49 18 62 0 230 84 108 156 MAD57955.1 electron transfer flavoprotein subunit alpha [Porticoccus sp.] diamond 147 67 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Cellvibrionales Porticoccaceae Porticoccus Porticoccus sp.
31419836 31419836 PRJNA532380_P_NODE_17776_length_213_cov_3.469512_g17451_i0 PRJNA532380 17776 213 3.469512 7.39006056 Bacteria 2 Bacteria Bacteria 50.1 6.5e-5   NR CAC9527309.1 86473 g17451 i0 47.1 1.43661971830986 51 27 71.8 0 192 40 106 156 CAC9527309.1 hypothetical protein [uncultured Gammaproteobacteria bacterium] diamond 306 50.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       uncultured Gammaproteobacteria bacterium
31974154 31974154 PRJNA532380_P_NODE_25198_length_177_cov_1.625000_g24873_i0 PRJNA532380 25198 177 1.625 2.87625 uncultured Gammaproteobacteria bacterium 86473 Bacteria Bacteria 47.8 1.27e-5   NR CAC9573227.1 86473 g24873 i0 45 1.35593220338983 40 22 67.8 0 14 133 2 41 CAC9573227.1 hypothetical protein, partial [uncultured Gammaproteobacteria bacterium] diamond 240 47.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       uncultured Gammaproteobacteria bacterium
32227479 32227479 PRJNA532380_P_NODE_33358_length_162_cov_0.920354_g33033_i0 PRJNA532380 33358 162 0.920354 1.49097348 Bathymodiolus brooksi thiotrophic gill symbiont 1052209 Bacteria Bacteria 73.9 9.19e-14   NR CAB9544841.1 1052209 g33033 i0 73.1 1.92592592592593 52 14 96.3 0 1 156 141 192 CAB9544841.1 hypothetical protein BROOK1789C_1992 [Bathymodiolus brooksi thiotrophic gill symbiont] diamond 312 73.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus brooksi thiotrophic gill symbiont
32259279 32259279 PRJNA532380_P_NODE_30998_length_165_cov_0.896552_g30673_i0 PRJNA532380 30998 165 0.896552 1.4793108 Candidatus Thioglobus sp. 2026721 Bacteria Bacteria 53.9 1.72e-7   NR MCS5590247.1 2026721 g30673 i0 58.1 0.781818181818182 43 18 78.2 0 33 161 66 108 MCS5590247.1 hypothetical protein [Candidatus Thioglobus sp.] diamond 129 53.9 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria   Candidatus Pseudothioglobaceae Candidatus Thioglobus Candidatus Thioglobus sp.
32385523 32385523 PRJNA532380_P_NODE_32759_length_163_cov_0.868421_g32434_i0 PRJNA532380 32759 163 0.868421 1.41552623 Bathymodiolus platifrons methanotrophic gill symbiont 113268 Bacteria Bacteria 77 9.28e-16   NR GAW87878.1 113268 g32434 i0 71.7 0.975460122699387 53 15 97.5 0 2 160 105 157 GAW87878.1 hypothetical protein bplSymb_SCF24501P001 [Bathymodiolus platifrons methanotrophic gill symbiont] diamond 159 77 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria       Bathymodiolus platifrons methanotrophic gill symbiont
32512413 32512413 PRJNA532380_P_NODE_22619_length_189_cov_0.942857_g22294_i0 PRJNA532380 22619 189 0.942857 1.78199973 Pararhodobacter oceanensis 2172121 Bacteria Bacteria 76.3 2.83e-14   NR WP_116559574.1 2172121 g22294 i0 57.1 4 63 26 100 1 189 1 141 202 WP_116559574.1 GMC family oxidoreductase [Pararhodobacter oceanensis] diamond 756 76.3 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Pararhodobacter Pararhodobacter oceanensis
32606765 32606765 PRJNA532380_P_NODE_32300_length_163_cov_0.912281_g31975_i0 PRJNA532380 32300 163 0.912281 1.48701803 Komagataeibacter oboediens 65958 Bacteria Bacteria 42.4 0.0176   NR WP_254511063.1 65958 g31975 i0 58.3 0.441717791411043 24 9 44.2 1 83 154 443 465 WP_254511063.1 hypothetical protein [Komagataeibacter oboediens] diamond 72 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae Komagataeibacter Komagataeibacter oboediens

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