RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA615175 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
29227919 29227919 PRJNA615175_P_NODE_2289_length_1014_cov_5.011690_g2170_i0 PRJNA615175 2289 1014 5.01169 50.8185366 Campylobacteraceae bacterium 2268179 Bacteria Bacteria 77.8 5.8e-12   NR MDR1615017.1 2268179 g2170 i0 29.3 1.09467455621302 181 116 51.2 5 106 624 4 180 MDR1615017.1 hypothetical protein [Campylobacteraceae bacterium] diamond 1110 77.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Campylobacteraceae   Campylobacteraceae bacterium
29322290 29322290 PRJNA615175_P_NODE_19769_length_312_cov_3.757322_g19601_i0 PRJNA615175 19769 312 3.757322 11.72284464 Helicobacter pylori 210 Bacteria Bacteria 41.6 0.0324   NR GAA9124962.1 210 g19601 i0 100 0.173076923076923 18 0 17.3 0 312 259 19 36 GAA9124962.1 hypothetical protein Kyoto190A_0650 [Helicobacter pylori] diamond 54 41.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
29669333 29669333 PRJNA615175_P_NODE_16310_length_348_cov_2.581818_g16142_i0 PRJNA615175 16310 348 2.581818 8.98472664 Desulfurellales bacterium 2482794 Bacteria Bacteria 80.5 6.98e-15   NR TXH52561.1 2482794 g16142 i0 41.9 1.00862068965517 117 61 96.6 4 337 2 323 437 TXH52561.1 MAG: DEAD/DEAH box helicase [Desulfurellales bacterium] diamond 351 80.5 1 Bacteria   Pseudomonadati Campylobacterota Desulfurellia Desulfurellales     Desulfurellales bacterium
31135640 31135640 PRJNA615175_P_NODE_29135_length_249_cov_1.579545_g28967_i0 PRJNA615175 29135 249 1.579545 3.93306705 Pseudomonadati 3379134 Bacteria Bacteria 48.5 2.12e-5   NR GAA9125267.1 210 g28967 i0 80.8 0.891566265060241 26 4 30.1 1 199 125 6 31 GAA9125267.1 hypothetical protein Kyoto190A_0800 [Helicobacter pylori] diamond 222 48.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);;