RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA851399" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA851399 · 4 ✖

analysis 1

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
27252782 27252782 PRJNA851399_P_NODE_30863_length_165_cov_0.879310_g30410_i0 PRJNA851399 30863 165 0.87931 1.4508615 root 1 Root_unresolved Root_unresolved 41.2 0.019   NR WP_240382657.1 197 g30410 i0 52.2 1.74545454545455 46 22 83.6 0 24 161 62 107 WP_240382657.1 hypothetical protein, partial [Campylobacter jejuni] diamond 288 41.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
29905415 29905415 PRJNA851399_P_NODE_16791_length_186_cov_1.861314_g16338_i0 PRJNA851399 16791 186 1.861314 3.46204404 Bacteria 2 Bacteria Bacteria 130 1.27e-36   NR PUB99708.1 210 g16338 i0 100 3.93548387096774 61 0 98.4 0 184 2 77 137 PUB99708.1 hypothetical protein C2S07_01860, partial [Helicobacter pylori] diamond 732 130 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31223851 31223851 PRJNA851399_P_NODE_36795_length_162_cov_1.805310_g36342_i0 PRJNA851399 36795 162 1.80531 2.9246022 Helicobacter pylori 210 Bacteria Bacteria 42 0.00259   NR GAA8780409.1 210 g36342 i0 41.5 0.981481481481482 53 28 94.4 2 8 160 1 52 GAA8780409.1 hypothetical protein Kyoto147A_5000 [Helicobacter pylori] diamond 159 42 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32553034 32553034 PRJNA851399_P_NODE_35439_length_163_cov_0.894737_g34986_i0 PRJNA851399 35439 163 0.894737 1.45842131 Aliarcobacter butzleri 28197 Bacteria Bacteria 53.1 1.13e-7   NR WP_305863257.1 28197 g34986 i0 64.1 2.15337423312883 39 14 71.8 0 14 130 19 57 WP_305863257.1 DUF1725 domain-containing protein, partial [Aliarcobacter butzleri] diamond 351 53.1 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Aliarcobacter Aliarcobacter butzleri

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