RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA352850" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA352850 · 3 ✖

analysis 1

  • diamond · 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
28116984 28116984 PRJNA352850_P_NODE_25045_length_554_cov_1.673267_g22226_i0 PRJNA352850 25045 554 1.673267 9.26989918 Helicobacter pylori 210 Bacteria Bacteria 73.6 4.93e-14   NR GAA8838853.1 210 g22226 i0 81 0.227436823104693 42 8 22.7 0 55 180 2 43 GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori] diamond 126 73.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28274853 28274853 PRJNA352850_P_NODE_25846_length_542_cov_1.371197_g23025_i0 PRJNA352850 25846 542 1.371197 7.43188774 Helicobacter pylori 210 Bacteria Bacteria 63.9 1.4e-9   NR GAA6899797.1 210 g23025 i0 62.7 0.282287822878229 51 19 28.2 0 158 6 54 104 GAA6899797.1 hypothetical protein Kyoto207A_1280 [Helicobacter pylori] diamond 153 63.9 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30787092 30787092 PRJNA352850_P_NODE_77854_length_253_cov_2.225490_g75021_i0 PRJNA352850 77854 253 2.22549 5.6304897 Pseudomonadati 3379134 Bacteria Bacteria 174 1.15e-54   NR WP_240376184.1 197 g75021 i0 100 1.99209486166008 84 0 99.6 0 253 2 5 88 WP_240376184.1 C-terminal helicase domain-containing protein, partial [Campylobacter jejuni] diamond 504 174 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni

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