RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB58983" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 23 ✖

tax_kingdom 1

bioproject 1

  • PRJEB58983 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
24350754 24350754 PRJEB58983_P_NODE_25380_length_263_cov_1.968421_g24965_i0 PRJEB58983 25380 263 1.968421 5.17694723 Mycobacterium tuberculosis 1773 Bacteria Bacteria 154 1.81e-46   NR MFV3573782.1 1773 g24965 i0 100 0.992395437262357 87 0 99.2 0 3 263 29 115 MFV3573782.1 hypothetical protein [Mycobacterium tuberculosis] diamond 261 154 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
27406319 27406319 PRJEB58983_P_NODE_33023_length_238_cov_2.806061_g32608_i0 PRJEB58983 33023 238 2.806061 6.67842518 Bacillati 1783272 Bacteria Bacteria 85.5 1.9e-17   NR HEV8622824.1 2080302 g32608 i0 50.7 2.86134453781513 75 37 94.5 0 237 13 78 152 HEV8622824.1 CoA transferase [Acidimicrobiia bacterium] diamond 681 85.5 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
27697413 27697413 PRJEB58983_P_NODE_26704_length_257_cov_3.173913_g26289_i0 PRJEB58983 26704 257 3.173913 8.15695641 Corynebacterium matruchotii 43768 Bacteria Bacteria 68.2 9.59e-12   NR SPW29625.1 43768 g26289 i0 71.7 0.536964980544747 46 13 53.7 0 214 77 5 50 SPW29625.1 Uncharacterised protein [Corynebacterium matruchotii] diamond 138 68.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium matruchotii
28201988 28201988 PRJEB58983_P_NODE_11706_length_368_cov_2.135593_g11291_i0 PRJEB58983 11706 368 2.135593 7.85898224 Streptomyces asiaticus 114695 Bacteria Bacteria 247 1.6699999999999996e-81   NR WP_344397443.1 114695 g11291 i0 100 1.98913043478261 122 0 99.5 0 366 1 53 174 WP_344397443.1 regulatory iron-sulfur-containing complex subunit RicT, partial [Streptomyces asiaticus] diamond 732 247 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
28233511 28233511 PRJEB58983_P_NODE_24206_length_268_cov_4.856410_g23791_i0 PRJEB58983 24206 268 4.85641 13.0151788 Streptomyces asiaticus 114695 Bacteria Bacteria 102 2.14e-26   NR GAA0914133.1 114695 g23791 i0 87.5 0.626865671641791 56 7 62.7 0 214 47 2 57 GAA0914133.1 hypothetical protein GCM10009574_101920 [Streptomyces asiaticus] diamond 168 102 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
28265193 28265193 PRJEB58983_P_NODE_31546_length_244_cov_0.912281_g31131_i0 PRJEB58983 31546 244 0.912281 2.22596564 Propionimicrobium lymphophilum 33012 Bacteria Bacteria 70.5 6.48e-12   NR WP_036916032.1 33012 g31131 i0 38.5 2.72950819672131 78 48 95.9 0 2 235 407 484 WP_036916032.1 DNA helicase PcrA [Propionimicrobium lymphophilum] diamond 666 70.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Propionimicrobium Propionimicrobium lymphophilum
28416600 28416600 PRJEB58983_P_NODE_20906_length_285_cov_1.419811_g20491_i0 PRJEB58983 20906 285 1.419811 4.04646135 Catellatospora 53365 Bacteria Bacteria 56.6 7.17e-7   NR WP_203694785.1 310354 g20491 i0 65 1.24210526315789 40 14 42.1 0 14 133 94 133 WP_203694785.1 hypothetical protein [Catellatospora coxensis] diamond 354 56.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Catellatospora Catellatospora coxensis
28865217 28865217 PRJEB58983_P_NODE_20188_length_289_cov_1.375000_g19773_i0 PRJEB58983 20188 289 1.375 3.97375 Pseudarthrobacter sp. MM222 3018929 Bacteria Bacteria 46.2 0.00386   NR WP_264357214.1 3018929 g19773 i0 37.7 0.550173010380623 53 32 55 1 184 26 511 562 WP_264357214.1 multicopper oxidase family protein [Pseudarthrobacter sp. MM222] diamond 159 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Pseudarthrobacter Pseudarthrobacter sp. MM222
29212757 29212757 PRJEB58983_P_NODE_15909_length_321_cov_1.879032_g15494_i0 PRJEB58983 15909 321 1.879032 6.03169272 Streptomyces sp. RTd22 1841249 Bacteria Bacteria 48.9 6.4899999999999e-4   NR WP_079163355.1 1841249 g15494 i0 36.9 0.785046728971963 84 41 67.3 3 77 292 1539 1622 WP_079163355.1 type I polyketide synthase [Streptomyces sp. RTd22] diamond 252 48.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. RTd22
29275576 29275576 PRJEB58983_P_NODE_24989_length_265_cov_1.796875_g24574_i0 PRJEB58983 24989 265 1.796875 4.76171875 Pseudoscardovia suis 987063 Bacteria Bacteria 52.4 1.47e-5   NR WP_094690702.1 987063 g24574 i0 49.1 0.622641509433962 55 27 62.3 1 101 265 38 91 WP_094690702.1 hypothetical protein [Pseudoscardovia suis] diamond 165 52.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Pseudoscardovia Pseudoscardovia suis
29464760 29464760 PRJEB58983_P_NODE_10830_length_381_cov_3.025974_g10415_i0 PRJEB58983 10830 381 3.025974 11.52896094 Micrococcales bacterium 2026762 Bacteria Bacteria 117 1.47e-28   NR NBR26421.1 2026762 g10415 i0 45.9 1.83464566929134 122 65 95.3 1 8 370 77 198 NBR26421.1 transposase [Micrococcales bacterium] diamond 699 117 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales     Micrococcales bacterium
30026967 30026967 PRJEB58983_P_NODE_32031_length_243_cov_0.917647_g31616_i0 PRJEB58983 32031 243 0.917647 2.22988221 root 1 Root_unresolved Root_unresolved 46.2 0.00221   NR WP_131172759.1 433330 g31616 i0 47.4 7.44444444444444 57 30 70.4 0 239 69 494 550 WP_131172759.1 xanthine dehydrogenase molybdopterin binding subunit [Propioniciclava tarda] diamond 1809 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Propioniciclava Propioniciclava tarda
30539092 30539092 PRJEB58983_P_NODE_12913_length_352_cov_1.491039_g12498_i0 PRJEB58983 12913 352 1.491039 5.24845728 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 57 1.12e-6   NR NDE60440.1 2080302 g12498 i0 28.7 1.78977272727273 108 75 90.3 1 8 325 43 150 NDE60440.1 hypothetical protein [Acidimicrobiia bacterium] diamond 630 57 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
30848332 30848332 PRJEB58983_P_NODE_30754_length_246_cov_0.895954_g30339_i0 PRJEB58983 30754 246 0.895954 2.20404684 PVC group 1783257 Bacteria Bacteria 87 8.77e-18   NR WP_303174791.1 1720 g30339 i0 48.8 5.98780487804878 84 40 98.8 1 243 1 73 156 WP_303174791.1 NAD(P)/FAD-dependent oxidoreductase [Corynebacterium sp.] diamond 1473 87 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium sp.
30943224 30943224 PRJEB58983_P_NODE_28234_length_252_cov_1.245810_g27819_i0 PRJEB58983 28234 252 1.24581 3.1394412 FCB group 1783270 Bacteria Bacteria 135 7.67e-35   NR WP_358289797.1 1886 g27819 i0 78.8 5.82142857142857 80 17 95.2 0 251 12 338 417 WP_358289797.1 HsdM family class I SAM-dependent methyltransferase [Streptomyces albidoflavus] diamond 1467 135 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces albidoflavus
31013045 31013045 PRJEB58983_P_NODE_31975_length_243_cov_1.182353_g31560_i0 PRJEB58983 31975 243 1.182353 2.87311779 Streptomyces asiaticus 114695 Bacteria Bacteria 146 8.899999999999999e-43   NR WP_344397554.1 114695 g31560 i0 100 0.987654320987654 80 0 98.8 0 241 2 41 120 WP_344397554.1 nucleoside recognition domain-containing protein, partial [Streptomyces asiaticus] diamond 240 146 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
31170796 31170796 PRJEB58983_P_NODE_18215_length_302_cov_1.659389_g17800_i0 PRJEB58983 18215 302 1.659389 5.01135478 Euzebya tangerina 591198 Bacteria Bacteria 67.8 2.89e-11   NR WP_116713987.1 591198 g17800 i0 59.6 2.06622516556291 52 18 51.7 1 139 294 5 53 WP_116713987.1 (2Fe-2S)-binding protein [Euzebya tangerina] diamond 624 67.8 1 Bacteria   Bacillati Actinomycetota Nitriliruptoria Euzebyales Euzebyaceae Euzebya Euzebya tangerina
31392586 31392586 PRJEB58983_P_NODE_20216_length_289_cov_1.083333_g19801_i0 PRJEB58983 20216 289 1.083333 3.13083237 Actinomycetota bacterium 2900548 Bacteria Bacteria 60.8 2.73e-8   NR MBS1889662.1 2900548 g19801 i0 32.1 0.8719723183391 84 57 87.2 0 2 253 437 520 MBS1889662.1 ubiquitin-conjugating enzyme E2 [Actinomycetota bacterium] diamond 252 60.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31424012 31424012 PRJEB58983_P_NODE_35296_length_208_cov_4.096296_g34881_i0 PRJEB58983 35296 208 4.096296 8.52029568 Mycobacterium sp. MAA66 3156297 Bacteria Bacteria 42.7 0.0242   NR WP_370070087.1 3156297 g34881 i0 47.2 0.764423076923077 53 25 73.6 2 184 32 142 193 WP_370070087.1 hypothetical protein [Mycobacterium sp. MAA66] diamond 159 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp. MAA66
31765129 31765129 PRJEB58983_P_NODE_2077_length_877_cov_3.009950_g1724_i0 PRJEB58983 2077 877 3.00995 26.3972615 Bacteria 2 Bacteria Bacteria 122 7.520000000000001e-27   NR WP_238175986.1 1266829 g1724 i0 35.7 2.00114025085519 297 169 95.8 5 2 841 1658 1949 WP_238175986.1 putative Ig domain-containing protein, partial [Kribbella albertanoniae] diamond 1755 122 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Kribbellaceae Kribbella Kribbella albertanoniae
32049888 32049888 PRJEB58983_P_NODE_24818_length_266_cov_1.487047_g24403_i0 PRJEB58983 24818 266 1.487047 3.95554502 FCB group 1783270 Bacteria Bacteria 156 5.219999999999998e-47   NR WP_344397525.1 114695 g24403 i0 93.8 1.82706766917293 81 5 91.4 0 244 2 1 81 WP_344397525.1 S-adenosylmethionine:tRNA ribosyltransferase-isomerase, partial [Streptomyces asiaticus] diamond 486 156 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus
32183360 32183360 PRJEB58983_P_NODE_24938_length_265_cov_2.312500_g24523_i0 PRJEB58983 24938 265 2.3125 6.128125 Hugonella massiliensis 1720315 Bacteria Bacteria 45.4 0.00467   NR WP_058985187.1 1720315 g24523 i0 56.7 0.679245283018868 30 13 34 0 111 22 153 182 WP_058985187.1 zinc ribbon domain-containing protein [Hugonella massiliensis] diamond 180 45.4 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Eggerthellales Eggerthellaceae Hugonella Hugonella massiliensis
32493035 32493035 PRJEB58983_P_NODE_11639_length_369_cov_2.206081_g11224_i0 PRJEB58983 11639 369 2.206081 8.14043889 FCB group 1783270 Bacteria Bacteria 243 4.15e-79   NR WP_344397257.1 114695 g11224 i0 99.2 1.98373983739837 122 1 99.2 0 367 2 53 174 WP_344397257.1 nitrilase-related carbon-nitrogen hydrolase, partial [Streptomyces asiaticus] diamond 732 243 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces asiaticus

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