RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

29 rows where analysis = "diamond", bioproject = "PRJNA675042" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 29 ✖

tax_kingdom 1

bioproject 1

  • PRJNA675042 · 29 ✖

analysis 1

  • diamond · 29 ✖

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
1923721 1923721 PRJNA675042_P_NODE_9302_length_513_cov_1.729545_g8855_i0 PRJNA675042 9302 513 1.729545 8.87256585 Arthrobacter russicus 172040 Bacteria Bacteria 311 9.09e-103   NR WP_309800122.1 172040 g8855 i0 100 0.976608187134503 167 0 97.7 0 1 501 70 236 WP_309800122.1 MFS transporter [Arthrobacter russicus] diamond 501 311 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter russicus
3197640 3197640 PRJNA675042_P_NODE_23863_length_395_cov_1.217391_g23413_i0 PRJNA675042 23863 395 1.217391 4.80869445 Bacteria 2 Bacteria Bacteria 213 4.999999999999998e-69   NR WP_316311919.1 28447 g23413 i0 97.9 1.45822784810127 96 2 72.9 0 393 106 12 107 WP_316311919.1 alpha-amylase family glycosyl hydrolase, partial [Clavibacter michiganensis] diamond 576 213 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Clavibacter Clavibacter michiganensis
4474552 4474552 PRJNA675042_P_NODE_180124_length_241_cov_0.916667_g179674_i0 PRJNA675042 180124 241 0.916667 2.20916747 Bacteria 2 Bacteria Bacteria 162 8.51e-50   NR WP_316308693.1 28447 g179674 i0 100 2.98755186721992 80 0 99.6 0 241 2 37 116 WP_316308693.1 efflux RND transporter permease subunit, partial [Clavibacter michiganensis] diamond 720 162 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Clavibacter Clavibacter michiganensis
8300025 8300025 PRJNA675042_P_NODE_22447_length_401_cov_2.323171_g21997_i0 PRJNA675042 22447 401 2.323171 9.31591571 Lawsonella 1847725 Bacteria Bacteria 182 4.3199999999999985e-55   NR WP_290598495.1 1847725 g21997 i0 100 0.665835411471322 89 0 66.6 0 401 135 165 253 WP_290598495.1 MULTISPECIES: thiamine phosphate synthase [Lawsonella] diamond 267 182 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
18499307 18499307 PRJNA675042_P_NODE_4375_length_660_cov_1.565588_g3954_i0 PRJNA675042 4375 660 1.565588 10.3328808 Curtobacterium flaccumfaciens 2035 Bacteria Bacteria 147 5.829999999999998e-41   NR WP_301597930.1 2035 g3954 i0 53.4 0.663636363636364 146 68 66.4 0 562 125 1 146 WP_301597930.1 hypothetical protein, partial [Curtobacterium flaccumfaciens] diamond 438 147 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Curtobacterium Curtobacterium flaccumfaciens
26638618 26638618 PRJNA675042_P_NODE_15761_length_438_cov_10.780822_g15311_i0 PRJNA675042 15761 438 10.780822 47.22000036 Stackebrandtia nassauensis 283811 Bacteria Bacteria 43.5 0.0293   NR WP_013017789.1 283811 g15311 i0 39.1 0.472602739726027 69 35 47.3 2 223 429 8 69 WP_013017789.1 hydroxyisourate hydrolase [Stackebrandtia nassauensis] diamond 207 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Glycomycetales Glycomycetaceae Stackebrandtia Stackebrandtia nassauensis
26701885 26701885 PRJNA675042_P_NODE_8581_length_526_cov_7.834437_g8137_i0 PRJNA675042 8581 526 7.834437 41.20913862 Curtobacterium flaccumfaciens 2035 Bacteria Bacteria 93.2 2.09e-20   NR WP_301597930.1 2035 g8137 i0 51.5 0.564638783269962 99 44 54.2 1 347 63 47 145 WP_301597930.1 hypothetical protein, partial [Curtobacterium flaccumfaciens] diamond 297 93.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Curtobacterium Curtobacterium flaccumfaciens
26955138 26955138 PRJNA675042_P_NODE_21662_length_405_cov_0.927711_g21212_i0 PRJNA675042 21662 405 0.927711 3.75722955 Lawsonella 1847725 Bacteria Bacteria 261 2.8e-85   NR WP_290595887.1 1847725 g21212 i0 100 0.985185185185185 133 0 98.5 0 405 7 185 317 WP_290595887.1 MULTISPECIES: carbohydrate kinase family protein [Lawsonella] diamond 399 261 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
27208023 27208023 PRJNA675042_P_NODE_100882_length_257_cov_0.972826_g100432_i0 PRJNA675042 100882 257 0.972826 2.50016282 Kitasatospora aburaviensis 67265 Bacteria Bacteria 42.7 0.0419   NR WP_345329611.1 67265 g100432 i0 43.1 0.67704280155642 58 33 67.7 0 256 83 283 340 WP_345329611.1 glycoside hydrolase family 19 protein [Kitasatospora aburaviensis] diamond 174 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Kitasatospora Kitasatospora aburaviensis
27776986 27776986 PRJNA675042_P_NODE_154204_length_244_cov_0.918129_g153754_i0 PRJNA675042 154204 244 0.918129 2.24023476 Curtobacterium flaccumfaciens 2035 Bacteria Bacteria 48.5 1.54e-4   NR WP_301597930.1 2035 g153754 i0 56.4 0.479508196721311 39 17 48 0 238 122 119 157 WP_301597930.1 hypothetical protein, partial [Curtobacterium flaccumfaciens] diamond 117 48.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Curtobacterium Curtobacterium flaccumfaciens
28124214 28124214 PRJNA675042_P_NODE_53285_length_318_cov_6.742857_g52835_i0 PRJNA675042 53285 318 6.742857 21.44228526 Gaiellaceae bacterium 2838783 Bacteria Bacteria 44.3 0.0179   NR MFL5911216.1 2838783 g52835 i0 37.1 0.660377358490566 70 41 64.2 2 212 9 8 76 MFL5911216.1 hypothetical protein [Gaiellaceae bacterium] diamond 210 44.3 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Gaiellales Gaiellaceae   Gaiellaceae bacterium
28124245 28124245 PRJNA675042_P_NODE_97985_length_260_cov_1.192513_g97535_i0 PRJNA675042 97985 260 1.192513 3.1005338 Kitasatospora aburaviensis 67265 Bacteria Bacteria 69.3 2.28e-12   NR WP_345329493.1 67265 g97535 i0 66.7 0.623076923076923 54 18 62.3 0 163 2 1 54 WP_345329493.1 peptidylprolyl isomerase [Kitasatospora aburaviensis] diamond 162 69.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Kitasatospora Kitasatospora aburaviensis
28945368 28945368 PRJNA675042_P_NODE_7408_length_551_cov_2.173640_g6968_i0 PRJNA675042 7408 551 2.17364 11.9767564 Corynebacterium tuberculostearicum 38304 Bacteria Bacteria 340 2.77e-114   NR WP_301714254.1 38304 g6968 i0 100 0.963702359346643 177 0 96.4 0 533 3 1 177 WP_301714254.1 chromate efflux transporter [Corynebacterium tuberculostearicum] diamond 531 340 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium tuberculostearicum
29166292 29166292 PRJNA675042_P_NODE_174849_length_241_cov_1.125000_g174399_i0 PRJNA675042 174849 241 1.125 2.71125 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 42.7 0.0359   NR HWX52473.1 2586742 g174399 i0 39.6 1.19502074688797 48 29 59.8 0 239 96 115 162 HWX52473.1 glutamate synthase central domain-containing protein [Solirubrobacteraceae bacterium] diamond 288 42.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
30366616 30366616 PRJNA675042_P_NODE_172492_length_242_cov_0.911243_g172042_i0 PRJNA675042 172492 242 0.911243 2.20520806 Arthrobacter russicus 172040 Bacteria Bacteria 120 4.589999999999999e-31   NR WP_309795609.1 172040 g172042 i0 100 0.706611570247934 57 0 70.7 0 242 72 17 73 WP_309795609.1 IS3 family transposase [Arthrobacter russicus] diamond 171 120 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter russicus
30429811 30429811 PRJNA675042_P_NODE_28853_length_376_cov_4.689769_g28403_i0 PRJNA675042 28853 376 4.689769 17.63353144 Lawsonella 1847725 Bacteria Bacteria 230 3.14e-73   NR WP_290595531.1 1847725 g28403 i0 100 0.901595744680851 113 0 90.2 0 1 339 29 141 WP_290595531.1 MULTISPECIES: 4-hydroxy-3-methylbut-2-enyl diphosphate reductase [Lawsonella] diamond 339 230 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
31092928 31092928 PRJNA675042_P_NODE_181195_length_241_cov_0.869048_g180745_i0 PRJNA675042 181195 241 0.869048 2.09440568 Curtobacterium flaccumfaciens 2035 Bacteria Bacteria 75.5 6.41e-15   NR WP_301597930.1 2035 g180745 i0 61.1 0.672199170124481 54 21 67.2 0 43 204 47 100 WP_301597930.1 hypothetical protein, partial [Curtobacterium flaccumfaciens] diamond 162 75.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Curtobacterium Curtobacterium flaccumfaciens
31155730 31155730 PRJNA675042_P_NODE_137395_length_247_cov_0.885057_g136945_i0 PRJNA675042 137395 247 0.885057 2.18609079 Mycobacterium tuberculosis 1773 Bacteria Bacteria 122 9.819999999999999e-34   NR MFV4733668.1 1773 g136945 i0 98.3 0.716599190283401 59 1 71.7 0 178 2 1 59 MFV4733668.1 hypothetical protein [Mycobacterium tuberculosis] diamond 177 122 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
31250906 31250906 PRJNA675042_P_NODE_30835_length_370_cov_1.006734_g30385_i0 PRJNA675042 30835 370 1.006734 3.7249158000000002 Renibacterium sp. 1914289 Bacteria Bacteria 165 1.18e-46   NR MBQ1443278.1 1914289 g30385 i0 95.1 0.656756756756757 81 4 65.7 0 128 370 72 152 MBQ1443278.1 VanZ family protein [Renibacterium sp.] diamond 243 165 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Renibacterium Renibacterium sp.
31250936 31250936 PRJNA675042_P_NODE_78455_length_283_cov_0.785714_g78005_i0 PRJNA675042 78455 283 0.785714 2.22357062 Curtobacterium flaccumfaciens 2035 Bacteria Bacteria 96.3 8.339999999999999e-23   NR WP_301597930.1 2035 g78005 i0 55.3 0.996466431095406 94 42 99.6 0 283 2 49 142 WP_301597930.1 hypothetical protein, partial [Curtobacterium flaccumfaciens] diamond 282 96.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Curtobacterium Curtobacterium flaccumfaciens
31693675 31693675 PRJNA675042_P_NODE_122577_length_249_cov_0.875000_g122127_i0 PRJNA675042 122577 249 0.875 2.17875 Curtobacterium flaccumfaciens 2035 Bacteria Bacteria 50.4 3.08e-5   NR WP_301597930.1 2035 g122127 i0 45.6 1.37349397590361 57 31 68.7 0 171 1 44 100 WP_301597930.1 hypothetical protein, partial [Curtobacterium flaccumfaciens] diamond 342 50.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Curtobacterium Curtobacterium flaccumfaciens
31757045 31757045 PRJNA675042_P_NODE_87957_length_271_cov_1.555556_g87507_i0 PRJNA675042 87957 271 1.555556 4.21555676 Arthrobacter russicus 172040 Bacteria Bacteria 116 3.51e-28   NR WP_309796727.1 172040 g87507 i0 100 0.686346863468635 62 0 68.6 0 186 1 1 62 WP_309796727.1 amidohydrolase [Arthrobacter russicus] diamond 186 116 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter russicus
31915148 31915148 PRJNA675042_P_NODE_181697_length_234_cov_2.111801_g181247_i0 PRJNA675042 181697 234 2.111801 4.94161434 Mycolicibacter sinensis 875328 Bacteria Bacteria 44.3 0.00918   NR WP_234787934.1 875328 g181247 i0 41.1 0.717948717948718 56 32 71.8 1 47 214 2 56 WP_234787934.1 FtsK/SpoIIIE domain-containing protein [Mycolicibacter sinensis] diamond 168 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacter Mycolicibacter sinensis
32326875 32326875 PRJNA675042_P_NODE_106279_length_251_cov_0.865169_g105829_i0 PRJNA675042 106279 251 0.865169 2.17157419 Cutibacterium modestum 2559073 Bacteria Bacteria 67.8 5.04e-12   NR WP_002527894.1 2559073 g105829 i0 56.3 0.956175298804781 80 35 95.6 0 251 12 70 149 WP_002527894.1 hypothetical protein [Cutibacterium modestum] diamond 240 67.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium modestum
32389816 32389816 PRJNA675042_P_NODE_49539_length_325_cov_0.916667_g49089_i0 PRJNA675042 49539 325 0.916667 2.97916775 Corynebacterium 1716 Bacteria Bacteria 132 7.99e-37   NR WP_144793544.1 1716 g49089 i0 71.3 0.867692307692308 94 27 86.8 0 42 323 1 94 WP_144793544.1 MULTISPECIES: hypothetical protein [Corynebacterium] diamond 282 132 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium  
32453394 32453394 PRJNA675042_P_NODE_5719_length_600_cov_3.573055_g5285_i0 PRJNA675042 5719 600 3.573055 21.43833 Actinotalea soli 2819234 Bacteria Bacteria 46.2 0.0186   NR WP_208055899.1 2819234 g5285 i0 32 0.75 150 86 72.5 5 76 510 13 151 WP_208055899.1 hypothetical protein [Actinotalea soli] diamond 450 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Actinotalea Actinotalea soli
32811753 32811753 PRJNA675042_P_NODE_146700_length_245_cov_1.848837_g146250_i0 PRJNA675042 146700 245 1.848837 4.52965065 Bacteria 2 Bacteria Bacteria 141 2.15e-41   NR MBR7559078.1 1773 g146250 i0 100 1.61632653061224 66 0 80.8 0 244 47 36 101 MBR7559078.1 hypothetical protein [Mycobacterium tuberculosis] diamond 396 141 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
32831493 32831493 PRJNA675042_P_NODE_31640_length_367_cov_1.350340_g31190_i0 PRJNA675042 31640 367 1.35034 4.9557478 Bifidobacterium breve DSM 2 1685 Bacteria Bacteria 53.5 6.87e-7   NR EFE88032.1 518634 g31190 i0 54.2 0.392370572207084 48 22 39.2 0 219 76 1 48 EFE88032.1 hypothetical protein BIFBRE_05119 [Bifidobacterium breve DSM 20213 = JCM 1192] diamond 144 53.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Bifidobacterium Bifidobacterium breve
32894245 32894245 PRJNA675042_P_NODE_103640_length_253_cov_10.233333_g103190_i0 PRJNA675042 103640 253 10.233333 25.89033249 Curtobacterium flaccumfaciens 2035 Bacteria Bacteria 63.5 3.03e-10   NR WP_301597930.1 2035 g103190 i0 46.4 0.99604743083004 84 40 94.9 2 245 6 52 134 WP_301597930.1 hypothetical protein, partial [Curtobacterium flaccumfaciens] diamond 252 63.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Curtobacterium Curtobacterium flaccumfaciens

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