RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA399711" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA399711 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
6184053 6184053 PRJNA399711_P_NODE_15945_length_172_cov_4.088889_g15879_i0 PRJNA399711 15945 172 4.088889 7.03288908 Helicobacter 209 Bacteria Bacteria 207 2.91e-49   NTclustered gi|50957138|gb|AY596223.1| 35818 g15879 i0 90.741 74.546511627907 162 2 94 1 10 171 331 183 Helicobacter pullorum strain NCTC 12827 23S ribosomal RNA gene, partial sequence blastn 12822 207 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pullorum
25562738 25562738 PRJNA399711_S_NODE_24977_length_255_cov_2.665138_g24835_i0 PRJNA399711 24977 255 2.665138 6.7961019 Campylobacter sp. CN_NE2 2984146 Bacteria Bacteria 87.9 6.35e-13   NTclustered gi|2427059240|gb|CP115608.1| 2984146 g24835 i0 80.342 1.54117647058824 117 21 45 2 41 156 1062063 1062178 Campylobacter sp. CN_NE2 strain Cn NE2 chromosome blastn 393 87.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. CN_NE2
25563065 25563065 PRJNA399711_S_NODE_32185_length_233_cov_2.015306_g32043_i0 PRJNA399711 32185 233 2.015306 4.69566298 Arcobacter ellisii 913109 Bacteria Bacteria 368 1.82e-97   NTclustered gi|1474793334|gb|CP032097.1| 913109 g32043 i0 95.633 11.9613733905579 229 10 98 0 5 233 2185287 2185059 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 2787 368 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
25564804 25564804 PRJNA399711_S_NODE_78489_length_169_cov_2.643939_g78347_i0 PRJNA399711 78489 169 2.643939 4.46825691 Sulfurimonas aquatica 2672570 Bacteria Bacteria 52.8 0.014   NTclustered gi|2006624948|gb|CP046072.1| 2672570 g78347 i0 100 0.165680473372781 28 0 17 0 130 157 1357853 1357880 Sulfurimonas aquatica strain H1576 chromosome, complete genome blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurimonadaceae Sulfurimonas Sulfurimonas aquatica
25698000 25698000 PRJNA399711_S_NODE_105994_length_152_cov_1.217391_g105852_i0 PRJNA399711 105994 152 1.217391 1.85043432 Arcobacter ellisii 913109 Bacteria Bacteria 78.7 2.05e-10   NTclustered gi|1474793334|gb|CP032097.1| 913109 g105852 i0 95.833 1.09210526315789 48 2 32 0 105 152 1245141 1245094 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 166 78.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
25701485 25701485 PRJNA399711_S_NODE_95034_length_158_cov_1.644628_g94892_i0 PRJNA399711 95034 158 1.644628 2.59851224 Campylobacter sp. RM12651 1660079 Bacteria Bacteria 154 3.48e-33   NTclustered gi|2198381838|gb|CP059600.1| 1660079 g94892 i0 85.333 5.4873417721519004 150 20 94 2 10 158 1871883 1872031 Campylobacter sp. RM12651 chromosome, complete genome blastn 867 154 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. RM12651
25835314 25835314 PRJNA399711_S_NODE_32691_length_231_cov_8.963918_g32549_i0 PRJNA399711 32691 231 8.963918 20.70665058 Arcobacter ellisii 913109 Bacteria Bacteria 303 5.16e-78   NTclustered gi|1474793334|gb|CP032097.1| 913109 g32549 i0 90.435 10.9350649350649 230 22 99 0 2 231 803655 803884 Arcobacter ellisii strain LMG 26155 chromosome, complete genome blastn 2526 303 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter ellisii
25972899 25972899 PRJNA399711_S_NODE_67716_length_178_cov_4.212766_g67574_i0 PRJNA399711 67716 178 4.212766 7.49872348 Helicobacter pullorum 35818 Bacteria Bacteria 318 1.34e-82   NTclustered gi|1540242994|emb|LR134509.1| 35818 g67574 i0 98.876 1 178 2 100 0 1 178 1702998 1703175 Helicobacter pullorum strain NCTC13154 genome assembly, chromosome: 1 blastn 178 318 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pullorum
26242534 26242534 PRJNA399711_S_NODE_108070_length_151_cov_1.008772_g107928_i0 PRJNA399711 108070 151 1.008772 1.52324572 Campylobacter ureolyticus RIGS 988 827 Bacteria Bacteria 267 4.04e-67   NTclustered gi|909715533|gb|CP012195.1| 1032069 g107928 i0 98.667 4.98013245033113 150 2 99 0 2 151 1046994 1047143 Campylobacter ureolyticus RIGS 9880 chromosome, complete genome blastn 752 267 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter ureolyticus
26517978 26517978 PRJNA399711_S_NODE_92416_length_159_cov_4.450820_g92274_i0 PRJNA399711 92416 159 4.45082 7.0768038 Helicobacter cholecystus 45498 Bacteria Bacteria 52.8 0.013   NTclustered gi|1540259954|emb|LR134518.1| 45498 g92274 i0 100 0.176100628930818 28 0 18 0 107 134 1360383 1360356 Helicobacter cholecystus strain NCTC13205 genome assembly, chromosome: 1 blastn 28 52.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter cholecystus

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