RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJEB14664" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJEB14664 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
21284 21284 PRJEB14664_P_NODE_4761_length_395_cov_1.450000_g4631_i0 PRJEB14664 4761 395 1.45 5.7275 Actinomycetota bacterium 2900548 Bacteria Bacteria 117 7.57e-28   NR HAM25046.1 2900548 g4631 i0 52.7 0.835443037974684 110 51 83.5 1 395 66 237 345 HAM25046.1 hypothetical protein [Actinomycetota bacterium] diamond 330 117 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
6088864 6088864 PRJEB14664_P_NODE_16865_length_169_cov_1.194030_g16735_i0 PRJEB14664 16865 169 1.19403 2.0179107 root 1 Root_unresolved Root_unresolved 105 1.12e-24   NR WP_220455551.1 89053 g16735 i0 89.1 100.562130177515 55 6 97.6 0 3 167 362 416 WP_220455551.1 carboxyl transferase domain-containing protein [Gordonia amicalis] diamond 16995 106 0.990566037735849 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Gordoniaceae Gordonia Gordonia amicalis
25211855 25211855 PRJEB14664_P_NODE_7280_length_300_cov_1.467925_g7150_i0 PRJEB14664 7280 300 1.467925 4.403775 Actinomycetota bacterium 2900548 Bacteria Bacteria 153 1.09e-45   NR MBS1889789.1 2900548 g7150 i0 77.8 0.99 99 22 99 0 4 300 25 123 MBS1889789.1 hypothetical protein [Actinomycetota bacterium] diamond 297 153 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
26646570 26646570 PRJEB14664_P_NODE_9561_length_250_cov_1.079070_g9431_i0 PRJEB14664 9561 250 1.07907 2.697675 FCB group 1783270 Bacteria Bacteria 85.1 3.15e-17   NR WP_091032644.1 58114 g9431 i0 64.3 4.884 84 27 98.4 2 3 248 254 336 WP_091032644.1 S8 family peptidase [Glycomyces harbinensis] diamond 1221 85.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Glycomycetales Glycomycetaceae Glycomyces Glycomyces harbinensis
27032997 27032997 PRJEB14664_P_NODE_17442_length_165_cov_1.230769_g17312_i0 PRJEB14664 17442 165 1.230769 2.03076885 Microbacterium sp. 51671 Bacteria Bacteria 69.7 3.45e-12   NR WP_309127655.1 51671 g17312 i0 66.7 2.65454545454545 48 16 87.3 0 164 21 208 255 WP_309127655.1 glycosyltransferase [Microbacterium sp.] diamond 438 69.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium sp.
27412557 27412557 PRJEB14664_P_NODE_7743_length_288_cov_1.391304_g7613_i0 PRJEB14664 7743 288 1.391304 4.00695552 unclassified Pseudonocardia 2619320 Bacteria Bacteria 44.3 0.0164   NR WP_226359473.1 2619320 g7613 i0 42.9 1.33333333333333 63 33 65.6 1 18 206 163 222 WP_226359473.1 MULTISPECIES: DUF4397 domain-containing protein [unclassified Pseudonocardia] diamond 384 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Pseudonocardia  
27696843 27696843 PRJEB14664_P_NODE_8444_length_272_cov_1.126582_g8314_i0 PRJEB14664 8444 272 1.126582 3.06430304 Actinomycetota bacterium 2900548 Bacteria Bacteria 96.7 9.59e-23   NR NDD97035.1 2900548 g8314 i0 57.3 1.96323529411765 89 38 98.2 0 1 267 87 175 NDD97035.1 fasciclin domain-containing protein [Actinomycetota bacterium] diamond 534 96.7 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27759966 27759966 PRJEB14664_P_NODE_7564_length_292_cov_1.731518_g7434_i0 PRJEB14664 7564 292 1.731518 5.05603256 Rhizocola hellebori 1392758 Bacteria Bacteria 42.4 0.0483   NR GIH04775.1 1392758 g7434 i0 33.8 0.698630136986301 68 43 67.8 1 275 78 36 103 GIH04775.1 hypothetical protein Rhe02_28420 [Rhizocola hellebori] diamond 204 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Rhizocola Rhizocola hellebori
28517499 28517499 PRJEB14664_P_NODE_18687_length_158_cov_0.975610_g18557_i0 PRJEB14664 18687 158 0.97561 1.5414638 Actinomycetota bacterium 2900548 Bacteria Bacteria 49.3 1.93e-5   NR MBS1890127.1 2900548 g18557 i0 69.7 0.626582278481013 33 10 62.7 0 104 6 104 136 MBS1890127.1 hypothetical protein [Actinomycetota bacterium] diamond 99 49.3 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28858275 28858275 PRJEB14664_P_NODE_12208_length_210_cov_1.828571_g12078_i0 PRJEB14664 12208 210 1.828571 3.8399991 Actinomycetes 1760 Bacteria Bacteria 128 1.4299999999999996e-34   NR WP_407774598.1 1785 g12078 i0 82.9 10 70 12 100 0 210 1 138 207 WP_407774598.1 alpha/beta fold hydrolase, partial [Mycobacterium sp.] diamond 2100 128 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
28991335 28991335 PRJEB14664_P_NODE_16468_length_172_cov_1.087591_g16338_i0 PRJEB14664 16468 172 1.087591 1.87065652 Ornithinimicrobium pekingense 384677 Bacteria Bacteria 53.1 2.93e-6   NR WP_022921253.1 384677 g16338 i0 53.2 4.06395348837209 47 22 82 0 143 3 3 49 WP_022921253.1 protoporphyrinogen oxidase [Ornithinimicrobium pekingense] diamond 699 53.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Ornithinimicrobiaceae Ornithinimicrobium Ornithinimicrobium pekingense
29432744 29432744 PRJEB14664_P_NODE_16510_length_171_cov_1.889706_g16380_i0 PRJEB14664 16510 171 1.889706 3.23139726 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 67.8 1.96e-12   NR MCP3885490.1 2021380 g16380 i0 60.4 0.929824561403509 53 21 93 0 170 12 77 129 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 159 67.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
30981129 30981129 PRJEB14664_P_NODE_17594_length_164_cov_1.240310_g17464_i0 PRJEB14664 17594 164 1.24031 2.0341084 Amycolatopsis thailandensis 589330 Bacteria Bacteria 48.9 8.43e-5   NR WP_395917789.1 589330 g17464 i0 58.5 1.48170731707317 41 16 73.2 1 162 43 167 207 WP_395917789.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Amycolatopsis thailandensis] diamond 243 48.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Amycolatopsis Amycolatopsis thailandensis
31392046 31392046 PRJEB14664_P_NODE_3476_length_480_cov_2.026966_g3352_i0 PRJEB14664 3476 480 2.026966 9.7294368 Gardnerella vaginalis 2702 Bacteria Bacteria 61.6 1.15e-7   NR WP_064347269.1 2702 g3352 i0 35.9 0.975 156 90 95 4 16 471 382 531 WP_064347269.1 RICIN domain-containing protein [Gardnerella vaginalis] diamond 468 61.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Bifidobacteriales Bifidobacteriaceae Gardnerella Gardnerella vaginalis
31486968 31486968 PRJEB14664_P_NODE_14476_length_188_cov_1.045752_g14346_i0 PRJEB14664 14476 188 1.045752 1.96601376 Saccharothrix variisporea 543527 Bacteria Bacteria 59.7 1.81e-8   NR WP_211351069.1 543527 g14346 i0 58.8 0.813829787234043 51 18 76.6 1 188 45 231 281 WP_211351069.1 trypsin-like serine protease [Saccharothrix variisporea] diamond 153 59.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Saccharothrix Saccharothrix variisporea
31550261 31550261 PRJEB14664_P_NODE_2016_length_648_cov_3.088091_g1907_i0 PRJEB14664 2016 648 3.088091 20.01082968 Streptomyces griseosporeus 1910 Bacteria Bacteria 247 1.05e-75   NR WP_391716895.1 1910 g1907 i0 59.3 8.95833333333333 214 84 98.6 2 640 2 118 329 WP_391716895.1 S8 family peptidase [Streptomyces griseosporeus] diamond 5805 247 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces griseosporeus
31613264 31613264 PRJEB14664_P_NODE_12236_length_210_cov_1.371429_g12106_i0 PRJEB14664 12236 210 1.371429 2.8800009 Acidimicrobiales bacterium 2201156 Bacteria Bacteria 68.2 1.88e-11   NR HQU26147.1 2201156 g12106 i0 51.5 5.32857142857143 68 33 97.1 0 205 2 247 314 HQU26147.1 nitronate monooxygenase [Acidimicrobiales bacterium] diamond 1119 68.2 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales     Acidimicrobiales bacterium
31802907 31802907 PRJEB14664_P_NODE_6817_length_313_cov_1.564748_g6687_i0 PRJEB14664 6817 313 1.564748 4.89766124 Demequina zhanjiangensis 3051659 Bacteria Bacteria 137 8.83e-36   NR WP_301128006.1 3051659 g6687 i0 76.1 7.36102236421725 88 21 84.3 0 2 265 376 463 WP_301128006.1 Re/Si-specific NAD(P)(+) transhydrogenase subunit beta [Demequina zhanjiangensis] diamond 2304 137 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Demequinaceae Demequina Demequina zhanjiangensis
32246348 32246348 PRJEB14664_P_NODE_19278_length_155_cov_1.000000_g19148_i0 PRJEB14664 19278 155 1 1.55 Actinomycetota bacterium 2900548 Bacteria Bacteria 55.1 4.89e-7   NR MFM2438233.1 2900548 g19148 i0 71.4 2.20645161290323 35 10 67.7 0 51 155 5 39 MFM2438233.1 hypothetical protein [Actinomycetota bacterium] diamond 342 55.1 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32902318 32902318 PRJEB14664_P_NODE_16340_length_173_cov_0.855072_g16210_i0 PRJEB14664 16340 173 0.855072 1.47927456 Bacillati 1783272 Bacteria Bacteria 44.7 0.00214   NR WP_234001632.1 450380 g16210 i0 76 1.78612716763006 25 6 43.4 0 168 94 38 62 WP_234001632.1 hypothetical protein [Microbacterium profundi] diamond 309 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Microbacterium Microbacterium profundi

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