RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA716463" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA716463 · 16 ✖

analysis 1

  • diamond · 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
21109795 21109795 PRJNA716463_P_NODE_111517_length_241_cov_3.101190_g111099_i0 PRJNA716463 111517 241 3.10119 7.4738679 uncultured Campylobacter sp. 218934 Bacteria Bacteria 164 2.52e-46   NR WP_297996866.1 218934 g111099 i0 100 2.98755186721992 80 0 99.6 0 241 2 30 109 WP_297996866.1 ribonuclease R family protein [uncultured Campylobacter sp.] diamond 720 164 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
27241582 27241582 PRJNA716463_P_NODE_53683_length_288_cov_1.986047_g53266_i0 PRJNA716463 53683 288 1.986047 5.71981536 uncultured Campylobacter sp. 218934 Bacteria Bacteria 167 8.07e-51   NR WP_298083418.1 218934 g53266 i0 98.8 0.833333333333333 80 1 83.3 0 49 288 1 80 WP_298083418.1 tetratricopeptide repeat protein [uncultured Campylobacter sp.] diamond 240 167 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
28410130 28410130 PRJNA716463_P_NODE_86826_length_263_cov_1.678947_g86409_i0 PRJNA716463 86826 263 1.678947 4.41563061 uncultured Campylobacter sp. 218934 Bacteria Bacteria 173 2.9e-53   NR WP_297880618.1 218934 g86409 i0 98.9 2.97718631178707 87 1 99.2 0 3 263 30 116 WP_297880618.1 endolytic transglycosylase MltG, partial [uncultured Campylobacter sp.] diamond 783 173 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
28567834 28567834 PRJNA716463_P_NODE_115187_length_236_cov_3.730061_g114769_i0 PRJNA716463 115187 236 3.730061 8.80294396 Helicobacter pylori 210 Bacteria Bacteria 54.7 9.77e-8   NR GAA9176533.1 210 g114769 i0 75.9 1.09322033898305 29 7 36.9 0 228 142 20 48 GAA9176533.1 hypothetical protein Kyoto193A_0850 [Helicobacter pylori] diamond 258 54.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29199572 29199572 PRJNA716463_P_NODE_3509_length_523_cov_3.804444_g3110_i0 PRJNA716463 3509 523 3.804444 19.89724212 uncultured Campylobacter sp. 218934 Bacteria Bacteria 81.3 5.04e-17   NR WP_298062591.1 218934 g3110 i0 90.9 0.252390057361377 44 4 25.2 0 133 2 1 44 WP_298062591.1 hypothetical protein [uncultured Campylobacter sp.] diamond 132 81.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
29231130 29231130 PRJNA716463_P_NODE_115229_length_236_cov_3.515337_g114811_i0 PRJNA716463 115229 236 3.515337 8.29619532 Campylobacter concisus 199 Bacteria Bacteria 157 4.459999999999999e-47   NR WP_035167532.1 199 g114811 i0 100 0.991525423728814 78 0 99.2 0 3 236 49 126 WP_035167532.1 hypothetical protein [Campylobacter concisus] diamond 234 157 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
29294130 29294130 PRJNA716463_P_NODE_72549_length_274_cov_2.676617_g72132_i0 PRJNA716463 72549 274 2.676617 7.33393058 uncultured Campylobacter sp. 218934 Bacteria Bacteria 172 3.52e-49   NR WP_299085931.1 218934 g72132 i0 98.9 2.98905109489051 91 1 99.6 0 274 2 238 328 WP_299085931.1 hypothetical protein [uncultured Campylobacter sp.] diamond 819 172 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
29304559 29304559 PRJNA716463_P_NODE_85009_length_264_cov_3.476440_g84592_i0 PRJNA716463 85009 264 3.47644 9.1778016 root 1 Root_unresolved Root_unresolved 45.1 0.00705   NR EAK6855355.1 195 g84592 i0 45.7 1.64772727272727 46 24 51.1 1 253 119 386 431 EAK6855355.1 hypothetical protein [Campylobacter coli] diamond 435 45.4 0.993392070484582 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
29830839 29830839 PRJNA716463_P_NODE_91671_length_259_cov_1.634409_g91254_i0 PRJNA716463 91671 259 1.634409 4.23311931 uncultured Campylobacter sp. 218934 Bacteria Bacteria 177 4.6e-54   NR WP_297944343.1 218934 g91254 i0 100 1.99227799227799 86 0 99.6 0 1 258 117 202 WP_297944343.1 hypothetical protein [uncultured Campylobacter sp.] diamond 516 177 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
31674233 31674233 PRJNA716463_P_NODE_52077_length_289_cov_2.032407_g51660_i0 PRJNA716463 52077 289 2.032407 5.87365623 Sulfurimonas 202746 Bacteria Bacteria 45.4 0.00643   NR HFB53485.1 202747 g51660 i0 61.8 1.78546712802768 34 13 35.3 0 1 102 239 272 HFB53485.1 HAD-IIB family hydrolase [Sulfurimonas autotrophica] diamond 516 45.8 0.991266375545852 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas autotrophica
31758744 31758744 PRJNA716463_P_NODE_79377_length_269_cov_1.862245_g78960_i0 PRJNA716463 79377 269 1.862245 5.00943905 Campylobacter concisus 199 Bacteria Bacteria 159 5.75e-45   NR WP_103582689.1 199 g78960 i0 84.3 0.992565055762082 89 14 99.3 0 2 268 259 347 WP_103582689.1 site-specific integrase [Campylobacter concisus] diamond 267 159 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter concisus
31885177 31885177 PRJNA716463_P_NODE_118817_length_230_cov_3.643312_g118399_i0 PRJNA716463 118817 230 3.643312 8.3796176 uncultured Campylobacter sp. 218934 Bacteria Bacteria 93.6 4.07e-20   NR WP_297960810.1 218934 g118399 i0 70.4 1.05652173913043 81 19 99.1 2 230 3 1593 1673 WP_297960810.1 hypothetical protein, partial [uncultured Campylobacter sp.] diamond 243 93.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
32360169 32360169 PRJNA716463_P_NODE_105199_length_247_cov_1.379310_g104782_i0 PRJNA716463 105199 247 1.37931 3.4068957 uncultured Campylobacter sp. 218934 Bacteria Bacteria 73.9 2.31e-15   NR WP_297882592.1 218934 g104782 i0 76.6 0.57085020242915 47 11 57.1 0 3 143 20 66 WP_297882592.1 hypothetical protein, partial [uncultured Campylobacter sp.] diamond 141 73.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
32675594 32675594 PRJNA716463_P_NODE_36080_length_299_cov_3.353982_g35663_i0 PRJNA716463 36080 299 3.353982 10.02840618 uncultured Campylobacter sp. 218934 Bacteria Bacteria 81.6 1.57e-15   NR WP_299190531.1 218934 g35663 i0 93.6 1.88628762541806 47 3 47.2 0 2 142 802 848 WP_299190531.1 alanine--tRNA ligase [uncultured Campylobacter sp.] diamond 564 81.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter uncultured Campylobacter sp.
32833190 32833190 PRJNA716463_P_NODE_22020_length_310_cov_3.375527_g21603_i0 PRJNA716463 22020 310 3.375527 10.4641337 Campylobacter sp. 205 Bacteria Bacteria 102 2.1699999999999998e-23   NR WP_291940314.1 205 g21603 i0 100 0.474193548387097 49 0 47.4 0 162 308 287 335 WP_291940314.1 hypothetical protein, partial [Campylobacter sp.] diamond 147 102 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp.
32896042 32896042 PRJNA716463_P_NODE_42000_length_297_cov_3.352679_g41583_i0 PRJNA716463 42000 297 3.352679 9.95745663 Campylobacter sp. 205 Bacteria Bacteria 95.9 1.62e-22   NR MFC2586766.1 205 g41583 i0 100 0.505050505050505 50 0 50.5 0 1 150 103 152 MFC2586766.1 OmpH family outer membrane protein [Campylobacter sp.] diamond 150 95.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp.

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