RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where bioproject = "PRJNA804229" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA804229 · 14 ✖

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
3773853 3773853 PRJNA804229_S_NODE_55283_length_270_cov_1.960352_g54325_i0 PRJNA804229 55283 270 1.960352 5.2929504 Campylobacter 194 Bacteria Bacteria 499 7.349999999999998e-137   NTclustered gi|1483583505|emb|LT631429.1| 204 g54325 i0 100 241.159259259259 270 0 100 0 1 270 30942 31211 Campylobacter showae genome assembly, plasmid: V blastn 65113 499 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
5050133 5050133 PRJNA804229_S_NODE_180624_length_152_cov_1.321101_g179666_i0 PRJNA804229 180624 152 1.321101 2.00807352 root 1 Root_unresolved Root_unresolved 281 1.46e-71   NTclustered gi|1483583505|emb|LT631429.1| 204 g179666 i0 100 110 152 0 100 0 1 152 33176 33327 Campylobacter showae genome assembly, plasmid: V blastn 16720 281 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
11009139 11009139 PRJNA804229_S_NODE_84529_length_221_cov_2.426966_g83571_i0 PRJNA804229 84529 221 2.426966 5.36359486 Campylobacter coli 195 Bacteria Bacteria 75.9 3.33e-16   NR RJF75347.1 195 g83571 i0 66.7 0.773755656108597 57 19 77.4 0 174 4 12 68 RJF75347.1 hypothetical protein D4Z77_08730, partial [Campylobacter coli] diamond 171 75.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
17799633 17799633 PRJNA804229_S_NODE_26794_length_360_cov_2.725552_g25836_i0 PRJNA804229 26794 360 2.725552 9.8119872 Campylobacter 194 Bacteria Bacteria 660 0   NTclustered gi|1483583505|emb|LT631429.1| 204 g25836 i0 99.722 274.622222222222 360 1 100 0 1 360 29298 29657 Campylobacter showae genome assembly, plasmid: V blastn 98864 660 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
23756737 23756737 PRJNA804229_S_NODE_40559_length_308_cov_2.758491_g39601_i0 PRJNA804229 40559 308 2.758491 8.49615228 Campylobacter ureolyticus 827 Bacteria Bacteria 569 6.419999999999998e-158   NTclustered gi|1829985141|gb|CP050963.1| 827 g39601 i0 100 248.383116883117 308 0 100 0 1 308 203571 203264 Campylobacter ureolyticus strain FDAARGOS_673 chromosome blastn 76502 569 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
27401950 27401950 PRJNA804229_S_NODE_14083_length_445_cov_3.228856_g13136_i0 PRJNA804229 14083 445 3.228856 14.3684092 Helicobacter pylori 210 Bacteria Bacteria 206 5.59e-66   NR WP_322538256.1 210 g13136 i0 96.3 0.721348314606742 107 4 72.1 0 404 84 1 107 WP_322538256.1 hypothetical protein, partial [Helicobacter pylori] diamond 321 206 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27559524 27559524 PRJNA804229_S_NODE_176484_length_153_cov_1.309091_g175526_i0 PRJNA804229 176484 153 1.309091 2.00290923 Helicobacter pylori 210 Bacteria Bacteria 55.8 1.31e-8   NR GAA6863873.1 210 g175526 i0 65.6 0.627450980392157 32 11 62.7 0 4 99 38 69 GAA6863873.1 hypothetical protein Kyoto206A_2050 [Helicobacter pylori] diamond 96 55.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28231351 28231351 PRJNA804229_S_NODE_117646_length_188_cov_1.324138_g116688_i0 PRJNA804229 117646 188 1.324138 2.48937944 Bacteria 2 Bacteria Bacteria 52.4 1.08e-6   NR WP_322538264.1 210 g116688 i0 49.2 1.88297872340426 59 30 94.1 0 2 178 56 114 WP_322538264.1 hypothetical protein, partial [Helicobacter pylori] diamond 354 52.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28673708 28673708 PRJNA804229_S_NODE_105907_length_198_cov_1.329032_g104949_i0 PRJNA804229 105907 198 1.329032 2.63148336 root 1 Root_unresolved Root_unresolved 51.2 1.62e-5   NR GAA8734012.1 210 g104949 i0 54.8 10.3333333333333 42 19 63.6 0 153 28 170 211 GAA8734012.1 hypothetical protein Kyoto147A_1470 [Helicobacter pylori] diamond 2046 51.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29233258 29233258 PRJNA804229_S_NODE_94789_length_209_cov_1.445783_g93831_i0 PRJNA804229 94789 209 1.445783 3.02168647 Helicobacter pylori 210 Bacteria Bacteria 45.1 2.21e-4   NR GAA8956022.1 210 g93831 i0 67.9 0.401913875598086 28 9 40.2 0 162 79 14 41 GAA8956022.1 hypothetical protein Kyoto181A_3010 [Helicobacter pylori] diamond 84 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29873520 29873520 PRJNA804229_S_NODE_110691_length_194_cov_0.953642_g109733_i0 PRJNA804229 110691 194 0.953642 1.85006548 root 1 Root_unresolved Root_unresolved 44.3 0.00508   NR GAA8854026.1 210 g109733 i0 52.4 3.91237113402062 42 20 64.9 0 172 47 108 149 GAA8854026.1 hypothetical protein Kyoto154A_0970 [Helicobacter pylori] diamond 759 44.7 0.991051454138702 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30970562 30970562 PRJNA804229_S_NODE_172754_length_155_cov_1.285714_g171796_i0 PRJNA804229 172754 155 1.285714 1.9928567 Campylobacter coli 195 Bacteria Bacteria 43.1 0.00118   NR RJF75347.1 195 g171796 i0 60.5 0.735483870967742 38 15 73.5 0 154 41 18 55 RJF75347.1 hypothetical protein D4Z77_08730, partial [Campylobacter coli] diamond 114 43.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
31982246 31982246 PRJNA804229_S_NODE_158358_length_162_cov_1.210084_g157400_i0 PRJNA804229 158358 162 1.210084 1.96033608 Helicobacter pylori 210 Bacteria Bacteria 52 1.72e-6   NR GAA8857246.1 210 g157400 i0 58.8 5.66666666666667 34 14 63 0 59 160 42 75 GAA8857246.1 hypothetical protein Kyoto154A_2180 [Helicobacter pylori] diamond 918 52 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32520529 32520529 PRJNA804229_S_NODE_133859_length_176_cov_2.082707_g132901_i0 PRJNA804229 133859 176 2.082707 3.66556432 Helicobacter pylori 210 Bacteria Bacteria 42 0.00295   NR GAA8966937.1 210 g132901 i0 75 0.409090909090909 24 6 40.9 0 10 81 5 28 GAA8966937.1 hypothetical protein Kyoto181A_4130 [Helicobacter pylori] diamond 72 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori

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