RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA1008049" and tax_kingdom = "Pseudomonadati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_clade 2

tax_superkingdom 1

tax_kingdom 1

  • Pseudomonadati · 32 ✖

bioproject 1

  • PRJNA1008049 · 32 ✖

analysis 1

  • diamond · 32 ✖
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
3980225 3980225 PRJNA1008049_S_NODE_3744_length_161_cov_3.553030_g3726_i0 PRJNA1008049 3744 161 3.55303 5.7203783 Neisseriaceae 481 Bacteria Bacteria 100 4.31e-24   NR WP_064086970.1 539 g3726 i0 92.3 7.84472049689441 52 3 95 1 155 3 153 204 WP_064086970.1 HNH endonuclease [Eikenella corrodens] diamond 1263 101 0.99009900990099 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Eikenella Eikenella corrodens
12480117 12480117 PRJNA1008049_S_NODE_3330_length_165_cov_5.595588_g3312_i0 PRJNA1008049 3330 165 5.595588 9.2327202 Flavobacterium sp. 27 239 Bacteria Bacteria 108 2.9e-28   NR WP_134146805.1 2512114 g3312 i0 100 0.981818181818182 54 0 98.2 0 163 2 36 89 WP_134146805.1 hypothetical protein [Flavobacterium sp. 270] diamond 162 108 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 270
18005540 18005540 PRJNA1008049_S_NODE_4355_length_156_cov_2.385827_g4337_i0 PRJNA1008049 4355 156 2.385827 3.72189012 Thermomonas hydrothermalis 213588 Bacteria Bacteria 98.6 2.4e-22   NR WP_273388368.1 213588 g4337 i0 100 0.980769230769231 51 0 98.1 0 155 3 841 891 WP_273388368.1 EAL domain-containing protein [Thermomonas hydrothermalis] diamond 153 98.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Lysobacterales Lysobacteraceae Thermomonas Thermomonas hydrothermalis
26686189 26686189 PRJNA1008049_S_NODE_2981_length_169_cov_2.900000_g2963_i0 PRJNA1008049 2981 169 2.9 4.901 Xanthocytophaga agilis 3048010 Bacteria Bacteria 95.9 2.64e-21   NR WP_314513102.1 3048010 g2963 i0 75 0.994082840236686 56 14 99.4 0 1 168 180 235 WP_314513102.1 TonB-dependent receptor [Xanthocytophaga agilis] diamond 168 95.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Cytophagia Cytophagales Rhodocytophagaceae Xanthocytophaga Xanthocytophaga agilis
26781429 26781429 PRJNA1008049_S_NODE_4601_length_154_cov_3.768000_g4583_i0 PRJNA1008049 4601 154 3.768 5.80272 Pseudomonas migulae 78543 Bacteria Bacteria 90.1 8.75e-22   NR WP_084321185.1 78543 g4583 i0 97.6 1.63636363636364 42 1 81.8 0 128 3 6 47 WP_084321185.1 GrlR family regulatory protein [Pseudomonas migulae] diamond 252 90.1 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pseudomonadales Pseudomonadaceae Pseudomonas Pseudomonas migulae
26844857 26844857 PRJNA1008049_S_NODE_721_length_226_cov_5.060914_g703_i0 PRJNA1008049 721 226 5.060914 11.43766564 Ferruginibacter sp. 1940288 Bacteria Bacteria 107 2.97e-28   NR HSN60774.1 1940288 g703 i0 65.3 0.995575221238938 75 26 99.6 0 226 2 29 103 HSN60774.1 hypothetical protein [Ferruginibacter sp.] diamond 225 107 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae Ferruginibacter Ferruginibacter sp.
26939391 26939391 PRJNA1008049_S_NODE_3922_length_159_cov_6.084615_g3904_i0 PRJNA1008049 3922 159 6.084615 9.67453785 Escherichia coli 562 Bacteria Bacteria 87.8 3.83e-21   NR MDW3502919.1 562 g3904 i0 74.5 1.73584905660377 51 13 96.2 0 158 6 4 54 MDW3502919.1 hypothetical protein [Escherichia coli] diamond 276 87.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Escherichia Escherichia coli
27065986 27065986 PRJNA1008049_S_NODE_1022_length_208_cov_8.212291_g1004_i0 PRJNA1008049 1022 208 8.212291 17.08156528 Pseudomonadota bacterium 1977087 Bacteria Bacteria 146 2.6799999999999993e-43   NR MBS0417629.1 1977087 g1004 i0 97 0.966346153846154 67 2 96.6 0 3 203 85 151 MBS0417629.1 c-type cytochrome [Pseudomonadota bacterium] diamond 201 146 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
27121520 27121520 PRJNA1008049_S_NODE_2082_length_180_cov_2.721854_g2064_i0 PRJNA1008049 2082 180 2.721854 4.8993372 Chitinophagaceae 563835 Bacteria Bacteria 104 9.44e-28   NR MEI8280745.1 1898104 g2064 i0 87.7 7.6 57 7 95 0 9 179 1 57 MEI8280745.1 S-adenosylmethionine:tRNA ribosyltransferase-isomerase [Bacteroidota bacterium] diamond 1368 105 0.990476190476191 Bacteria FCB group Pseudomonadati Bacteroidota         Bacteroidota bacterium
27319121 27319121 PRJNA1008049_S_NODE_1623_length_188_cov_42.490566_g1605_i0 PRJNA1008049 1623 188 42.490566 79.88226408 Helicobacter pylori 210 Bacteria Bacteria 60.1 2.75e-10   NR GAA9125267.1 210 g1605 i0 83.9 0.49468085106383 31 5 49.5 0 55 147 4 34 GAA9125267.1 hypothetical protein Kyoto190A_0800 [Helicobacter pylori] diamond 93 60.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27761365 27761365 PRJNA1008049_S_NODE_524_length_244_cov_4.553488_g506_i0 PRJNA1008049 524 244 4.553488 11.11051072 Haemophilus paraphrohaemolyticus 736 Bacteria Bacteria 162 1.97e-44   NR WP_318655603.1 736 g506 i0 100 0.995901639344262 81 0 99.6 0 244 2 674 754 WP_318655603.1 N-6 DNA methylase [Haemophilus paraphrohaemolyticus] diamond 243 162 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Haemophilus Haemophilus paraphrohaemolyticus
28543173 28543173 PRJNA1008049_S_NODE_5147_length_150_cov_12.438017_g5129_i0 PRJNA1008049 5147 150 12.438017 18.6570255 Bacteroidota 976 Bacteria Bacteria 60.8 2.9e-9   NR HTE12334.1 1869212 g5129 i0 58.1 5.54 43 18 86 0 130 2 4 46 HTE12334.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Chitinophagaceae bacterium] diamond 831 60.8 1 Bacteria FCB group Pseudomonadati Bacteroidota Chitinophagia Chitinophagales Chitinophagaceae   Chitinophagaceae bacterium
29024415 29024415 PRJNA1008049_S_NODE_1468_length_192_cov_17.239264_g1450_i0 PRJNA1008049 1468 192 17.239264 33.09938688 Flavobacterium sp. 27 239 Bacteria Bacteria 54.7 2.91e-8   NR WP_134148188.1 2512114 g1450 i0 100 0.828125 27 0 42.2 0 190 110 19 45 WP_134148188.1 rSAM-modified peptide [Flavobacterium sp. 270] diamond 159 54.7 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 270
29308111 29308111 PRJNA1008049_S_NODE_2549_length_175_cov_2.020548_g2531_i0 PRJNA1008049 2549 175 2.020548 3.535959 Luteolibacter sp. 1962973 Bacteria Bacteria 80.9 5.26e-16   NR WP_348214879.1 1962973 g2531 i0 80.4 0.96 56 11 96 0 170 3 1813 1868 WP_348214879.1 hypothetical protein [Luteolibacter sp.] diamond 168 80.9 1 Bacteria PVC group Pseudomonadati Verrucomicrobiota Verrucomicrobiia Verrucomicrobiales Verrucomicrobiaceae Luteolibacter Luteolibacter sp.
29308112 29308112 PRJNA1008049_S_NODE_3529_length_163_cov_4.917910_g3511_i0 PRJNA1008049 3529 163 4.91791 8.0161933 Paracoccus salipaludis 2032623 Bacteria Bacteria 100 8.19e-24   NR WP_095638330.1 2032623 g3511 i0 96.2 0.975460122699387 53 2 97.5 0 4 162 230 282 WP_095638330.1 DMT family transporter [Paracoccus salipaludis] diamond 159 100 1 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Rhodobacterales Paracoccaceae Paracoccus Paracoccus salipaludis
29490043 29490043 PRJNA1008049_S_NODE_4510_length_154_cov_25.976000_g4492_i0 PRJNA1008049 4510 154 25.976 40.00304 root 1 Root_unresolved Root_unresolved 47.8 1.06e-5   NR MDB4232109.1 2024849 g4492 i0 88.9 1.05194805194805 27 3 52.6 0 154 74 22 48 MDB4232109.1 hypothetical protein [Candidatus Pelagibacter sp.] diamond 162 48.1 0.993762993762994 Bacteria   Pseudomonadati Pseudomonadota Alphaproteobacteria Candidatus Pelagibacterales Candidatus Pelagibacteraceae Candidatus Pelagibacter Candidatus Pelagibacter sp.
29781768 29781768 PRJNA1008049_S_NODE_2111_length_179_cov_6.220000_g2093_i0 PRJNA1008049 2111 179 6.22 11.1338 Lutibacter sp. 1925666 Bacteria Bacteria 70.9 4.97e-13   NR MFA5300317.1 1925666 g2093 i0 55.7 3.03351955307263 61 25 98.9 1 179 3 132 192 MFA5300317.1 hypothetical protein [Lutibacter sp.] diamond 543 70.9 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Lutibacter Lutibacter sp.
29781769 29781769 PRJNA1008049_S_NODE_3211_length_166_cov_6.167883_g3193_i0 PRJNA1008049 3211 166 6.167883 10.23868578 Flavobacterium sp. 27 239 Bacteria Bacteria 112 1.01e-29   NR WP_134145436.1 2512114 g3193 i0 98.2 0.993975903614458 55 1 99.4 0 1 165 119 173 WP_134145436.1 Crp/Fnr family transcriptional regulator [Flavobacterium sp. 270] diamond 165 112 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 270
29876656 29876656 PRJNA1008049_S_NODE_1271_length_199_cov_2.070588_g1253_i0 PRJNA1008049 1271 199 2.070588 4.12047012 Ignavibacteriota bacterium 2026749 Bacteria Bacteria 60.5 1.16e-8   NR MCP5064278.1 2026749 g1253 i0 51.9 1.5678391959799 52 25 78.4 0 156 1 320 371 MCP5064278.1 hypothetical protein [Ignavibacteriota bacterium] diamond 312 60.5 1 Bacteria FCB group Pseudomonadati Ignavibacteriota         Ignavibacteriota bacterium
30223985 30223985 PRJNA1008049_S_NODE_4572_length_154_cov_6.352000_g4554_i0 PRJNA1008049 4572 154 6.352 9.78208 Haemophilus parainfluenzae 729 Bacteria Bacteria 101 1.07e-24   NR WP_049371740.1 729 g4554 i0 100 0.993506493506494 51 0 99.4 0 154 2 146 196 WP_049371740.1 ABC transporter permease [Haemophilus parainfluenzae] diamond 153 101 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Haemophilus Haemophilus parainfluenzae
30382473 30382473 PRJNA1008049_S_NODE_3693_length_161_cov_7.810606_g3675_i0 PRJNA1008049 3693 161 7.810606 12.57507566 Flavobacterium sp. 27 239 Bacteria Bacteria 103 4.15e-27   NR TDW46491.1 2512114 g3675 i0 100 1.97515527950311 53 0 98.8 0 161 3 15 67 TDW46491.1 four helix bundle protein [Flavobacterium sp. 270] diamond 318 103 1 Bacteria FCB group Pseudomonadati Bacteroidota Flavobacteriia Flavobacteriales Flavobacteriaceae Flavobacterium Flavobacterium sp. 270
30658930 30658930 PRJNA1008049_S_NODE_4693_length_153_cov_8.080645_g4675_i0 PRJNA1008049 4693 153 8.080645 12.36338685 Escherichia 561 Bacteria Bacteria 71.6 6.88e-13   NR WP_072662973.1 543 g4675 i0 56.3 5.43137254901961 48 20 94.1 1 8 151 699 745 WP_072662973.1 MULTISPECIES: BREX-1 system adenine-specific DNA-methyltransferase PglX [Enterobacteriaceae] diamond 831 71.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae    
30690466 30690466 PRJNA1008049_S_NODE_953_length_211_cov_41.434066_g935_i0 PRJNA1008049 953 211 41.434066 87.42587926 Bacteria 2 Bacteria Bacteria 51.2 1.95e-5   NR GAA9247141.1 210 g935 i0 100 0.597156398104265 21 0 29.9 0 176 114 1 21 GAA9247141.1 hypothetical protein Kyoto199A_1050 [Helicobacter pylori] diamond 126 51.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31101119 31101119 PRJNA1008049_S_NODE_3095_length_167_cov_15.021739_g3077_i0 PRJNA1008049 3095 167 15.021739 25.08630413 Salmonella 590 Bacteria Bacteria 85.5 1.55e-19   NR WP_007117400.1 1224 g3077 i0 79.6 1.94011976047904 54 11 97 0 166 5 78 131 WP_007117400.1 MULTISPECIES: transposase [Pseudomonadota] diamond 324 85.5 1 Bacteria   Pseudomonadati Pseudomonadota          
31139954 31139954 PRJNA1008049_S_NODE_735_length_225_cov_4.500000_g717_i0 PRJNA1008049 735 225 4.5 10.125 uncultured Campylobacter sp. 218934 Bacteria Bacteria 67.4 4.34e-12   NR WP_299224394.1 218934 g717 i0 90.2 1.06666666666667 41 1 50.7 1 27 140 1 41 WP_299224394.1 hypothetical protein [uncultured Campylobacter sp.] diamond 240 67.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
31424895 31424895 PRJNA1008049_S_NODE_3076_length_168_cov_1.769784_g3058_i0 PRJNA1008049 3076 168 1.769784 2.97323712 Pseudomonadota bacterium 1977087 Bacteria Bacteria 108 9.93e-27   NR MBS0419246.1 1977087 g3058 i0 96.4 0.982142857142857 55 2 98.2 0 3 167 233 287 MBS0419246.1 HlyD family secretion protein [Pseudomonadota bacterium] diamond 165 108 1 Bacteria   Pseudomonadati Pseudomonadota         Pseudomonadota bacterium
31456692 31456692 PRJNA1008049_S_NODE_3496_length_163_cov_18.216418_g3478_i0 PRJNA1008049 3496 163 18.216418 29.69276134 Haemophilus paraphrohaemolyticus 736 Bacteria Bacteria 94.7 5.9e-21   NR WP_318655603.1 736 g3478 i0 81.1 0.975460122699387 53 10 97.5 0 3 161 557 609 WP_318655603.1 N-6 DNA methylase [Haemophilus paraphrohaemolyticus] diamond 159 94.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Pasteurellales Pasteurellaceae Haemophilus Haemophilus paraphrohaemolyticus
31519978 31519978 PRJNA1008049_S_NODE_556_length_241_cov_6.853774_g538_i0 PRJNA1008049 556 241 6.853774 16.51759534 Acidobacteriota bacterium 1978231 Bacteria Bacteria 89 3.0600000000000003e-21   NR MDQ6785862.1 1978231 g538 i0 95.3 1.21991701244813 43 2 53.5 0 136 8 31 73 MDQ6785862.1 hypothetical protein [Acidobacteriota bacterium] diamond 294 89 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
31930954 31930954 PRJNA1008049_S_NODE_4357_length_156_cov_2.370079_g4339_i0 PRJNA1008049 4357 156 2.370079 3.69732324 Moraxella osloensis 34062 Bacteria Bacteria 94.7 4.22e-21   NR WP_180949485.1 34062 g4339 i0 100 0.942307692307692 49 0 94.2 0 149 3 333 381 WP_180949485.1 relaxase/mobilization nuclease domain-containing protein [Moraxella osloensis] diamond 147 94.7 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Moraxellales Moraxellaceae Faucicola Faucicola osloensis
32089237 32089237 PRJNA1008049_S_NODE_2378_length_177_cov_33.047297_g2360_i0 PRJNA1008049 2378 177 33.047297 58.49371569 Shigella flexneri 623 Bacteria Bacteria 51.6 5.51e-7   NR MDC9934134.1 623 g2360 i0 86.2 0.932203389830508 29 4 49.2 0 173 87 27 55 MDC9934134.1 hypothetical protein [Shigella flexneri] diamond 165 51.6 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella flexneri
32437560 32437560 PRJNA1008049_S_NODE_379_length_265_cov_7.639831_g361_i0 PRJNA1008049 379 265 7.639831 20.24555215 Neisseria dumasiana 1931275 Bacteria Bacteria 80.1 2.32e-15   NR WP_253247077.1 1931275 g361 i0 47.8 1.0188679245283 90 36 94 2 250 2 256 341 WP_253247077.1 RHS repeat-associated core domain-containing protein [Neisseria dumasiana] diamond 270 80.1 1 Bacteria   Pseudomonadati Pseudomonadota Betaproteobacteria Neisseriales Neisseriaceae Neisseria Neisseria dumasiana
32437561 32437561 PRJNA1008049_S_NODE_719_length_226_cov_10.319797_g701_i0 PRJNA1008049 719 226 10.319797 23.32274122 Shigella sonnei 624 Bacteria Bacteria 52.8 6.19e-7   NR WP_353763804.1 624 g701 i0 75.8 1.48672566371681 33 8 43.8 0 127 225 48 80 WP_353763804.1 hypothetical protein, partial [Shigella sonnei] diamond 336 52.8 1 Bacteria   Pseudomonadati Pseudomonadota Gammaproteobacteria Enterobacterales Enterobacteriaceae Shigella Shigella sonnei

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