RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA1105232" 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

  • PRJNA1105232 · 18 ✖

analysis 1

  • blastn · 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
1487250 1487250 PRJNA1105232_S_NODE_13262_length_179_cov_1.600000_g13046_i0 PRJNA1105232 13262 179 1.6 2.864 Tessaracoccus palaemonis 2829499 Bacteria Bacteria 126 8.81e-25   NTclustered gi|2070850042|gb|CP079216.1| 2829499 g13046 i0 80.233 5.04469273743017 172 30 95 4 1 170 1160726 1160895 Tessaracoccus palaemonis strain J1M15 chromosome, complete genome blastn 903 126 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Tessaracoccus Tessaracoccus palaemonis
2295850 2295850 PRJNA1105232_S_NODE_9722_length_204_cov_2.535484_g9506_i0 PRJNA1105232 9722 204 2.535484 5.17238736 Cutibacterium 1912216 Bacteria Bacteria 366 5.599999999999998e-97   NTclustered gi|1446500593|gb|CP031442.1| 1747 g9506 i0 99.024 266.573529411765 205 1 100 1 1 204 55863 55659 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 54381 366 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
4039337 4039337 PRJNA1105232_S_NODE_13244_length_179_cov_2.000000_g13028_i0 PRJNA1105232 13244 179 2 3.58 Streptomyces sp. NBC_00857 2975851 Bacteria Bacteria 84.2 5.38e-12   NTclustered gi|2655540414|gb|CP108829.1| 2975851 g13028 i0 94.444 11.4469273743017 54 3 30 0 65 118 3622111 3622164 Streptomyces sp. NBC_00857 chromosome, complete genome blastn 2049 84.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_00857
4848437 4848437 PRJNA1105232_S_NODE_944_length_495_cov_3.347534_g732_i0 PRJNA1105232 944 495 3.347534 16.5702933 Rhodococcoides 3259750 Bacteria Bacteria 881 0   NTclustered gi|2637134465|gb|CP140264.1| 1828 g732 i0 98.788 396.321212121212 495 6 100 0 1 495 2529965 2530459 Rhodococcoides fascians strain GS01 chromosome, complete genome blastn 196179 881 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcoides Rhodococcoides fascians
7398199 7398199 PRJNA1105232_S_NODE_12426_length_184_cov_1.540741_g12210_i0 PRJNA1105232 12426 184 1.540741 2.83496344 Corynebacterium 1716 Bacteria Bacteria 86.1 1.55e-12   NTclustered gi|2099489108|gb|CP083646.1| 108486 g12210 i0 84.27 11.4347826086957 89 12 48 2 4 91 160636 160549 Corynebacterium falsenii strain FDAARGOS_1494 chromosome, complete genome blastn 2104 86.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium falsenii
7398206 7398206 PRJNA1105232_S_NODE_4586_length_274_cov_2.333333_g4370_i0 PRJNA1105232 4586 274 2.333333 6.39333242 Cutibacterium 1912216 Bacteria Bacteria 507 4.47e-139   NTclustered gi|1446500593|gb|CP031442.1| 1747 g4370 i0 100 270.244525547445 274 0 100 0 1 274 56884 57157 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 74047 507 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
9948583 9948583 PRJNA1105232_S_NODE_13988_length_175_cov_1.238095_g13772_i0 PRJNA1105232 13988 175 1.238095 2.16666625 Rhodococcus 1827 Bacteria Bacteria 318 1.32e-82   NTclustered gi|24210968|gb|AF544358.1| 152507 g13772 i0 99.429 103 175 1 100 0 1 175 313 487 Uncultured actinobacterium isolate D44 16S ribosomal RNA gene, partial sequence blastn 18025 318 1 Bacteria   Bacillati Actinomycetota Actinomycetes       uncultured Actinomycetes bacterium
12499245 12499245 PRJNA1105232_S_NODE_1770_length_392_cov_3.629738_g1554_i0 PRJNA1105232 1770 392 3.629738 14.22857296 Rhodococcus 1827 Bacteria Bacteria 725 0   NTclustered gi|2660106423|gb|CP138905.1| 1831 g1554 i0 100 405.18112244898 392 0 100 0 1 392 3355003 3354612 MAG: Rhodococcus sp. (in: high G+C Gram-positive bacteria) isolate 1088c chromosome blastn 158831 725 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. (in: high G+C Gram-positive bacteria)
14241406 14241406 PRJNA1105232_S_NODE_2272_length_359_cov_2.416129_g2056_i0 PRJNA1105232 2272 359 2.416129 8.67390311 Dermacoccus nishinomiyaensis 1274 Bacteria Bacteria 664 0   NTclustered gi|1966870119|gb|CP068484.1| 1274 g2056 i0 100 308.089136490251 359 0 100 0 1 359 128396 128754 Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome blastn 110604 664 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Dermacoccus Dermacoccus nishinomiyaensis
15048098 15048098 PRJNA1105232_S_NODE_14712_length_171_cov_1.885246_g14496_i0 PRJNA1105232 14712 171 1.885246 3.22377066 Cutibacterium 1912216 Bacteria Bacteria 311 2.14e-80   NTclustered gi|1446500593|gb|CP031442.1| 1747 g14496 i0 99.415 274.590643274854 171 1 100 0 1 171 56248 56078 Cutibacterium acnes strain KCOM 1315 chromosome, complete genome blastn 46955 311 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
15048116 15048116 PRJNA1105232_S_NODE_712_length_554_cov_3.722772_g504_i0 PRJNA1105232 712 554 3.722772 20.62415688 Nocardiaceae 85025 Bacteria Bacteria 955 0   NTclustered gi|2637134465|gb|CP140264.1| 1828 g504 i0 99.244 386.025270758123 529 4 95 0 1 529 1621711 1621183 Rhodococcoides fascians strain GS01 chromosome, complete genome blastn 213858 955 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcoides Rhodococcoides fascians
16322931 16322931 PRJNA1105232_S_NODE_5013_length_265_cov_1.662037_g4797_i0 PRJNA1105232 5013 265 1.662037 4.40439805 Micrococcus 1269 Bacteria Bacteria 484 2.0199999999999998e-132   NTclustered gi|1891023613|gb|CP058971.1| 1270 g4797 i0 99.623 286.664150943396 265 1 100 0 1 265 345797 346061 Micrococcus luteus strain V017 chromosome, complete genome blastn 75966 484 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
18871998 18871998 PRJNA1105232_S_NODE_7115_length_231_cov_1.027473_g6899_i0 PRJNA1105232 7115 231 1.027473 2.37346263 Corynebacterium 1716 Bacteria Bacteria 399 6.399999999999999e-107   NTclustered gi|1403572617|emb|LS483460.1| 38301 g6899 i0 97.845 374.922077922078 232 4 100 1 1 231 490737 490506 Corynebacterium minutissimum strain NCTC10288 genome assembly, chromosome: 1 blastn 86607 399 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium minutissimum
19338451 19338451 PRJNA1105232_S_NODE_7276_length_229_cov_1.155556_g7060_i0 PRJNA1105232 7276 229 1.155556 2.64622324 Streptomyces sp. BB1-1-1 3074430 Bacteria Bacteria 52.8 0.02   NTclustered gi|2578926657|gb|CP134203.1| 3074430 g7060 i0 100 0.122270742358079 28 0 12 0 159 186 4456821 4456794 Streptomyces sp. BB1-1-1 chromosome, complete genome blastn 28 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. BB1-1-1
20146770 20146770 PRJNA1105232_S_NODE_12276_length_185_cov_1.529412_g12060_i0 PRJNA1105232 12276 185 1.529412 2.8294122 Dermacoccus 57495 Bacteria Bacteria 342 8.369999999999999e-90   NTclustered gi|1966870119|gb|CP068484.1| 1274 g12060 i0 100 229.864864864865 185 0 100 0 1 185 126200 126384 Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome blastn 42525 342 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Dermacoccus Dermacoccus nishinomiyaensis
21889420 21889420 PRJNA1105232_S_NODE_7658_length_224_cov_1.674286_g7442_i0 PRJNA1105232 7658 224 1.674286 3.75040064 Rhodococcus sp. NBC_00294 2976004 Bacteria Bacteria 374 3.7399999999999986e-99   NTclustered gi|2659055393|gb|CP108043.1| 2976004 g7442 i0 96.875 397.571428571429 224 6 100 1 1 224 2179455 2179233 Rhodococcus sp. NBC_00294 chromosome, complete genome blastn 89056 374 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. NBC_00294
23164845 23164845 PRJNA1105232_S_NODE_13479_length_178_cov_1.209302_g13263_i0 PRJNA1105232 13479 178 1.209302 2.15255756 Homoserinibacter sp. YIM 151385 2985506 Bacteria Bacteria 189 1.1e-43   NTclustered gi|2428672229|gb|CP115175.1| 2985506 g13263 i0 95.763 111.044943820225 118 4 66 1 62 178 949516 949633 Homoserinibacter sp. YIM 151385 chromosome, complete genome blastn 19766 189 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Homoserinibacter Homoserinibacter sp. YIM 151385
23164885 23164885 PRJNA1105232_S_NODE_719_length_552_cov_3.330020_g511_i0 PRJNA1105232 719 552 3.33002 18.3817104 Dermacoccus nishinomiyaensis 1274 Bacteria Bacteria 948 0   NTclustered gi|1966870119|gb|CP068484.1| 1274 g511 i0 99.238 224.204710144928 525 4 95 0 1 525 127664 128188 Dermacoccus nishinomiyaensis strain FDAARGOS_1119 chromosome blastn 123761 948 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Dermacoccus Dermacoccus nishinomiyaensis

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