RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA633835" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA633835 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
4431511 4431511 PRJNA633835_S_NODE_10204_length_249_cov_0.875000_g10136_i0 PRJNA633835 10204 249 0.875 2.17875 uncultured Rothia sp. 316088 Bacteria Bacteria 86.7 3.66e-20   NR WP_294498813.1 316088 g10136 i0 95.3 0.518072289156627 43 2 51.8 0 229 101 42 84 WP_294498813.1 hypothetical protein [uncultured Rothia sp.] diamond 129 86.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Rothia uncultured Rothia sp.
28975794 28975794 PRJNA633835_S_NODE_8948_length_257_cov_35.717391_g8880_i0 PRJNA633835 8948 257 35.717391 91.79369487 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 102 2.79e-25   NR WP_411061857.1 3110112 g8880 i0 92.5 16.6926070038911 53 4 61.9 0 257 99 96 148 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 4290 103 0.990291262135922 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3
30965779 30965779 PRJNA633835_S_NODE_12254_length_240_cov_5.107784_g12186_i0 PRJNA633835 12254 240 5.107784 12.2586816 Bifidobacterium animalis 28025 Bacteria Bacteria 136 4.209999999999999e-40   NR WP_367631614.1 28025 g12186 i0 91.8 2.85 73 6 91.3 0 240 22 5 77 WP_367631614.1 hypothetical protein, partial [Bifidobacterium animalis] diamond 684 136 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Bifidobacterium Bifidobacterium animalis
31091971 31091971 PRJNA633835_S_NODE_5715_length_298_cov_0.915556_g5647_i0 PRJNA633835 5715 298 0.915556 2.72835688 Gaiellaceae bacterium 2838783 Bacteria Bacteria 42 0.0117   NR HEX6700076.1 2838783 g5647 i0 45.9 0.37248322147651 37 20 37.2 0 114 4 12 48 HEX6700076.1 hypothetical protein [Gaiellaceae bacterium] diamond 111 42 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
31977459 31977459 PRJNA633835_S_NODE_7218_length_276_cov_1.699507_g7150_i0 PRJNA633835 7218 276 1.699507 4.69063932 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 115 5.26e-30   NR WP_411061857.1 3110112 g7150 i0 80.9 12.0108695652174 68 13 73.9 0 275 72 88 155 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 3315 116 0.991379310344828 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3

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