RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA784298" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA784298 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
4593656 4593656 PRJNA784298_P_NODE_25904_length_244_cov_0.900585_g25703_i0 PRJNA784298 25904 244 0.900585 2.1974274 Microbacterium 33882 Bacteria Bacteria 147 3.18e-41   NR WP_081768083.1 1451261 g25703 i0 93.8 1.9672131147541 80 5 98.4 0 242 3 77 156 WP_081768083.1 IS30 family transposase [Microbacterium sp. MRS-1] diamond 480 148 0.993243243243243 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. MRS-1
24991813 24991813 PRJNA784298_P_NODE_23760_length_251_cov_0.865169_g23559_i0 PRJNA784298 23760 251 0.865169 2.17157419 Marmoricola sp. 1909296 Bacteria Bacteria 138 8.97e-38   NR MCW2760197.1 1909296 g23559 i0 83.1 1.9840637450199201 83 14 99.2 0 249 1 83 165 MCW2760197.1 drrA 4 [Marmoricola sp.] diamond 498 138 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Marmoricola Marmoricola sp.
26705211 26705211 PRJNA784298_P_NODE_22161_length_261_cov_0.925532_g21960_i0 PRJNA784298 22161 261 0.925532 2.41563852 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 142 3.59e-39   NR MCU1357911.1 2201156 g21960 i0 72.1 19.6551724137931 86 24 98.9 0 2 259 190 275 MCU1357911.1 hypothetical protein [Acidimicrobiales bacterium] diamond 5130 142 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
26999469 26999469 PRJNA784298_P_NODE_23362_length_253_cov_0.983333_g23161_i0 PRJNA784298 23362 253 0.983333 2.48783249 FCB group 1783270 Bacteria Bacteria 164 3.06e-49   NR WP_344397402.1 114695 g23161 i0 97.6 1.99209486166008 84 2 99.6 0 1 252 52 135 WP_344397402.1 helix-turn-helix domain-containing protein, partial [Streptomyces asiaticus] diamond 504 164 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
27148023 27148023 PRJNA784298_P_NODE_24982_length_247_cov_0.885057_g24781_i0 PRJNA784298 24982 247 0.885057 2.18609079 Nocardioides sp. 35761 Bacteria Bacteria 136 1.3e-35   NR HET6938384.1 35761 g24781 i0 80.2 3.98380566801619 81 15 98.4 1 4 246 359 438 HET6938384.1 phospholipase D-like domain-containing protein [Nocardioides sp.] diamond 984 136 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp.
27884160 27884160 PRJNA784298_P_NODE_26505_length_242_cov_0.911243_g26304_i0 PRJNA784298 26505 242 0.911243 2.20520806 PVC group 1783257 Bacteria Bacteria 42.4 0.0497   NR MDE2409429.1 1911520 g26304 i0 31.7 2.81404958677686 60 37 69.4 1 68 235 152 211 MDE2409429.1 DHA2 family efflux MFS transporter permease subunit [Actinomycetales bacterium] diamond 681 42.7 0.992974238875878 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales     Actinomycetales bacterium
28042133 28042133 PRJNA784298_P_NODE_24465_length_248_cov_1.948571_g24264_i0 PRJNA784298 24465 248 1.948571 4.83245608 FCB group 1783270 Bacteria Bacteria 165 1.27e-50   NR WP_344397525.1 114695 g24264 i0 95.1 1.98387096774194 82 4 99.2 0 246 1 34 115 WP_344397525.1 S-adenosylmethionine:tRNA ribosyltransferase-isomerase, partial [Streptomyces asiaticus] diamond 492 165 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
28294591 28294591 PRJNA784298_P_NODE_13426_length_341_cov_0.876866_g13225_i0 PRJNA784298 13426 341 0.876866 2.99011306 FCB group 1783270 Bacteria Bacteria 228 2.0599999999999993e-74   NR WP_344397295.1 114695 g13225 i0 97.3 1.98826979472141 113 3 99.4 0 341 3 5 117 WP_344397295.1 twin-arginine translocation signal domain-containing protein, partial [Streptomyces asiaticus] diamond 678 228 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
29548140 29548140 PRJNA784298_P_NODE_20070_length_275_cov_5.108911_g19869_i0 PRJNA784298 20070 275 5.108911 14.04950525 Streptomyces asiaticus 114695 Bacteria Bacteria 102 1.63e-26   NR GAA0914133.1 114695 g19869 i0 86 0.621818181818182 57 8 62.2 0 265 95 1 57 GAA0914133.1 hypothetical protein GCM10009574_101920 [Streptomyces asiaticus] diamond 171 102 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
29873411 29873411 PRJNA784298_P_NODE_20211_length_274_cov_3.000000_g20010_i0 PRJNA784298 20211 274 3 8.22 FCB group 1783270 Bacteria Bacteria 179 8.56e-56   NR WP_344397439.1 114695 g20010 i0 100 1.99270072992701 91 0 99.6 0 1 273 37 127 WP_344397439.1 hypothetical protein, partial [Streptomyces asiaticus] diamond 546 179 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
30622215 30622215 PRJNA784298_P_NODE_23813_length_251_cov_0.853933_g23612_i0 PRJNA784298 23813 251 0.853933 2.14337183 Streptomyces sp. MMG1533 1415546 Bacteria Bacteria 45.1 0.00643   NR WP_053754403.1 1415546 g23612 i0 33.7 1.0996015936255 92 40 89.6 4 248 24 760 847 WP_053754403.1 caspase, EACC1-associated type [Streptomyces sp. MMG1533] diamond 276 45.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. MMG1533
30685413 30685413 PRJNA784298_P_NODE_24373_length_249_cov_0.875000_g24172_i0 PRJNA784298 24373 249 0.875 2.17875 Frankiales bacterium 1909291 Bacteria Bacteria 43.1 0.0305   NR MCW2540481.1 1909291 g24172 i0 36.1 0.734939759036145 61 36 73.5 1 231 49 240 297 MCW2540481.1 helicase [Frankiales bacterium] diamond 183 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales     Frankiales bacterium
31254274 31254274 PRJNA784298_P_NODE_16175_length_309_cov_1.254237_g15974_i0 PRJNA784298 16175 309 1.254237 3.87559233 Actinocrinis sp. 1920516 Bacteria Bacteria 44.3 0.0179   NR HEU5426675.1 1920516 g15974 i0 45.5 0.533980582524272 55 26 51.5 2 27 185 127 179 HEU5426675.1 methyltransferase domain-containing protein [Actinocrinis sp.] diamond 165 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Catenulisporales Actinospicaceae Actinocrinis Actinocrinis sp.
32212707 32212707 PRJNA784298_P_NODE_18958_length_284_cov_1.459716_g18757_i0 PRJNA784298 18958 284 1.459716 4.14559344 Streptomyces 1883 Bacteria Bacteria 44.3 0.0176   NR WP_189970192.1 67381 g18757 i0 50 3.38028169014085 40 20 42.3 0 11 130 497 536 WP_189970192.1 FxSxx-COOH system tetratricopeptide repeat protein [Streptomyces violascens] diamond 960 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces violascens
32330210 32330210 PRJNA784298_P_NODE_11479_length_370_cov_0.912458_g11278_i0 PRJNA784298 11479 370 0.912458 3.3760946 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 44.7 0.00684   NR HEX3693270.1 2586742 g11278 i0 36.5 0.510810810810811 63 37 48.6 1 241 62 26 88 HEX3693270.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 189 44.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
32497589 32497589 PRJNA784298_P_NODE_21539_length_265_cov_1.203125_g21338_i0 PRJNA784298 21539 265 1.203125 3.18828125 FCB group 1783270 Bacteria Bacteria 61.6 1.32e-9   NR WP_344397439.1 114695 g21338 i0 96.8 0.70188679245283 31 1 35.1 0 1 93 113 143 WP_344397439.1 hypothetical protein, partial [Streptomyces asiaticus] diamond 186 61.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus

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