RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

31 rows where analysis = "diamond", bioproject = "PRJEB36940" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 31 ✖

tax_kingdom 1

bioproject 1

  • PRJEB36940 · 31 ✖

analysis 1

  • diamond · 31 ✖

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
7709239 7709239 PRJEB36940_P_NODE_8427_length_298_cov_1.991111_g8298_i0 PRJEB36940 8427 298 1.991111 5.93351078 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 144 6.119999999999998e-42   NR MCP3885490.1 2021380 g8298 i0 76.1 0.885906040268456 88 19 88.6 1 265 2 3 88 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 264 144 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
19182338 19182338 PRJEB36940_P_NODE_6816_length_330_cov_2.066148_g6687_i0 PRJEB36940 6816 330 2.066148 6.8182884 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 162 6.51e-49   NR MCP3885490.1 2021380 g6687 i0 75.8 0.9 99 24 90 0 299 3 3 101 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 297 162 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
26685012 26685012 PRJEB36940_P_NODE_5481_length_366_cov_1.283276_g5352_i0 PRJEB36940 5481 366 1.283276 4.69679016 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 50.8 5.21e-5   NR MBX9717869.1 1873462 g5352 i0 35.8 0.434426229508197 53 34 43.4 0 317 159 38 90 MBX9717869.1 hypothetical protein [Microbacteriaceae bacterium] diamond 159 50.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
26843641 26843641 PRJEB36940_P_NODE_12701_length_251_cov_0.876404_g12572_i0 PRJEB36940 12701 251 0.876404 2.19977404 Corynebacterium glucuronolyticum 39791 Bacteria Bacteria 150 3.839999999999999e-40   NR WP_236589323.1 39791 g12572 i0 89.2 0.99203187250996006 83 9 99.2 0 1 249 380 462 WP_236589323.1 DNA polymerase I [Corynebacterium glucuronolyticum] diamond 249 150 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium glucuronolyticum
27001452 27001452 PRJEB36940_P_NODE_12162_length_253_cov_1.288889_g12033_i0 PRJEB36940 12162 253 1.288889 3.26088917 Frankia umida 573489 Bacteria Bacteria 45.4 0.00458   NR WP_248827075.1 573489 g12033 i0 49 0.58102766798419 49 22 58.1 2 193 47 308 353 WP_248827075.1 hypothetical protein [Frankia umida] diamond 147 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae Frankia Frankia umida
27033268 27033268 PRJEB36940_P_NODE_15102_length_244_cov_0.912281_g14973_i0 PRJEB36940 15102 244 0.912281 2.22596564 unclassified Streptomyces 2593676 Bacteria Bacteria 48.9 1.15e-4   NR WP_351346055.1 2593676 g14973 i0 57.1 1.0327868852459 42 17 51.6 1 115 240 62 102 WP_351346055.1 MULTISPECIES: DUF3824 domain-containing protein [unclassified Streptomyces] diamond 252 48.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
27191242 27191242 PRJEB36940_P_NODE_9082_length_288_cov_2.316279_g8953_i0 PRJEB36940 9082 288 2.316279 6.67088352 Actinoplanes sp. NPDC 1871 Bacteria Bacteria 49.7 2.4e-4   NR WP_360988949.1 3154595 g8953 i0 42.6 0.708333333333333 68 39 70.8 0 5 208 331 398 WP_360988949.1 Calx-beta domain-containing protein [Actinoplanes sp. NPDC023801] diamond 204 49.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Actinoplanes Actinoplanes sp. NPDC023801
27317960 27317960 PRJEB36940_P_NODE_15643_length_243_cov_0.905882_g15514_i0 PRJEB36940 15643 243 0.905882 2.20129326 Raineyella sp. W15-4 3081651 Bacteria Bacteria 62 5.79e-9   NR WP_317837320.1 3081651 g15514 i0 68.2 0.54320987654321 44 14 54.3 0 111 242 1 44 WP_317837320.1 ClC family H(+)/Cl(-) exchange transporter [Raineyella sp. W15-4] diamond 132 62 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Raineyella Raineyella sp. W15-4
27507496 27507496 PRJEB36940_P_NODE_16363_length_230_cov_3.133758_g16234_i0 PRJEB36940 16363 230 3.133758 7.2076434 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 46.6 8.86e-4   NR HUE08590.1 2201156 g16234 i0 37 0.704347826086957 54 34 70.4 0 51 212 51 104 HUE08590.1 ML domain-containing protein [Acidimicrobiales bacterium] diamond 162 46.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
27538971 27538971 PRJEB36940_P_NODE_9664_length_281_cov_1.158654_g9535_i0 PRJEB36940 9664 281 1.158654 3.25581774 Gaiellales bacterium 2093372 Bacteria Bacteria 61.6 1.24e-8   NR HYX87382.1 2093372 g9535 i0 50.8 1.2491103202847 59 27 60.9 1 278 108 76 134 HYX87382.1 hypothetical protein [Gaiellales bacterium] diamond 351 61.6 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales     Gaiellales bacterium
27697121 27697121 PRJEB36940_P_NODE_6384_length_341_cov_1.044776_g6255_i0 PRJEB36940 6384 341 1.044776 3.56268616 Mycobacterium numidiamassiliense 1841861 Bacteria Bacteria 89.7 2.87e-18   NR WP_217348935.1 1841861 g6255 i0 45.8 1.80351906158358 96 52 84.5 0 47 334 277 372 WP_217348935.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Mycobacterium numidiamassiliense] diamond 615 89.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium numidiamassiliense
27760218 27760218 PRJEB36940_P_NODE_7444_length_317_cov_1.270492_g7315_i0 PRJEB36940 7444 317 1.270492 4.02745964 Thermoleophilia bacterium 2026888 Bacteria Bacteria 47.8 0.00122   NR MCX8032484.1 2026888 g7315 i0 31.6 0.747634069400631 79 45 72.9 2 233 3 23 94 MCX8032484.1 3-oxo-5-alpha-steroid 4-dehydrogenase [Thermoleophilia bacterium] diamond 237 47.8 1 Bacteria   Bacillati Actinomycetota Thermoleophilia       Thermoleophilia bacterium
27854574 27854574 PRJEB36940_P_NODE_1265_length_740_cov_2.278861_g1146_i0 PRJEB36940 1265 740 2.278861 16.8635714 Actinomycetota bacterium 2900548 Bacteria Bacteria 73.2 1.04e-10   NR MBS1889663.1 2900548 g1146 i0 32.8 1.58918918918919 131 83 53.1 2 406 14 705 830 MBS1889663.1 hypothetical protein [Actinomycetota bacterium] diamond 1176 73.2 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28075511 28075511 PRJEB36940_P_NODE_16265_length_234_cov_2.409938_g16136_i0 PRJEB36940 16265 234 2.409938 5.63925492 Eggerthellaceae bacterium 1972561 Bacteria Bacteria 45.4 0.00377   NR MBQ9691124.1 1972561 g16136 i0 37.1 0.794871794871795 62 38 79.5 1 216 31 44 104 MBQ9691124.1 hypothetical protein [Eggerthellaceae bacterium] diamond 186 45.4 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Eggerthellales Eggerthellaceae   Eggerthellaceae bacterium
28511136 28511136 PRJEB36940_P_NODE_12427_length_252_cov_0.871508_g12298_i0 PRJEB36940 12427 252 0.871508 2.19620016 Actinomycetes 1760 Bacteria Bacteria 120 5.059999999999999e-31   NR WP_055917743.1 1736341 g12298 i0 84.1 10.5 63 10 75 0 64 252 1 63 WP_055917743.1 aldo/keto reductase [Leifsonia sp. Leaf336] diamond 2646 120 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. Leaf336
28517756 28517756 PRJEB36940_P_NODE_5727_length_358_cov_1.589474_g5598_i0 PRJEB36940 5727 358 1.589474 5.69031692 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 99.8 9.37e-22   NR HXY28052.1 2201156 g5598 i0 44.9 1.9608938547486 118 63 97.2 2 356 9 132 249 HXY28052.1 hypothetical protein [Acidimicrobiales bacterium] diamond 702 99.8 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
28517758 28517758 PRJEB36940_P_NODE_6667_length_334_cov_0.892720_g6538_i0 PRJEB36940 6667 334 0.89272 2.9816848 Streptomyces sp. 13 442704 Bacteria Bacteria 42.7 0.0251   NR WP_143615944.1 2591006 g6538 i0 42.6 0.48502994011976 54 23 41.3 2 177 314 1 54 WP_143615944.1 hypothetical protein [Streptomyces sp. 130] diamond 162 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. 130
28826624 28826624 PRJEB36940_P_NODE_6688_length_333_cov_2.142308_g6559_i0 PRJEB36940 6688 333 2.142308 7.13388564 Kocuria 57493 Bacteria Bacteria 87.8 6.84e-18   NR WP_047687975.1 1339234 g6559 i0 51.8 2.37837837837838 83 39 73.9 1 78 323 6 88 WP_047687975.1 NAD(P)-dependent alcohol dehydrogenase [Kocuria sp. ZOR0020] diamond 792 87.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria sp. ZOR0020
29180918 29180918 PRJEB36940_P_NODE_12189_length_253_cov_0.866667_g12060_i0 PRJEB36940 12189 253 0.866667 2.19266751 Thermoleophilaceae bacterium 2732252 Bacteria Bacteria 90.5 6.56e-19   NR MBD0282516.1 2732252 g12060 i0 48.8 7.8498023715415 82 39 97.2 1 249 4 518 596 MBD0282516.1 phosphoenolpyruvate carboxykinase (GTP) [Thermoleophilaceae bacterium] diamond 1986 90.5 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Thermoleophilales Thermoleophilaceae   Thermoleophilaceae bacterium
29205962 29205962 PRJEB36940_P_NODE_3329_length_465_cov_1.336735_g3201_i0 PRJEB36940 3329 465 1.336735 6.21581775 Bacteria 2 Bacteria Bacteria 48.1 0.00236   NR WP_347955776.1 36820 g3201 i0 52.3 1.39354838709677 44 21 28.4 0 333 202 49 92 WP_347955776.1 CoA pyrophosphatase [Gordonia aichiensis] diamond 648 48.5 0.991752577319588 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia aichiensis
29773947 29773947 PRJEB36940_P_NODE_14391_length_246_cov_0.901734_g14262_i0 PRJEB36940 14391 246 0.901734 2.21826564 Bacteria 2 Bacteria Bacteria 127 3.919999999999999e-34   NR TPW10136.1 2024894 g14262 i0 76.3 1.85365853658537 76 18 92.7 0 246 19 204 279 TPW10136.1 MAG: hypothetical protein FD127_3883, partial [Acidimicrobiaceae bacterium] diamond 456 127 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Acidimicrobiaceae   Acidimicrobiaceae bacterium
30033441 30033441 PRJEB36940_P_NODE_11691_length_258_cov_1.529730_g11562_i0 PRJEB36940 11691 258 1.52973 3.9467034 Streptomyces viridosporus 67581 Bacteria Bacteria 107 3.98e-27   NR WP_081235542.1 67581 g11562 i0 57 3.8953488372093 86 36 100 1 258 1 74 158 WP_081235542.1 hypothetical protein [Streptomyces viridosporus] diamond 1005 107 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces viridosporus
30601913 30601913 PRJEB36940_P_NODE_10593_length_270_cov_1.365482_g10464_i0 PRJEB36940 10593 270 1.365482 3.6868014 Micromonosporaceae bacterium 1873464 Bacteria Bacteria 43.1 0.0197   NR HET8681271.1 1873464 g10464 i0 37 1.02222222222222 92 40 84.4 5 42 269 60 149 HET8681271.1 WhiB family transcriptional regulator [Micromonosporaceae bacterium] diamond 276 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae   Micromonosporaceae bacterium
30633441 30633441 PRJEB36940_P_NODE_15093_length_244_cov_0.912281_g14964_i0 PRJEB36940 15093 244 0.912281 2.22596564 Actinoplanes nipponensis 135950 Bacteria Bacteria 141 4.42e-41   NR WP_203763885.1 135950 g14964 i0 86.3 0.983606557377049 80 11 98.4 0 3 242 60 139 WP_203763885.1 Imm32 family immunity protein [Actinoplanes nipponensis] diamond 240 141 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Actinoplanes Actinoplanes nipponensis
30696716 30696716 PRJEB36940_P_NODE_1794_length_627_cov_4.178700_g1674_i0 PRJEB36940 1794 627 4.1787 26.200449 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 94.7 3.64e-19   NR HEV7885180.1 2586742 g1674 i0 30.7 2.51196172248804 179 114 84.7 2 39 569 139 309 HEV7885180.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 1575 94.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
30785030 30785030 PRJEB36940_P_NODE_12654_length_251_cov_1.280899_g12525_i0 PRJEB36940 12654 251 1.280899 3.21505649 root 1 Root_unresolved Root_unresolved 63.9 1.41e-9   NR WP_344537869.1 46160 g12525 i0 47.4 2.1394422310757 57 30 68.1 0 6 176 658 714 WP_344537869.1 beta-glucosidase family protein [Actinomadura fulvescens] diamond 537 63.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura fulvescens
30823181 30823181 PRJEB36940_P_NODE_10334_length_273_cov_1.355000_g10205_i0 PRJEB36940 10334 273 1.355 3.69915 Actinomycetota bacterium 2900548 Bacteria Bacteria 64.7 7.86e-10   NR MDQ4144637.1 2900548 g10205 i0 41 0.912087912087912 83 42 85.7 3 273 40 229 309 MDQ4144637.1 hypothetical protein [Actinomycetota bacterium] diamond 249 64.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30854755 30854755 PRJEB36940_P_NODE_12734_length_251_cov_0.876404_g12605_i0 PRJEB36940 12734 251 0.876404 2.19977404 Actinomycetota bacterium 2900548 Bacteria Bacteria 78.2 1.35e-14   NR MEM9606042.1 2900548 g12605 i0 60.3 2.98804780876494 63 23 75.3 1 62 250 37 97 MEM9606042.1 long-chain-acyl-CoA synthetase [Actinomycetota bacterium] diamond 750 78.2 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
30854758 30854758 PRJEB36940_P_NODE_15534_length_243_cov_0.911765_g15405_i0 PRJEB36940 15534 243 0.911765 2.21558895 Coriobacteriia bacterium 2052159 Bacteria Bacteria 43.5 0.0188   NR MCL2654093.1 2052159 g15405 i0 38 0.876543209876543 71 43 86.4 1 5 214 234 304 MCL2654093.1 HAMP domain-containing histidine kinase [Coriobacteriia bacterium] diamond 213 43.5 1 Bacteria   Bacillati Actinomycetota Coriobacteriia       Coriobacteriia bacterium
31645025 31645025 PRJEB36940_P_NODE_13857_length_248_cov_0.885714_g13728_i0 PRJEB36940 13857 248 0.885714 2.19657072 Plantactinospora sp. KBS5 1928616 Bacteria Bacteria 65.1 5.13e-10   NR WP_157756824.1 2024580 g13728 i0 59.3 0.653225806451613 54 22 65.3 0 162 1 86 139 WP_157756824.1 ABC transporter substrate-binding protein [Plantactinospora sp. KBS50] diamond 162 65.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Plantactinospora Plantactinospora sp. KBS50
32751605 32751605 PRJEB36940_P_NODE_15940_length_242_cov_0.917160_g15811_i0 PRJEB36940 15940 242 0.91716 2.2195272 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 142 8.12e-40   NR MCC6437400.1 2201156 g15811 i0 77.5 0.991735537190083 80 18 99.2 0 240 1 17 96 MCC6437400.1 hypothetical protein [Acidimicrobiales bacterium] diamond 240 142 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium

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