RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA971676 · 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
14972655 14972655 PRJNA971676_P_NODE_3712_length_413_cov_2.055882_g3623_i0 PRJNA971676 3712 413 2.055882 8.49079266 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 185 2.98e-57   NR MCP3885490.1 2021380 g3623 i0 76.5 0.835351089588378 115 27 83.5 0 66 410 3 117 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 345 185 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
25170811 25170811 PRJNA971676_P_NODE_21440_length_243_cov_0.905882_g21351_i0 PRJNA971676 21440 243 0.905882 2.20129326 Actinomycetota bacterium 2900548 Bacteria Bacteria 151 1.83e-41   NR MBC8387515.1 2900548 g21351 i0 92.5 0.987654320987654 80 6 98.8 0 241 2 264 343 MBC8387515.1 lysine--tRNA ligase [Actinomycetota bacterium] diamond 240 151 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
26836258 26836258 PRJNA971676_P_NODE_20201_length_244_cov_1.087719_g20112_i0 PRJNA971676 20201 244 1.087719 2.65403436 Acidiferrimicrobium sp. IK 2871700 Bacteria Bacteria 42.7 0.0376   NR WP_262323164.1 2871700 g20112 i0 40.4 0.577868852459016 47 28 57.8 0 55 195 235 281 WP_262323164.1 Na+/H+ antiporter NhaA [Acidiferrimicrobium sp. IK] diamond 141 42.7 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Acidimicrobiaceae Acidiferrimicrobium Acidiferrimicrobium sp. IK
26899474 26899474 PRJNA971676_P_NODE_17881_length_247_cov_0.885057_g17792_i0 PRJNA971676 17881 247 0.885057 2.18609079 Actinomycetota bacterium 2900548 Bacteria Bacteria 69.7 1.14e-11   NR HAJ95965.1 2900548 g17792 i0 68.5 0.65587044534413 54 17 65.6 0 86 247 120 173 HAJ95965.1 hypothetical protein [Actinomycetota bacterium] diamond 162 69.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
26962524 26962524 PRJNA971676_P_NODE_16242_length_249_cov_0.875000_g16153_i0 PRJNA971676 16242 249 0.875 2.17875 Kocuria carniphila 262208 Bacteria Bacteria 174 1.7999999999999998e-48   NR WP_368631423.1 262208 g16153 i0 100 1 83 0 100 0 1 249 178 260 WP_368631423.1 MobF family relaxase [Kocuria carniphila] diamond 249 174 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Kocuria Kocuria carniphila
26994077 26994077 PRJNA971676_P_NODE_2962_length_454_cov_2.068241_g2873_i0 PRJNA971676 2962 454 2.068241 9.38981414 Mycobacterium xenopi 3993 1299333 Bacteria Bacteria 45.8 0.0218   NR EUA51196.1 1299333 g2873 i0 57.6 0.218061674008811 33 12 20.5 1 108 16 223 255 EUA51196.1 m24 family peptidase [Mycobacterium xenopi 3993] diamond 99 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium xenopi
29267901 29267901 PRJNA971676_P_NODE_20449_length_244_cov_0.900585_g20360_i0 PRJNA971676 20449 244 0.900585 2.1974274 Streptomyces sp. AcH 5 1931 Bacteria Bacteria 57 3.5e-7   NR WP_041994276.1 352211 g20360 i0 46.8 5.33606557377049 62 25 75 2 50 232 318 372 WP_041994276.1 glycosyltransferase [Streptomyces sp. AcH 505] diamond 1302 57 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. AcH 505
29299670 29299670 PRJNA971676_P_NODE_10309_length_284_cov_0.995261_g10220_i0 PRJNA971676 10309 284 0.995261 2.82654124 Actinomycetota bacterium 2900548 Bacteria Bacteria 46.6 0.0027   NR MBI5869466.1 2900548 g10220 i0 40 0.686619718309859 65 36 65.5 2 191 6 481 545 MBI5869466.1 FAD-dependent oxidoreductase [Actinomycetota bacterium] diamond 195 46.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
29425755 29425755 PRJNA971676_P_NODE_15409_length_250_cov_0.870056_g15320_i0 PRJNA971676 15409 250 0.870056 2.17514 Lawsonella clevelandensis 1528099 Bacteria Bacteria 171 1.03e-47   NR WP_303678763.1 1528099 g15320 i0 100 1.968 82 0 98.4 0 3 248 487 568 WP_303678763.1 serine/threonine protein kinase [Lawsonella clevelandensis] diamond 492 171 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
29747701 29747701 PRJNA971676_P_NODE_4650_length_380_cov_1.254072_g4561_i0 PRJNA971676 4650 380 1.254072 4.7654736 Cyanobacteriota/Melainabacteria group 1798711 Bacteria Bacteria 60.5 6.13e-8   NR WP_326467092.1 1872138 g4561 i0 31.3 8.7315789473684209 128 75 97.1 3 371 3 54 173 WP_326467092.1 hypothetical protein [Actinophytocola sp.] diamond 3318 60.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinophytocola Actinophytocola sp.
29804788 29804788 PRJNA971676_P_NODE_11931_length_268_cov_1.364103_g11842_i0 PRJNA971676 11931 268 1.364103 3.65579604 Mycolicibacterium austroafricanum 39687 Bacteria Bacteria 43.5 0.025   NR WP_222879370.1 39687 g11842 i0 37 0.906716417910448 81 42 80.6 2 239 24 181 261 WP_222879370.1 YgfZ/GcvT domain-containing protein [Mycolicibacterium austroafricanum] diamond 243 43.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycolicibacterium Mycolicibacterium austroafricanum
29868072 29868072 PRJNA971676_P_NODE_1871_length_554_cov_1.602911_g1783_i0 PRJNA971676 1871 554 1.602911 8.88012694 unclassified Streptomyces 2593676 Bacteria Bacteria 73.6 1.54e-11   NR WP_383730436.1 2593676 g1783 i0 35.2 5.35018050541516 165 91 85 7 53 523 33 189 WP_383730436.1 MULTISPECIES: RICIN domain-containing protein [unclassified Streptomyces] diamond 2964 73.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces  
29899760 29899760 PRJNA971676_P_NODE_3231_length_437_cov_2.563187_g3142_i0 PRJNA971676 3231 437 2.563187 11.20112719 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 85.1 1.99e-16   NR HEV7885180.1 2586742 g3142 i0 39.8 0.707093821510298 103 62 70.7 0 312 4 207 309 HEV7885180.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 309 85.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
30057432 30057432 PRJNA971676_P_NODE_16051_length_249_cov_0.875000_g15962_i0 PRJNA971676 16051 249 0.875 2.17875 Amycolatopsis umgeniensis 336628 Bacteria Bacteria 42.7 0.0403   NR WP_246480740.1 336628 g15962 i0 45.8 0.578313253012048 48 24 55.4 1 139 2 252 299 WP_246480740.1 PQQ-dependent sugar dehydrogenase [Amycolatopsis umgeniensis] diamond 144 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis umgeniensis
30910813 30910813 PRJNA971676_P_NODE_15954_length_249_cov_0.875000_g15865_i0 PRJNA971676 15954 249 0.875 2.17875 Actinomycetes bacterium 1883427 Bacteria Bacteria 58.2 1.87e-8   NR MCK4377310.1 1883427 g15865 i0 60.7 0.674698795180723 56 21 67.5 1 234 67 76 130 MCK4377310.1 DUF5320 domain-containing protein [Actinomycetes bacterium] diamond 168 58.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
31005449 31005449 PRJNA971676_P_NODE_21154_length_243_cov_0.905882_g21065_i0 PRJNA971676 21154 243 0.905882 2.20129326 Gardnerella vaginalis 2702 Bacteria Bacteria 157 6.02e-46   NR WP_240612648.1 2702 g21065 i0 97.5 0.987654320987654 80 2 98.8 0 242 3 74 153 WP_240612648.1 hypothetical protein [Gardnerella vaginalis] diamond 240 157 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella vaginalis
31131530 31131530 PRJNA971676_P_NODE_13355_length_254_cov_2.961326_g13266_i0 PRJNA971676 13355 254 2.961326 7.52176804 Actinomycetota bacterium 2900548 Bacteria Bacteria 52.8 1.19e-5   NR MEY3615212.1 2900548 g13266 i0 32.9 0.968503937007874 82 55 96.9 0 247 2 111 192 MEY3615212.1 hypothetical protein [Actinomycetota bacterium] diamond 246 52.8 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31194614 31194614 PRJNA971676_P_NODE_21815_length_243_cov_0.905882_g21726_i0 PRJNA971676 21815 243 0.905882 2.20129326 Conexibacter sp. 1929289 Bacteria Bacteria 43.1 0.0275   NR HST40254.1 1929289 g21726 i0 40.4 0.641975308641975 52 31 64.2 0 55 210 39 90 HST40254.1 2-succinyl-5-enolpyruvyl-6-hydroxy-3-cyclohexene-1-carboxylic-acid synthase [Conexibacter sp.] diamond 156 43.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Conexibacteraceae Conexibacter Conexibacter sp.
31226486 31226486 PRJNA971676_P_NODE_3055_length_449_cov_1.013298_g2966_i0 PRJNA971676 3055 449 1.013298 4.54970802 Actinomycetota bacterium 2900548 Bacteria Bacteria 75.1 5.97e-13   NR MBK5227492.1 2900548 g2966 i0 32.8 0.915367483296214 137 84 86.9 5 12 401 140 275 MBK5227492.1 hypothetical protein [Actinomycetota bacterium] diamond 411 75.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31511484 31511484 PRJNA971676_P_NODE_11256_length_274_cov_1.532338_g11167_i0 PRJNA971676 11256 274 1.532338 4.19860612 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 44.7 0.0106   NR MEN3278996.1 2586742 g11167 i0 34.2 0.832116788321168 76 45 77.7 2 57 269 271 346 MEN3278996.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 228 44.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
32340314 32340314 PRJNA971676_P_NODE_11919_length_268_cov_1.548718_g11830_i0 PRJNA971676 11919 268 1.548718 4.15056424 FCB group 1783270 Bacteria Bacteria 52 2.86e-5   NR HVX42731.1 1957017 g11830 i0 36.8 1.25373134328358 68 42 76.1 1 205 2 64 130 HVX42731.1 hypothetical protein [Mycobacteriales bacterium] diamond 336 52 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales     Mycobacteriales bacterium
32807235 32807235 PRJNA971676_P_NODE_13180_length_256_cov_1.524590_g13091_i0 PRJNA971676 13180 256 1.52459 3.9029504 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 84.3 4.02e-17   NR HVM05321.1 2201156 g13091 i0 67.9 0.62109375 53 17 62.1 0 161 3 1 53 HVM05321.1 transcriptional regulator FtrA [Acidimicrobiales bacterium] diamond 159 84.3 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
32907875 32907875 PRJNA971676_P_NODE_21040_length_243_cov_1.788235_g20951_i0 PRJNA971676 21040 243 1.788235 4.34541105 Actinomycetes 1760 Bacteria Bacteria 42.7 0.0357   NR WP_108957301.1 67301 g20951 i0 45.1 2.53086419753086 51 23 56.8 2 68 205 118 168 WP_108957301.1 hypothetical protein [Streptomyces fragilis] diamond 615 43.1 0.990719257540603 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces fragilis

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