RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA664479" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA664479 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
1905263 1905263 PRJNA664479_S_NODE_18742_length_161_cov_0.910714_g18666_i0 PRJNA664479 18742 161 0.910714 1.46624954 Microlunatus 29404 Bacteria Bacteria 99.4 1.4100000000000001e-22   NR HYI55672.1 39595 g18666 i0 96.2 1.97515527950311 53 2 98.8 0 3 161 335 387 HYI55672.1 efflux RND transporter permease subunit [Microlunatus sp.] diamond 318 100 0.994 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Microlunatus Microlunatus sp.
8815248 8815248 PRJNA664479_S_NODE_15067_length_166_cov_0.871795_g14991_i0 PRJNA664479 15067 166 0.871795 1.4471797 Marmoricola sp. 1909296 Bacteria Bacteria 100 1.79e-23   NR HET7351026.1 1909296 g14991 i0 89.1 0.993975903614458 55 6 99.4 0 165 1 201 255 HET7351026.1 N-acetyl-gamma-glutamyl-phosphate reductase [Marmoricola sp.] diamond 165 100 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Marmoricola Marmoricola sp.
19756071 19756071 PRJNA664479_S_NODE_14496_length_167_cov_0.864407_g14420_i0 PRJNA664479 14496 167 0.864407 1.44355969 Nakamurella sp. 1869182 Bacteria Bacteria 95.9 8.73e-22   NR MEP6562322.1 1869182 g14420 i0 87.3 2.96407185628743 55 7 98.8 0 1 165 112 166 MEP6562322.1 phosphate ABC transporter permease PstA [Nakamurella sp.] diamond 495 95.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Nakamurellales Nakamurellaceae Nakamurella Nakamurella sp.
27018172 27018172 PRJNA664479_S_NODE_14722_length_167_cov_0.864407_g14646_i0 PRJNA664479 14722 167 0.864407 1.44355969 Mycobacterium kubicae 120959 Bacteria Bacteria 108 8.02e-28   NR WP_068159641.1 120959 g14646 i0 96.4 1.97604790419162 55 2 98.8 0 2 166 24 78 WP_068159641.1 ParA family protein [Mycobacterium kubicae] diamond 330 108 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium kubicae
28502648 28502648 PRJNA664479_S_NODE_15027_length_166_cov_0.871795_g14951_i0 PRJNA664479 15027 166 0.871795 1.4471797 Actinacidiphila acidipaludis 2873382 Bacteria Bacteria 42 0.0251   NR WP_222963454.1 2873382 g14951 i0 48 0.903614457831325 50 19 81.3 2 162 28 65 112 WP_222963454.1 DUF445 domain-containing protein [Actinacidiphila acidipaludis] diamond 150 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Actinacidiphila Actinacidiphila acidipaludis
28912831 28912831 PRJNA664479_S_NODE_17448_length_163_cov_0.894737_g17372_i0 PRJNA664479 17448 163 0.894737 1.45842131 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 67.4 2.54e-11   NR MCU0311140.1 2201156 g17372 i0 63 0.993865030674847 54 20 99.4 0 163 2 141 194 MCU0311140.1 SulP family inorganic anion transporter [Acidimicrobiales bacterium] diamond 162 67.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
29071163 29071163 PRJNA664479_S_NODE_18828_length_161_cov_0.910714_g18752_i0 PRJNA664479 18828 161 0.910714 1.46624954 Micrococcales bacterium 2026762 Bacteria Bacteria 97.8 7.700000000000001e-23   NR MDN5702711.1 2026762 g18752 i0 100 0.987577639751553 53 0 98.8 0 1 159 130 182 MDN5702711.1 NAD(P)-dependent oxidoreductase [Micrococcales bacterium] diamond 159 97.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales     Micrococcales bacterium
29638954 29638954 PRJNA664479_S_NODE_5810_length_225_cov_0.943182_g5734_i0 PRJNA664479 5810 225 0.943182 2.1221595 Streptomyces sp. NPDC 1931 Bacteria Bacteria 43.5 0.0155   NR WP_402602257.1 3366012 g5734 i0 38.9 0.72 54 25 72 1 214 53 156 201 WP_402602257.1 MFS transporter [Streptomyces sp. NPDC092296] diamond 162 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC092296
30018432 30018432 PRJNA664479_S_NODE_7311_length_208_cov_0.754717_g7235_i0 PRJNA664479 7311 208 0.754717 1.56981136 Phycicoccus sp. 1902410 Bacteria Bacteria 40 0.0374   NR HET7761415.1 1902410 g7235 i0 41.5 0.591346153846154 41 19 59.1 1 14 136 2 37 HET7761415.1 DUF2905 domain-containing protein [Phycicoccus sp.] diamond 123 40 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Phycicoccus Phycicoccus sp.
30397925 30397925 PRJNA664479_S_NODE_16753_length_164_cov_0.886957_g16677_i0 PRJNA664479 16753 164 0.886957 1.45460948 Actinomycetospora callitridis 913944 Bacteria Bacteria 89 1.57e-20   NR WP_274195460.1 913944 g16677 i0 90.6 0.969512195121951 53 5 97 0 5 163 113 165 WP_274195460.1 hypothetical protein [Actinomycetospora callitridis] diamond 159 89 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinomycetospora Actinomycetospora callitridis
30618500 30618500 PRJNA664479_S_NODE_16093_length_165_cov_0.862069_g16017_i0 PRJNA664479 16093 165 0.862069 1.42241385 Actinomycetota bacterium 2900548 Bacteria Bacteria 55.1 5.86e-7   NR MBE3094350.1 2900548 g16017 i0 53.8 1.89090909090909 52 24 94.5 0 159 4 244 295 MBE3094350.1 F0F1 ATP synthase subunit alpha [Actinomycetota bacterium] diamond 312 55.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30649959 30649959 PRJNA664479_S_NODE_12633_length_174_cov_0.912000_g12557_i0 PRJNA664479 12633 174 0.912 1.58688 Actinomycetota bacterium 2900548 Bacteria Bacteria 40.4 0.0428   NR MEL6984900.1 2900548 g12557 i0 39.5 0.655172413793103 38 23 65.5 0 33 146 70 107 MEL6984900.1 hypothetical protein [Actinomycetota bacterium] diamond 114 40.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30713350 30713350 PRJNA664479_S_NODE_15334_length_166_cov_0.871795_g15258_i0 PRJNA664479 15334 166 0.871795 1.4471797 Micrococcus lylae 1273 Bacteria Bacteria 67.8 1.95e-11   NR WP_180962190.1 1273 g15258 i0 64.8 0.975903614457831 54 18 95.8 1 166 8 262 315 WP_180962190.1 FtsK/SpoIIIE domain-containing protein [Micrococcus lylae] diamond 162 67.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus lylae
30820347 30820347 PRJNA664479_S_NODE_17934_length_162_cov_0.902655_g17858_i0 PRJNA664479 17934 162 0.902655 1.4623011 Promicromonosporaceae 85017 Bacteria Bacteria 54.7 6.45e-7   NR WP_079570262.1 526729 g17858 i0 96 7.40740740740741 25 1 46.3 0 86 160 1 25 WP_079570262.1 sugar phosphate nucleotidyltransferase [Krasilnikoviella flava] diamond 1200 54.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Promicromonosporaceae Krasilnikoviella Krasilnikoviella flava
30934667 30934667 PRJNA664479_S_NODE_14274_length_167_cov_1.135593_g14198_i0 PRJNA664479 14274 167 1.135593 1.89644031 Micrococcus cohnii 993416 Bacteria Bacteria 84.7 7.41e-19   NR WP_184242018.1 993416 g14198 i0 95.5 0.790419161676647 44 2 79 0 1 132 133 176 WP_184242018.1 SixA phosphatase family protein [Micrococcus cohnii] diamond 132 84.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus cohnii
30997824 30997824 PRJNA664479_S_NODE_18654_length_161_cov_0.910714_g18578_i0 PRJNA664479 18654 161 0.910714 1.46624954 Actinomyces sp. oral taxon 17 29317 Bacteria Bacteria 110 1.95e-26   NR WP_034514390.1 712117 g18578 i0 96.2 0.987577639751553 53 2 98.8 0 1 159 264 316 WP_034514390.1 hypothetical protein [Actinomyces sp. oral taxon 170] diamond 159 110 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces sp. oral taxon 170
31705493 31705493 PRJNA664479_S_NODE_18837_length_161_cov_0.910714_g18761_i0 PRJNA664479 18837 161 0.910714 1.46624954 Actinomycetes 1760 Bacteria Bacteria 75.1 3.07e-14   NR WP_007468405.1 286804 g18761 i0 64.2 14.8136645962733 53 19 98.8 0 159 1 227 279 WP_007468405.1 class 1b ribonucleoside-diphosphate reductase subunit beta [Segniliparus rugosus] diamond 2385 75.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Segniliparaceae Segniliparus Segniliparus rugosus
32263106 32263106 PRJNA664479_S_NODE_16678_length_164_cov_0.886957_g16602_i0 PRJNA664479 16678 164 0.886957 1.45460948 Rhodococcoides yunnanense 278209 Bacteria Bacteria 42 0.0233   NR WP_072801780.1 278209 g16602 i0 63.3 0.548780487804878 30 11 54.9 0 126 37 5 34 WP_072801780.1 MBL fold metallo-hydrolase [Rhodococcoides yunnanense] diamond 90 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcoides Rhodococcoides yunnanense

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