RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA602115 · 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
28943430 28943430 PRJNA602115_P_NODE_11188_length_203_cov_0.901408_g11163_i0 PRJNA602115 11188 203 0.901408 1.82985824 Streptomyces sp. NBC_ 1931 Bacteria Bacteria 43.1 0.0159   NR WP_329376215.1 2903833 g11163 i0 51.4 1.0935960591133 37 16 51.7 1 48 152 69 105 WP_329376215.1 mannosyltransferase family protein [Streptomyces sp. NBC_01351] diamond 222 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_01351
30333196 30333196 PRJNA602115_P_NODE_7932_length_223_cov_1.185185_g7907_i0 PRJNA602115 7932 223 1.185185 2.64296255 unclassified Micromonospora 2617518 Bacteria Bacteria 48.1 3.28e-4   NR WP_377583842.1 2617518 g7907 i0 44.8 0.780269058295964 58 26 71.3 2 42 200 169 225 WP_377583842.1 MULTISPECIES: winged helix-turn-helix domain-containing protein [unclassified Micromonospora] diamond 174 48.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Micromonospora  
30616960 30616960 PRJNA602115_P_NODE_8793_length_209_cov_0.864865_g8768_i0 PRJNA602115 8793 209 0.864865 1.80756785 Streptomyces sp. Ag82_O1-15 1938855 Bacteria Bacteria 42 0.0445   NR WP_095850585.1 1938855 g8768 i0 38.7 0.889952153110048 62 35 87.6 2 2 184 384 443 WP_095850585.1 MBL fold metallo-hydrolase [Streptomyces sp. Ag82_O1-15] diamond 186 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. Ag82_O1-15
31312207 31312207 PRJNA602115_P_NODE_7895_length_224_cov_0.975460_g7870_i0 PRJNA602115 7895 224 0.97546 2.1850304 Williamsia serinedens 391736 Bacteria Bacteria 71.2 1.77e-14   NR MCP2159627.1 391736 g7870 i0 92.3 0.522321428571429 39 3 52.2 0 119 3 1 39 MCP2159627.1 hypothetical protein [Williamsia serinedens] diamond 117 71.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Williamsia Williamsia serinedens

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