RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJNA495391" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 9 ✖

tax_kingdom 1

bioproject 1

  • PRJNA495391 · 9 ✖

analysis 1

  • diamond · 9 ✖

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
26792248 26792248 PRJNA495391_S_NODE_55741_length_166_cov_2.541985_g54689_i0 PRJNA495391 55741 166 2.541985 4.2196951 Sulfurovum sp. 1969726 Bacteria Bacteria 76.3 2.02e-14   NR MCB4781899.1 1969726 g54689 i0 60 3.97590361445783 55 22 99.4 0 165 1 125 179 MCB4781899.1 reverse transcriptase family protein [Sulfurovum sp.] diamond 660 76.3 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.
27203157 27203157 PRJNA495391_S_NODE_3882_length_649_cov_6.177524_g2885_i0 PRJNA495391 3882 649 6.177524 40.09213076 Helicobacter pylori 210 Bacteria Bacteria 45.4 0.0327   NR MDO7823221.1 210 g2885 i0 100 0.0924499229583975 20 0 9.2 0 588 647 34 53 MDO7823221.1 hypothetical protein [Helicobacter pylori] diamond 60 45.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27898094 27898094 PRJNA495391_S_NODE_54925_length_167_cov_3.575758_g53873_i0 PRJNA495391 54925 167 3.575758 5.97151586 Helicobacter pylori 210 Bacteria Bacteria 65.1 1.6e-12   NR GAA8948601.1 210 g53873 i0 100 0.520958083832335 29 0 52.1 0 167 81 17 45 GAA8948601.1 hypothetical protein Kyoto181A_0400 [Helicobacter pylori] diamond 87 65.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29271246 29271246 PRJNA495391_S_NODE_58689_length_163_cov_1.210938_g57637_i0 PRJNA495391 58689 163 1.210938 1.97382894 Campylobacterales 213849 Bacteria Bacteria 40 0.0294   NR WP_290879973.1 218 g57637 i0 47.5 1.71165644171779 40 21 73.6 0 141 22 34 73 WP_290879973.1 co-chaperone GroES [Helicobacter sp.] diamond 279 40.4 0.99009900990099 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter sp.
29887546 29887546 PRJNA495391_S_NODE_27951_length_228_cov_2.518135_g26899_i0 PRJNA495391 27951 228 2.518135 5.7413478 Campylobacter jejuni 197 Bacteria Bacteria 161 5.12e-45   NR ECR3422575.1 197 g26899 i0 100 3 76 0 100 0 228 1 282 357 ECR3422575.1 hypothetical protein [Campylobacter jejuni] diamond 684 161 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
31293162 31293162 PRJNA495391_S_NODE_19135_length_274_cov_2.117155_g18083_i0 PRJNA495391 19135 274 2.117155 5.8010047 Bacteria 2 Bacteria Bacteria 178 2.49e-51   NR ECR3422575.1 197 g18083 i0 100 2.95620437956204 90 0 98.5 0 272 3 386 475 ECR3422575.1 hypothetical protein [Campylobacter jejuni] diamond 810 178 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
31783585 31783585 PRJNA495391_S_NODE_24697_length_242_cov_2.758454_g23645_i0 PRJNA495391 24697 242 2.758454 6.67545868 Campylobacter sp. CS_ED1 2984140 Bacteria Bacteria 107 1.74e-26   NR WP_270871688.1 2984140 g23645 i0 70 1.93388429752066 80 24 99.2 0 3 242 52 131 WP_270871688.1 major capsid protein, partial [Campylobacter sp. CS_ED1] diamond 468 107 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter sp. CS_ED1
32480014 32480014 PRJNA495391_S_NODE_40339_length_193_cov_1.740506_g39287_i0 PRJNA495391 40339 193 1.740506 3.35917658 Campylobacter jejuni 197 Bacteria Bacteria 100 3.4099999999999995e-24   NR ECR3422573.1 197 g39287 i0 91.7 0.932642487046632 60 5 93.3 0 193 14 63 122 ECR3422573.1 DUF334 domain-containing protein [Campylobacter jejuni] diamond 180 100 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
32858063 32858063 PRJNA495391_S_NODE_52100_length_171_cov_3.125000_g51048_i0 PRJNA495391 52100 171 3.125 5.34375 Helicobacter pylori 210 Bacteria Bacteria 57 8.77e-9   NR GAA8686254.1 210 g51048 i0 100 0.543859649122807 31 0 54.4 0 123 31 1 31 GAA8686254.1 hypothetical protein Kyoto145A_1480 [Helicobacter pylori] diamond 93 57 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori

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