RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Pseudomonadati · 16 ✖

bioproject 1

  • PRJEB6584 · 16 ✖

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
25523723 25523723 PRJEB6584d_S_NODE_17169_length_154_cov_2.210084_g17101_i0 PRJEB6584 17169 154 2.210084 3.40352936 Wolinella succinogenes 844 Bacteria Bacteria 268 1.15e-67   NTclustered gi|34483186|emb|BX571660.1| 844 g17101 i0 99.324 165.928571428571 148 1 96 0 7 154 336273 336126 Wolinella succinogenes, complete genome; segment 4/7 blastn 25553 268 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Wolinella Wolinella succinogenes
25615839 25615839 PRJEB6584h_S_NODE_3241_length_283_cov_2697.729839_g3179_i0 PRJEB6584 3241 283 2697.729839 7634.57544437 root 1 Root_unresolved Root_unresolved 71.3 7.21e-8   NTclustered gi|2222028449|gb|CP094103.1| 210 g3179 i0 97.619 14.2226148409894 42 0 15 1 1 42 1292616 1292576 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 4025 71.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
25659785 25659785 PRJEB6584h_S_NODE_8546_length_211_cov_2.454545_g8484_i0 PRJEB6584 8546 211 2.454545 5.17908995 Poseidonibacter lekithochrous 1904463 Bacteria Bacteria 52.8 0.019   NTclustered gi|1850313845|gb|CP054052.1| 1904463 g8484 i0 100 0.132701421800948 28 0 13 0 4 31 366258 366231 Poseidonibacter lekithochrous strain DSM 100870 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Poseidonibacter Poseidonibacter lekithochrous
25752560 25752560 PRJEB6584p_S_NODE_2010_length_237_cov_2101.133663_g1979_i0 PRJEB6584 2010 237 2101.133663 4979.68678131 root 1 Root_unresolved Root_unresolved 71.3 5.87e-8   NTclustered gi|2222028449|gb|CP094103.1| 210 g1979 i0 97.561 17.4472573839662 41 1 17 0 1 41 1292617 1292577 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 4135 71.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
25752569 25752569 PRJEB6584p_S_NODE_3066_length_219_cov_142.646739_g3035_i0 PRJEB6584 3066 219 142.646739 312.39635841 root 1 Root_unresolved Root_unresolved 65.8 2.49e-6   NTclustered gi|2222034613|gb|CP094108.1| 210 g3035 i0 100 17.1872146118721 35 0 16 0 185 219 685183 685149 Helicobacter pylori strain Hpfe073 chromosome, complete genome blastn 3764 65.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
25795758 25795758 PRJEB6584h_S_NODE_10195_length_202_cov_1.670659_g10133_i0 PRJEB6584 10195 202 1.670659 3.37473118 Malaciobacter marinus 505249 Bacteria Bacteria 52.8 0.018   NTclustered gi|1474785413|gb|CP032101.1| 505249 g10133 i0 100 0.138613861386139 28 0 14 0 84 111 1771318 1771291 Malaciobacter marinus strain JCM 15502 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Malaciobacter Malaciobacter marinus
26204255 26204255 PRJEB6584d_S_NODE_5654_length_245_cov_3.866667_g5586_i0 PRJEB6584 5654 245 3.866667 9.47333415 uncultured Campylobacterota bacterium 120858 Bacteria Bacteria 255 1.57e-63   NTclustered gi|346681361|gb|JF740475.1| 120858 g5586 i0 87.838 144.910204081633 222 21 90 6 9 228 756 539 Uncultured epsilon proteobacterium clone ITS_E3W_007 16S-23S ribosomal RNA intergenic spacer, partial sequence blastn 35503 255 1 Bacteria   Pseudomonadati Campylobacterota         uncultured Campylobacterota bacterium
26206083 26206083 PRJEB6584p_S_NODE_1134_length_274_cov_1647.138075_g1103_i0 PRJEB6584 1134 274 1647.138075 4513.1583255 Helicobacter pylori 210 Bacteria Bacteria 71.3 6.95e-8   NTclustered gi|2222028449|gb|CP094103.1| 210 g1103 i0 97.619 14.7846715328467 42 0 15 1 1 42 1292617 1292577 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 4051 71.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26206084 26206084 PRJEB6584p_S_NODE_1262_length_266_cov_1925.519481_g1231_i0 PRJEB6584 1262 266 1925.519481 5121.88181946 Helicobacter pylori 210 Bacteria Bacteria 71.3 6.72e-8   NTclustered gi|2222028449|gb|CP094103.1| 210 g1231 i0 95.556 14.6992481203008 45 1 17 1 1 44 1292615 1292571 Helicobacter pylori strain Hpfe077 chromosome, complete genome blastn 3910 71.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
26432006 26432006 PRJEB6584d_S_NODE_12159_length_179_cov_2.756944_g12091_i0 PRJEB6584 12159 179 2.756944 4.93492976 Sulfurimonas 202746 Bacteria Bacteria 283 4.94e-72   NTclustered gi|470486842|ref|NR_076783.1| 202747 g12091 i0 98.148 268.385474860335 162 3 91 0 1 162 1941 2102 Sulfurimonas autotrophica strain DSM 16294 23S ribosomal RNA gene, complete sequence blastn 48041 283 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas autotrophica
26476237 26476237 PRJEB6584b_S_NODE_4536_length_185_cov_2.813333_g4518_i0 PRJEB6584 4536 185 2.813333 5.20466605 Arcobacter ellisii 913109 Bacteria Bacteria 337 3.89e-88   NTclustered gi|1474793334|gb|CP032097.1| 913109 g4518 i0 99.459 382.956756756757 185 1 100 0 1 185 953830 954014 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 70847 337 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
26568059 26568059 PRJEB6584d_S_NODE_6392_length_233_cov_1.227273_g6324_i0 PRJEB6584 6392 233 1.227273 2.85954609 Sulfurimonadaceae 2771471 Bacteria Bacteria 298 2.43e-76   NTclustered gi|2159817265|gb|CP087998.1| 2894755 g6324 i0 90.625 274.965665236052 224 21 96 0 1 224 1881922 1882145 Sulfurimonas sp. HSL-3221 chromosome, complete genome blastn 64067 298 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Thiomicrolovo Thiomicrolovo sulfuroxydans
26568133 26568133 PRJEB6584j_S_NODE_976_length_302_cov_175.782772_g947_i0 PRJEB6584 976 302 175.782772 530.86397144 root 1 Root_unresolved Root_unresolved 65.8 3.61e-6   NTclustered gi|2222034613|gb|CP094108.1| 210 g947 i0 100 12.5761589403974 35 0 12 0 268 302 685183 685149 Helicobacter pylori strain Hpfe073 chromosome, complete genome blastn 3798 65.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32928991 32928991 PRJEB6584a_S_NODE_4593_length_187_cov_0.901316_g4573_i0 PRJEB6584 4593 187 0.901316 1.68546092 Nitratiruptor tergarcus 269259 Bacteria Bacteria 47 5.57e-4   NR WP_084274523.1 269259 g4573 i0 69.7 1.84491978609626 33 10 52.9 0 3 101 285 317 WP_084274523.1 RCC1 domain-containing protein [Nitratiruptor tergarcus] diamond 345 47 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Nautiliales Nitratiruptoraceae Nitratiruptor Nitratiruptor tergarcus
33065697 33065697 PRJEB6584l_S_NODE_23989_length_154_cov_3.722689_g23837_i0 PRJEB6584 23989 154 3.722689 5.73294106 Helicobacter pylori 210 Bacteria Bacteria 75.5 2.24e-16   NR GAA9184244.1 210 g23837 i0 100 0.623376623376623 32 0 62.3 0 31 126 1 32 GAA9184244.1 hypothetical protein Kyoto193A_2890 [Helicobacter pylori] diamond 96 75.5 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
33127940 33127940 PRJEB6584l_S_NODE_16279_length_174_cov_2.892086_g16127_i0 PRJEB6584 16279 174 2.892086 5.03222964 Pseudomonadati 3379134 Bacteria Bacteria 102 4.12e-27   NR WP_240384152.1 197 g16127 i0 100 1.79310344827586 52 0 89.7 0 168 13 15 66 WP_240384152.1 hypothetical protein, partial [Campylobacter jejuni] diamond 312 102 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni

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