RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA600413", 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

  • PRJNA600413 · 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
1848766 1848766 PRJNA600413_P_NODE_119722_length_165_cov_0.879310_g119021_i0 PRJNA600413 119722 165 0.87931 1.4508615 Wolinella succinogenes 844 Bacteria Bacteria 296 5.77e-76   NTclustered gi|34483865|emb|BX571662.1| 844 g119021 i0 99.387 1.97575757575758 163 1 99 0 3 165 314757 314919 Wolinella succinogenes, complete genome; segment 6/7 blastn 326 296 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Wolinella Wolinella succinogenes
3123973 3123973 PRJNA600413_P_NODE_116003_length_165_cov_1.517241_g115302_i0 PRJNA600413 116003 165 1.517241 2.50344765 Campylobacter concisus 199 Bacteria Bacteria 176 7.85e-40   NTclustered gi|2700477995|gb|CP147775.1| 199 g115302 i0 87.5 3.75757575757576 152 19 92 0 3 154 1682126 1682277 Campylobacter concisus strain RMIT-O23 chromosome blastn 620 176 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
10779244 10779244 PRJNA600413_P_NODE_73149_length_184_cov_1.511111_g72448_i0 PRJNA600413 73149 184 1.511111 2.78044424 Campylobacter showae 204 Bacteria Bacteria 292 8.490000000000001e-75   NTclustered gi|1483583529|emb|LT631453.1| 204 g72448 i0 95.161 4.05434782608696 186 7 100 2 1 184 767020 766835 Campylobacter showae strain B91_SCBr genome assembly, chromosome: I blastn 746 292 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae
17152920 17152920 PRJNA600413_P_NODE_89074_length_174_cov_1.632000_g88373_i0 PRJNA600413 89074 174 1.632 2.83968 Campylobacter gracilis 824 Bacteria Bacteria 255 1.04e-63   NTclustered gi|909717139|gb|CP012196.1| 824 g88373 i0 93.143 2.01149425287356 175 10 99 2 2 174 2193387 2193213 Campylobacter gracilis strain ATCC 33236, complete genome blastn 350 255 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter gracilis
19701751 19701751 PRJNA600413_P_NODE_84236_length_177_cov_1.593750_g83535_i0 PRJNA600413 84236 177 1.59375 2.8209375 Helicobacter pylori 210 Bacteria Bacteria 118 6.479999999999999e-32   NR GAA8852711.1 210 g83535 i0 100 0.983050847457627 58 0 98.3 0 175 2 44 101 GAA8852711.1 hypothetical protein DUHN55_41910 [Helicobacter pylori] diamond 174 118 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
20269223 20269223 PRJNA600413_P_NODE_96976_length_169_cov_6.258333_g96275_i0 PRJNA600413 96976 169 6.258333 10.57658277 Campylobacterales 213849 Bacteria Bacteria 313 5.859999999999999e-81   NTclustered gi|385731235|gb|JQ743035.1| 196 g96275 i0 100 130 169 0 100 0 1 169 306 474 Campylobacter fetus strain campy-a11 16S ribosomal RNA gene, partial sequence blastn 21970 313 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter fetus
27459308 27459308 PRJNA600413_P_NODE_92483_length_172_cov_1.658537_g91782_i0 PRJNA600413 92483 172 1.658537 2.85268364 Helicobacter pylori 210 Bacteria Bacteria 114 4.6899999999999994e-30   NR GAA8852816.1 210 g91782 i0 96.5 0.994186046511628 57 2 99.4 0 172 2 18 74 GAA8852816.1 HAD-IA family hydrolase [Helicobacter pylori] diamond 171 114 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27459311 27459311 PRJNA600413_P_NODE_96823_length_170_cov_1.157025_g96122_i0 PRJNA600413 96823 170 1.157025 1.9669425 Helicobacter pylori 210 Bacteria Bacteria 55.5 3.73e-8   NR GAA6912895.1 210 g96122 i0 79.1 1.62352941176471 43 9 75.9 0 146 18 7 49 GAA6912895.1 hypothetical protein Kyoto207A_3080 [Helicobacter pylori] diamond 276 55.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28785083 28785083 PRJNA600413_P_NODE_90287_length_173_cov_2.072581_g89586_i0 PRJNA600413 90287 173 2.072581 3.58556513 Sulfurimonas crateris 2574727 Bacteria Bacteria 65.5 1.37e-10   NR WP_137012573.1 2574727 g89586 i0 91.9 0.641618497109827 37 3 64.2 0 115 5 1 37 WP_137012573.1 leucyl aminopeptidase [Sulfurimonas crateris] diamond 111 65.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas crateris
29164364 29164364 PRJNA600413_P_NODE_35009_length_242_cov_1.056995_g34308_i0 PRJNA600413 35009 242 1.056995 2.5579279 Arcobacter sp. 1872629 Bacteria Bacteria 61.6 8.21e-9   NR HIP13207.1 1872629 g34308 i0 55.8 0.644628099173554 52 23 64.5 0 3 158 873 924 HIP13207.1 hypothetical protein [Arcobacter sp.] diamond 156 61.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter sp.
29953572 29953572 PRJNA600413_P_NODE_115651_length_165_cov_1.758621_g114950_i0 PRJNA600413 115651 165 1.758621 2.90172465 Desulfurellales bacterium 2482794 Bacteria Bacteria 79.3 1.67e-15   NR TXH57003.1 2482794 g114950 i0 80 0.818181818181818 45 9 81.8 0 165 31 446 490 TXH57003.1 MAG: hypothetical protein E6Q97_05300 [Desulfurellales bacterium] diamond 135 79.3 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
30079750 30079750 PRJNA600413_P_NODE_52632_length_205_cov_1.115385_g51931_i0 PRJNA600413 52632 205 1.115385 2.28653925 Helicobacter pylori 210 Bacteria Bacteria 61.2 1.2e-10   NR GAA6859275.1 210 g51931 i0 50 0.790243902439024 54 27 79 0 164 3 6 59 GAA6859275.1 hypothetical protein Kyoto206A_0900 [Helicobacter pylori] diamond 162 61.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30680016 30680016 PRJNA600413_P_NODE_24793_length_285_cov_2.474576_g24092_i0 PRJNA600413 24793 285 2.474576 7.0525416 Helicobacter pylori 210 Bacteria Bacteria 107 3.23e-28   NR GAA9165282.1 210 g24092 i0 96.1 1.24210526315789 51 2 53.7 0 1 153 2 52 GAA9165282.1 hypothetical protein Kyoto190A_5390 [Helicobacter pylori] diamond 354 107 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30711791 30711791 PRJNA600413_P_NODE_69234_length_187_cov_1.195652_g68533_i0 PRJNA600413 69234 187 1.195652 2.23586924 Helicobacter pylori 210 Bacteria Bacteria 57.4 2.3e-9   NR GAA8692375.1 210 g68533 i0 60 0.641711229946524 40 16 64.2 0 3 122 2 41 GAA8692375.1 hypothetical protein Kyoto145A_2350 [Helicobacter pylori] diamond 120 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30869754 30869754 PRJNA600413_P_NODE_134034_length_163_cov_0.894737_g133333_i0 PRJNA600413 134034 163 0.894737 1.45842131 Sulfurimonas crateris 2574727 Bacteria Bacteria 100 4.2299999999999997e-23   NR WP_223175817.1 2574727 g133333 i0 94.4 0.993865030674847 54 3 99.4 0 1 162 289 342 WP_223175817.1 heavy metal translocating P-type ATPase [Sulfurimonas crateris] diamond 162 100 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas crateris
31059680 31059680 PRJNA600413_P_NODE_132335_length_163_cov_0.894737_g131634_i0 PRJNA600413 132335 163 0.894737 1.45842131 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 72 5.77e-13   NR NVJ52270.1 2268179 g131634 i0 71.2 1.91411042944785 52 14 95.7 1 7 162 292 342 NVJ52270.1 hypothetical protein [Campylobacteraceae bacterium] diamond 312 72 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
31248946 31248946 PRJNA600413_P_NODE_78055_length_181_cov_1.477273_g77354_i0 PRJNA600413 78055 181 1.477273 2.67386413 Helicobacter pylori 210 Bacteria Bacteria 56.6 4.04e-9   NR GAA6916578.1 210 g77354 i0 66.7 0.646408839779006 39 13 64.6 0 8 124 1 39 GAA6916578.1 hypothetical protein Kyoto207A_3550 [Helicobacter pylori] diamond 117 56.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31565500 31565500 PRJNA600413_P_NODE_100336_length_168_cov_1.336134_g99635_i0 PRJNA600413 100336 168 1.336134 2.24470512 Helicobacter pylori 210 Bacteria Bacteria 54.7 4.96e-8   NR GAA8948737.1 210 g99635 i0 75 0.642857142857143 36 7 64.3 1 118 11 1 34 GAA8948737.1 hypothetical protein Kyoto181A_0640 [Helicobacter pylori] diamond 108 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32039849 32039849 PRJNA600413_P_NODE_74478_length_183_cov_1.716418_g73777_i0 PRJNA600413 74478 183 1.716418 3.14104494 Helicobacter pylori 210 Bacteria Bacteria 59.3 8.63e-10   NR GAA6953508.1 210 g73777 i0 100 0.426229508196721 26 0 42.6 0 177 100 1 26 GAA6953508.1 hypothetical protein Kyoto211A_0720 [Helicobacter pylori] diamond 78 59.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32071407 32071407 PRJNA600413_P_NODE_121498_length_165_cov_0.879310_g120797_i0 PRJNA600413 121498 165 0.87931 1.4508615 Campylobacter showae 204 Bacteria Bacteria 99 1.95e-22   NR WP_002952489.1 204 g120797 i0 96.3 0.981818181818182 54 2 98.2 0 163 2 310 363 WP_002952489.1 site-specific integrase [Campylobacter showae] diamond 162 99 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter showae

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