RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJEB29441", 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 · 15 ✖

tax_kingdom 1

  • Pseudomonadati · 15 ✖

bioproject 1

  • PRJEB29441 · 15 ✖

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
3538893 3538893 PRJEB29441_P_NODE_3523_length_654_cov_7.927273_g3135_i0 PRJEB29441 3523 654 7.927273 51.84436542 Helicobacter 209 Bacteria Bacteria 1186 0   NTclustered gi|2157108461|dbj|AP025204.1| 213 g3135 i0 99.691 150.964831804281 648 2 99 0 1 648 128110 127463 Helicobacter cinaedi 94105 DNA, complete genome blastn 98731 1186 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi
3538954 3538954 PRJEB29441_P_NODE_43803_length_163_cov_1.561404_g43362_i0 PRJEB29441 43803 163 1.561404 2.54508852 Campylobacter 194 Bacteria Bacteria 296 5.68e-76   NTclustered gi|76781202|gb|DQ174170.1| 203 g43362 i0 99.39 110.674846625767 164 0 100 1 1 163 1448 1285 Campylobacter rectus strain CCUG 11640 16S ribosomal RNA (rrs) gene, partial sequence blastn 18040 296 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter rectus
6405031 6405031 PRJEB29441_P_NODE_48286_length_155_cov_3.613208_g47845_i0 PRJEB29441 48286 155 3.613208 5.6004724 Campylobacter concisus 199 Bacteria Bacteria 287 3.21e-73   NTclustered gi|1935888393|gb|CP049239.1| 199 g47845 i0 100 198.522580645161 155 0 100 0 1 155 1034238 1034392 Campylobacter concisus strain P3UCO1 chromosome, complete genome blastn 30771 287 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
8641527 8641527 PRJEB29441_P_NODE_37667_length_169_cov_4.633333_g37226_i0 PRJEB29441 37667 169 4.633333 7.83033277 Helicobacteraceae 72293 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|2157108461|dbj|AP025204.1| 213 g37226 i0 100 113.994082840237 169 0 100 0 1 169 124572 124404 Helicobacter cinaedi 94105 DNA, complete genome blastn 19265 313 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi
9916523 9916523 PRJEB29441_P_NODE_39768_length_166_cov_2.119658_g39327_i0 PRJEB29441 39768 166 2.119658 3.51863228 Campylobacter 194 Bacteria Bacteria 307 2.69e-79   NTclustered gi|1207769205|gb|MF351718.1| 199 g39327 i0 100 243.83734939759 166 0 100 0 1 166 332 167 Campylobacter concisus strain H11O-S1 23S ribosomal RNA gene, partial sequence blastn 40477 307 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
15328880 15328880 PRJEB29441_P_NODE_44213_length_163_cov_0.894737_g43772_i0 PRJEB29441 44213 163 0.894737 1.45842131 Campylobacter ureolyticus 827 Bacteria Bacteria 302 1.22e-77   NTclustered gi|909715533|gb|CP012195.1| 1032069 g43772 i0 100 1 163 0 100 0 1 163 916529 916691 Campylobacter ureolyticus RIGS 9880 chromosome, complete genome blastn 163 302 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
17566201 17566201 PRJEB29441_P_NODE_39774_length_166_cov_1.991453_g39333_i0 PRJEB29441 39774 166 1.991453 3.30581198 Campylobacter 194 Bacteria Bacteria 300 4.5e-77   NTclustered gi|1483583505|emb|LT631429.1| 204 g39333 i0 99.394 239.457831325301 165 1 99 0 2 166 29365 29529 Campylobacter showae genome assembly, plasmid: V blastn 39750 300 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
18839984 18839984 PRJEB29441_P_NODE_32955_length_182_cov_1.624060_g32514_i0 PRJEB29441 32955 182 1.62406 2.9557892 root 1 Root_unresolved Root_unresolved 337 3.82e-88   NTclustered gi|285196821|gb|GU427148.1| 204 g32514 i0 100 104 182 0 100 0 1 182 113 294 Campylobacter showae clone ATC_T20_13 16S ribosomal RNA gene, partial sequence blastn 18928 337 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
18840087 18840087 PRJEB29441_P_NODE_6395_length_466_cov_8.609113_g5957_i0 PRJEB29441 6395 466 8.609113 40.11846658 Helicobacter 209 Bacteria Bacteria 850 0   NTclustered gi|2157106196|dbj|AP025196.1| 213 g5957 i0 99.571 136.289699570815 466 2 100 0 1 466 135571 135106 Helicobacter cinaedi T36 DNA, complete genome blastn 63511 850 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cinaedi
20427027 20427027 PRJEB29441_P_NODE_17517_length_257_cov_1.913462_g17076_i0 PRJEB29441 17517 257 1.913462 4.91759734 Campylobacter helveticus 28898 Bacteria Bacteria 475 1.1699999999999999e-129   NTclustered gi|1590155399|gb|CP037747.1| 28898 g17076 i0 100 268.307392996109 257 0 100 0 1 257 535063 534807 Campylobacter helveticus strain 2013D-9613 chromosome, complete genome blastn 68955 475 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter helveticus
21390448 21390448 PRJEB29441_P_NODE_33677_length_180_cov_1.725191_g33236_i0 PRJEB29441 33677 180 1.725191 3.1053438 Arcobacteraceae 2808963 Bacteria Bacteria 327 2.2699999999999996e-85   NTclustered gi|1474790806|gb|CP032100.1| 663365 g33236 i0 99.444 385 180 1 100 0 1 180 1733699 1733878 Arcobacter suis CECT 7833 chromosome, complete genome blastn 69300 327 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter suis
21703584 21703584 PRJEB29441_P_NODE_5378_length_513_cov_11.226293_g4949_i0 PRJEB29441 5378 513 11.226293 57.59088309 uncultured Campylobacterota bacterium 120858 Bacteria Bacteria 560 6.75e-155   NTclustered gi|17530431|gb|AF445743.1| 120858 g4949 i0 92.405 66.5964912280702 395 27 77 3 1 393 2 395 Uncultured Campylobacterota bacterium clone SM2H05 16S ribosomal RNA gene, partial sequence blastn 34164 560 1 Bacteria   Pseudomonadati Campylobacterota         uncultured Campylobacterota bacterium
27854519 27854519 PRJEB29441_P_NODE_37605_length_170_cov_1.256198_g37164_i0 PRJEB29441 37605 170 1.256198 2.1355366 Helicobacter pylori 210 Bacteria Bacteria 53.9 8.82e-8   NR GAA6966648.1 210 g37164 i0 61 1.53529411764706 41 16 72.4 0 125 3 1 41 GAA6966648.1 hypothetical protein Kyoto211A_2720 [Helicobacter pylori] diamond 261 53.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31069598 31069598 PRJEB29441_P_NODE_20335_length_236_cov_1.192513_g19894_i0 PRJEB29441 20335 236 1.192513 2.81433068 Pseudomonadati 3379134 Bacteria Bacteria 61.6 8.33e-11   NR GAA9037979.1 210 g19894 i0 74.3 1.27118644067797 35 9 44.5 0 37 141 3 37 GAA9037979.1 hypothetical protein Kyoto184A_00910 [Helicobacter pylori] diamond 300 61.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31423674 31423674 PRJEB29441_P_NODE_44696_length_163_cov_0.894737_g44255_i0 PRJEB29441 44696 163 0.894737 1.45842131 Poseidonibacter antarcticus 2478538 Bacteria Bacteria 51.6 6.68e-6   NR WP_162984614.1 2478538 g44255 i0 45.3 0.975460122699387 53 29 97.5 0 2 160 78 130 WP_162984614.1 GAG-pre-integrase domain-containing protein, partial [Poseidonibacter antarcticus] diamond 159 51.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Poseidonibacter Poseidonibacter antarcticus

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