RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA764222" 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

  • PRJNA764222 · 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
6309883 6309883 PRJNA764222_S_NODE_9045_length_269_cov_5.274775_g8887_i0 PRJNA764222 9045 269 5.274775 14.18914475 Microbacterium esteraromaticum 57043 Bacteria Bacteria 175 1.05e-53   NR PYC99494.1 57043 g8887 i0 98.9 0.992565055762082 89 1 99.3 0 1 267 68 156 PYC99494.1 hypothetical protein B4U78_016800, partial [Microbacterium esteraromaticum] diamond 267 175 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
26768352 26768352 PRJNA764222_S_NODE_13781_length_240_cov_1.295337_g13623_i0 PRJNA764222 13781 240 1.295337 3.1088088 Cutibacterium acnes 1747 Bacteria Bacteria 52.4 4.65e-6   NR MES9280136.1 1747 g13623 i0 43.8 2.1125 80 41 97.5 3 7 240 60 137 MES9280136.1 reverse transcriptase domain-containing protein [Cutibacterium acnes] diamond 507 52.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27147606 27147606 PRJNA764222_S_NODE_10282_length_261_cov_1.878505_g10124_i0 PRJNA764222 10282 261 1.878505 4.90289805 Cutibacterium acnes 1747 Bacteria Bacteria 58.2 4.99e-9   NR MES6750617.1 1747 g10124 i0 48.4 0.71264367816092 62 25 63.2 1 27 191 4 65 MES6750617.1 hypothetical protein [Cutibacterium acnes] diamond 186 58.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27242815 27242815 PRJNA764222_S_NODE_8663_length_273_cov_1.150442_g8505_i0 PRJNA764222 8663 273 1.150442 3.14070666 Saccharopolyspora elongata 2530387 Bacteria Bacteria 40.8 0.0496   NR WP_132489592.1 2530387 g8505 i0 45.3 0.582417582417582 53 27 57.1 2 187 32 33 84 WP_132489592.1 hypothetical protein [Saccharopolyspora elongata] diamond 159 40.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Saccharopolyspora Saccharopolyspora elongata
27274505 27274505 PRJNA764222_S_NODE_10763_length_257_cov_4.600000_g10605_i0 PRJNA764222 10763 257 4.6 11.822 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 47.4 0.00103   NR MBM3808383.1 2080302 g10605 i0 36.8 0.88715953307393 76 37 75.9 3 241 47 195 270 MBM3808383.1 hypothetical protein [Acidimicrobiia bacterium] diamond 228 47.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
27306214 27306214 PRJNA764222_S_NODE_19623_length_211_cov_1.823171_g19465_i0 PRJNA764222 19623 211 1.823171 3.84689081 Streptomyces sp. NPDC 1931 Bacteria Bacteria 43.1 0.0183   NR WP_398314961.1 3365031 g19465 i0 30 0.995260663507109 70 45 93.8 2 14 211 165 234 WP_398314961.1 DNA/RNA non-specific endonuclease [Streptomyces sp. NPDC018026] diamond 210 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC018026
29484486 29484486 PRJNA764222_S_NODE_19990_length_209_cov_2.308642_g19832_i0 PRJNA764222 19990 209 2.308642 4.82506178 Nocardioides sp. 35761 Bacteria Bacteria 108 1.8499999999999999e-28   NR HEX8780462.1 35761 g19832 i0 75.4 0.990430622009569 69 17 99 0 209 3 75 143 HEX8780462.1 hypothetical protein [Nocardioides sp.] diamond 207 108 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp.
29683485 29683485 PRJNA764222_S_NODE_21890_length_201_cov_1.655844_g21732_i0 PRJNA764222 21890 201 1.655844 3.32824644 Actinomycetes 1760 Bacteria Bacteria 42.4 0.0292   NR HYP93838.1 1785 g21732 i0 40.7 1.65671641791045 54 29 80.6 1 6 167 295 345 HYP93838.1 hypothetical protein [Mycobacterium sp.] diamond 333 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
30210984 30210984 PRJNA764222_S_NODE_4772_length_313_cov_2.748120_g4614_i0 PRJNA764222 4772 313 2.74812 8.6016156 Streptomyces sp. 1931 Bacteria Bacteria 43.5 0.0405   NR WP_415940400.1 2789263 g4614 i0 72 0.23961661341853 25 7 24 0 120 194 160 184 WP_415940400.1 endonuclease/exonuclease/phosphatase family protein, partial [Streptomyces sp. 039-1] diamond 75 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. 039-1
30852677 30852677 PRJNA764222_S_NODE_5314_length_305_cov_5.189922_g5156_i0 PRJNA764222 5314 305 5.189922 15.8292621 Bacillati 1783272 Bacteria Bacteria 213 2.3199999999999994e-67   NR PYC99595.1 57043 g5156 i0 100 1.98688524590164 101 0 99.3 0 3 305 38 138 PYC99595.1 hypothetical protein B4U78_015940, partial [Microbacterium esteraromaticum] diamond 606 213 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium esteraromaticum
31032947 31032947 PRJNA764222_S_NODE_8235_length_276_cov_3.484716_g8077_i0 PRJNA764222 8235 276 3.484716 9.61781616 Nocardioides speluncae 2670337 Bacteria Bacteria 43.5 0.0289   NR WP_109507820.1 2670337 g8077 i0 33.3 0.91304347826087 84 41 88 4 25 267 313 384 WP_109507820.1 hypothetical protein [Nocardioides speluncae] diamond 252 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides speluncae
31158702 31158702 PRJNA764222_S_NODE_8775_length_272_cov_1.613333_g8617_i0 PRJNA764222 8775 272 1.613333 4.38826576 Nonomuraea cypriaca 1187855 Bacteria Bacteria 43.5 0.0267   NR WP_195898817.1 1187855 g8617 i0 35.5 0.683823529411765 62 40 68.4 0 67 252 256 317 WP_195898817.1 hypothetical protein [Nonomuraea cypriaca] diamond 186 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea cypriaca
32276035 32276035 PRJNA764222_S_NODE_24938_length_188_cov_2.645390_g24780_i0 PRJNA764222 24938 188 2.64539 4.9733332 root 1 Root_unresolved Root_unresolved 47.4 4.13e-4   NR MES8310468.1 1747 g24780 i0 57.6 2.63297872340426 33 14 52.7 0 152 54 304 336 MES8310468.1 hypothetical protein [Cutibacterium acnes] diamond 495 47.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32551243 32551243 PRJNA764222_S_NODE_25799_length_185_cov_1.811594_g25641_i0 PRJNA764222 25799 185 1.811594 3.3514489 Nocardia nova 37330 Bacteria Bacteria 40.8 0.0128   NR WP_267465073.1 37330 g25641 i0 39.6 0.778378378378378 48 29 77.8 0 145 2 8 55 WP_267465073.1 RBD-like domain-containing protein, partial [Nocardia nova] diamond 144 40.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia nova
32875440 32875440 PRJNA764222_S_NODE_17360_length_221_cov_3.683908_g17202_i0 PRJNA764222 17360 221 3.683908 8.14143668 root 1 Root_unresolved Root_unresolved 44.3 0.00453   NR MES6300509.1 1747 g17202 i0 63.9 5.37556561085973 36 12 47.5 1 219 115 61 96 MES6300509.1 reverse transcriptase domain-containing protein [Cutibacterium acnes] diamond 1188 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes

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