RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB6584 · 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
25933298 25933298 PRJEB6584o_S_NODE_41364_length_171_cov_1.808824_g41256_i0 PRJEB6584 41364 171 1.808824 3.09308904 Cellulomonas sp. P24 2885206 Bacteria Bacteria 89 7.19e-19   NR WP_259307301.1 2885206 g41256 i0 80.4 5.89473684210526 56 11 98.2 0 169 2 441 496 WP_259307301.1 catalase/peroxidase HPI [Cellulomonas sp. P24] diamond 1008 89 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Cellulomonas Cellulomonas sp. P24
26476658 26476658 PRJEB6584l_S_NODE_20960_length_161_cov_1.269841_g20808_i0 PRJEB6584 20960 161 1.269841 2.04444401 Bacteria 2 Bacteria Bacteria 90.9 6.61e-20   NR WP_308504914.1 249061 g20808 i0 88 2.79503105590062 50 6 93.2 0 160 11 257 306 WP_308504914.1 protoporphyrinogen/coproporphyrinogen oxidase, partial [uncultured Actinomyces sp.] diamond 450 90.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Actinomycetales Actinomycetaceae Actinomyces uncultured Actinomyces sp.
30792207 30792207 PRJEB6584_P_NODE_674_length_204_cov_1.737143_g660_i0 PRJEB6584 674 204 1.737143 3.54377172 Actinomycetota bacterium 2900548 Bacteria Bacteria 84.3 2.72e-17   NR MDQ2761917.1 2900548 g660 i0 69.6 0.823529411764706 56 17 82.4 0 22 189 246 301 MDQ2761917.1 phage/plasmid replication protein, II/X family [Actinomycetota bacterium] diamond 168 84.3 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
32912347 32912347 PRJEB6584o_S_NODE_39785_length_172_cov_2.766423_g39677_i0 PRJEB6584 39785 172 2.766423 4.75824756 Nocardia sp. NPDC 1821 Bacteria Bacteria 41.6 0.0379   NR WP_357330302.1 3155518 g39677 i0 42.6 0.941860465116279 54 24 82 1 19 159 713 766 WP_357330302.1 aminodeoxychorismate synthase component I [Nocardia sp. NPDC050712] diamond 162 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia sp. NPDC050712
32946420 32946420 PRJEB6584o_S_NODE_14370_length_233_cov_1.696970_g14262_i0 PRJEB6584 14370 233 1.69697 3.9539401 Nocardia sp. NPDC 1821 Bacteria Bacteria 48.9 8.12e-5   NR WP_364690350.1 3155162 g14262 i0 59.5 0.476394849785408 37 15 47.6 0 122 232 1 37 WP_364690350.1 A24 family peptidase [Nocardia sp. NPDC051030] diamond 111 48.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Nocardiaceae Nocardia Nocardia sp. NPDC051030
32963445 32963445 PRJEB6584f_S_NODE_3386_length_182_cov_2.707483_g3380_i0 PRJEB6584 3386 182 2.707483 4.92761906 Streptosporangium roseum 2001 Bacteria Bacteria 41.6 0.0316   NR WP_352036708.1 2001 g3380 i0 51.6 0.510989010989011 31 15 51.1 0 145 53 114 144 WP_352036708.1 hypothetical protein [Streptosporangium roseum] diamond 93 41.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Streptosporangium Streptosporangium roseum
32997977 32997977 PRJEB6584o_S_NODE_6435_length_329_cov_9.074830_g6327_i0 PRJEB6584 6435 329 9.07483 29.8561907 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 114 6.28e-30   NR MCP3885490.1 2021380 g6327 i0 68.7 0.756838905775076 83 26 75.7 0 328 80 69 151 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 249 114 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
33025725 33025725 PRJEB6584h_S_NODE_8892_length_209_cov_4.034483_g8830_i0 PRJEB6584 8892 209 4.034483 8.43206947 Streptomyces 1883 Bacteria Bacteria 71.2 2.11e-12   NR WP_250924502.1 2897419 g8830 i0 64 5.74162679425837 50 18 71.8 0 3 152 222 271 WP_250924502.1 Dot/Icm T4SS effector Zinc-dependent metalloprotease LegP [Streptomyces albipurpureus] diamond 1200 71.6 0.994413407821229 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces albipurpureus
33031613 33031613 PRJEB6584e_S_NODE_2532_length_184_cov_3.630872_g2517_i0 PRJEB6584 2532 184 3.630872 6.68080448 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 48.9 1.1e-4   NR MFQ5948245.1 2080302 g2517 i0 57.1 3.40760869565217 42 18 68.5 0 3 128 237 278 MFQ5948245.1 AMP-dependent synthetase/ligase [Acidimicrobiia bacterium] diamond 627 48.9 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
33032288 33032288 PRJEB6584p_S_NODE_53956_length_157_cov_3.450820_g53925_i0 PRJEB6584 53956 157 3.45082 5.4177874 Agromyces sp. Marseille-P2726 2709132 Bacteria Bacteria 42 0.022   NR WP_173921702.1 2709132 g53925 i0 50 0.764331210191083 40 20 76.4 0 156 37 315 354 WP_173921702.1 BtrH N-terminal domain-containing protein [Agromyces sp. Marseille-P2726] diamond 120 42 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Agromyces Agromyces sp. Marseille-P2726
33042673 33042673 PRJEB6584o_S_NODE_18004_length_211_cov_5.011364_g17896_i0 PRJEB6584 18004 211 5.011364 10.57397804 Bacteria 2 Bacteria Bacteria 42.4 0.0326   NR WP_218236158.1 908359 g17896 i0 51.3 1.19431279620853 39 16 51.2 1 170 63 229 267 WP_218236158.1 FG-GAP-like repeat-containing protein [Nocardioides daeguensis] diamond 252 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides daeguensis
33048871 33048871 PRJEB6584o_S_NODE_23629_length_192_cov_3.968153_g23521_i0 PRJEB6584 23629 192 3.968153 7.61885376 Streptomyces sp. NPDC 1931 Bacteria Bacteria 73.2 3.42e-13   NR WP_356414246.1 3157177 g23521 i0 56.9 2.6875 58 25 90.6 0 190 17 191 248 WP_356414246.1 FAD-binding oxidoreductase [Streptomyces sp. NPDC006529] diamond 516 73.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC006529
33066111 33066111 PRJEB6584o_S_NODE_53413_length_165_cov_1.207692_g53305_i0 PRJEB6584 53413 165 1.207692 1.9926918 Propionibacteriaceae bacterium 2021380 Bacteria Bacteria 87.4 3.8e-20   NR MCP3885490.1 2021380 g53305 i0 75.5 0.963636363636364 53 13 96.4 0 3 161 60 112 MCP3885490.1 translation initiation factor IF-5A [Propionibacteriaceae bacterium] diamond 159 87.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae   Propionibacteriaceae bacterium
33076692 33076692 PRJEB6584e_S_NODE_2317_length_191_cov_2.307692_g2302_i0 PRJEB6584 2317 191 2.307692 4.40769172 FCB group 1783270 Bacteria Bacteria 42.7 0.0187   NR WP_012933403.1 191495 g2302 i0 51.2 8.8586387434555 41 19 64.4 1 183 61 430 469 WP_012933403.1 FAD-binding oxidoreductase [Conexibacter woesei] diamond 1692 43.1 0.990719257540603 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Conexibacteraceae Conexibacter Conexibacter woesei
33082889 33082889 PRJEB6584o_S_NODE_13254_length_242_cov_2.130435_g13146_i0 PRJEB6584 13254 242 2.130435 5.1556527 Acidimicrobiia bacterium 2080302 Bacteria Bacteria 77 9.96e-16   NR MCZ7529044.1 2080302 g13146 i0 68.1 0.582644628099174 47 15 58.3 0 193 53 68 114 MCZ7529044.1 hypothetical protein [Acidimicrobiia bacterium] diamond 141 77 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia       Acidimicrobiia bacterium
33083360 33083360 PRJEB6584o_S_NODE_94_length_1305_cov_12.890551_g83_i0 PRJEB6584 94 1305 12.890551 168.22169055 Actinomycetota bacterium 2900548 Bacteria Bacteria 517 1.5099999999999995e-180   NR MDQ2761917.1 2900548 g83 i0 69.3 0.816091954022989 355 107 81.1 1 81 1139 1 355 MDQ2761917.1 phage/plasmid replication protein, II/X family [Actinomycetota bacterium] diamond 1065 517 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
33100384 33100384 PRJEB6584o_S_NODE_8134_length_301_cov_4.421053_g8026_i0 PRJEB6584 8134 301 4.421053 13.30736953 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 44.7 0.0158   NR HET9073594.1 2586742 g8026 i0 60.9 1.51495016611296 46 18 45.8 0 32 169 795 840 HET9073594.1 PAS domain S-box protein [Solirubrobacteraceae bacterium] diamond 456 44.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
33116683 33116683 PRJEB6584a_S_NODE_5943_length_173_cov_3.608696_g5923_i0 PRJEB6584 5943 173 3.608696 6.24304408 Streptomyces sp. NPDC 1931 Bacteria Bacteria 44.7 0.00309   NR WP_351411637.1 3154401 g5923 i0 50 2.82658959537572 40 20 69.4 0 5 124 824 863 WP_351411637.1 tetratricopeptide repeat protein [Streptomyces sp. NPDC001868] diamond 489 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC001868
33151162 33151162 PRJEB6584o_S_NODE_13816_length_237_cov_3.019802_g13708_i0 PRJEB6584 13816 237 3.019802 7.15693074 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 49.3 1.68e-4   NR HET7017320.1 2339230 g13708 i0 36.9 0.822784810126582 65 40 81 1 213 22 82 146 HET7017320.1 VCBS repeat-containing protein [Streptosporangiaceae bacterium] diamond 195 49.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
33168523 33168523 PRJEB6584o_S_NODE_6360_length_330_cov_39.461017_g6252_i0 PRJEB6584 6360 330 39.461017 130.2213561 Microlunatus sp. 39595 Bacteria Bacteria 45.8 0.00648   NR HET9647417.1 39595 g6252 i0 41.1 0.663636363636364 73 40 66.4 2 312 94 7 76 HET9647417.1 RDD family protein [Microlunatus sp.] diamond 219 45.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Microlunatus Microlunatus sp.

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