RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

28 rows where analysis = "diamond", bioproject = "PRJNA1245487" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 28 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1245487 · 28 ✖

analysis 1

  • diamond · 28 ✖

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
5454574 5454574 PRJNA1245487_P_NODE_18865_length_254_cov_2.408840_g18527_i0 PRJNA1245487 18865 254 2.40884 6.1184536 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 133 1.2e-37   NR MCP3885490.1 2021380 g18527 i0 79.3 0.968503937007874 82 17 96.9 0 251 6 44 125 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 246 133 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
8004432 8004432 PRJNA1245487_P_NODE_21367_length_244_cov_1.403509_g21029_i0 PRJNA1245487 21367 244 1.403509 3.42456196 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 145 2.29e-39   NR HWT94901.1 2586742 g21029 i0 93.6 0.959016393442623 78 5 95.9 0 243 10 418 495 HWT94901.1 cation:dicarboxylase symporter family transporter [Solirubrobacteraceae bacterium] diamond 234 145 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
15654152 15654152 PRJNA1245487_P_NODE_22273_length_239_cov_3.060241_g21935_i0 PRJNA1245487 22273 239 3.060241 7.31397599 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 135 7.9e-38   NR HEY7072805.1 2201156 g21935 i0 94.9 0.99163179916318 79 4 99.2 0 239 3 141 219 HEY7072805.1 energy-coupling factor ABC transporter permease [Acidimicrobiales bacterium] diamond 237 135 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
26724976 26724976 PRJNA1245487_P_NODE_22081_length_242_cov_0.923077_g21743_i0 PRJNA1245487 22081 242 0.923077 2.23384634 Lawsonella 1847725 Bacteria Bacteria 164 9.92e-47   NR WP_290598462.1 1847725 g21743 i0 100 0.991735537190083 80 0 99.2 0 3 242 212 291 WP_290598462.1 MULTISPECIES: DUF445 domain-containing protein [Lawsonella] diamond 240 164 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
27168191 27168191 PRJNA1245487_P_NODE_21982_length_242_cov_0.923077_g21644_i0 PRJNA1245487 21982 242 0.923077 2.23384634 Arthrobacter sp. B1I2 3042263 Bacteria Bacteria 75.1 9.84e-14   NR WP_306901936.1 3042263 g21644 i0 50 1.52479338842975 66 32 81.8 1 2 199 273 337 WP_306901936.1 FAD-dependent oxidoreductase [Arthrobacter sp. B1I2] diamond 369 75.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter sp. B1I2
27453015 27453015 PRJNA1245487_P_NODE_21923_length_242_cov_1.698225_g21585_i0 PRJNA1245487 21923 242 1.698225 4.1097045 Lawsonella clevelandensis 1528099 Bacteria Bacteria 166 1.4999999999999996e-47   NR WP_053979130.1 1528099 g21585 i0 96.3 0.991735537190083 80 3 99.2 0 240 1 12 91 WP_053979130.1 ATP-dependent Clp protease ATP-binding subunit ClpX [Lawsonella clevelandensis] diamond 240 166 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
27628972 27628972 PRJNA1245487_P_NODE_20604_length_247_cov_1.408046_g20266_i0 PRJNA1245487 20604 247 1.408046 3.47787362 Cutibacterium 1912216 Bacteria Bacteria 154 7.08e-42   NR MES8350226.1 1747 g20266 i0 91.5 12.9473684210526 82 7 99.6 0 2 247 188 269 MES8350226.1 ATP-binding protein [Cutibacterium acnes] diamond 3198 154 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27674003 27674003 PRJNA1245487_P_NODE_15044_length_292_cov_0.716895_g14706_i0 PRJNA1245487 15044 292 0.716895 2.0933334 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 41.2 0.046   NR MDX1449770.1 2080302 g14706 i0 45.2 0.318493150684932 31 17 31.8 0 122 214 45 75 MDX1449770.1 dihydroorotase [Acidimicrobiia bacterium] diamond 93 41.2 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
28715863 28715863 PRJNA1245487_P_NODE_17807_length_264_cov_1.267016_g17469_i0 PRJNA1245487 17807 264 1.267016 3.34492224 Spirillospora sp. NBC_ 2052479 Bacteria Bacteria 42.7 0.0473   NR WUI03268.1 2976006 g17469 i0 36.6 0.931818181818182 82 46 93.2 2 15 260 73 148 WUI03268.1 histidine kinase [Spirillospora sp. NBC_00431] diamond 246 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Spirillospora Spirillospora sp. NBC_00431
28828424 28828424 PRJNA1245487_P_NODE_3968_length_630_cov_4.249551_g3640_i0 PRJNA1245487 3968 630 4.249551 26.7721713 FCB group 1783270 Bacteria Bacteria 127 2.46e-31   NR MBQ9003247.1 1972561 g3640 i0 32.4 2.0952380952381 216 124 92.4 5 598 17 112 327 MBQ9003247.1 hypothetical protein [Eggerthellaceae bacterium] diamond 1320 128 0.9921875 Bacteria   Bacillati Actinomycetota Coriobacteriia Eggerthellales Eggerthellaceae   Eggerthellaceae bacterium
29063210 29063210 PRJNA1245487_P_NODE_23388_length_208_cov_4.103704_g23050_i0 PRJNA1245487 23388 208 4.103704 8.53570432 Actinomycetota bacterium 2900548 Bacteria Bacteria 52.8 6.54e-6   NR HET9249065.1 2900548 g23050 i0 46.8 2.68269230769231 62 30 88 2 25 207 26 85 HET9249065.1 phosphatase PAP2 family protein [Actinomycetota bacterium] diamond 558 52.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29221114 29221114 PRJNA1245487_P_NODE_21549_length_243_cov_5.511765_g21211_i0 PRJNA1245487 21549 243 5.511765 13.39358895 Glycomyces harbinensis 58114 Bacteria Bacteria 124 7.069999999999998e-35   NR WP_284075323.1 58114 g21211 i0 100 0.703703703703704 57 0 70.4 0 172 2 1 57 WP_284075323.1 hypothetical protein, partial [Glycomyces harbinensis] diamond 171 124 1 Bacteria   Bacillati Actinomycetota Actinomycetes Glycomycetales Glycomycetaceae Glycomyces Glycomyces harbinensis
29631102 29631102 PRJNA1245487_P_NODE_19490_length_251_cov_2.151685_g19152_i0 PRJNA1245487 19490 251 2.151685 5.40072935 Pseudarthrobacter sp. NamE5 2576839 Bacteria Bacteria 110 5.940000000000001e-27   NR WP_138605553.1 2576839 g19152 i0 63.1 1.00398406374502 84 30 99.2 1 251 3 217 300 WP_138605553.1 class A beta-lactamase [Pseudarthrobacter sp. NamE5] diamond 252 110 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Pseudarthrobacter Pseudarthrobacter sp. NamE5
29662593 29662593 PRJNA1245487_P_NODE_19570_length_251_cov_0.876404_g19232_i0 PRJNA1245487 19570 251 0.876404 2.19977404 Actinomadura luzonensis 2805427 Bacteria Bacteria 43.1 0.0267   NR WP_247815731.1 2805427 g19232 i0 41.3 0.896414342629482 75 35 82.5 3 7 213 164 235 WP_247815731.1 DUF998 domain-containing protein [Actinomadura luzonensis] diamond 225 43.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura luzonensis
29694212 29694212 PRJNA1245487_P_NODE_20850_length_246_cov_1.485549_g20512_i0 PRJNA1245487 20850 246 1.485549 3.65445054 Streptomyces sp. NPDC 1931 Bacteria Bacteria 43.5 0.0199   NR WP_360313611.1 3154588 g20512 i0 45.1 1.24390243902439 51 26 62.2 1 211 59 322 370 WP_360313611.1 MATE family efflux transporter [Streptomyces sp. NPDC007325] diamond 306 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC007325
29978789 29978789 PRJNA1245487_P_NODE_20891_length_246_cov_0.901734_g20553_i0 PRJNA1245487 20891 246 0.901734 2.21826564 [Propionibacterium] namnetense SK182B-JCVI 1051006 Bacteria Bacteria 120 2.13e-31   NR EGR97606.1 1051006 g20553 i0 91.4 0.98780487804878 81 7 98.8 0 244 2 7 87 EGR97606.1 sortase family protein [ [[Propionibacterium] namnetense SK182B-JCVI] diamond 243 120 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium namnetense
30168212 30168212 PRJNA1245487_P_NODE_21792_length_243_cov_0.917647_g21454_i0 PRJNA1245487 21792 243 0.917647 2.22988221 Microbacterium sp. 51671 Bacteria Bacteria 130 5.42e-34   NR WP_287271558.1 51671 g21454 i0 80 1.97530864197531 80 16 98.8 0 3 242 27 106 WP_287271558.1 amidohydrolase family protein [Microbacterium sp.] diamond 480 130 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp.
30326878 30326878 PRJNA1245487_P_NODE_19652_length_251_cov_0.876404_g19314_i0 PRJNA1245487 19652 251 0.876404 2.19977404 Lawsonella clevelandensis 1528099 Bacteria Bacteria 167 2.37e-50   NR WP_304135342.1 1528099 g19314 i0 98.8 0.99203187250996006 83 1 99.2 0 249 1 75 157 WP_304135342.1 YceD family protein [Lawsonella clevelandensis] diamond 249 167 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
30895244 30895244 PRJNA1245487_P_NODE_20694_length_247_cov_0.896552_g20356_i0 PRJNA1245487 20694 247 0.896552 2.21448344 Rubrobacter sp. 2036010 Bacteria Bacteria 132 2.7699999999999993e-34   NR MBA2442077.1 2036010 g20356 i0 72 0.995951417004049 82 23 99.6 0 246 1 96 177 MBA2442077.1 multicopper oxidase domain-containing protein [Rubrobacter sp.] diamond 246 132 1 Bacteria   Bacillati Actinomycetota Rubrobacteria Rubrobacterales Rubrobacteraceae Rubrobacter Rubrobacter sp.
31432383 31432383 PRJNA1245487_P_NODE_19756_length_250_cov_2.175141_g19418_i0 PRJNA1245487 19756 250 2.175141 5.4378525 Lawsonella 1847725 Bacteria Bacteria 176 1.3e-53   NR WP_290595346.1 1847725 g19418 i0 100 0.996 83 0 99.6 0 1 249 31 113 WP_290595346.1 MULTISPECIES: GNAT family N-acetyltransferase [Lawsonella] diamond 249 176 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
31717066 31717066 PRJNA1245487_P_NODE_22097_length_242_cov_0.923077_g21759_i0 PRJNA1245487 22097 242 0.923077 2.23384634 Nocardioides aequoreus 397278 Bacteria Bacteria 48.1 3.47e-4   NR WP_030484132.1 397278 g21759 i0 74.2 0.768595041322314 31 8 38.4 0 9 101 196 226 WP_030484132.1 maleylpyruvate isomerase N-terminal domain-containing protein [Nocardioides aequoreus] diamond 186 48.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides aequoreus
31875102 31875102 PRJNA1245487_P_NODE_21757_length_243_cov_0.917647_g21419_i0 PRJNA1245487 21757 243 0.917647 2.22988221 Brachybacterium sp. ACRRE 2918184 Bacteria Bacteria 95.9 3.1900000000000003e-21   NR WP_239201673.1 2918184 g21419 i0 65.4 1.98765432098765 81 27 98.8 1 241 2 244 324 WP_239201673.1 site-specific integrase [Brachybacterium sp. ACRRE] diamond 483 95.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium sp. ACRRE
31938367 31938367 PRJNA1245487_P_NODE_20457_length_248_cov_0.891429_g20119_i0 PRJNA1245487 20457 248 0.891429 2.21074392 Kocuria marina 223184 Bacteria Bacteria 160 3.18e-44   NR WP_084117955.1 223184 g20119 i0 100 1.98387096774194 82 0 99.2 0 248 3 296 377 WP_084117955.1 penicillin-binding transpeptidase domain-containing protein [Kocuria marina] diamond 492 160 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria marina
32255291 32255291 PRJNA1245487_P_NODE_19078_length_253_cov_0.866667_g18740_i0 PRJNA1245487 19078 253 0.866667 2.19266751 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 42.7 0.0375   NR HEY4850706.1 2339230 g18740 i0 40 0.889328063241107 75 33 80.6 3 206 3 156 225 HEY4850706.1 endonuclease/exonuclease/phosphatase family protein [Streptosporangiaceae bacterium] diamond 225 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
32413259 32413259 PRJNA1245487_P_NODE_19259_length_252_cov_1.731844_g18921_i0 PRJNA1245487 19259 252 1.731844 4.36424688 Streptomyces alkaliphilus 1472722 Bacteria Bacteria 175 2.35e-54   NR WP_368733365.1 1472722 g18921 i0 100 1 84 0 100 0 252 1 61 144 WP_368733365.1 YncE family protein, partial [Streptomyces alkaliphilus] diamond 252 175 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces alkaliphilus
32760230 32760230 PRJNA1245487_P_NODE_16600_length_275_cov_1.019802_g16262_i0 PRJNA1245487 16600 275 1.019802 2.8044555 Brevibacterium linens 1703 Bacteria Bacteria 42.7 0.0461   NR WP_369865852.1 1703 g16262 i0 51.6 1.03636363636364 95 23 87.3 5 25 264 102 188 WP_369865852.1 hypothetical protein, partial [Brevibacterium linens] diamond 285 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Brevibacteriaceae Brevibacterium Brevibacterium linens
32823217 32823217 PRJNA1245487_P_NODE_16880_length_272_cov_1.567839_g16542_i0 PRJNA1245487 16880 272 1.567839 4.26452208 Nocardioides fonticola 450363 Bacteria Bacteria 73.2 1.04e-12   NR WP_344733583.1 450363 g16542 i0 48.3 0.981617647058823 89 46 98.2 0 5 271 578 666 WP_344733583.1 tetratricopeptide repeat protein [Nocardioides fonticola] diamond 267 73.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides fonticola
32886022 32886022 PRJNA1245487_P_NODE_15040_length_292_cov_1.031963_g14702_i0 PRJNA1245487 15040 292 1.031963 3.01333196 Amycolatopsis taiwanensis 342230 Bacteria Bacteria 43.9 0.0258   NR WP_027942007.1 342230 g14702 i0 60 0.616438356164384 30 12 30.8 0 274 185 198 227 WP_027942007.1 ABC transporter permease [Amycolatopsis taiwanensis] diamond 180 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis taiwanensis

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