RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJEB48872" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 25 ✖

tax_kingdom 1

bioproject 1

  • PRJEB48872 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
12837307 12837307 PRJEB48872_P_NODE_548851_length_180_cov_1.865248_g533039_i0 PRJEB48872 548851 180 1.865248 3.3574464 Winkia neuii 33007 Bacteria Bacteria 64.7 2.6200000000000003e-10   NR MDU2270241.1 33007 g533039 i0 68.3 6.6 63 14 95 1 180 10 3 65 MDU2270241.1 hypothetical protein [Winkia neuii] diamond 1188 64.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Winkia Winkia neuii
26906990 26906990 PRJEB48872_P_NODE_653082_length_158_cov_1.176471_g637270_i0 PRJEB48872 653082 158 1.176471 1.85882418 Phytoactinopolyspora endophytica 1642495 Bacteria Bacteria 41.6 0.0236   NR WP_129668897.1 1642495 g637270 i0 45 0.759493670886076 40 22 75.9 0 134 15 7 46 WP_129668897.1 hypothetical protein [Phytoactinopolyspora endophytica] diamond 120 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jiangellales Jiangellaceae Phytoactinopolyspora Phytoactinopolyspora endophytica
27026742 27026742 PRJEB48872_P_NODE_485562_length_198_cov_1.691824_g469750_i0 PRJEB48872 485562 198 1.691824 3.34981152 Nocardia 1817 Bacteria Bacteria 76.6 1.66e-14   NR WP_067697201.1 328049 g469750 i0 54.7 1.95454545454545 64 29 97 0 5 196 183 246 WP_067697201.1 RNA ligase (ATP) [Nocardia jejuensis] diamond 387 76.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia jejuensis
27033465 27033465 PRJEB48872_P_NODE_559322_length_178_cov_1.050360_g543510_i0 PRJEB48872 559322 178 1.05036 1.8696408 Lentzea terrae 2200761 Bacteria Bacteria 72.8 2.15e-13   NR WP_112274745.1 2200761 g543510 i0 65.5 5.89887640449438 58 20 97.8 0 1 174 91 148 WP_112274745.1 ornithine cyclodeaminase family protein [Lentzea terrae] diamond 1050 72.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Lentzea Lentzea terrae
27096663 27096663 PRJEB48872_P_NODE_443042_length_213_cov_1.091954_g427230_i0 PRJEB48872 443042 213 1.091954 2.32586202 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 41.6 0.0347   NR HET7722121.1 2201156 g427230 i0 33.8 0.957746478873239 68 38 85.9 2 199 17 55 122 HET7722121.1 GTP-binding protein [Acidimicrobiales bacterium] diamond 204 41.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
27532354 27532354 PRJEB48872_P_NODE_373883_length_243_cov_1.225490_g358071_i0 PRJEB48872 373883 243 1.22549 2.9779407 Bacteria 2 Bacteria Bacteria 44.7 0.0083   NR WP_393209404.1 47854 g358071 i0 42.2 1.77777777777778 45 26 55.6 0 13 147 400 444 WP_393209404.1 non-ribosomal peptide synthetase [Micromonospora chersina] diamond 432 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Micromonospora Micromonospora chersina
28139244 28139244 PRJEB48872_P_NODE_696325_length_150_cov_1.477477_g680513_i0 PRJEB48872 696325 150 1.477477 2.2162155 [Propionibacterium] namnetense SK182B-JCVI 1051006 Bacteria Bacteria 103 2.7999999999999998e-24   NR EGR95577.1 1051006 g680513 i0 100 0.98 49 0 98 0 2 148 209 257 EGR95577.1 DEAD/DEAH box helicase [ [[Propionibacterium] namnetense SK182B-JCVI] diamond 147 103 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium namnetense
28549634 28549634 PRJEB48872_P_NODE_318147_length_275_cov_1.512712_g302335_i0 PRJEB48872 318147 275 1.512712 4.159958 Streptomyces sp. P17 3074716 Bacteria Bacteria 165 2.93e-51   NR WP_315889329.1 3074716 g302335 i0 98.8 0.872727272727273 80 1 87.3 0 275 36 4 83 WP_315889329.1 hypothetical protein, partial [Streptomyces sp. P17] diamond 240 165 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. P17
28581126 28581126 PRJEB48872_P_NODE_618507_length_164_cov_2.336000_g602695_i0 PRJEB48872 618507 164 2.336 3.83104 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 75.1 4.77e-14   NR HVA18697.1 2586742 g602695 i0 61.8 1.00609756097561 55 20 98.8 1 162 1 111 165 HVA18697.1 IS66 family transposase [Solirubrobacteraceae bacterium] diamond 165 75.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
29654139 29654139 PRJEB48872_P_NODE_490890_length_196_cov_2.458599_g475078_i0 PRJEB48872 490890 196 2.458599 4.81885404 Nocardia cyriacigeorgica 135487 Bacteria Bacteria 47 6.34e-4   NR WP_163829273.1 135487 g475078 i0 56.8 0.566326530612245 37 16 56.6 0 196 86 315 351 WP_163829273.1 LLM class flavin-dependent oxidoreductase [Nocardia cyriacigeorgica] diamond 111 47 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia cyriacigeorgica
30191370 30191370 PRJEB48872_P_NODE_288552_length_296_cov_1.595331_g272740_i0 PRJEB48872 288552 296 1.595331 4.72217976 Streptomyces 1883 Bacteria Bacteria 53.5 9.17e-6   NR WP_277725811.1 1883 g272740 i0 45.6 0.577702702702703 57 31 57.8 0 125 295 5 61 WP_277725811.1 MULTISPECIES: alpha/beta fold hydrolase [Streptomyces] diamond 171 53.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
30216244 30216244 PRJEB48872_P_NODE_454632_length_208_cov_2.295858_g438820_i0 PRJEB48872 454632 208 2.295858 4.77538464 Actinomycetes 1760 Bacteria Bacteria 89 4.4e-19   NR WP_281689161.1 1848 g438820 i0 70.6 5.88461538461539 68 20 98.1 0 3 206 99 166 WP_281689161.1 leucyl aminopeptidase [Pseudonocardia thermophila] diamond 1224 89 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia Pseudonocardia thermophila
30318411 30318411 PRJEB48872_P_NODE_384272_length_238_cov_1.216080_g368460_i0 PRJEB48872 384272 238 1.21608 2.8942704 Antrihabitans cavernicola 2495913 Bacteria Bacteria 77.4 1.67e-14   NR WP_235916124.1 2495913 g368460 i0 66.7 32.5966386554622 54 18 68.1 0 227 66 303 356 WP_235916124.1 alkane 1-monooxygenase [Antrihabitans cavernicola] diamond 7758 77.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Antrihabitans Antrihabitans cavernicola
30854946 30854946 PRJEB48872_P_NODE_525794_length_186_cov_2.020408_g509982_i0 PRJEB48872 525794 186 2.020408 3.75795888 Actinomycetota bacterium 2900548 Bacteria Bacteria 42 0.0322   NR HCU93596.1 2900548 g509982 i0 34.5 1.62903225806452 55 34 85.5 1 17 175 36 90 HCU93596.1 FAD-dependent oxidoreductase [Actinomycetota bacterium] diamond 303 42 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30949932 30949932 PRJEB48872_P_NODE_684774_length_152_cov_1.451327_g668962_i0 PRJEB48872 684774 152 1.451327 2.20601704 Gaiellaceae bacterium 2838783 Bacteria Bacteria 75.1 7.77e-16   NR MFL5913074.1 2838783 g668962 i0 64.6 2.74342105263158 48 17 94.7 0 144 1 1 48 MFL5913074.1 VOC family protein [Gaiellaceae bacterium] diamond 417 75.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
31543873 31543873 PRJEB48872_P_NODE_455256_length_208_cov_1.775148_g439444_i0 PRJEB48872 455256 208 1.775148 3.69230784 Bacteria 2 Bacteria Bacteria 73.9 1.31e-13   NR HYO39498.1 1871072 g439444 i0 77.6 6.375 49 11 70.7 0 59 205 4 52 HYO39498.1 SDR family oxidoreductase [Nocardioidaceae bacterium] diamond 1326 74.3 0.994616419919246 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae   Nocardioidaceae bacterium
31543874 31543874 PRJEB48872_P_NODE_502876_length_193_cov_1.331169_g487064_i0 PRJEB48872 502876 193 1.331169 2.56915617 Bacteria 2 Bacteria Bacteria 82.4 2.03e-16   NR HXA11108.1 1785 g487064 i0 65.6 1.98963730569948 64 22 99.5 0 2 193 306 369 HXA11108.1 S8 family serine peptidase [Mycobacterium sp.] diamond 384 82.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
31866586 31866586 PRJEB48872_P_NODE_503597_length_193_cov_0.974026_g487785_i0 PRJEB48872 503597 193 0.974026 1.87987018 Micromonosporaceae bacterium 1873464 Bacteria Bacteria 42.7 0.0196   NR HLT09819.1 1873464 g487785 i0 63 0.419689119170984 27 10 42 0 83 163 38 64 HLT09819.1 response regulator transcription factor [Micromonosporaceae bacterium] diamond 81 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae   Micromonosporaceae bacterium
31898415 31898415 PRJEB48872_P_NODE_410077_length_226_cov_1.652406_g394265_i0 PRJEB48872 410077 226 1.652406 3.73443756 Motilibacteraceae bacterium 3069370 Bacteria Bacteria 42.4 0.0217   NR HEU4675776.1 3069370 g394265 i0 48 0.663716814159292 50 23 66.4 1 163 14 39 85 HEU4675776.1 YkgJ family cysteine cluster protein [Motilibacteraceae bacterium] diamond 150 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Motilibacterales Motilibacteraceae   Motilibacteraceae bacterium
32151560 32151560 PRJEB48872_P_NODE_452998_length_209_cov_1.476471_g437186_i0 PRJEB48872 452998 209 1.476471 3.08582439 Streptosporangiales bacterium 2604148 Bacteria Bacteria 57.8 1.11e-7   NR MQA84538.1 2604148 g437186 i0 68.2 0.631578947368421 44 13 63.2 1 75 206 21 63 MQA84538.1 hypothetical protein [Streptosporangiales bacterium] diamond 132 57.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales     Streptosporangiales bacterium
32246810 32246810 PRJEB48872_P_NODE_695998_length_150_cov_1.666667_g680186_i0 PRJEB48872 695998 150 1.666667 2.5000005 Virgisporangium aliadipatigenens 741659 Bacteria Bacteria 60.8 4.12e-9   NR WP_203905251.1 741659 g680186 i0 60 1 50 20 100 0 1 150 292 341 WP_203905251.1 RNA ligase (ATP) [Virgisporangium aliadipatigenens] diamond 150 60.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Virgisporangium Virgisporangium aliadipatigenens
32310042 32310042 PRJEB48872_P_NODE_526359_length_186_cov_1.680272_g510547_i0 PRJEB48872 526359 186 1.680272 3.12530592 Mycolicibacterium sp. 2320850 Bacteria Bacteria 71.2 6.68e-14   NR MBV8347302.1 2320850 g510547 i0 66 5.37096774193548 53 18 85.5 0 159 1 12 64 MBV8347302.1 acyl-CoA dehydrogenase [Mycolicibacterium sp.] diamond 999 71.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium sp.
32436607 32436607 PRJEB48872_P_NODE_601879_length_168_cov_1.271318_g586067_i0 PRJEB48872 601879 168 1.271318 2.13581424 Actinomadura lepetitiana 2126066 Bacteria Bacteria 104 6.4300000000000006e-27   NR NDU78753.1 2126066 g586067 i0 92.7 0.982142857142857 55 4 98.2 0 167 3 47 101 NDU78753.1 rhodanese-like domain-containing protein [Actinomadura lepetitiana] diamond 165 104 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura lepetitiana
32587893 32587893 PRJEB48872_P_NODE_686419_length_152_cov_1.265487_g670607_i0 PRJEB48872 686419 152 1.265487 1.92354024 Bacillati 1783272 Bacteria Bacteria 79.3 9.06e-16   NR WP_410169667.1 235986 g670607 i0 72 22.6973684210526 50 14 98.7 0 2 151 105 154 WP_410169667.1 AAA family ATPase [Actinacidiphila glaucinigra] diamond 3450 80.1 0.990012484394507 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Actinacidiphila Actinacidiphila glaucinigra
32846196 32846196 PRJEB48872_P_NODE_479420_length_200_cov_1.633540_g463608_i0 PRJEB48872 479420 200 1.63354 3.26708 Actinomycetospora chibensis 663606 Bacteria Bacteria 42.4 0.0281   NR WP_274187481.1 663606 g463608 i0 45.5 0.825 55 28 81 2 164 3 240 293 WP_274187481.1 F510_1955 family glycosylhydrolase [Actinomycetospora chibensis] diamond 165 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinomycetospora Actinomycetospora chibensis

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