RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA690234" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 14 ✖

tax_kingdom 1

bioproject 1

  • PRJNA690234 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
26924251 26924251 PRJNA690234_P_NODE_25982_length_252_cov_0.865922_g25615_i0 PRJNA690234 25982 252 0.865922 2.18212344 Jiangella aurantiaca 2530373 Bacteria Bacteria 42.7 0.034   NR WP_132103968.1 2530373 g25615 i0 41.9 0.738095238095238 62 36 73.8 0 30 215 158 219 WP_132103968.1 DUF998 domain-containing protein [Jiangella aurantiaca] diamond 186 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jiangellales Jiangellaceae Jiangella Jiangella aurantiaca
26924253 26924253 PRJNA690234_P_NODE_31062_length_243_cov_0.917647_g30695_i0 PRJNA690234 31062 243 0.917647 2.22988221 Lawsonella clevelandensis 1528099 Bacteria Bacteria 127 3.59e-34   NR WP_303678770.1 1528099 g30695 i0 91.4 1 81 7 100 0 243 1 10 90 WP_303678770.1 HAD family hydrolase [Lawsonella clevelandensis] diamond 243 127 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
27050846 27050846 PRJNA690234_P_NODE_31502_length_242_cov_1.621302_g31135_i0 PRJNA690234 31502 242 1.621302 3.92355084 Nonomuraea sp. NPDC 1883105 Bacteria Bacteria 42 0.032   NR WP_357828315.1 3154919 g31135 i0 39.1 1.07851239669421 87 40 91.7 3 2 223 23 109 WP_357828315.1 hypothetical protein [Nonomuraea sp. NPDC046802] diamond 261 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp. NPDC046802
27303793 27303793 PRJNA690234_P_NODE_29123_length_246_cov_0.901734_g28756_i0 PRJNA690234 29123 246 0.901734 2.21826564 Humibacillus sp. 2290955 Bacteria Bacteria 43.1 0.0183   NR MEO7449135.1 2290955 g28756 i0 40.7 0.658536585365854 54 30 63.4 1 57 212 80 133 MEO7449135.1 vitamin K epoxide reductase family protein [Humibacillus sp.] diamond 162 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Intrasporangiaceae Humibacillus Humibacillus sp.
27714614 27714614 PRJNA690234_P_NODE_23444_length_262_cov_1.359788_g23077_i0 PRJNA690234 23444 262 1.359788 3.56264456 Labedella populi 2498850 Bacteria Bacteria 84.3 1.05e-16   NR RWZ64551.1 2498850 g23077 i0 51.7 4.96946564885496 87 37 99.6 1 261 1 360 441 RWZ64551.1 HNH endonuclease [Labedella populi] diamond 1302 84.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Labedella Labedella populi
27872035 27872035 PRJNA690234_P_NODE_24325_length_257_cov_0.847826_g23958_i0 PRJNA690234 24325 257 0.847826 2.17891282 Actinomycetota bacterium 2900548 Bacteria Bacteria 41.6 0.0381   NR MBM3714893.1 2900548 g23958 i0 36.5 0.735408560311284 63 34 66.5 2 37 207 52 114 MBM3714893.1 hypothetical protein [Actinomycetota bacterium] diamond 189 41.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28104380 28104380 PRJNA690234_P_NODE_20865_length_278_cov_1.000000_g20498_i0 PRJNA690234 20865 278 1 2.78 Streptomyces 1883 Bacteria Bacteria 43.9 0.0197   NR WP_328536739.1 2975720 g20498 i0 39.2 1.98561151079137 51 31 55 0 153 1 205 255 WP_328536739.1 hypothetical protein [Streptomyces sp. NBC_00344] diamond 552 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_00344
28566638 28566638 PRJNA690234_P_NODE_28427_length_247_cov_1.229885_g28060_i0 PRJNA690234 28427 247 1.229885 3.03781595 unclassified Actinoplanes 2626549 Bacteria Bacteria 43.5 0.0206   NR WP_364324654.1 2626549 g28060 i0 51.1 0.546558704453441 45 22 54.7 0 55 189 92 136 WP_364324654.1 MULTISPECIES: sensor histidine kinase [unclassified Actinoplanes] diamond 135 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Actinoplanes  
29482061 29482061 PRJNA690234_P_NODE_32030_length_242_cov_0.887574_g31663_i0 PRJNA690234 32030 242 0.887574 2.14792908 Lawsonella clevelandensis 1528099 Bacteria Bacteria 158 2.48e-45   NR PZP88937.1 1528099 g31663 i0 100 0.991735537190083 80 0 99.2 0 2 241 98 177 PZP88937.1 MAG: mycothiol synthase [Lawsonella clevelandensis] diamond 240 158 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
29734626 29734626 PRJNA690234_P_NODE_25510_length_252_cov_1.586592_g25143_i0 PRJNA690234 25510 252 1.586592 3.99821184 Lawsonella clevelandensis 1528099 Bacteria Bacteria 131 4.11e-34   NR WP_303678682.1 1528099 g25143 i0 95.2 0.988095238095238 83 4 98.8 0 251 3 69 151 WP_303678682.1 histidinol dehydrogenase [Lawsonella clevelandensis] diamond 249 131 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
30725695 30725695 PRJNA690234_P_NODE_19574_length_287_cov_0.869159_g19207_i0 PRJNA690234 19574 287 0.869159 2.49448633 Bacteria 2 Bacteria Bacteria 44.3 0.0174   NR WP_076478792.1 1344003 g19207 i0 39.6 1.04529616724739 53 27 50.2 1 111 254 341 393 WP_076478792.1 NADH-quinone oxidoreductase subunit NuoF [Williamsia sterculiae] diamond 300 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Williamsia Williamsia sterculiae
31282986 31282986 PRJNA690234_P_NODE_10795_length_388_cov_1.485714_g10429_i0 PRJNA690234 10795 388 1.485714 5.76457032 Actinomycetota bacterium 2900548 Bacteria Bacteria 64.7 2.58e-9   NR MCX6448414.1 2900548 g10429 i0 35.9 1.46134020618557 103 57 73.5 2 297 13 14 115 MCX6448414.1 CoA ester lyase [Actinomycetota bacterium] diamond 567 64.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32517137 32517137 PRJNA690234_P_NODE_25019_length_253_cov_1.061111_g24652_i0 PRJNA690234 25019 253 1.061111 2.68461083 Capillimicrobium sp. 2976761 Bacteria Bacteria 40.4 0.0427   NR HEU4657962.1 2976761 g24652 i0 40.4 0.616600790513834 52 29 59.3 1 216 67 16 67 HEU4657962.1 hypothetical protein [Capillimicrobium sp.] diamond 156 40.4 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Capillimicrobiaceae Capillimicrobium Capillimicrobium sp.
32548782 32548782 PRJNA690234_P_NODE_30839_length_243_cov_1.711765_g30472_i0 PRJNA690234 30839 243 1.711765 4.15958895 Trebonia sp. 2767075 Bacteria Bacteria 42.4 0.0487   NR WP_300610734.1 2767075 g30472 i0 44 0.617283950617284 50 25 61.7 1 242 93 283 329 WP_300610734.1 thiolase family protein [Trebonia sp.] diamond 150 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Treboniaceae Trebonia Trebonia sp.

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