RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 20 ✖

bioproject 1

  • PRJNA670521 · 20 ✖

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
19016577 19016577 PRJNA670521_P_NODE_18115_length_439_cov_1.672131_g17373_i0 PRJNA670521 18115 439 1.672131 7.34065509 Campylobacter 194 Bacteria Bacteria 52.8 0.042   NTclustered gi|2323232558|gb|CP109813.1| 195 g17373 i0 100 6.37813211845102 28 0 6 0 349 376 1354708 1354681 Campylobacter coli strain CC20JX12 chromosome, complete genome blastn 2800 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
26765197 26765197 PRJNA670521_P_NODE_43021_length_314_cov_1.680498_g42276_i0 PRJNA670521 43021 314 1.680498 5.27676372 Helicobacter pylori 210 Bacteria Bacteria 49.3 2.25e-5   NR GAA8732296.1 210 g42276 i0 80 0.238853503184713 25 5 23.9 0 74 148 13 37 GAA8732296.1 hypothetical protein Kyoto147A_0500 [Helicobacter pylori] diamond 75 49.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27113159 27113159 PRJNA670521_P_NODE_83682_length_245_cov_0.895349_g82937_i0 PRJNA670521 83682 245 0.895349 2.19360505 Helicobacter pylori 210 Bacteria Bacteria 42.4 0.00485   NR GAA9114287.1 210 g82937 i0 40.4 0.636734693877551 52 31 63.7 0 173 18 1 52 GAA9114287.1 hypothetical protein Kyoto184A_10050 [Helicobacter pylori] diamond 156 42.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27144478 27144478 PRJNA670521_P_NODE_15402_length_469_cov_2.515152_g14660_i0 PRJNA670521 15402 469 2.515152 11.79606288 Helicobacter pylori 210 Bacteria Bacteria 55.5 1.36e-6   NR GAA6899797.1 210 g14660 i0 40.7 0.518123667377399 81 47 51.2 1 25 264 1 81 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 243 55.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27397943 27397943 PRJNA670521_P_NODE_77203_length_248_cov_0.880000_g76458_i0 PRJNA670521 77203 248 0.88 2.1824 Helicobacter pylori 210 Bacteria Bacteria 70.1 5.2e-14   NR GAA6836004.1 210 g76458 i0 72.3 0.568548387096774 47 13 56.9 0 68 208 1 47 GAA6836004.1 hypothetical protein Kyoto200A_4630 [Helicobacter pylori] diamond 141 70.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28155744 28155744 PRJNA670521_P_NODE_89065_length_243_cov_0.905882_g88320_i0 PRJNA670521 89065 243 0.905882 2.20129326 Campylobacterales bacterium 2268180 Bacteria Bacteria 49.3 1.77e-4   NR MBN2782706.1 2268180 g88320 i0 43.8 0.592592592592593 48 27 59.3 0 148 5 5 52 MBN2782706.1 DEAD/DEAH box helicase [Campylobacterales bacterium] diamond 144 49.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales     Campylobacterales bacterium
29071413 29071413 PRJNA670521_P_NODE_92688_length_241_cov_0.916667_g91943_i0 PRJNA670521 92688 241 0.916667 2.20916747 Campylobacter devanensis 3161138 Bacteria Bacteria 42.7 0.0356   NR WP_086289084.1 3161138 g91943 i0 64 0.311203319502075 25 9 31.1 0 236 162 501 525 WP_086289084.1 BspA family leucine-rich repeat surface protein [Campylobacter devanensis] diamond 75 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter devanensis
29292173 29292173 PRJNA670521_P_NODE_51289_length_293_cov_0.795455_g50544_i0 PRJNA670521 51289 293 0.795455 2.33068315 Helicobacter pylori 210 Bacteria Bacteria 47.8 1.04e-4   NR GAB0054173.1 210 g50544 i0 76.9 0.532423208191126 26 6 26.6 0 215 292 1 26 GAB0054173.1 hypothetical protein YGH029_14970 [Helicobacter pylori] diamond 156 47.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29387047 29387047 PRJNA670521_P_NODE_14869_length_477_cov_1.066832_g14127_i0 PRJNA670521 14869 477 1.066832 5.08878864 Helicobacter pylori 210 Bacteria Bacteria 60.1 2.52e-8   NR GAA6899797.1 210 g14127 i0 51.6 0.40251572327044 64 31 40.3 0 459 268 54 117 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 192 60.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29828938 29828938 PRJNA670521_P_NODE_88611_length_243_cov_0.905882_g87866_i0 PRJNA670521 88611 243 0.905882 2.20129326 Helicobacter pylori 210 Bacteria Bacteria 57.8 2.98e-9   NR GAA8757316.1 210 g87866 i0 70.6 0.938271604938272 34 10 42 0 103 2 1 34 GAA8757316.1 hypothetical protein Kyoto147A_3750 [Helicobacter pylori] diamond 228 57.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30113206 30113206 PRJNA670521_P_NODE_81492_length_246_cov_0.890173_g80747_i0 PRJNA670521 81492 246 0.890173 2.18982558 Helicobacter pylori 210 Bacteria Bacteria 59.7 2.67e-9   NR GAA8854448.1 210 g80747 i0 58 1.81707317073171 50 20 59.8 1 1 147 43 92 GAA8854448.1 hypothetical protein Kyoto154A_1400 [Helicobacter pylori] diamond 447 59.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30156596 30156596 PRJNA670521_P_NODE_84032_length_245_cov_0.895349_g83287_i0 PRJNA670521 84032 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 43.9 0.00313   NR GAA9038383.1 210 g83287 i0 36.7 3.24489795918367 60 38 73.5 0 21 200 28 87 GAA9038383.1 hypothetical protein Kyoto184A_01150 [Helicobacter pylori] diamond 795 44.3 0.99097065462754 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30176409 30176409 PRJNA670521_P_NODE_91232_length_242_cov_0.869822_g90487_i0 PRJNA670521 91232 242 0.869822 2.10496924 Helicobacter pylori 210 Bacteria Bacteria 67.4 3.08e-12   NR GAA6899797.1 210 g90487 i0 46.7 0.929752066115702 75 40 93 0 239 15 27 101 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 225 67.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30366473 30366473 PRJNA670521_P_NODE_76732_length_248_cov_0.880000_g75987_i0 PRJNA670521 76732 248 0.88 2.1824 Campylobacterota bacterium 2026809 Bacteria Bacteria 96.7 6.44e-22   NR MCL4431196.1 2026809 g75987 i0 60.6 0.858870967741935 71 28 85.9 0 214 2 1 71 MCL4431196.1 hypothetical protein [Campylobacterota bacterium] diamond 213 96.7 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
30650195 30650195 PRJNA670521_P_NODE_47713_length_302_cov_0.847162_g46968_i0 PRJNA670521 47713 302 0.847162 2.55842924 Helicobacter pylori 210 Bacteria Bacteria 56.2 1.43e-7   NR GAA6899797.1 210 g46968 i0 52.9 0.506622516556291 51 24 50.7 0 286 134 27 77 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 153 56.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30681784 30681784 PRJNA670521_P_NODE_70433_length_251_cov_0.865169_g69688_i0 PRJNA670521 70433 251 0.865169 2.17157419 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.0195   NR GAA8884369.1 210 g69688 i0 47.5 0.47808764940239 40 19 45.4 1 55 168 11 50 GAA8884369.1 hypothetical protein Kyoto154A_4810 [Helicobacter pylori] diamond 120 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30757195 30757195 PRJNA670521_P_NODE_83554_length_245_cov_0.895349_g82809_i0 PRJNA670521 83554 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 60.5 1.44e-9   NR MDU9757963.1 210 g82809 i0 50.8 7.46938775510204 61 30 74.7 0 226 44 2 62 MDU9757963.1 endonuclease [Helicobacter pylori] diamond 1830 60.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31883253 31883253 PRJNA670521_P_NODE_20917_length_413_cov_3.047059_g20174_i0 PRJNA670521 20917 413 3.047059 12.58435367 Helicobacter pylori 210 Bacteria Bacteria 78.6 9.54e-16   NR GAA6899797.1 210 g20174 i0 64.1 0.464891041162228 64 23 46.5 0 408 217 54 117 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 192 78.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32168372 32168372 PRJNA670521_P_NODE_70898_length_251_cov_0.865169_g70153_i0 PRJNA670521 70898 251 0.865169 2.17157419 Helicobacter pylori 210 Bacteria Bacteria 42 0.0467   NR GAA6899338.1 210 g70153 i0 44.1 1.62549800796813 68 37 81.3 1 217 14 93 159 GAA6899338.1 hypothetical protein Kyoto207A_1020 [Helicobacter pylori] diamond 408 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32705243 32705243 PRJNA670521_P_NODE_90360_length_242_cov_0.911243_g89615_i0 PRJNA670521 90360 242 0.911243 2.20520806 Helicobacter pylori 210 Bacteria Bacteria 45.4 3.68e-4   NR GAA9074958.1 210 g89615 i0 50 0.520661157024793 42 21 52.1 0 159 34 23 64 GAA9074958.1 hypothetical protein Kyoto184A_06860 [Helicobacter pylori] diamond 126 45.4 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);;