RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJEB25583" 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

  • PRJEB25583 · 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
1297226 1297226 PRJEB25583_P_NODE_8302_length_151_cov_1.026316_g8125_i0 PRJEB25583 8302 151 1.026316 1.54973716 Micrococcus 1269 Bacteria Bacteria 58.5 1.82e-8   NR WP_053090902.1 1270 g8125 i0 93.3 1.19205298013245 30 2 59.6 0 91 2 1 30 WP_053090902.1 HNH endonuclease family protein [Micrococcus luteus] diamond 180 58.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
14051135 14051135 PRJEB25583_P_NODE_5972_length_170_cov_1.751880_g5795_i0 PRJEB25583 5972 170 1.75188 2.978196 Glutamicibacter creatinolyticus 162496 Bacteria Bacteria 100 1.43e-23   NR WP_343833135.1 162496 g5795 i0 83.6 0.970588235294118 55 9 97.1 0 4 168 195 249 WP_343833135.1 hypothetical protein [Glutamicibacter creatinolyticus] diamond 165 100 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Glutamicibacter Glutamicibacter creatinolyticus
26780060 26780060 PRJEB25583_P_NODE_7861_length_154_cov_0.914530_g7684_i0 PRJEB25583 7861 154 0.91453 1.4083762 Lawsonella 1847725 Bacteria Bacteria 62.4 2.9e-10   NR WP_290598844.1 1847725 g7684 i0 96.7 0.584415584415584 30 1 58.4 0 63 152 104 133 WP_290598844.1 MULTISPECIES: cation:proton antiporter [Lawsonella] diamond 90 62.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella  
26811688 26811688 PRJEB25583_P_NODE_5741_length_173_cov_1.411765_g5564_i0 PRJEB25583 5741 173 1.411765 2.44235345 uncultured Corynebacterium sp. 159447 Bacteria Bacteria 80.1 8.91e-17   NR WP_294163761.1 159447 g5564 i0 66.1 0.971098265895954 56 19 97.1 0 6 173 8 63 WP_294163761.1 hypothetical protein [uncultured Corynebacterium sp.] diamond 168 80.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium uncultured Corynebacterium sp.
27412662 27412662 PRJEB25583_P_NODE_8003_length_153_cov_1.000000_g7826_i0 PRJEB25583 8003 153 1 1.53 Nonomuraea sp. NPDC 1883105 Bacteria Bacteria 48.5 2.19e-5   NR WP_397354329.1 3364374 g7826 i0 51.2 0.803921568627451 41 20 80.4 0 25 147 58 98 WP_397354329.1 hypothetical protein [Nonomuraea sp. NPDC052265] diamond 123 48.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp. NPDC052265
27444329 27444329 PRJEB25583_P_NODE_2023_length_294_cov_1.696498_g1846_i0 PRJEB25583 2023 294 1.696498 4.98770412 Brachybacterium kimchii 2942909 Bacteria Bacteria 75.9 3.73e-15   NR WP_249480029.1 2942909 g1846 i0 70.6 0.520408163265306 51 15 52 0 3 155 77 127 WP_249480029.1 hypothetical protein [Brachybacterium kimchii] diamond 153 75.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium kimchii
27696955 27696955 PRJEB25583_P_NODE_3764_length_209_cov_1.191860_g3587_i0 PRJEB25583 3764 209 1.19186 2.4909874 Brachybacterium hainanense 1541174 Bacteria Bacteria 97.1 1.07e-21   NR WP_376981018.1 1541174 g3587 i0 62.3 0.990430622009569 69 24 99 1 207 1 93 159 WP_376981018.1 hypothetical protein [Brachybacterium hainanense] diamond 207 97.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium hainanense
27760064 27760064 PRJEB25583_P_NODE_7824_length_154_cov_1.230769_g7647_i0 PRJEB25583 7824 154 1.230769 1.89538426 Micrococcus sp. KRD 1271 Bacteria Bacteria 67.4 4.45e-13   NR WP_206451778.1 2729721 g7647 i0 92.3 0.75974025974026 39 3 76 0 37 153 1 39 WP_206451778.1 hypothetical protein, partial [Micrococcus sp. KRD096] diamond 117 67.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus sp. KRD096
28043912 28043912 PRJEB25583_P_NODE_3485_length_217_cov_1.361111_g3308_i0 PRJEB25583 3485 217 1.361111 2.95361087 Solirubrobacterales bacterium 1909295 Bacteria Bacteria 78.6 1.86e-16   NR HET9162384.1 1909295 g3308 i0 50 1.93548387096774 70 34 96.8 1 7 216 55 123 HET9162384.1 group I intron-associated PD-(D/E)XK endonuclease [Solirubrobacterales bacterium] diamond 420 78.6 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales     Solirubrobacterales bacterium
28075391 28075391 PRJEB25583_P_NODE_5845_length_172_cov_1.103704_g5668_i0 PRJEB25583 5845 172 1.103704 1.89837088 Cutibacterium sp. 1912221 Bacteria Bacteria 65.1 1.83e-10   NR WP_303196701.1 1912221 g5668 i0 57.9 1.98837209302326 57 24 99.4 0 171 1 100 156 WP_303196701.1 phage portal protein [Cutibacterium sp.] diamond 342 65.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium sp.
28921398 28921398 PRJEB25583_P_NODE_7508_length_156_cov_1.319328_g7331_i0 PRJEB25583 7508 156 1.319328 2.05815168 Bacteria 2 Bacteria Bacteria 45.4 0.00115   NR WP_245231896.1 1269 g7331 i0 100 1.26923076923077 22 0 42.3 0 156 91 210 231 WP_245231896.1 MULTISPECIES: aquaporin [Micrococcus] diamond 198 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus  
29275142 29275142 PRJEB25583_P_NODE_3229_length_225_cov_1.904255_g3052_i0 PRJEB25583 3229 225 1.904255 4.28457375 Brachybacterium kimchii 2942909 Bacteria Bacteria 62 4.77e-9   NR WP_249480025.1 2942909 g3052 i0 51.4 0.986666666666667 74 36 98.7 0 2 223 243 316 WP_249480025.1 hypothetical protein [Brachybacterium kimchii] diamond 222 62 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium kimchii
30033291 30033291 PRJEB25583_P_NODE_1091_length_439_cov_1.791045_g915_i0 PRJEB25583 1091 439 1.791045 7.86268755 Micrococcus yunnanensis 566027 Bacteria Bacteria 224 5.229999999999998e-69   NR WP_135040285.1 566027 g915 i0 100 0.738041002277904 108 0 73.8 0 3 326 312 419 WP_135040285.1 IS21 family transposase [Micrococcus yunnanensis] diamond 324 224 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus yunnanensis
30254641 30254641 PRJEB25583_P_NODE_3272_length_224_cov_1.251337_g3095_i0 PRJEB25583 3272 224 1.251337 2.80299488 Nesterenkonia rhizosphaerae 1348272 Bacteria Bacteria 64.7 8.15e-11   NR WP_345477990.1 1348272 g3095 i0 53 1.6875 66 31 88.4 0 213 16 102 167 WP_345477990.1 hypothetical protein [Nesterenkonia rhizosphaerae] diamond 378 64.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Nesterenkonia Nesterenkonia rhizosphaerae
30696575 30696575 PRJEB25583_P_NODE_2434_length_263_cov_1.911504_g2257_i0 PRJEB25583 2434 263 1.911504 5.02725552 Micrococcus luteus 1270 Bacteria Bacteria 63.9 1.63e-9   NR PZQ78065.1 1270 g2257 i0 54 1.43726235741445 63 25 67.3 1 69 245 547 609 PZQ78065.1 MAG: hypothetical protein DI545_06600 [Micrococcus luteus] diamond 378 63.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus Micrococcus luteus
31360523 31360523 PRJEB25583_P_NODE_2236_length_276_cov_1.171548_g2059_i0 PRJEB25583 2236 276 1.171548 3.23347248 Actinomyces faecalis 2722820 Bacteria Bacteria 129 1.43e-33   NR WP_172121382.1 2722820 g2059 i0 75.3 2.01086956521739 93 21 98.9 1 275 3 286 378 WP_172121382.1 phage portal protein [Actinomyces faecalis] diamond 555 129 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces Actinomyces faecalis
31455320 31455320 PRJEB25583_P_NODE_3316_length_222_cov_1.702703_g3139_i0 PRJEB25583 3316 222 1.702703 3.78000066 Brachybacterium halotolerans 2795215 Bacteria Bacteria 47.8 2.09e-4   NR WP_228357984.1 2795215 g3139 i0 41.1 0.986486486486487 73 39 98.6 1 219 1 18 86 WP_228357984.1 hypothetical protein [Brachybacterium halotolerans] diamond 219 47.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Brachybacterium Brachybacterium halotolerans
31765049 31765049 PRJEB25583_P_NODE_1937_length_302_cov_1.822642_g1760_i0 PRJEB25583 1937 302 1.822642 5.50437884 Actinomycetes 1760 Bacteria Bacteria 122 3.5899999999999998e-31   NR WP_301587187.1 66228 g1760 i0 66.7 2.69205298013245 93 30 91.4 1 300 25 222 314 WP_301587187.1 phage major capsid protein [Gleimia europaea] diamond 813 122 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Gleimia Gleimia europaea
31771508 31771508 PRJEB25583_P_NODE_5677_length_174_cov_1.124088_g5500_i0 PRJEB25583 5677 174 1.124088 1.95591312 uncultured Acidimicrobiales bacterium 310071 Bacteria Bacteria 41.6 0.00746   NR CAA9259618.1 310071 g5500 i0 60.7 0.482758620689655 28 11 48.3 0 143 60 17 44 CAA9259618.1 MAG: hypothetical protein AVDCRST_MAG20-2631 [uncultured Acidimicrobiales bacterium] diamond 84 41.6 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     uncultured Acidimicrobiales bacterium
32208102 32208102 PRJEB25583_P_NODE_4118_length_200_cov_3.742331_g3941_i0 PRJEB25583 4118 200 3.742331 7.484662 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 42.4 0.0287   NR WP_375136088.1 2056861 g3941 i0 55.6 5.16 27 11 39 1 14 91 162 188 WP_375136088.1 TolB family protein, partial [Microbacterium sp. HMWF026] diamond 1032 42.7 0.992974238875878 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp. HMWF026
32277978 32277978 PRJEB25583_P_NODE_6219_length_167_cov_2.007692_g6042_i0 PRJEB25583 6219 167 2.007692 3.35284564 uncultured Rothia sp. 316088 Bacteria Bacteria 88.6 8.45e-19   NR WP_346843744.1 316088 g6042 i0 70.9 0.988023952095808 55 16 98.8 0 166 2 239 293 WP_346843744.1 hypothetical protein [uncultured Rothia sp.] diamond 165 88.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Rothia uncultured Rothia sp.
32467867 32467867 PRJEB25583_P_NODE_6359_length_166_cov_1.209302_g6182_i0 PRJEB25583 6359 166 1.209302 2.00744132 Devriesea agamarum 472569 Bacteria Bacteria 63.5 5.93e-10   NR WP_058234990.1 472569 g6182 i0 52.7 0.993975903614458 55 19 99.4 1 166 2 328 375 WP_058234990.1 hypothetical protein [Devriesea agamarum] diamond 165 63.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Dermabacteraceae Devriesea Devriesea agamarum
32556408 32556408 PRJEB25583_P_NODE_6759_length_162_cov_1.528000_g6582_i0 PRJEB25583 6759 162 1.528 2.47536 Kocuria 57493 Bacteria Bacteria 42 0.0044   NR WP_095797769.1 2029858 g6582 i0 43.8 1.77777777777778 48 25 85.2 1 25 162 24 71 WP_095797769.1 hypothetical protein [Kocuria sp. WRN011] diamond 288 42.4 0.990566037735849 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria sp. WRN011

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