RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJNA222400" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJNA222400 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
11845761 11845761 PRJNA222400_P_NODE_2530_length_306_cov_6.315175_g2497_i0 PRJNA222400 2530 306 6.315175 19.3244355 Profundirhabdus halotolerans 2604685 Bacteria Bacteria 135 3.6e-39   NR MTV28656.1 2604685 g2497 i0 98.6 0.686274509803922 70 1 68.6 0 256 47 4 73 MTV28656.1 hypothetical protein [Profundirhabdus halotolerans] diamond 210 135 1 Bacteria   Bacillati Actinomycetota Nitriliruptoria Nitriliruptorales Nitriliruptoraceae Profundirhabdus Profundirhabdus halotolerans
16944520 16944520 PRJNA222400_P_NODE_754_length_600_cov_2.742287_g723_i0 PRJNA222400 754 600 2.742287 16.453722 Streptomyces endophyticus 714166 Bacteria Bacteria 132 8.17e-37   NR WP_326017364.1 714166 g723 i0 100 0.32 64 0 32 0 490 299 1 64 WP_326017364.1 hypothetical protein, partial [Streptomyces endophyticus] diamond 192 132 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces endophyticus
27881387 27881387 PRJNA222400_P_NODE_2865_length_280_cov_1.939394_g2832_i0 PRJNA222400 2865 280 1.939394 5.4303032 Bacteria 2 Bacteria Bacteria 146 7.539999999999998e-42   NR HJR39614.1 1871072 g2832 i0 68.5 12.8142857142857 92 29 98.6 0 5 280 42 133 HJR39614.1 peptide-methionine (S)-S-oxide reductase MsrA [Nocardioidaceae bacterium] diamond 3588 146 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae   Nocardioidaceae bacterium
27895130 27895130 PRJNA222400_P_NODE_8165_length_166_cov_0.888889_g8132_i0 PRJNA222400 8165 166 0.888889 1.47555574 Spirillospora sp. NPDC 2052479 Bacteria Bacteria 69.7 4.04e-12   NR WP_358409399.1 3155478 g8132 i0 57.4 1.95180722891566 54 23 97.6 0 4 165 2 55 WP_358409399.1 carboxylesterase/lipase family protein [Spirillospora sp. NPDC047279] diamond 324 69.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Spirillospora Spirillospora sp. NPDC047279
28684791 28684791 PRJNA222400_P_NODE_767_length_593_cov_1.806985_g736_i0 PRJNA222400 767 593 1.806985 10.71542105 Actinomycetota bacterium 2900548 Bacteria Bacteria 75.9 3.63e-12   NR MBW3555663.1 2900548 g736 i0 64.2 1.37099494097808 67 22 33.9 1 593 393 537 601 MBW3555663.1 transketolase [Actinomycetota bacterium] diamond 813 75.9 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29252666 29252666 PRJNA222400_P_NODE_3429_length_247_cov_1.449495_g3396_i0 PRJNA222400 3429 247 1.449495 3.58025265 Actinomycetes bacterium 1883427 Bacteria Bacteria 70.5 6.5e-12   NR MDO5286783.1 1883427 g3396 i0 47.3 2.61133603238866 74 39 89.9 0 24 245 404 477 MDO5286783.1 S8 family serine peptidase [Actinomycetes bacterium] diamond 645 70.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
29379240 29379240 PRJNA222400_P_NODE_6609_length_175_cov_1.015873_g6576_i0 PRJNA222400 6609 175 1.015873 1.77777775 Tessaracoccus sp. 1971211 Bacteria Bacteria 45.4 0.00169   NR MEZ5088053.1 1971211 g6576 i0 63.6 2.07428571428571 33 10 56.6 1 129 31 202 232 MEZ5088053.1 prolyl oligopeptidase family serine peptidase [Tessaracoccus sp.] diamond 363 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Tessaracoccus Tessaracoccus sp.
29979198 29979198 PRJNA222400_P_NODE_3311_length_253_cov_1.784314_g3278_i0 PRJNA222400 3311 253 1.784314 4.51431442 Streptomyces lannensis 766498 Bacteria Bacteria 41.2 0.0324   NR GAA3892282.1 766498 g3278 i0 34.7 0.889328063241107 75 43 88.9 2 227 3 5 73 GAA3892282.1 hypothetical protein GCM10022207_69960 [Streptomyces lannensis] diamond 225 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces lannensis
30042351 30042351 PRJNA222400_P_NODE_3111_length_265_cov_1.291667_g3078_i0 PRJNA222400 3111 265 1.291667 3.42291755 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 42.7 0.0485   NR HET9729942.1 2080302 g3078 i0 33.7 0.939622641509434 83 49 89.4 3 239 3 735 815 HET9729942.1 hypothetical protein [Acidimicrobiia bacterium] diamond 249 42.7 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
30421907 30421907 PRJNA222400_P_NODE_7773_length_167_cov_0.881356_g7740_i0 PRJNA222400 7773 167 0.881356 1.47186452 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 82.8 2.57e-18   NR MCP3885490.1 2021380 g7740 i0 77.1 1.76047904191617 48 11 86.2 0 22 165 3 50 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 294 82.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
30579265 30579265 PRJNA222400_P_NODE_833_length_564_cov_3.085437_g802_i0 PRJNA222400 833 564 3.085437 17.40186468 Streptomyces sp. NPDC1 1931 Bacteria Bacteria 211 1.29e-64   NR WP_403972386.1 3366109 g802 i0 72.1 3.62234042553191 136 35 72.3 2 562 155 180 312 WP_403972386.1 zinc metalloprotease [Streptomyces sp. NPDC101118] diamond 2043 211 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC101118
30628649 30628649 PRJNA222400_P_NODE_4093_length_220_cov_2.491228_g4060_i0 PRJNA222400 4093 220 2.491228 5.4807016 root 1 Root_unresolved Root_unresolved 59.7 1.78e-8   NR WP_013864343.1 29405 g4060 i0 57.1 8.03181818181818 56 23 76.4 1 39 206 9 63 WP_013864343.1 SDR family NAD(P)-dependent oxidoreductase [Microlunatus phosphovorus] diamond 1767 59.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Microlunatus Microlunatus phosphovorus
30800564 30800564 PRJNA222400_P_NODE_3194_length_260_cov_1.170616_g3161_i0 PRJNA222400 3194 260 1.170616 3.0436016 Mycobacterium tuberculosis 1773 Bacteria Bacteria 43.1 0.029   NR CNF55950.1 1773 g3161 i0 38.2 0.784615384615385 68 40 76.2 2 53 250 54 121 CNF55950.1 Uncharacterised protein [Mycobacterium tuberculosis] diamond 204 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
31369798 31369798 PRJNA222400_P_NODE_4416_length_211_cov_1.444444_g4383_i0 PRJNA222400 4416 211 1.444444 3.04777684 Brevibacterium sp. ACRRH 2918183 Bacteria Bacteria 75.9 1.48e-14   NR WP_239271111.1 2918183 g4383 i0 58.3 0.853080568720379 60 25 85.3 0 6 185 17 76 WP_239271111.1 enoyl-CoA hydratase [Brevibacterium sp. ACRRH] diamond 180 75.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium sp. ACRRH
31464677 31464677 PRJNA222400_P_NODE_4896_length_201_cov_1.605263_g4863_i0 PRJNA222400 4896 201 1.605263 3.22657863 Actinomycetota bacterium 2900548 Bacteria Bacteria 98.6 4.02e-22   NR MDQ4039554.1 2900548 g4863 i0 68.2 1.92537313432836 66 21 98.5 0 200 3 317 382 MDQ4039554.1 M20/M25/M40 family metallo-hydrolase [Actinomycetota bacterium] diamond 387 98.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31527823 31527823 PRJNA222400_P_NODE_2996_length_273_cov_1.120536_g2963_i0 PRJNA222400 2996 273 1.120536 3.05906328 Actinomycetota bacterium 2900548 Bacteria Bacteria 43.5 0.00536   NR MEX1046562.1 2900548 g2963 i0 34.1 0.967032967032967 88 50 92.3 3 271 20 5 88 MEX1046562.1 hypothetical protein [Actinomycetota bacterium] diamond 264 43.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31559554 31559554 PRJNA222400_P_NODE_6796_length_172_cov_1.788618_g6763_i0 PRJNA222400 6796 172 1.788618 3.07642296 Streptomyces katrae 68223 Bacteria Bacteria 40 0.0417   NR WP_237292424.1 68223 g6763 i0 47.6 0.732558139534884 42 21 71.5 1 3 125 60 101 WP_237292424.1 lamin tail domain-containing protein [Streptomyces katrae] diamond 126 40 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces katrae
31640305 31640305 PRJNA222400_P_NODE_7596_length_168_cov_0.873950_g7563_i0 PRJNA222400 7596 168 0.87395 1.468236 Bacillati 1783272 Bacteria Bacteria 50.1 3.46e-5   NR MEN6430923.1 2478480 g7563 i0 47.3 2.94642857142857 55 26 98.2 1 167 3 315 366 MEN6430923.1 citrate/2-methylcitrate synthase [Coriobacteriales bacterium] diamond 495 50.1 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales     Coriobacteriales bacterium
31956598 31956598 PRJNA222400_P_NODE_4777_length_204_cov_0.974194_g4744_i0 PRJNA222400 4777 204 0.974194 1.98735576 Actinomycetes 1760 Bacteria Bacteria 73.6 1.19e-14   NR HVE26076.1 65475 g4744 i0 51.5 4.94117647058824 68 29 100 1 204 1 48 111 HVE26076.1 peptide-methionine (R)-S-oxide reductase MsrB [Sporichthya sp.] diamond 1008 73.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Sporichthyales Sporichthyaceae Sporichthya Sporichthya sp.
32160595 32160595 PRJNA222400_P_NODE_3378_length_250_cov_1.034826_g3345_i0 PRJNA222400 3378 250 1.034826 2.587065 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 41.6 0.0142   NR HEY2285091.1 2339230 g3345 i0 43.5 0.744 62 32 70.8 2 200 24 8 69 HEY2285091.1 hypothetical protein [Streptosporangiaceae bacterium] diamond 186 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
32526585 32526585 PRJNA222400_P_NODE_8279_length_165_cov_1.344828_g8246_i0 PRJNA222400 8279 165 1.344828 2.2189662 root 1 Root_unresolved Root_unresolved 42.7 0.0134   NR HEX8067016.1 2732252 g8246 i0 33.3 3.92727272727273 54 36 98.2 0 4 165 179 232 HEX8067016.1 hypothetical protein [Thermoleophilaceae bacterium] diamond 648 43.1 0.990719257540603 Bacteria   Bacillati Actinomycetota Thermoleophilia Thermoleophilales Thermoleophilaceae   Thermoleophilaceae bacterium
32571944 32571944 PRJNA222400_P_NODE_5419_length_192_cov_1.958042_g5386_i0 PRJNA222400 5419 192 1.958042 3.7594406399999998 Nonomuraea maritima 683260 Bacteria Bacteria 41.2 0.0482   NR WP_090770336.1 683260 g5386 i0 38.7 0.96875 62 31 90.6 2 175 2 47 105 WP_090770336.1 C40 family peptidase [Nonomuraea maritima] diamond 186 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea maritima

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