RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA401346" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA401346 · 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
414205 414205 PRJNA401346_P_NODE_5221_length_233_cov_1.203488_g5200_i0 PRJNA401346 5221 233 1.203488 2.80412704 Lawsonella 1847725 Bacteria Bacteria 161 7.15e-46   NR WP_290598356.1 1847725 g5200 i0 96.1 0.991416309012876 77 3 99.1 0 1 231 277 353 WP_290598356.1 MULTISPECIES: NADH-quinone oxidoreductase subunit NuoF [Lawsonella] diamond 231 161 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
4909079 4909079 PRJNA401346_P_NODE_4004_length_264_cov_1.832512_g3983_i0 PRJNA401346 4004 264 1.832512 4.83783168 Actinomycetota bacterium 2900548 Bacteria Bacteria 152 2.6e-45   NR MBS1889789.1 2900548 g3983 i0 84.9 1.96590909090909 86 13 97.7 0 3 260 39 124 MBS1889789.1 hypothetical protein [Actinomycetota bacterium] diamond 519 152 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28559888 28559888 PRJNA401346_P_NODE_8387_length_202_cov_0.907801_g8366_i0 PRJNA401346 8387 202 0.907801 1.83375802 Streptomyces mobaraensis 35621 Bacteria Bacteria 43.5 0.00631   NR WP_351510981.1 35621 g8366 i0 41.9 0.638613861386139 43 25 63.9 0 175 47 89 131 WP_351510981.1 DUF2752 domain-containing protein [Streptomyces mobaraensis] diamond 129 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces mobaraensis
29285797 29285797 PRJNA401346_P_NODE_6849_length_207_cov_0.876712_g6828_i0 PRJNA401346 6849 207 0.876712 1.81479384 Nonomuraea roseola 46179 Bacteria Bacteria 42.4 0.024   NR GAA3470419.1 46179 g6828 i0 46.3 0.594202898550725 41 22 59.4 0 81 203 96 136 GAA3470419.1 hypothetical protein GCM10018965_049720 [Nonomuraea roseola] diamond 123 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea roseola

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