RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA274362" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA274362 · 3 ✖

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
20184672 20184672 PRJNA274362_S_NODE_30376_length_173_cov_0.927419_g30256_i0 PRJNA274362 30376 173 0.927419 1.60443487 Arcobacteraceae 2808963 Bacteria Bacteria 302 1.31e-77   NTclustered gi|1847324382|gb|CP053840.1| 1054033 g30256 i0 98.817 388.606936416185 169 2 98 0 5 173 2091570 2091738 Arcobacter venerupis strain LMG 26156 chromosome, complete genome blastn 67229 302 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Arcobacteraceae Arcobacter Arcobacter venerupis
27800742 27800742 PRJNA274362_S_NODE_20384_length_204_cov_3.554839_g20264_i0 PRJNA274362 20384 204 3.554839 7.25187156 Helicobacter pylori 210 Bacteria Bacteria 58.2 1.39e-9   NR GAA8838853.1 210 g20264 i0 92.9 0.411764705882353 28 2 41.2 0 3 86 14 41 GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori] diamond 84 58.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30358919 30358919 PRJNA274362_S_NODE_14892_length_233_cov_0.842391_g14772_i0 PRJNA274362 14892 233 0.842391 1.96277103 Helicobacter pylori 210 Bacteria Bacteria 61.6 9.63e-11   NR GAA8812112.1 210 g14772 i0 72.7 0.424892703862661 33 9 42.5 0 157 59 14 46 GAA8812112.1 hypothetical protein Kyoto149A_3190 [Helicobacter pylori] diamond 99 61.6 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);;