RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA416866 · 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
419600 419600 PRJNA416866_P_NODE_1021_length_708_cov_4.897991_g886_i0 PRJNA416866 1021 708 4.897991 34.67777628 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 223 7.820000000000001e-71   NR MCP3885490.1 2021380 g886 i0 72.5 0.63135593220339 149 41 63.1 0 31 477 3 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 447 223 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
27455031 27455031 PRJNA416866_P_NODE_7523_length_236_cov_1.120000_g7379_i0 PRJNA416866 7523 236 1.12 2.6432 Actinobacteria bacterium RBG_16_7 2900548 Bacteria Bacteria 68.9 1.6e-11   NR OFW52635.1 1797205 g7379 i0 45.1 1.80508474576271 71 38 90.3 1 8 220 9 78 OFW52635.1 MAG: hypothetical protein A2V75_08425 [Actinobacteria bacterium RBG_16_70_17] diamond 426 68.9 1 Bacteria   Bacillati Actinomycetota         Actinobacteria bacterium RBG_16_70_17
27644481 27644481 PRJNA416866_P_NODE_4944_length_295_cov_1.094017_g4800_i0 PRJNA416866 4944 295 1.094017 3.22735015 Baekduia sp. 2600305 Bacteria Bacteria 43.5 0.0344   NR WP_327467491.1 2600305 g4800 i0 36.7 0.803389830508475 79 35 73.2 4 235 20 189 259 WP_327467491.1 ubiquinol-cytochrome c reductase iron-sulfur subunit [Baekduia sp.] diamond 237 43.5 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Baekduiaceae Baekduia Baekduia sp.
28102753 28102753 PRJNA416866_P_NODE_8285_length_224_cov_1.582822_g8141_i0 PRJNA416866 8285 224 1.582822 3.54552128 Bacillati 1783272 Bacteria Bacteria 61.6 6.41e-9   NR WP_207387496.1 1306540 g8141 i0 55.9 7.03125 59 26 79 0 3 179 447 505 WP_207387496.1 protein kinase domain-containing protein [Protofrankia symbiont of Coriaria myrtifolia] diamond 1575 61.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Frankiales Frankiaceae Protofrankia Protofrankia symbiont of Coriaria myrtifolia
28149544 28149544 PRJNA416866_P_NODE_2765_length_407_cov_3.393064_g2622_i0 PRJNA416866 2765 407 3.393064 13.80977048 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 75.5 4.81e-13   NR HEV7885180.1 2586742 g2622 i0 36.7 0.722358722358722 98 62 72.2 0 113 406 207 304 HEV7885180.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 294 75.5 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
28323802 28323802 PRJNA416866_P_NODE_8406_length_222_cov_2.080745_g8262_i0 PRJNA416866 8406 222 2.080745 4.6192539 PVC group 1783257 Bacteria Bacteria 48.5 2.65e-4   NR WP_093263124.1 35622 g8262 i0 53.7 4.35135135135135 41 19 55.4 0 183 61 15 55 WP_093263124.1 serine/threonine-protein kinase [Thermostaphylospora chromogena] diamond 966 48.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Thermostaphylospora Thermostaphylospora chromogena
28608094 28608094 PRJNA416866_P_NODE_7207_length_241_cov_1.777778_g7063_i0 PRJNA416866 7207 241 1.777778 4.28444498 root 1 Root_unresolved Root_unresolved 110 8.54e-27   NR WP_163768864.1 39692 g7063 i0 75.8 7.40663900414938 66 16 82.2 0 239 42 52 117 WP_163768864.1 NAD(P)-dependent alcohol dehydrogenase [Mycolicibacterium parafortuitum] diamond 1785 110 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium parafortuitum
28749361 28749361 PRJNA416866_P_NODE_7747_length_232_cov_1.812865_g7603_i0 PRJNA416866 7747 232 1.812865 4.2058468 Actinomycetota bacterium 2900548 Bacteria Bacteria 64.3 7.97e-10   NR MSW82988.1 2900548 g7603 i0 42.9 1.2801724137931 56 32 72.4 0 64 231 135 190 MSW82988.1 hypothetical protein [Actinomycetota bacterium] diamond 297 64.3 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29285962 29285962 PRJNA416866_P_NODE_3569_length_353_cov_1.534247_g3426_i0 PRJNA416866 3569 353 1.534247 5.41589191 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 62.8 3.22e-9   NR MDO4241565.1 1873462 g3426 i0 35.5 1.02832861189802 121 52 98.6 4 3 350 68 167 MDO4241565.1 adenylate kinase [Microbacteriaceae bacterium] diamond 363 62.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
29285965 29285965 PRJNA416866_P_NODE_4489_length_311_cov_1.308000_g4346_i0 PRJNA416866 4489 311 1.308 4.06788 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 52 1.11e-5   NR MBX9717869.1 1873462 g4346 i0 37.7 0.51125401929260506 53 33 51.1 0 236 78 38 90 MBX9717869.1 hypothetical protein [Microbacteriaceae bacterium] diamond 159 52 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
29822636 29822636 PRJNA416866_P_NODE_7591_length_235_cov_1.080460_g7447_i0 PRJNA416866 7591 235 1.08046 2.539081 Actinomadura sp. 1N219 3375152 Bacteria Bacteria 43.9 0.0132   NR WP_395980051.1 3375152 g7447 i0 36.1 0.919148936170213 72 46 91.9 0 8 223 256 327 WP_395980051.1 MFS transporter [Actinomadura sp. 1N219] diamond 216 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura sp. 1N219
30455091 30455091 PRJNA416866_P_NODE_10093_length_207_cov_0.876712_g9949_i0 PRJNA416866 10093 207 0.876712 1.81479384 Mycobacteriaceae bacterium 2448780 Bacteria Bacteria 64.7 3.75e-10   NR MBX9641612.1 2448780 g9949 i0 47.8 0.971014492753623 67 32 97.1 1 201 1 14 77 MBX9641612.1 TLD domain-containing protein [Mycobacteriaceae bacterium] diamond 201 64.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae   Mycobacteriaceae bacterium
30644145 30644145 PRJNA416866_P_NODE_10813_length_204_cov_1.678322_g10669_i0 PRJNA416866 10813 204 1.678322 3.42377688 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 87.8 1e-18   NR MDO9352533.1 2586742 g10669 i0 65.6 1.88235294117647 64 21 94.1 1 11 202 53 115 MDO9352533.1 Sir2 family NAD-dependent protein deacetylase [Solirubrobacteraceae bacterium] diamond 384 87.8 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
30644147 30644147 PRJNA416866_P_NODE_11333_length_203_cov_0.901408_g11189_i0 PRJNA416866 11333 203 0.901408 1.82985824 Actinomycetota bacterium 2900548 Bacteria Bacteria 42.4 0.0302   NR MDQ4010117.1 2900548 g11189 i0 39.7 0.931034482758621 63 32 93.1 2 8 196 37 93 MDQ4010117.1 phosphatase PAP2 family protein [Actinomycetota bacterium] diamond 189 42.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31592779 31592779 PRJNA416866_P_NODE_6356_length_258_cov_1.817259_g6212_i0 PRJNA416866 6356 258 1.817259 4.68852822 Actinoallomurus vinaceus 1080074 Bacteria Bacteria 49.7 1.69e-4   NR WP_345435951.1 1080074 g6212 i0 50 1.59302325581395 54 27 62.8 0 97 258 567 620 WP_345435951.1 amino acid adenylation domain-containing protein [Actinoallomurus vinaceus] diamond 411 49.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinoallomurus Actinoallomurus vinaceus
31798786 31798786 PRJNA416866_P_NODE_11477_length_202_cov_0.907801_g11333_i0 PRJNA416866 11477 202 0.907801 1.83375802 Bacteria 2 Bacteria Bacteria 60.1 1.4e-8   NR MFT6393132.1 1967498 g11333 i0 58.5 8.5990099009901 53 22 78.7 0 41 199 2 54 MFT6393132.1 NAD(P)-dependent dehydrogenase (short-subunit alcohol dehydrogenase family) [Ilumatobacter sp.] diamond 1737 60.1 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae Ilumatobacter Ilumatobacter sp.
31845508 31845508 PRJNA416866_P_NODE_7237_length_241_cov_0.822222_g7093_i0 PRJNA416866 7237 241 0.822222 1.98155502 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 57 5.83e-8   NR MBX9717869.1 1873462 g7093 i0 61.5 0.485477178423237 39 15 48.5 0 123 239 41 79 MBX9717869.1 hypothetical protein [Microbacteriaceae bacterium] diamond 117 57 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae bacterium
31940363 31940363 PRJNA416866_P_NODE_9637_length_209_cov_0.864865_g9493_i0 PRJNA416866 9637 209 0.864865 1.80756785 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 102 2.2399999999999998e-23   NR MCU1357160.1 2201156 g9493 i0 69.4 3.38755980861244 62 19 89 0 207 22 563 624 MCU1357160.1 primary-amine oxidase [Acidimicrobiales bacterium] diamond 708 102 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
31972130 31972130 PRJNA416866_P_NODE_6258_length_260_cov_1.628141_g6114_i0 PRJNA416866 6258 260 1.628141 4.2331666 Streptomyces sp. NPDC 1931 Bacteria Bacteria 42.7 0.0473   NR WP_403467419.1 3366069 g6114 i0 36 0.865384615384615 75 46 86.5 2 3 227 119 191 WP_403467419.1 SAV_2336 N-terminal domain-related protein [Streptomyces sp. NPDC096013] diamond 225 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC096013
32083696 32083696 PRJNA416866_P_NODE_4858_length_298_cov_1.628692_g4714_i0 PRJNA416866 4858 298 1.628692 4.85350216 Bacteria candidate phyla 1783234 Bacteria Bacteria 87.8 1.02e-17   NR HEY2197241.1 1785 g4714 i0 51.2 9.59395973154362 86 42 86.6 0 260 3 425 510 HEY2197241.1 NHL repeat-containing protein [Mycobacterium sp.] diamond 2859 88.6 0.99097065462754 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
32193756 32193756 PRJNA416866_P_NODE_9878_length_208_cov_0.870748_g9734_i0 PRJNA416866 9878 208 0.870748 1.81115584 Nocardioides sp. 35761 Bacteria Bacteria 65.1 2.91e-10   NR WP_324499474.1 35761 g9734 i0 50.7 0.966346153846154 67 25 96.6 1 1 201 103 161 WP_324499474.1 hypothetical protein [Nocardioides sp.] diamond 201 65.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides sp.
32621300 32621300 PRJNA416866_P_NODE_3180_length_376_cov_7.361905_g3037_i0 PRJNA416866 3180 376 7.361905 27.6807628 Streptomyces 1883 Bacteria Bacteria 43.5 0.04   NR WP_260634659.1 285578 g3037 i0 48.6 0.558510638297872 35 15 27.9 1 223 119 129 160 WP_260634659.1 hypothetical protein [Streptomyces angustmyceticus] diamond 210 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces angustmyceticus
32762231 32762231 PRJNA416866_P_NODE_2000_length_485_cov_1.478774_g1858_i0 PRJNA416866 2000 485 1.478774 7.1720539 Branchiibius hedensis 672460 Bacteria Bacteria 117 1.9000000000000003e-28   NR WP_172461504.1 672460 g1858 i0 68.8 0.977319587628866 80 25 49.5 0 35 274 260 339 WP_172461504.1 alcohol dehydrogenase AdhP [Branchiibius hedensis] diamond 474 117 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Branchiibius Branchiibius hedensis
32856637 32856637 PRJNA416866_P_NODE_5080_length_291_cov_1.113043_g4936_i0 PRJNA416866 5080 291 1.113043 3.23895513 Thermoleophilaceae bacterium 2732252 Bacteria Bacteria 43.1 0.0497   NR MBJ7347507.1 2732252 g4936 i0 46 0.515463917525773 50 24 50.5 2 223 77 1042 1089 MBJ7347507.1 hypothetical protein [Thermoleophilaceae bacterium] diamond 150 43.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Thermoleophilales Thermoleophilaceae   Thermoleophilaceae bacterium
32888015 32888015 PRJNA416866_P_NODE_3500_length_358_cov_1.292929_g3357_i0 PRJNA416866 3500 358 1.292929 4.62868582 Microbacteriaceae bacterium 1873462 Bacteria Bacteria 46.2 0.00266   NR MBX9717869.1 1873462 g3357 i0 42.9 0.35195530726257 42 24 35.2 0 128 3 40 81 MBX9717869.1 hypothetical protein [Microbacteriaceae bacterium] diamond 126 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae   Microbacteriaceae 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);;