RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA169559" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA169559 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
6157550 6157550 PRJNA169559_P_NODE_24045_length_314_cov_1.870175_g21969_i0 PRJNA169559 24045 314 1.870175 5.8723495 Olsenella uli 133926 Bacteria Bacteria 65.1 1.18e-9   NR WP_036575748.1 133926 g21969 i0 49.2 0.601910828025478 63 32 60.2 0 269 81 97 159 WP_036575748.1 AAA domain-containing protein [Olsenella uli] diamond 189 65.1 1 Bacteria   Bacillati Actinomycetota Coriobacteriia Coriobacteriales Atopobiaceae Olsenella Olsenella uli
11843811 11843811 PRJNA169559_P_NODE_8990_length_566_cov_15.931099_g4846_i1 PRJNA169559 8990 566 15.931099 90.17002034 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 174 5.26e-52   NR MCP3885490.1 2021380 g4846 i1 57.3 1.60070671378092 150 62 78.4 2 499 56 3 152 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 906 174 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
20766722 20766722 PRJNA169559_P_NODE_6297_length_677_cov_13.299383_g4846_i0 PRJNA169559 6297 677 13.299383 90.03682291 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 174 1.95e-51   NR MCP3885490.1 2021380 g4846 i0 57.3 1.33825701624815 150 62 65.6 2 179 622 3 152 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 906 174 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
20766731 20766731 PRJNA169559_P_NODE_7717_length_611_cov_12.957045_g6140_i0 PRJNA169559 7717 611 12.957045 79.16754495 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 226 1.99e-72   NR MCP3885490.1 2021380 g6140 i0 71.5 0.741407528641571 151 41 74.1 1 53 505 3 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 453 226 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
27042333 27042333 PRJNA169559_P_NODE_30882_length_261_cov_1.538793_g28806_i0 PRJNA169559 30882 261 1.538793 4.01624973 Actinomycetota bacterium 2900548 Bacteria Bacteria 56.6 5.74e-7   NR MBM3800203.1 2900548 g28806 i0 60 1.36781609195402 40 16 46 0 259 140 127 166 MBM3800203.1 phosphate ABC transporter substrate-binding protein PstS [Actinomycetota bacterium] diamond 357 56.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27105344 27105344 PRJNA169559_P_NODE_23042_length_327_cov_15.600671_g20971_i0 PRJNA169559 23042 327 15.600671 51.01419417 Kibdelosporangium aridum 2030 Bacteria Bacteria 43.9 0.0404   NR WP_380143769.1 2030 g20971 i0 35.3 0.623853211009174 68 41 59.6 1 59 253 1035 1102 WP_380143769.1 type I polyketide synthase [Kibdelosporangium aridum] diamond 204 43.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Kibdelosporangium Kibdelosporangium aridum
27723925 27723925 PRJNA169559_P_NODE_36384_length_244_cov_1.279070_g34307_i0 PRJNA169559 36384 244 1.27907 3.1209308 PVC group 1783257 Bacteria Bacteria 43.1 0.0267   NR HKR51636.1 1873463 g34307 i0 75 2.21311475409836 24 6 29.5 0 3 74 405 428 HKR51636.1 ABC transporter ATP-binding protein [Pseudonocardiaceae bacterium] diamond 540 43.5 0.990804597701149 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae   Pseudonocardiaceae bacterium
27990001 27990001 PRJNA169559_P_NODE_18205_length_399_cov_1.718919_g16204_i0 PRJNA169559 18205 399 1.718919 6.85848681 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 64.3 5.53e-9   NR MDR9451268.1 2080302 g16204 i0 43.3 0.676691729323308 90 39 67.7 2 20 289 214 291 MDR9451268.1 Calx-beta domain-containing protein [Acidimicrobiia bacterium] diamond 270 64.3 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
29333827 29333827 PRJNA169559_P_NODE_34829_length_248_cov_1.488584_g32752_i0 PRJNA169559 34829 248 1.488584 3.69168832 Bacteria 2 Bacteria Bacteria 63.2 2.4e-9   NR WP_286278342.1 1162966 g32752 i0 80 2.96370967741935 35 7 42.3 0 246 142 338 372 WP_286278342.1 NADP-dependent isocitrate dehydrogenase [Naasia aerilata] diamond 735 63.5 0.995275590551181 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Naasia Naasia aerilata
30010895 30010895 PRJNA169559_P_NODE_15571_length_427_cov_17.919598_g4887_i1 PRJNA169559 15571 427 17.919598 76.51668346 Streptomyces atratus 1893 Bacteria Bacteria 42.7 0.0478   NR GGT61744.1 1893 g4887 i1 57.1 0.295081967213115 42 17 28.8 1 144 266 21 62 GGT61744.1 hypothetical protein GCM10010207_71750 [Streptomyces atratus] diamond 126 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces atratus
30471049 30471049 PRJNA169559_P_NODE_29773_length_266_cov_1.628692_g27697_i0 PRJNA169559 29773 266 1.628692 4.33232072 Bacteria 2 Bacteria Bacteria 57.4 3.42e-7   NR MCY7299032.1 2497619 g27697 i0 39.7 10.015037593985 73 41 82.3 1 221 3 542 611 MCY7299032.1 transketolase [Ilumatobacteraceae bacterium] diamond 2664 57.4 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
31369750 31369750 PRJNA169559_P_NODE_45656_length_206_cov_2.717514_g43579_i0 PRJNA169559 45656 206 2.717514 5.59807884 Sphaerisporangium aureirubrum 1544736 Bacteria Bacteria 41.2 0.0255   NR WP_380748489.1 1544736 g43579 i0 47.5 0.58252427184466 40 20 56.8 1 40 156 10 49 WP_380748489.1 hypothetical protein [Sphaerisporangium aureirubrum] diamond 120 41.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Sphaerisporangium Sphaerisporangium aureirubrum
31401338 31401338 PRJNA169559_P_NODE_42856_length_227_cov_2.535354_g40779_i0 PRJNA169559 42856 227 2.535354 5.75525358 Jatrophihabitantaceae bacterium 2811413 Bacteria Bacteria 46.2 0.00117   NR HEV7193968.1 2811413 g40779 i0 51.4 0.488986784140969 37 18 48.9 0 221 111 154 190 HEV7193968.1 adenylate kinase [Jatrophihabitantaceae bacterium] diamond 111 46.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Jatrophihabitantales Jatrophihabitantaceae   Jatrophihabitantaceae bacterium
31829935 31829935 PRJNA169559_P_NODE_49037_length_150_cov_1.206612_g46960_i0 PRJNA169559 49037 150 1.206612 1.809918 FCB group 1783270 Bacteria Bacteria 100 2.68e-26   NR WP_409111595.1 1930 g46960 i0 98 2 50 1 100 0 150 1 15 64 WP_409111595.1 DNA repair protein RecO, partial [Streptomyces scabiei] diamond 300 101 0.99009900990099 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces scabiei
31875427 31875427 PRJNA169559_P_NODE_19257_length_384_cov_20.532394_g4887_i2 PRJNA169559 19257 384 20.532394 78.84439296 Streptomyces atratus 1893 Bacteria Bacteria 42.7 0.0355   NR GGT61744.1 1893 g4887 i2 57.1 0.328125 42 17 32 1 101 223 21 62 GGT61744.1 hypothetical protein GCM10010207_71750 [Streptomyces atratus] diamond 126 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces atratus
32097048 32097048 PRJNA169559_P_NODE_698_length_1984_cov_4.130946_g329_i0 PRJNA169559 698 1984 4.130946 81.95796864 Sporichthyaceae bacterium 2740536 Bacteria Bacteria 107 3.97e-21   NR HEX3611043.1 2740536 g329 i0 30.4 2.54334677419355 359 188 49 14 1570 599 11 342 HEX3611043.1 NHL repeat-containing protein [Sporichthyaceae bacterium] diamond 5046 107 1 Bacteria   Bacillati Actinomycetota Actinomycetes Sporichthyales Sporichthyaceae   Sporichthyaceae bacterium
32431409 32431409 PRJNA169559_P_NODE_4359_length_807_cov_5.282776_g3124_i0 PRJNA169559 4359 807 5.282776 42.63200232 Streptomyces 1883 Bacteria Bacteria 47.8 0.0348   NR WP_030929278.1 1476876 g3124 i0 26 1.33457249070632 181 120 62.5 4 102 605 245 424 WP_030929278.1 FG-GAP-like repeat-containing protein [Streptomyces sp. NRRL B-24720] diamond 1077 47.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NRRL B-24720
32697471 32697471 PRJNA169559_P_NODE_46320_length_196_cov_4.473054_g44243_i0 PRJNA169559 46320 196 4.473054 8.76718584 Streptomyces sp. AJS327 2545265 Bacteria Bacteria 42.7 0.021   NR MBA0051260.1 2545265 g44243 i0 40 2.98469387755102 65 27 96.4 2 7 195 929 983 MBA0051260.1 SDR family NAD(P)-dependent oxidoreductase [Streptomyces sp. AJS327] diamond 585 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. AJS327

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