RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA506002" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA506002 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
26633889 26633889 PRJNA506002_S_NODE_5221_length_473_cov_5.532500_g4976_i0 PRJNA506002 5221 473 5.5325 26.168725 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 118 2.7199999999999997e-30   NR WP_411061857.1 3110112 g4976 i0 91 9.95137420718816 67 6 42.5 0 471 271 71 137 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 4707 119 0.991596638655462 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3
26982168 26982168 PRJNA506002_S_NODE_562_length_906_cov_32.662665_g401_i0 PRJNA506002 562 906 32.662665 295.9237449 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 249 1.5600000000000002e-79   NR WP_411061857.1 3110112 g401 i0 81.7 8.69205298013245 164 29 54.3 1 3 494 5 167 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 7875 251 0.99203187250996006 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3
27266782 27266782 PRJNA506002_S_NODE_723_length_823_cov_28.898667_g401_i1 PRJNA506002 723 823 28.898667 237.83602941 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 249 5.82e-80   NR WP_411061857.1 3110112 g401 i1 81.7 9.56865127582017 164 29 59.8 1 821 330 5 167 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 7875 251 0.99203187250996006 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3
27519479 27519479 PRJNA506002_S_NODE_52063_length_258_cov_0.854054_g51817_i0 PRJNA506002 52063 258 0.854054 2.20345932 Dactylosporangium siamense 685454 Bacteria Bacteria 40.8 0.0269   NR WP_380084923.1 685454 g51817 i0 84 0.290697674418605 25 4 29.1 0 176 102 2 26 WP_380084923.1 hypothetical protein, partial [Dactylosporangium siamense] diamond 75 40.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Dactylosporangium Dactylosporangium siamense
28087668 28087668 PRJNA506002_S_NODE_11045_length_400_cov_2.321101_g10799_i0 PRJNA506002 11045 400 2.321101 9.284404 Rothia mucilaginosa 43675 Bacteria Bacteria 259 6.18e-79   NR WP_314934045.1 43675 g10799 i0 97.7 0.975 130 3 97.5 0 392 3 658 787 WP_314934045.1 RNA-directed DNA polymerase [Rothia mucilaginosa] diamond 390 259 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Rothia Rothia mucilaginosa
28151131 28151131 PRJNA506002_S_NODE_49845_length_262_cov_0.846561_g49599_i0 PRJNA506002 49845 262 0.846561 2.21798982 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 43.5 0.0171   NR WP_411061857.1 3110112 g49599 i0 82.6 2.10687022900763 23 4 26.3 0 193 261 145 167 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 552 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3
28435170 28435170 PRJNA506002_S_NODE_48266_length_264_cov_5.701571_g48020_i0 PRJNA506002 48266 264 5.701571 15.05214744 Nakamurella endophytica 1748367 Bacteria Bacteria 68.9 2.23e-11   NR GGM12118.1 1748367 g48020 i0 94.1 0.772727272727273 34 2 38.6 0 263 162 311 344 GGM12118.1 (2Fe-2S) ferredoxin [Nakamurella endophytica] diamond 204 68.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Nakamurellales Nakamurellaceae Nakamurella Nakamurella endophytica
30614087 30614087 PRJNA506002_S_NODE_36193_length_291_cov_1.403670_g35947_i0 PRJNA506002 36193 291 1.40367 4.0846797 uncultured Jatrophihabitans sp. 1610747 Bacteria Bacteria 44.7 0.0139   NR WP_375491867.1 1610747 g35947 i0 34.6 0.536082474226804 52 32 53.6 1 204 49 309 358 WP_375491867.1 dolichyl-phosphate-mannose--protein mannosyltransferase [uncultured Jatrophihabitans sp.] diamond 156 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jatrophihabitantales Jatrophihabitantaceae Jatrophihabitans uncultured Jatrophihabitans sp.
30677251 30677251 PRJNA506002_S_NODE_6493_length_451_cov_2.269841_g6248_i0 PRJNA506002 6493 451 2.269841 10.23698291 Actinomycetota bacterium 2900548 Bacteria Bacteria 59.3 4.14e-7   NR TML99286.1 2900548 g6248 i0 36.9 0.738359201773836 111 60 70.5 5 439 122 175 280 TML99286.1 MAG: PQQ-like beta-propeller repeat protein, partial [Actinomycetota bacterium] diamond 333 59.3 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30961849 30961849 PRJNA506002_S_NODE_2174_length_588_cov_34.314563_g401_i2 PRJNA506002 2174 588 34.314563 201.76963044 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 246 5.26e-80   NR WP_411061857.1 3110112 g401 i2 88.2 11.7602040816327 144 17 73.5 0 586 155 5 148 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 6915 247 0.995951417004049 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3
31625670 31625670 PRJNA506002_S_NODE_936_length_755_cov_31.064516_g280_i6 PRJNA506002 936 755 31.064516 234.5370958 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 142 3.93e-38   NR WP_411061857.1 3110112 g280 i6 92.3 6.19867549668874 78 6 31 0 753 520 71 148 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 4680 142 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3
32480123 32480123 PRJNA506002_S_NODE_46479_length_268_cov_1.497436_g46233_i0 PRJNA506002 46479 268 1.497436 4.01312848 Piscicoccus intestinalis 746033 Bacteria Bacteria 43.5 0.0246   NR WP_068430052.1 746033 g46233 i0 43.9 1.15298507462687 41 23 45.9 0 45 167 205 245 WP_068430052.1 universal stress protein [Piscicoccus intestinalis] diamond 309 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermatophilaceae Piscicoccus Piscicoccus intestinalis
32575075 32575075 PRJNA506002_S_NODE_40839_length_280_cov_1.859903_g40593_i0 PRJNA506002 40839 280 1.859903 5.2077284 Streptomyces kaniharaensis 212423 Bacteria Bacteria 45.4 0.00469   NR WP_153470276.1 212423 g40593 i0 40.4 0.610714285714286 57 30 61.1 2 88 258 129 181 WP_153470276.1 hypothetical protein [Streptomyces kaniharaensis] diamond 171 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces kaniharaensis
32575076 32575076 PRJNA506002_S_NODE_42979_length_276_cov_0.822660_g42733_i0 PRJNA506002 42979 276 0.82266 2.2705416 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 47 0.00103   NR WP_411061857.1 3110112 g42733 i0 91.3 0.25 23 2 25 0 109 41 135 157 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 69 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. E11-3
32637543 32637543 PRJNA506002_S_NODE_2140_length_591_cov_3.893822_g1906_i0 PRJNA506002 2140 591 3.893822 23.01248802 Streptomyces sp. E11-3 3110112 Bacteria Bacteria 140 3.8099999999999996e-38   NR WP_411061857.1 3110112 g1906 i0 92.3 1.97969543147208 78 6 39.6 0 589 356 71 148 WP_411061857.1 hypothetical protein, partial [Streptomyces sp. E11-3] diamond 1170 140 1 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);;