RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA1001940" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 12 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1001940 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
9927461 9927461 PRJNA1001940_S_NODE_162228_length_170_cov_4.503937_g161174_i0 PRJNA1001940 162228 170 4.503937 7.6566929 Williamsia sp. DF 1872085 Bacteria Bacteria 112 3.3500000000000006e-27   NR WP_247208156.1 2934157 g161174 i0 100 0.988235294117647 56 0 98.8 0 3 170 6 61 WP_247208156.1 bifunctional 3-(3-hydroxy-phenyl)propionate/3-hydroxycinnamic acid hydroxylase [Williamsia sp. DF01-3] diamond 168 112 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Williamsia Williamsia sp. DF01-3
15027476 15027476 PRJNA1001940_S_NODE_85192_length_235_cov_2.994792_g84138_i0 PRJNA1001940 85192 235 2.994792 7.0377612 Actinomycetota bacterium 2900548 Bacteria Bacteria 108 9.6e-26   NR MDQ6716132.1 2900548 g84138 i0 60.3 0.995744680851064 78 31 99.6 0 234 1 343 420 MDQ6716132.1 UDP-glucose/GDP-mannose dehydrogenase family protein [Actinomycetota bacterium] diamond 234 108 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
19273623 19273623 PRJNA1001940_S_NODE_76676_length_248_cov_2.575610_g75622_i0 PRJNA1001940 76676 248 2.57561 6.3875128 Williamsia sp. D3 1313067 Bacteria Bacteria 166 5.82e-49   NR WP_023961249.1 1313067 g75622 i0 100 0.991935483870968 82 0 99.2 0 3 248 132 213 WP_023961249.1 A/G-specific adenine glycosylase [Williamsia sp. D3] diamond 246 166 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Williamsia Williamsia sp. D3
21824631 21824631 PRJNA1001940_S_NODE_60058_length_280_cov_1.772152_g59004_i0 PRJNA1001940 60058 280 1.772152 4.9620256 Marmoricola sp. 1909296 Bacteria Bacteria 137 2.22e-38   NR HET9500296.1 1909296 g59004 i0 71 2.98928571428571 93 27 99.6 0 280 2 50 142 HET9500296.1 hypothetical protein [Marmoricola sp.] diamond 837 137 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Marmoricola Marmoricola sp.
27950441 27950441 PRJNA1001940_S_NODE_168985_length_167_cov_1.548387_g167931_i0 PRJNA1001940 168985 167 1.548387 2.58580629 Williamsia sp. D3 1313067 Bacteria Bacteria 114 1.12e-27   NR WP_023960497.1 1313067 g167931 i0 96.4 0.988023952095808 55 2 98.8 0 167 3 591 645 WP_023960497.1 AAA domain-containing protein [Williamsia sp. D3] diamond 165 114 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Williamsia Williamsia sp. D3
28518836 28518836 PRJNA1001940_S_NODE_45047_length_320_cov_1.732852_g43993_i0 PRJNA1001940 45047 320 1.732852 5.5451264 Williamsia sp. D3 1313067 Bacteria Bacteria 167 4.51e-48   NR WP_023962072.1 1313067 g43993 i0 100 0.75 80 0 75 0 1 240 288 367 WP_023962072.1 SMP-30/gluconolactonase/LRE family protein [Williamsia sp. D3] diamond 240 167 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Williamsia Williamsia sp. D3
29276361 29276361 PRJNA1001940_S_NODE_36209_length_351_cov_3.568182_g35155_i0 PRJNA1001940 36209 351 3.568182 12.52431882 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 45.1 0.0201   NR HEX4539557.1 2201156 g35155 i0 36 0.735042735042735 86 42 67.5 2 82 318 164 243 HEX4539557.1 hypothetical protein [Acidimicrobiales bacterium] diamond 258 45.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
29837349 29837349 PRJNA1001940_S_NODE_140411_length_183_cov_1.714286_g139357_i0 PRJNA1001940 140411 183 1.714286 3.13714338 Bacillati 1783272 Bacteria Bacteria 122 2.2099999999999998e-32   NR PYC99595.1 57043 g139357 i0 100 1.9672131147541 60 0 98.4 0 182 3 103 162 PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum] diamond 360 122 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
30476872 30476872 PRJNA1001940_S_NODE_181973_length_161_cov_1.220339_g180919_i0 PRJNA1001940 181973 161 1.220339 1.96474579 Cutibacterium acnes 1747 Bacteria Bacteria 41.6 0.0313   NR MES6376112.1 1747 g180919 i0 43.1 0.950310559006211 51 27 91.3 1 2 148 265 315 MES6376112.1 reverse transcriptase family protein [Cutibacterium acnes] diamond 153 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
30595535 30595535 PRJNA1001940_S_NODE_194393_length_155_cov_1.741071_g193339_i0 PRJNA1001940 194393 155 1.741071 2.69866005 Actinomycetota 201174 Bacteria Bacteria 41.6 0.0289   NR WP_062772500.1 1609100 g193339 i0 42.6 2.59354838709677 47 27 91 0 13 153 308 354 WP_062772500.1 glutamate synthase-related protein [Streptomyces sp. NRRL S-1521] diamond 402 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NRRL S-1521
31670417 31670417 PRJNA1001940_S_NODE_191777_length_156_cov_2.539823_g190723_i0 PRJNA1001940 191777 156 2.539823 3.96212388 root 1 Root_unresolved Root_unresolved 75.9 1.02e-14   NR MES9346198.1 1747 g190723 i0 70.6 9.80769230769231 51 15 98.1 0 154 2 96 146 MES9346198.1 reverse transcriptase family protein [Cutibacterium acnes] diamond 1530 76.3 0.99475753604194 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
31772671 31772671 PRJNA1001940_S_NODE_110537_length_206_cov_1.969325_g109483_i0 PRJNA1001940 110537 206 1.969325 4.0568095 Microbacterium pumilum 344165 Bacteria Bacteria 42 0.0107   NR WP_344063947.1 344165 g109483 i0 36.5 1.45631067961165 52 27 75.7 2 171 16 21 66 WP_344063947.1 hypothetical protein [Microbacterium pumilum] diamond 300 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium pumilum

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