RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

9 rows where analysis = "diamond", bioproject = "PRJDB9741" 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

  • PRJDB9741 · 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
26684187 26684187 PRJDB9741_P_NODE_10841_length_200_cov_2.344371_g10524_i0 PRJDB9741 10841 200 2.344371 4.688742 Helicobacter pylori 210 Bacteria Bacteria 57.4 6.05e-9   NR GAA6953508.1 210 g10524 i0 75 0.48 32 8 48 0 146 51 1 32 GAA6953508.1 hypothetical protein Kyoto211A_0720 [Helicobacter pylori] diamond 96 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27121066 27121066 PRJDB9741_P_NODE_19102_length_179_cov_2.307692_g18785_i0 PRJDB9741 19102 179 2.307692 4.13076868 Pseudomonadati 3379134 Bacteria Bacteria 102 3.81e-26   NR WP_175055342.1 197 g18785 i0 100 5.93296089385475 59 0 98.9 0 179 3 59 117 WP_175055342.1 GAF domain-containing protein, partial [Campylobacter jejuni] diamond 1062 102 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter jejuni
27342866 27342866 PRJDB9741_P_NODE_27803_length_167_cov_0.864407_g27486_i0 PRJDB9741 27803 167 0.864407 1.44355969 Bacteria 2 Bacteria Bacteria 42 0.00203   NR GAA8912035.1 210 g27486 i0 61.5 0.844311377245509 26 10 46.7 0 2 79 12 37 GAA8912035.1 hypothetical protein Kyoto166A_2340 [Helicobacter pylori] diamond 141 42.4 0.990566037735849 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
27474897 27474897 PRJDB9741_P_NODE_19543_length_179_cov_0.915385_g19226_i0 PRJDB9741 19543 179 0.915385 1.63853915 Helicobacter pylori 210 Bacteria Bacteria 69.7 8.21e-14   NR GAA6859872.1 210 g19226 i0 90.6 0.536312849162011 32 3 53.6 0 82 177 4 35 GAA6859872.1 hypothetical protein Kyoto206A_1100 [Helicobacter pylori] diamond 96 69.7 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28226478 28226478 PRJDB9741_P_NODE_36846_length_162_cov_2.159292_g36529_i0 PRJDB9741 36846 162 2.159292 3.49805304 Bacteria 2 Bacteria Bacteria 110 2.64e-30   NR WP_240369625.1 195 g36529 i0 98.1 1.96296296296296 53 1 98.1 0 3 161 15 67 WP_240369625.1 hypothetical protein, partial [Campylobacter coli] diamond 318 110 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae Campylobacter Campylobacter coli
29747986 29747986 PRJDB9741_P_NODE_12091_length_194_cov_2.034483_g11774_i0 PRJDB9741 12091 194 2.034483 3.94689702 Helicobacter pylori 210 Bacteria Bacteria 57.4 8.2e-9   NR GAA8686254.1 210 g11774 i0 100 0.479381443298969 31 0 47.9 0 103 11 1 31 GAA8686254.1 hypothetical protein Kyoto145A_1480 [Helicobacter pylori] diamond 93 57.4 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31517967 31517967 PRJDB9741_P_NODE_19556_length_178_cov_5.286822_g19239_i0 PRJDB9741 19556 178 5.286822 9.41054316 Helicobacter pylori 210 Bacteria Bacteria 61.2 6.08e-11   NR GAA8948601.1 210 g19239 i0 68.9 1.51685393258427 45 13 75.8 1 176 42 2 45 GAA8948601.1 hypothetical protein Kyoto181A_0400 [Helicobacter pylori] diamond 270 61.2 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32024083 32024083 PRJDB9741_P_NODE_5678_length_264_cov_1.841860_g5362_i0 PRJDB9741 5678 264 1.84186 4.8625104 Helicobacter pylori 210 Bacteria Bacteria 79 4.45e-17   NR GAA8734169.1 210 g5362 i0 77 0.840909090909091 74 17 84.1 0 10 231 6 79 GAA8734169.1 hypothetical protein Kyoto147A_1540 [Helicobacter pylori] diamond 222 79 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
32055559 32055559 PRJDB9741_P_NODE_20438_length_177_cov_1.593750_g20121_i0 PRJDB9741 20438 177 1.59375 2.8209375 Helicobacter pylori 210 Bacteria Bacteria 55.5 1.11e-8   NR GAA9221949.1 210 g20121 i0 83.9 1.52542372881356 31 4 50.8 1 137 48 6 36 GAA9221949.1 hypothetical protein Kyoto198A_3800 [Helicobacter pylori] diamond 270 55.5 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);;