RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA1237888" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1237888 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
1049756 1049756 PRJNA1237888_S_NODE_7281_length_163_cov_0.912281_g7231_i0 PRJNA1237888 7281 163 0.912281 1.48701803 Brachybacterium epidermidis 2781983 Bacteria Bacteria 104 1.3399999999999999e-25   NR WP_412019672.1 2781983 g7231 i0 92.6 0.993865030674847 54 4 99.4 0 1 162 19 72 WP_412019672.1 bifunctional hydroxymethylpyrimidine kinase/phosphomethylpyrimidine kinase [Brachybacterium epidermidis] diamond 162 104 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium epidermidis
1621300 1621300 PRJNA1237888_S_NODE_6082_length_169_cov_0.866667_g6032_i0 PRJNA1237888 6082 169 0.866667 1.46466723 Leifsonia sp. fls2-241-R2A-4 1870902 Bacteria Bacteria 113 2.63e-29   NR WP_285115130.1 3040290 g6032 i0 98.2 0.994082840236686 56 1 99.4 0 168 1 140 195 WP_285115130.1 hydrogen peroxide-dependent heme synthase [Leifsonia sp. fls2-241-R2A-40a] diamond 168 113 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. fls2-241-R2A-40a
11253108 11253108 PRJNA1237888_S_NODE_6789_length_165_cov_0.896552_g6739_i0 PRJNA1237888 6789 165 0.896552 1.4793108 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 57.8 6.24e-8   NR MET0146444.1 2497619 g6739 i0 59.3 0.981818181818182 54 22 98.2 0 2 163 338 391 MET0146444.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 162 57.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
15649660 15649660 PRJNA1237888_S_NODE_6853_length_165_cov_0.896552_g6803_i0 PRJNA1237888 6853 165 0.896552 1.4793108 Actinomyces sp. HMSC 29317 Bacteria Bacteria 105 3.98e-27   NR WP_286131160.1 1739406 g6803 i0 92.7 2 55 4 100 0 1 165 35 89 WP_286131160.1 hypothetical protein [Actinomyces sp. HMSC035G02] diamond 330 105 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces sp. HMSC035G02
27912692 27912692 PRJNA1237888_S_NODE_6405_length_167_cov_0.881356_g6355_i0 PRJNA1237888 6405 167 0.881356 1.47186452 Mycobacteroides 670516 Bacteria Bacteria 101 3.1499999999999995e-23   NR CPW90708.1 36809 g6355 i0 96.4 7.90419161676647 55 2 98.8 0 167 3 449 503 CPW90708.1 Hypothetical protein ERS075547_08931 [Mycobacteroides abscessus] diamond 1320 101 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides abscessus
28273436 28273436 PRJNA1237888_S_NODE_7226_length_163_cov_0.912281_g7176_i0 PRJNA1237888 7226 163 0.912281 1.48701803 Bifidobacterium bombi 471511 Bacteria Bacteria 42.7 0.0126   NR WP_044088114.1 471511 g7176 i0 42.2 6.6441717791411 45 25 82.8 1 147 13 249 292 WP_044088114.1 AbaSI family restriction endonuclease [Bifidobacterium bombi] diamond 1083 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Bifidobacterium Bifidobacterium bombi
29126351 29126351 PRJNA1237888_S_NODE_6669_length_166_cov_0.888889_g6619_i0 PRJNA1237888 6669 166 0.888889 1.47555574 Lawsonella 1847725 Bacteria Bacteria 105 1.28e-25   NR WP_290599322.1 1847725 g6619 i0 100 0.993975903614458 55 0 99.4 0 1 165 6 60 WP_290599322.1 MULTISPECIES: hypothetical protein [Lawsonella] diamond 165 105 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
29788976 29788976 PRJNA1237888_S_NODE_7471_length_162_cov_0.920354_g7421_i0 PRJNA1237888 7471 162 0.920354 1.49097348 Rothia kristinae 37923 Bacteria Bacteria 60.5 6.13e-10   NR WP_224799608.1 37923 g7421 i0 50 0.962962962962963 52 26 96.3 0 2 157 61 112 WP_224799608.1 hypothetical protein [Rothia kristinae] diamond 156 60.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Rothia Rothia kristinae
30104943 30104943 PRJNA1237888_S_NODE_6592_length_166_cov_0.888889_g6542_i0 PRJNA1237888 6592 166 0.888889 1.47555574 Microlunatus lacustris 88568 Bacteria Bacteria 94 3.51e-21   NR GAA1432589.1 88568 g6542 i0 92.6 0.975903614457831 54 4 97.6 0 3 164 220 273 GAA1432589.1 LCP family protein [Microlunatus lacustris] diamond 162 94 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Microlunatus Microlunatus lacustris
30691881 30691881 PRJNA1237888_S_NODE_7193_length_163_cov_0.912281_g7143_i0 PRJNA1237888 7193 163 0.912281 1.48701803 Gordonia 2053 Bacteria Bacteria 48.1 1.49e-4   NR HCS59105.1 84595 g7143 i0 82.6 1.69325153374233 23 4 42.3 0 6 74 307 329 HCS59105.1 forkhead-associated protein [Gordonia polyisoprenivorans] diamond 276 48.5 0.991752577319588 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia polyisoprenivorans
30831670 30831670 PRJNA1237888_S_NODE_6394_length_167_cov_1.169492_g6344_i0 PRJNA1237888 6394 167 1.169492 1.95305164 Umezawaea tangerina 84725 Bacteria Bacteria 42.4 0.0183   NR WP_106187718.1 84725 g6344 i0 50 0.610778443113772 34 17 61.1 0 55 156 342 375 WP_106187718.1 DUF5685 family protein [Umezawaea tangerina] diamond 102 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Umezawaea Umezawaea tangerina
31147270 31147270 PRJNA1237888_S_NODE_6115_length_169_cov_0.866667_g6065_i0 PRJNA1237888 6115 169 0.866667 1.46466723 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 45.8 0.00113   NR HLB22205.1 2586742 g6065 i0 75 0.568047337278107 32 7 56.8 1 74 169 63 93 HLB22205.1 sulfite exporter TauE/SafE family protein [Solirubrobacteraceae bacterium] diamond 96 45.8 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
32399719 32399719 PRJNA1237888_S_NODE_6999_length_164_cov_0.904348_g6949_i0 PRJNA1237888 6999 164 0.904348 1.48313072 Mycobacteroides 670516 Bacteria Bacteria 108 4.97e-27   NR WP_070917080.1 1774 g6949 i0 94.4 6.91463414634146 54 3 98.8 0 1 162 176 229 WP_070917080.1 mycofactocin-coupled SDR family oxidoreductase [Mycobacteroides chelonae] diamond 1134 109 0.990825688073395 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacteroides Mycobacteroides chelonae

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