RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1137393 · 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
27038737 27038737 PRJNA1137393_P_NODE_69302_length_162_cov_1.840708_g68786_i0 PRJNA1137393 69302 162 1.840708 2.98194696 Helicobacter pylori 210 Bacteria Bacteria 60.8 4.62e-10   NR GAA8950930.1 210 g68786 i0 65.9 0.814814814814815 44 15 81.5 0 31 162 48 91 GAA8950930.1 hypothetical protein Kyoto181A_1790 [Helicobacter pylori] diamond 132 60.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
28681171 28681171 PRJNA1137393_P_NODE_22407_length_195_cov_1.383562_g21891_i0 PRJNA1137393 22407 195 1.383562 2.6979459 Helicobacter pylori 210 Bacteria Bacteria 51.6 5.58e-7   NR GAA6795254.1 210 g21891 i0 62.9 1.6 35 13 53.8 0 181 77 4 38 GAA6795254.1 hypothetical protein Kyoto200A_0170 [Helicobacter pylori] diamond 312 51.6 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
30070287 30070287 PRJNA1137393_P_NODE_13752_length_229_cov_1.155556_g13236_i0 PRJNA1137393 13752 229 1.155556 2.64622324 Helicobacter pylori 210 Bacteria Bacteria 40.8 0.0121   NR GAA8989908.1 210 g13236 i0 92.3 0.510917030567686 39 3 51.1 0 111 227 1 39 GAA8989908.1 hypothetical protein Kyoto181A_5900 [Helicobacter pylori] diamond 117 40.8 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
31260171 31260171 PRJNA1137393_P_NODE_15135_length_221_cov_2.034884_g14619_i0 PRJNA1137393 15135 221 2.034884 4.49709364 Pseudomonadati 3379134 Bacteria Bacteria 50.1 1.25e-5   NR GAA9176272.1 210 g14619 i0 79.2 1.30316742081448 24 5 32.6 0 27 98 1 24 GAA9176272.1 hypothetical protein Kyoto193A_0470 [Helicobacter pylori] diamond 288 50.1 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);;