RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA763718" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 22 ✖

bioproject 1

  • PRJNA763718 · 22 ✖

analysis 1

  • diamond · 22 ✖
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
7122914 7122914 PRJNA763718_S_NODE_4906_length_198_cov_1.372671_g4698_i0 PRJNA763718 4906 198 1.372671 2.71788858 Cloacibacterium 501783 Bacteria Bacteria 72 9.66e-13   NR MEN9487606.1 1898104 g4698 i0 55.2 6.09090909090909 67 28 98.5 1 2 196 817 883 MEN9487606.1 hypothetical protein [Bacteroidota bacterium] diamond 1206 72 1 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
26609787 26609787 PRJNA763718_S_NODE_7901_length_157_cov_0.966667_g7693_i0 PRJNA763718 7901 157 0.966667 1.51766719 unclassified Pseudoalteromonas 194690 Bacteria Bacteria 111 5.940000000000001e-27   NR WP_024597516.1 194690 g7693 i0 98.1 0.993630573248408 52 1 99.4 0 1 156 181 232 WP_024597516.1 MULTISPECIES: UvrD-helicase domain-containing protein [unclassified Pseudoalteromonas] diamond 156 111 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Alteromonadales Pseudoalteromonadaceae Pseudoalteromonas  
27031143 27031143 PRJNA763718_S_NODE_4862_length_199_cov_1.172840_g4654_i0 PRJNA763718 4862 199 1.17284 2.3339516 Pseudomonadati 3379134 Bacteria Bacteria 42.7 0.0204   NR HEV7517336.1 2651171 g4654 i0 35.7 1.67336683417085 56 33 84.4 1 15 182 396 448 HEV7517336.1 hypothetical protein [Thermoanaerobaculia bacterium] diamond 333 42.7 1 Bacteria   Pseudomonadati Acidobacteriota Thermoanaerobaculia       Thermoanaerobaculia bacterium
27558532 27558532 PRJNA763718_S_NODE_4624_length_204_cov_1.574850_g4416_i0 PRJNA763718 4624 204 1.57485 3.212694 Aeromonas 642 Bacteria Bacteria 126 1.05e-35   NR WP_019444963.1 642 g4416 i0 100 0.985294117647059 67 0 98.5 0 203 3 23 89 WP_019444963.1 MULTISPECIES: helix-turn-helix domain-containing protein [Aeromonas] diamond 201 126 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
27748411 27748411 PRJNA763718_S_NODE_7124_length_164_cov_3.039370_g6916_i0 PRJNA763718 7124 164 3.03937 4.9845668 Aeromonas 642 Bacteria Bacteria 105 9.13e-27   NR WP_019444962.1 642 g6916 i0 100 0.896341463414634 49 0 89.6 0 162 16 137 185 WP_019444962.1 MULTISPECIES: ImmA/IrrE family metallo-endopeptidase [Aeromonas] diamond 147 105 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
27884059 27884059 PRJNA763718_S_NODE_8365_length_153_cov_1.982759_g8157_i0 PRJNA763718 8365 153 1.982759 3.03362127 root 1 Root_unresolved Root_unresolved 43.1 6.9e-4   NR MBS4163024.1 362787 g8157 i0 74.1 3.35294117647059 27 7 52.9 0 2 82 19 45 MBS4163024.1 hypothetical protein [Candidatus Protochlamydia amoebophila] diamond 513 43.1 1 Bacteria PVC group Pseudomonadati Chlamydiota Chlamydiia Parachlamydiales Parachlamydiaceae Candidatus Protochlamydia Candidatus Protochlamydia amoebophila
28537739 28537739 PRJNA763718_S_NODE_5207_length_192_cov_1.787097_g4999_i0 PRJNA763718 5207 192 1.787097 3.43122624 Pseudomonas sp. 306 Bacteria Bacteria 41.6 0.0399   NR HLT04349.1 306 g4999 i0 36.2 0.734375 47 26 73.4 1 14 154 152 194 HLT04349.1 class I SAM-dependent methyltransferase [Pseudomonas sp.] diamond 141 41.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas sp.
28705122 28705122 PRJNA763718_S_NODE_7567_length_160_cov_1.341463_g7359_i0 PRJNA763718 7567 160 1.341463 2.1463408 Comamonadaceae 80864 Bacteria Bacteria 87.8 1.37e-18   NR WP_010104906.1 1110389 g7359 i0 78.4 5.6625 51 11 95.6 0 155 3 422 472 WP_010104906.1 adenosylhomocysteinase [Verminephrobacter aporrectodeae] diamond 906 88.2 0.99546485260771 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Burkholderiales Comamonadaceae Verminephrobacter Verminephrobacter aporrectodeae
28726989 28726989 PRJNA763718_S_NODE_7587_length_160_cov_0.934959_g7379_i0 PRJNA763718 7587 160 0.934959 1.4959344 Flammeovirga yaeyamensis 367791 Bacteria Bacteria 41.6 0.00663   NR ACA05074.1 367791 g7379 i0 57.1 0.7875 42 18 78.8 0 126 1 13 54 ACA05074.1 hypothetical protein, partial [Flammeovirga yaeyamensis] diamond 126 41.6 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Flammeovirgaceae Flammeovirga Flammeovirga yaeyamensis
28916164 28916164 PRJNA763718_S_NODE_928_length_556_cov_38.500963_g733_i0 PRJNA763718 928 556 38.500963 214.06535428 Enterobacter hormaechei 158836 Bacteria Bacteria 131 8.099999999999999e-36   NR WP_096179768.1 158836 g733 i0 94.6 0.60431654676259 112 6 60.4 0 338 3 1 112 WP_096179768.1 hypothetical protein, partial [Enterobacter hormaechei] diamond 336 131 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Enterobacter Enterobacter hormaechei
29326763 29326763 PRJNA763718_S_NODE_3889_length_224_cov_1.465241_g3681_i0 PRJNA763718 3889 224 1.465241 3.28213984 Bacteroidia bacterium 2044936 Bacteria Bacteria 42.7 0.0299   NR MBT8260500.1 2044936 g3681 i0 40.9 0.589285714285714 44 26 58.9 0 192 61 28 71 MBT8260500.1 caspase family protein [Bacteroidia bacterium] diamond 132 42.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Bacteroidia       Bacteroidia bacterium
29863638 29863638 PRJNA763718_S_NODE_6671_length_169_cov_6.121212_g6463_i0 PRJNA763718 6671 169 6.121212 10.34484828 Neoroseomonas marina 1232220 Bacteria Bacteria 42.4 0.0175   NR WP_170056679.1 1232220 g6463 i0 81.8 5.50295857988166 22 4 39.1 0 97 162 151 172 WP_170056679.1 RNA-directed DNA polymerase, partial [Neoroseomonas marina] diamond 930 42.4 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Acetobacterales Acetobacteraceae Neoroseomonas Neoroseomonas marina
29999797 29999797 PRJNA763718_S_NODE_5711_length_183_cov_1.232877_g5503_i0 PRJNA763718 5711 183 1.232877 2.25616491 Pseudomonadota 1224 Bacteria Bacteria 51.2 1.63e-5   NR WP_235184783.1 29487 g5503 i0 48.3 4.85245901639344 58 27 95.1 1 1 174 244 298 WP_235184783.1 MULTISPECIES: phage tail protein [Photorhabdus] diamond 888 51.2 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Morganellaceae Photorhabdus  
30338024 30338024 PRJNA763718_S_NODE_6672_length_169_cov_6.090909_g6464_i0 PRJNA763718 6672 169 6.090909 10.29363621 Planctomycetota bacterium 2026780 Bacteria Bacteria 42.7 0.0132   NR MBM4009064.1 2026780 g6464 i0 38.5 1.38461538461538 39 21 63.9 1 12 119 137 175 MBM4009064.1 DMT family transporter [Planctomycetota bacterium] diamond 234 42.7 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
30621783 30621783 PRJNA763718_S_NODE_3513_length_237_cov_3.270000_g3305_i0 PRJNA763718 3513 237 3.27 7.7499 Borrelia miyamotoi 47466 Bacteria Bacteria 79.3 2.06e-15   NR WP_152300945.1 47466 g3305 i0 54.5 4.87341772151899 77 35 97.5 0 235 5 142 218 WP_152300945.1 L-lactate dehydrogenase [Borrelia miyamotoi] diamond 1155 79.3 1 Bacteria   Pseudomonadati Spirochaetota Spirochaetia Spirochaetales Borreliaceae Borrelia Borrelia miyamotoi
30653336 30653336 PRJNA763718_S_NODE_4153_length_215_cov_12.634831_g3945_i0 PRJNA763718 4153 215 12.634831 27.16488665 Gemmatales bacterium 2838789 Bacteria Bacteria 42 0.0454   NR MCS7017116.1 2838789 g3945 i0 41.4 0.809302325581395 58 25 80.9 3 184 11 162 210 MCS7017116.1 ABC transporter permease [Gemmatales bacterium] diamond 174 42 1 Bacteria PVC group Pseudomonadati Planctomycetota Planctomycetia Gemmatales     Gemmatales bacterium
30653337 30653337 PRJNA763718_S_NODE_4493_length_207_cov_1.564706_g4285_i0 PRJNA763718 4493 207 1.564706 3.23894142 Helicobacter pylori 210 Bacteria Bacteria 61.2 1.79e-10   NR GAA8802695.1 210 g4285 i0 92 0.72463768115942 50 4 72.5 0 184 35 7 56 GAA8802695.1 hypothetical protein Kyoto149A_2190 [Helicobacter pylori] diamond 150 61.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31064490 31064490 PRJNA763718_S_NODE_5975_length_179_cov_1.070423_g5767_i0 PRJNA763718 5975 179 1.070423 1.91605717 Sorangiineae bacterium NIC37A_2 1970199 Bacteria Bacteria 97.1 9.58e-22   NR OQX66423.1 1970199 g5767 i0 75.9 0.972067039106145 58 14 97.2 0 2 175 315 372 OQX66423.1 MAG: hypothetical protein B6A08_20570 [Sorangiineae bacterium NIC37A_2] diamond 174 97.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia Myxococcales     Sorangiineae bacterium NIC37A_2
31190265 31190265 PRJNA763718_S_NODE_7255_length_163_cov_1.539683_g7047_i0 PRJNA763718 7255 163 1.539683 2.50968329 Aeromonas 642 Bacteria Bacteria 107 1.09e-27   NR WP_019444962.1 642 g7047 i0 100 0.975460122699387 53 0 97.5 0 3 161 49 101 WP_019444962.1 MULTISPECIES: ImmA/IrrE family metallo-endopeptidase [Aeromonas] diamond 159 107 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
31222014 31222014 PRJNA763718_S_NODE_6475_length_172_cov_1.051852_g6267_i0 PRJNA763718 6475 172 1.051852 1.80918544 Polyangiaceae bacterium 2268199 Bacteria Bacteria 45.8 3.77e-4   NR HXS16005.1 2268199 g6267 i0 50 0.906976744186046 52 26 90.7 0 16 171 11 62 HXS16005.1 ATP synthase subunit I [Polyangiaceae bacterium] diamond 156 45.8 1 Bacteria   Pseudomonadati Myxococcota   Polyangiales Polyangiaceae   Polyangiaceae bacterium
31601967 31601967 PRJNA763718_S_NODE_6696_length_169_cov_2.303030_g6488_i0 PRJNA763718 6696 169 2.30303 3.8921207 Aeromonas 642 Bacteria Bacteria 52.4 2.64e-6   NR WP_019444962.1 642 g6488 i0 96.3 0.479289940828402 27 1 47.9 0 89 169 1 27 WP_019444962.1 MULTISPECIES: ImmA/IrrE family metallo-endopeptidase [Aeromonas] diamond 81 52.4 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Aeromonadales Aeromonadaceae Aeromonas  
32686389 32686389 PRJNA763718_S_NODE_7680_length_159_cov_0.942623_g7472_i0 PRJNA763718 7680 159 0.942623 1.49877057 Bacteria 2 Bacteria Bacteria 45.1 0.00187   NR MEI6226463.1 2026735 g7472 i0 48 3.81132075471698 50 26 94.3 0 156 7 92 141 MEI6226463.1 DDE-type integrase/transposase/recombinase [Deltaproteobacteria bacterium] diamond 606 45.1 1 Bacteria   Pseudomonadati Myxococcota Myxococcia       Deltaproteobacteria 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);;