RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where bioproject = "PRJNA1167252", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 31 ✖

tax_kingdom 1

  • Pseudomonadati · 31 ✖

bioproject 1

  • PRJNA1167252 · 31 ✖

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
9242492 9242492 PRJNA1167252_P_NODE_23908_length_251_cov_0.876404_g23635_i0 PRJNA1167252 23908 251 0.876404 2.19977404 Helicobacter cinaedi 213 Bacteria Bacteria 464 2.47e-126   NTclustered gi|2157106196|dbj|AP025196.1| 213 g23635 i0 100 9.40637450199203 251 0 100 0 1 251 806819 806569 Helicobacter cinaedi T36 DNA, complete genome blastn 2361 464 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi
13068200 13068200 PRJNA1167252_P_NODE_25151_length_249_cov_0.886364_g24878_i0 PRJNA1167252 25151 249 0.886364 2.20704636 Helicobacter cinaedi 213 Bacteria Bacteria 449 6.840000000000001e-122   NTclustered gi|2157108461|dbj|AP025204.1| 213 g24878 i0 99.197 10.855421686747 249 2 100 0 1 249 1770024 1769776 Helicobacter cinaedi 94105 DNA, complete genome blastn 2703 449 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi
13793130 13793130 PRJNA1167252_P_NODE_15631_length_310_cov_1.316456_g15358_i0 PRJNA1167252 15631 310 1.316456 4.0810136 Helicobacter 209 Bacteria Bacteria 322 2e-83   NTclustered gi|1540242994|emb|LR134509.1| 35818 g15358 i0 85.621 63.5225806451613 306 44 99 0 5 310 534873 535178 Helicobacter pullorum strain NCTC13154 genome assembly, chromosome: 1 blastn 19692 322 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pullorum
16891629 16891629 PRJNA1167252_P_NODE_23494_length_252_cov_0.871508_g23221_i0 PRJNA1167252 23494 252 0.871508 2.19620016 Helicobacter cinaedi 213 Bacteria Bacteria 438 1.5e-118   NTclustered gi|2157108461|dbj|AP025204.1| 213 g23221 i0 98.016 11.2380952380952 252 5 100 0 1 252 661434 661685 Helicobacter cinaedi 94105 DNA, complete genome blastn 2832 438 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi
18166263 18166263 PRJNA1167252_P_NODE_27355_length_245_cov_0.906977_g27082_i0 PRJNA1167252 27355 245 0.906977 2.22209365 Helicobacter 209 Bacteria Bacteria 161 5.57e-49   NR WP_115552024.1 209 g27082 i0 92.6 0.991836734693878 81 6 99.2 0 243 1 17 97 WP_115552024.1 MULTISPECIES: 50S ribosomal protein L13 [Helicobacter] diamond 243 161 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter  
20715923 20715923 PRJNA1167252_P_NODE_24637_length_250_cov_0.881356_g24364_i0 PRJNA1167252 24637 250 0.881356 2.20339 Helicobacter cinaedi 213 Bacteria Bacteria 457 4.1099999999999985e-124   NTclustered gi|2157106196|dbj|AP025196.1| 213 g24364 i0 99.6 1 250 1 100 0 1 250 345052 345301 Helicobacter cinaedi T36 DNA, complete genome blastn 250 457 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi
21991280 21991280 PRJNA1167252_P_NODE_26658_length_247_cov_0.890805_g26385_i0 PRJNA1167252 26658 247 0.890805 2.20028835 Sulfurovum sp. NBC37-1 387093 Bacteria Bacteria 224 4.469999999999999e-54   NTclustered gi|151423458|dbj|AP009179.1| 387093 g26385 i0 83.065 1.00404858299595 248 40 100 2 1 247 179312 179558 Sulfurovum sp. NBC37-1 DNA, complete genome blastn 248 224 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp. NBC37-1
23992153 23992153 PRJNA1167252_P_NODE_25719_length_248_cov_0.891429_g25446_i0 PRJNA1167252 25719 248 0.891429 2.21074392 Sulfurovum sp. 1969726 Bacteria Bacteria 122 1.88e-33   NR WP_309496389.1 1969726 g25446 i0 93.9 0.798387096774194 66 4 79.8 0 247 50 76 141 WP_309496389.1 50S ribosomal protein L11 [Sulfurovum sp.] diamond 198 122 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
27198324 27198324 PRJNA1167252_P_NODE_25102_length_249_cov_0.886364_g24829_i0 PRJNA1167252 25102 249 0.886364 2.20704636 Helicobacter rodentium 59617 Bacteria Bacteria 159 8.19e-45   NR WP_290456029.1 59617 g24829 i0 100 3.95180722891566 82 0 98.8 0 3 248 68 149 WP_290456029.1 vitamin B12 dependent-methionine synthase activation domain-containing protein, partial [Helicobacter rodentium] diamond 984 159 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter rodentium
27293354 27293354 PRJNA1167252_P_NODE_26543_length_247_cov_0.896552_g26270_i0 PRJNA1167252 26543 247 0.896552 2.21448344 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 181 2.14e-51   NR HHD83554.1 2268179 g26270 i0 100 1.97975708502024 82 0 99.6 0 246 1 361 442 HHD83554.1 glycoside hydrolase [Campylobacteraceae bacterium] diamond 489 181 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
27451569 27451569 PRJNA1167252_P_NODE_24763_length_250_cov_0.881356_g24490_i0 PRJNA1167252 24763 250 0.881356 2.20339 Campylobacteraceae bacterium 4484_4 1970775 Bacteria Bacteria 120 2.85e-30   NR OQX74040.1 1970775 g24490 i0 71.3 0.96 80 23 96 0 248 9 256 335 OQX74040.1 MAG: ribosomal protein S12 methylthiotransferase RimO [Campylobacteraceae bacterium 4484_4] diamond 240 120 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium 4484_4
27672515 27672515 PRJNA1167252_P_NODE_26544_length_247_cov_0.896552_g26271_i0 PRJNA1167252 26544 247 0.896552 2.21448344 Campylobacterota bacterium 2026809 Bacteria Bacteria 135 3.04e-39   NR MEA3419954.1 2026809 g26271 i0 88.3 1.83400809716599 77 9 93.5 0 1 231 41 117 MEA3419954.1 four helix bundle protein [Campylobacterota bacterium] diamond 453 135 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
27735821 27735821 PRJNA1167252_P_NODE_23444_length_252_cov_0.871508_g23171_i0 PRJNA1167252 23444 252 0.871508 2.19620016 Sulfurovum sp. 1969726 Bacteria Bacteria 61.2 1.17e-8   NR HEY9129661.1 1969726 g23171 i0 44.3 3.64285714285714 61 34 72.6 0 186 4 1 61 HEY9129661.1 hypothetical protein [Sulfurovum sp.] diamond 918 61.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
28228080 28228080 PRJNA1167252_P_NODE_27726_length_245_cov_0.906977_g27453_i0 PRJNA1167252 27726 245 0.906977 2.22209365 Campylobacterales 213849 Bacteria Bacteria 145 4.24e-39   NR MCW8820865.1 1969726 g27453 i0 79 4.9469387755102 81 17 99.2 0 1 243 116 196 MCW8820865.1 phosphoglucomutase (alpha-D-glucose-1,6-bisphosphate-dependent) [Sulfurovum sp.] diamond 1212 145 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
28556585 28556585 PRJNA1167252_P_NODE_18007_length_288_cov_0.786047_g17734_i0 PRJNA1167252 18007 288 0.786047 2.26381536 Campylobacterota bacterium 2026809 Bacteria Bacteria 127 1e-31   NR HHD78554.1 2026809 g17734 i0 66 1.95833333333333 94 32 97.9 0 5 286 97 190 HHD78554.1 polysaccharide biosynthesis protein [Campylobacterota bacterium] diamond 564 127 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
28745860 28745860 PRJNA1167252_P_NODE_25987_length_248_cov_0.891429_g25714_i0 PRJNA1167252 25987 248 0.891429 2.21074392 Campylobacterota bacterium 2026809 Bacteria Bacteria 152 2.03e-44   NR HFQ61202.1 2026809 g25714 i0 86.6 0.991935483870968 82 11 99.2 0 248 3 14 95 HFQ61202.1 hypothetical protein [Campylobacterota bacterium] diamond 246 152 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
29144270 29144270 PRJNA1167252_P_NODE_28149_length_244_cov_0.912281_g27876_i0 PRJNA1167252 28149 244 0.912281 2.22596564 Sulfurovum 265570 Bacteria Bacteria 128 3.4499999999999995e-32   NR WP_309494623.1 1969726 g27876 i0 90.1 2.59426229508197 71 7 87.3 0 244 32 967 1037 WP_309494623.1 efflux RND transporter permease subunit [Sulfurovum sp.] diamond 633 128 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
29743631 29743631 PRJNA1167252_P_NODE_28090_length_244_cov_0.912281_g27817_i0 PRJNA1167252 28090 244 0.912281 2.22596564 Sulfurovum 265570 Bacteria Bacteria 134 6.570000000000001e-36   NR WP_197548448.1 265570 g27817 i0 85 15.7745901639344 80 12 98.4 0 5 244 126 205 WP_197548448.1 MULTISPECIES: D-alanine--D-alanine ligase [Sulfurovum] diamond 3849 135 0.992592592592593 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum  
29977292 29977292 PRJNA1167252_P_NODE_9311_length_414_cov_0.914956_g9038_i0 PRJNA1167252 9311 414 0.914956 3.78791784 Helicobacter rodentium 59617 Bacteria Bacteria 199 1.9e-61   NR WP_289687182.1 59617 g9038 i0 95.9 0.702898550724638 97 4 70.3 0 414 124 173 269 WP_289687182.1 alginate O-acetyltransferase AlgX-related protein [Helicobacter rodentium] diamond 291 199 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter rodentium
30009105 30009105 PRJNA1167252_P_NODE_25971_length_248_cov_0.891429_g25698_i0 PRJNA1167252 25971 248 0.891429 2.21074392 Sulfurovum sp. 1969726 Bacteria Bacteria 94.4 1.0300000000000001e-22   NR HEY9129123.1 1969726 g25698 i0 58.4 3.58064516129032 77 31 91.9 1 248 21 47 123 HEY9129123.1 phosphotransferase [Sulfurovum sp.] diamond 888 94.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
30040512 30040512 PRJNA1167252_P_NODE_16091_length_306_cov_0.802575_g15818_i0 PRJNA1167252 16091 306 0.802575 2.4558795 uncultured Sulfurovum sp. 269237 Bacteria Bacteria 102 6.59e-23   NR CAA6822264.1 269237 g15818 i0 64.2 0.794117647058823 81 29 79.4 0 3 245 5798 5878 CAA6822264.1 MAG: internalin, putative [uncultured Sulfurovum sp.] diamond 243 102 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum uncultured Sulfurovum sp.
30419995 30419995 PRJNA1167252_P_NODE_26033_length_248_cov_0.880000_g25760_i0 PRJNA1167252 26033 248 0.88 2.1824 Hydrogenimonas cancrithermarum 2993563 Bacteria Bacteria 93.2 1.84e-22   NR WP_286335927.1 2993563 g25760 i0 76 0.907258064516129 75 18 90.7 0 247 23 34 108 WP_286335927.1 hypothetical protein [Hydrogenimonas cancrithermarum] diamond 225 93.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Hydrogenimonadaceae Hydrogenimonas Hydrogenimonas cancrithermarum
30925407 30925407 PRJNA1167252_P_NODE_26934_length_246_cov_0.901734_g26661_i0 PRJNA1167252 26934 246 0.901734 2.21826564 Campylobacterales bacterium 2268180 Bacteria Bacteria 121 2.51e-33   NR HHH19421.1 2268180 g26661 i0 86.8 0.829268292682927 68 9 82.9 0 246 43 60 127 HHH19421.1 thiamine phosphate synthase [Campylobacterales bacterium] diamond 204 121 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
31070936 31070936 PRJNA1167252_P_NODE_29415_length_242_cov_0.923077_g29142_i0 PRJNA1167252 29415 242 0.923077 2.23384634 Sulfurovum 265570 Bacteria Bacteria 146 8.339999999999998e-39   NR WP_295420580.1 1969726 g29142 i0 88.8 7.83471074380165 80 9 99.2 0 241 2 218 297 WP_295420580.1 endonuclease MutS2 [Sulfurovum sp.] diamond 1896 147 0.993197278911565 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
31304381 31304381 PRJNA1167252_P_NODE_29375_length_242_cov_0.923077_g29102_i0 PRJNA1167252 29375 242 0.923077 2.23384634 Aliarcobacter sp. 2321116 Bacteria Bacteria 75.9 5.98e-15   NR MFA7087037.1 2321116 g29102 i0 97.4 0.471074380165289 38 1 47.1 0 3 116 141 178 MFA7087037.1 hypothetical protein [Aliarcobacter sp.] diamond 114 75.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter sp.
31525966 31525966 PRJNA1167252_P_NODE_27216_length_246_cov_0.861272_g26943_i0 PRJNA1167252 27216 246 0.861272 2.11872912 Campylobacterota bacterium 2026809 Bacteria Bacteria 133 4.32e-34   NR MEA2091446.1 2026809 g26943 i0 76.5 4.91463414634146 81 19 98.8 0 1 243 424 504 MEA2091446.1 hypothetical protein [Campylobacterota bacterium] diamond 1209 133 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
31652169 31652169 PRJNA1167252_P_NODE_25437_length_249_cov_0.886364_g25164_i0 PRJNA1167252 25437 249 0.886364 2.20704636 Sulfurovum sp. 1969726 Bacteria Bacteria 68.9 2.31e-11   NR MBT8343643.1 1969726 g25164 i0 94.9 4.62650602409639 39 2 47 0 248 132 515 553 MBT8343643.1 efflux RND transporter permease subunit [Sulfurovum sp.] diamond 1152 68.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
32063523 32063523 PRJNA1167252_P_NODE_27158_length_246_cov_0.901734_g26885_i0 PRJNA1167252 27158 246 0.901734 2.21826564 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 114 1e-29   NR HHD77423.1 2268179 g26885 i0 100 0.707317073170732 58 0 70.7 0 71 244 1 58 HHD77423.1 tetratricopeptide repeat protein [Campylobacteraceae bacterium] diamond 174 114 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
32411773 32411773 PRJNA1167252_P_NODE_26319_length_247_cov_0.896552_g26046_i0 PRJNA1167252 26319 247 0.896552 2.21448344 Sulfurovum sp. 1969726 Bacteria Bacteria 145 2.69e-38   NR PHS34166.1 1969726 g26046 i0 88.9 2.95141700404858 81 9 98.4 0 245 3 713 793 PHS34166.1 MAG: ferredoxin [Sulfurovum sp.] diamond 729 145 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
32695693 32695693 PRJNA1167252_P_NODE_26440_length_247_cov_0.896552_g26167_i0 PRJNA1167252 26440 247 0.896552 2.21448344 Campylobacterota bacterium 2026809 Bacteria Bacteria 166 6.77e-48   NR HFU77626.1 2026809 g26167 i0 98.8 0.995951417004049 82 1 99.6 0 247 2 37 118 HFU77626.1 toxic anion resistance protein [Campylobacterota bacterium] diamond 246 166 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
32821725 32821725 PRJNA1167252_P_NODE_29280_length_242_cov_0.923077_g29007_i0 PRJNA1167252 29280 242 0.923077 2.23384634 Sulfurovum sp. 1969726 Bacteria Bacteria 127 6.14e-32   NR HIQ47699.1 1969726 g29007 i0 72.5 3.94214876033058 80 22 99.2 0 240 1 227 306 HIQ47699.1 DUF2309 domain-containing protein [Sulfurovum sp.] diamond 954 127 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.

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