RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA643700", tax_phylum = "Campylobacterota" and tax_superkingdom = "Bacteria"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Bacteria · 20 ✖

tax_phylum 1

  • Campylobacterota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJNA643700 · 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
3168967 3168967 PRJNA643700_P_NODE_299543_length_210_cov_1.291925_g297987_i0 PRJNA643700 299543 210 1.291925 2.7130425 Arcobacter venerupis 1054033 Bacteria Bacteria 52.8 0.018   NTclustered gi|1847324382|gb|CP053840.1| 1054033 g297987 i0 100 0.133333333333333 28 0 13 0 88 115 2761702 2761729 Arcobacter venerupis strain LMG 26156 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter venerupis
5721561 5721561 PRJNA643700_P_NODE_106945_length_402_cov_4.804533_g105391_i0 PRJNA643700 106945 402 4.804533 19.31422266 Arcobacter iocasae 2906515 Bacteria Bacteria 58.4 8.28e-4   NTclustered gi|2809047151|gb|CP090177.1| 2906515 g105391 i0 100 0.0771144278606965 31 0 8 0 363 393 686366 686336 Arcobacter sp. KX21116 chromosome, complete genome blastn 31 58.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter iocasae
5721595 5721595 PRJNA643700_P_NODE_153465_length_328_cov_2.354839_g151910_i0 PRJNA643700 153465 328 2.354839 7.72387192 Aliarcobacter butzleri 28197 Bacteria Bacteria 52.8 0.031   NTclustered gi|526271239|gb|CP006615.1| 1036172 g151910 i0 100 0.341463414634146 28 0 9 0 179 206 114736 114763 Arcobacter butzleri 7h1h, complete genome blastn 112 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri
8271463 8271463 PRJNA643700_P_NODE_332767_length_193_cov_2.027778_g331211_i0 PRJNA643700 332767 193 2.027778 3.9136115400000002 Helicobacter pylori 210 Bacteria Bacteria 52.8 0.017   NTclustered gi|2642300512|gb|CP078412.1| 210 g331211 i0 100 0.290155440414508 28 0 15 0 68 95 191396 191423 Helicobacter pylori strain HpGP-POR-102 chromosome, complete genome blastn 56 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
10822254 10822254 PRJNA643700_P_NODE_102809_length_411_cov_2.174033_g101255_i0 PRJNA643700 102809 411 2.174033 8.93527563 Candidatus Thiovulum stygium 2951083 Bacteria Bacteria 52.8 0.039   NTclustered gi|2182967327|gb|CP091137.1| 2951083 g101255 i0 100 0.0681265206812652 28 0 7 0 297 324 1233022 1232995 MAG: Candidatus Thiovulum stygium isolate 07-Movile_MetG_Ill chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Thiovulum Candidatus Thiovulum stygium
10822258 10822258 PRJNA643700_P_NODE_109629_length_397_cov_2.402299_g108075_i0 PRJNA643700 109629 397 2.402299 9.53712703 Helicobacter pylori 210 Bacteria Bacteria 58.4 8.17e-4   NTclustered gi|2642415116|gb|CP079341.1| 210 g108075 i0 78.723 0.236775818639798 94 15 23 4 189 281 1097908 1097819 Helicobacter pylori strain HpGP-PER-020 chromosome, complete genome blastn 94 58.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
15920954 15920954 PRJNA643700_P_NODE_220193_length_261_cov_2.207547_g218637_i0 PRJNA643700 220193 261 2.207547 5.76169767 Malaciobacter canalis 1912871 Bacteria Bacteria 52.8 0.024   NTclustered gi|1724553138|gb|CP042812.1| 1912871 g218637 i0 100 0.10727969348659 28 0 11 0 224 251 1135613 1135640 Malaciobacter canalis strain LMG 29148 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Malaciobacter Malaciobacter canalis
15921069 15921069 PRJNA643700_P_NODE_356073_length_182_cov_2.736842_g354517_i0 PRJNA643700 356073 182 2.736842 4.98105244 Campylobacter canadensis 449520 Bacteria Bacteria 52.8 0.015   NTclustered gi|1845963639|gb|CP035946.1| 449520 g354517 i0 100 0.153846153846154 28 0 15 0 44 71 549840 549813 Campylobacter canadensis strain LMG 24001 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter canadensis
15921167 15921167 PRJNA643700_P_NODE_425713_length_162_cov_0.920354_g424157_i0 PRJNA643700 425713 162 0.920354 1.49097348 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 54.7 0.004   NTclustered gi|2581873871|gb|CP134842.1| 2933791 g424157 i0 100 0.537037037037037 29 0 18 0 122 150 1750831 1750859 Arcobacter cryaerophilus gv. pseudocryaerophilus strain LEO 65 chromosome, complete genome blastn 87 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
19744937 19744937 PRJNA643700_P_NODE_195676_length_282_cov_2.596567_g194120_i0 PRJNA643700 195676 282 2.596567 7.32231894 Arcobacteraceae bacterium 2808971 Bacteria Bacteria 52.8 0.026   NTclustered gi|2621701254|emb|OY759974.1| 2808971 g194120 i0 100 0.198581560283688 28 0 10 0 163 190 112319 112346 MAG: Arcobacteraceae bacterium isolate 2f960911-6b7a-430b-8fcb-36b605e4e712 genome assembly, chromosome: 1 blastn 56 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae   Arcobacteraceae bacterium
20285094 20285094 PRJNA643700_P_NODE_357836_length_182_cov_1.052632_g356280_i0 PRJNA643700 357836 182 1.052632 1.91579024 Campylobacter 194 Bacteria Bacteria 211 2.41e-50   NTclustered gi|2524016160|dbj|AP028392.1| 197 g356280 i0 88.108 248.351648351648 185 12 100 7 1 182 809432 809609 Campylobacter jejuni BCH-11447 DNA, complete genome blastn 45200 211 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
21020555 21020555 PRJNA643700_P_NODE_283437_length_219_cov_1.141176_g281881_i0 PRJNA643700 283437 219 1.141176 2.49917544 Halarcobacter mediterraneus 2023153 Bacteria Bacteria 52.8 0.019   NTclustered gi|2621784616|emb|OY781074.1| 2023153 g281881 i0 100 0.127853881278539 28 0 13 0 149 176 344552 344525 MAG: Halarcobacter mediterraneus isolate a5fc0a89-db13-449e-aec2-f9d0956b3340 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Halarcobacter Halarcobacter mediterraneus
22295220 22295220 PRJNA643700_P_NODE_268718_length_227_cov_2.629213_g267162_i0 PRJNA643700 268718 227 2.629213 5.96831351 Campylobacter sp. RM12651 1660079 Bacteria Bacteria 52.8 0.02   NTclustered gi|2198381838|gb|CP059600.1| 1660079 g267162 i0 100 0.123348017621145 28 0 12 0 141 168 1740102 1740075 Campylobacter sp. RM12651 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. RM12651
27112723 27112723 PRJNA643700_P_NODE_263822_length_230_cov_2.314917_g262266_i0 PRJNA643700 263822 230 2.314917 5.3243091 Helicobacter trogontum 50960 Bacteria Bacteria 41.6 0.0348   NR TLD96448.1 50960 g262266 i0 38.6 1.72173913043478 44 27 57.4 0 178 47 36 79 TLD96448.1 hypothetical protein LS80_008400 [Helicobacter trogontum] diamond 396 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter trogontum
28976135 28976135 PRJNA643700_P_NODE_210768_length_269_cov_1.418182_g209212_i0 PRJNA643700 210768 269 1.418182 3.81490958 unclassified Campylobacter 2593542 Bacteria Bacteria 45.1 0.00722   NR WP_150139290.1 2593542 g209212 i0 37.7 0.680297397769517 61 29 58 2 259 104 159 219 WP_150139290.1 MULTISPECIES: glycosyltransferase family 2 protein [unclassified Campylobacter] diamond 183 45.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter  
29039434 29039434 PRJNA643700_P_NODE_328188_length_195_cov_4.082192_g326632_i0 PRJNA643700 328188 195 4.082192 7.9602744 Campylobacterota bacterium 2026809 Bacteria Bacteria 43.1 0.0144   NR RLA72111.1 2026809 g326632 i0 41.9 0.661538461538462 43 25 66.2 0 162 34 71 113 RLA72111.1 MAG: hypothetical protein DRG30_07700 [Campylobacterota bacterium] diamond 129 43.1 1 Bacteria   Pseudomonadati Campylobacterota         Campylobacterota bacterium
29607125 29607125 PRJNA643700_P_NODE_80670_length_466_cov_2.400480_g79126_i0 PRJNA643700 80670 466 2.40048 11.1862368 Poseidonibacter lekithochrous 1904463 Bacteria Bacteria 45.4 0.0323   NR WP_071626310.1 1904463 g79126 i0 34.2 0.489270386266094 76 48 47.6 1 150 371 132 207 WP_071626310.1 type IV pili methyl-accepting chemotaxis transducer N-terminal domain-containing protein [Poseidonibacter lekithochrous] diamond 228 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Poseidonibacter Poseidonibacter lekithochrous
29733558 29733558 PRJNA643700_P_NODE_277970_length_222_cov_1.242775_g276414_i0 PRJNA643700 277970 222 1.242775 2.7589605 Aliarcobacter cryaerophilus 28198 Bacteria Bacteria 42.7 0.0277   NR WP_342837299.1 28198 g276414 i0 39 0.797297297297297 59 33 78.4 2 14 187 208 264 WP_342837299.1 MBL fold metallo-hydrolase [Aliarcobacter cryaerophilus] diamond 177 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter cryaerophilus
30397710 30397710 PRJNA643700_P_NODE_244913_length_243_cov_1.386598_g243357_i0 PRJNA643700 244913 243 1.386598 3.36943314 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 41.6 0.0275   NR MBV5278496.1 2268179 g243357 i0 37.5 0.691358024691358 56 33 67.9 2 182 18 34 88 MBV5278496.1 hypothetical protein [Campylobacteraceae bacterium] diamond 168 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
32673268 32673268 PRJNA643700_P_NODE_232640_length_252_cov_1.133005_g231084_i0 PRJNA643700 232640 252 1.133005 2.8551726 Campylobacter iguaniorum 1244531 Bacteria Bacteria 42.7 0.0395   NR WP_038453659.1 1244531 g231084 i0 45.9 0.44047619047619 37 20 44 0 108 218 316 352 WP_038453659.1 sensor histidine kinase [Campylobacter iguaniorum] diamond 111 42.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter iguaniorum

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