RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA1103784" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 16 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1103784 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
7397982 7397982 PRJNA1103784_P_NODE_7706_length_241_cov_1.785714_g7651_i0 PRJNA1103784 7706 241 1.785714 4.30357074 Arthrobacter russicus 172040 Bacteria Bacteria 156 1.4e-43   NR WP_309797000.1 172040 g7651 i0 97.5 0.983402489626556 79 2 98.3 0 3 239 302 380 WP_309797000.1 mycothione reductase [Arthrobacter russicus] diamond 237 156 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter russicus
27352404 27352404 PRJNA1103784_P_NODE_6243_length_248_cov_0.880000_g6188_i0 PRJNA1103784 6243 248 0.88 2.1824 Microbacterium sp. LCT-H2 1914306 Bacteria Bacteria 156 3.69e-45   NR WP_071330048.1 1914306 g6188 i0 85.4 0.991935483870968 82 12 99.2 0 1 246 9 90 WP_071330048.1 endonuclease/exonuclease/phosphatase family protein [Microbacterium sp. LCT-H2] diamond 246 156 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. LCT-H2
28078314 28078314 PRJNA1103784_P_NODE_7625_length_242_cov_0.911243_g7570_i0 PRJNA1103784 7625 242 0.911243 2.20520806 Prescottella equi 43767 Bacteria Bacteria 140 3.39e-38   NR NKS38102.1 43767 g7570 i0 82.5 1.98347107438017 80 14 99.2 0 2 241 235 314 NKS38102.1 hypothetical protein [Prescottella equi] diamond 480 140 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Prescottella Prescottella equi
28425834 28425834 PRJNA1103784_P_NODE_4686_length_268_cov_1.548718_g4631_i0 PRJNA1103784 4686 268 1.548718 4.15056424 Corynebacterium suicordis 203264 Bacteria Bacteria 109 1.5999999999999998e-25   NR WP_194556289.1 203264 g4631 i0 100 0.559701492537313 50 0 56 0 1 150 518 567 WP_194556289.1 DEAD/DEAH box helicase [Corynebacterium suicordis] diamond 150 109 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium suicordis
29174979 29174979 PRJNA1103784_P_NODE_7549_length_242_cov_0.911243_g7494_i0 PRJNA1103784 7549 242 0.911243 2.20520806 Bacteria 2 Bacteria Bacteria 141 5.85e-42   NR MCT6839605.1 2478472 g7494 i0 98.7 1.97107438016529 79 1 97.9 0 2 238 9 87 MCT6839605.1 cation:dicarboxylase symporter family transporter [Bifidobacteriales bacterium] diamond 477 141 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales     Bifidobacteriales bacterium
29427136 29427136 PRJNA1103784_P_NODE_6349_length_248_cov_0.880000_g6294_i0 PRJNA1103784 6349 248 0.88 2.1824 Rhodococcus 1827 Bacteria Bacteria 58.2 1.47e-7   NR WP_301850652.1 103816 g6294 i0 39.5 2.98790322580645 81 48 98 1 245 3 587 666 WP_301850652.1 ATP-binding protein [Rhodococcus pyridinivorans] diamond 741 58.5 0.994871794871795 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus pyridinivorans
29616501 29616501 PRJNA1103784_P_NODE_7810_length_241_cov_0.916667_g7755_i0 PRJNA1103784 7810 241 0.916667 2.20916747 root 1 Root_unresolved Root_unresolved 53.5 5.61e-6   NR MBI2691692.1 1909295 g7755 i0 42.4 1.56846473029046 59 34 73.4 0 43 219 301 359 MBI2691692.1 cytochrome P450 [Solirubrobacterales bacterium] diamond 378 53.9 0.992578849721707 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales     Solirubrobacterales bacterium
30185272 30185272 PRJNA1103784_P_NODE_5532_length_252_cov_2.106145_g5477_i0 PRJNA1103784 5532 252 2.106145 5.3074854 Rhodococcus 1827 Bacteria Bacteria 169 2.9799999999999998e-52   NR MCW0191935.1 1831 g5477 i0 100 3.95238095238095 83 0 98.8 0 2 250 31 113 MCW0191935.1 hypothetical protein [Rhodococcus sp. (in: high G+C Gram-positive bacteria)] diamond 996 169 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Rhodococcus Rhodococcus sp. (in: high G+C Gram-positive bacteria)
30257605 30257605 PRJNA1103784_P_NODE_7512_length_242_cov_1.337278_g7457_i0 PRJNA1103784 7512 242 1.337278 3.23621276 Arthrobacter russicus 172040 Bacteria Bacteria 129 2.39e-34   NR WP_296363163.1 172040 g7457 i0 100 0.818181818181818 66 0 81.8 0 44 241 1 66 WP_296363163.1 carbohydrate ABC transporter permease [Arthrobacter russicus] diamond 198 129 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter russicus
31363433 31363433 PRJNA1103784_P_NODE_7776_length_241_cov_0.916667_g7721_i0 PRJNA1103784 7776 241 0.916667 2.20916747 Lawsonella sp. 2041415 Bacteria Bacteria 62 5.68e-9   NR WP_320616745.1 2041415 g7721 i0 100 0.37344398340249 30 0 37.3 0 150 239 214 243 WP_320616745.1 transcription termination factor Rho [Lawsonella sp.] diamond 90 62 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella sp.
32059147 32059147 PRJNA1103784_P_NODE_5438_length_254_cov_1.618785_g5383_i0 PRJNA1103784 5438 254 1.618785 4.1117139 Lawsonella clevelandensis 1528099 Bacteria Bacteria 175 2.7499999999999993e-52   NR WP_373567037.1 1528099 g5383 i0 100 0.992125984251969 84 0 99.2 0 254 3 183 266 WP_373567037.1 16S rRNA (adenine(1518)-N(6)/adenine(1519)-N(6))-dimethyltransferase RsmA [Lawsonella clevelandensis] diamond 252 175 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
32154151 32154151 PRJNA1103784_P_NODE_5198_length_259_cov_1.365591_g5143_i0 PRJNA1103784 5198 259 1.365591 3.53688069 Renibacterium sp. 1914289 Bacteria Bacteria 179 2.58e-56   NR MBQ1445421.1 1914289 g5143 i0 96.5 0.996138996138996 86 3 99.6 0 1 258 29 114 MBQ1445421.1 hypothetical protein [Renibacterium sp.] diamond 258 179 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Renibacterium Renibacterium sp.
32185853 32185853 PRJNA1103784_P_NODE_7258_length_243_cov_1.758824_g7203_i0 PRJNA1103784 7258 243 1.758824 4.27394232 Luteipulveratus mongoliensis 571913 Bacteria Bacteria 61.6 3.12e-9   NR WP_169787611.1 571913 g7203 i0 46.8 0.950617283950617 77 39 95.1 2 6 236 140 214 WP_169787611.1 TetR/AcrR family transcriptional regulator [Luteipulveratus mongoliensis] diamond 231 61.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermacoccaceae Luteipulveratus Luteipulveratus mongoliensis
32650952 32650952 PRJNA1103784_P_NODE_1000_length_495_cov_2.196682_g945_i0 PRJNA1103784 1000 495 2.196682 10.8735759 Actinomycetota 201174 Bacteria Bacteria 103 2.78e-24   NR HEY7821804.1 2080302 g945 i0 50.5 1.88484848484848 101 46 61.2 1 319 17 6 102 HEY7821804.1 peptidoglycan-binding domain-containing protein [Acidimicrobiia bacterium] diamond 933 103 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
32691280 32691280 PRJNA1103784_P_NODE_2720_length_328_cov_1.007843_g2665_i0 PRJNA1103784 2720 328 1.007843 3.30572504 Streptomyces olivoreticuli 68246 Bacteria Bacteria 45.1 0.0142   NR WP_116209566.1 68246 g2665 i0 36.5 0.576219512195122 63 40 57.6 0 191 3 227 289 WP_116209566.1 cytochrome P450 [Streptomyces olivoreticuli] diamond 189 45.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces olivoreticuli
32817326 32817326 PRJNA1103784_P_NODE_4040_length_281_cov_2.649038_g3985_i0 PRJNA1103784 4040 281 2.649038 7.44379678 Nakamurella sp. 1869182 Bacteria Bacteria 42.7 0.0485   NR MEO5834577.1 1869182 g3985 i0 37.2 0.918149466192171 86 39 86.5 2 267 25 11 86 MEO5834577.1 LysM peptidoglycan-binding domain-containing protein [Nakamurella sp.] diamond 258 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Nakamurellales Nakamurellaceae Nakamurella Nakamurella 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);;