RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA289590", tax_kingdom = "Pseudomonadati" and tax_phylum = "Campylobacterota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Campylobacterota · 2 ✖

tax_kingdom 1

  • Pseudomonadati · 2 ✖

bioproject 1

  • PRJNA289590 · 2 ✖

analysis 1

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
4199925 4199925 PRJNA289590_P_NODE_5844_length_403_cov_1.663842_g5620_i0 PRJNA289590 5844 403 1.663842 6.70528326 Pseudomonadati 3379134 Bacteria Bacteria 191 4.76e-59   NR GAA7768098.1 210 g5620 i0 93.8 5.95533498759305 96 6 71.5 0 288 1 29 124 GAA7768098.1 dCTP deaminase [Helicobacter pylori] diamond 2400 191 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Helicobacteraceae Helicobacter Helicobacter pylori
15675573 15675573 PRJNA289590_P_NODE_7613_length_344_cov_2.400000_g7389_i0 PRJNA289590 7613 344 2.4 8.256 Sulfurovum sp. 1969726 Bacteria Bacteria 154 8.2e-46   NR MDD3500781.1 1969726 g7389 i0 73.7 0.994186046511628 114 25 95.1 1 342 16 4 117 MDD3500781.1 hypothetical protein [Sulfurovum sp.] diamond 342 154 1 Bacteria   Pseudomonadati Campylobacterota Epsilonproteobacteria Campylobacterales Sulfurovaceae Sulfurovum Sulfurovum sp.

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