RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA922890" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 8 ✖

tax_kingdom 1

bioproject 1

  • PRJNA922890 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
14926606 14926606 PRJNA922890_P_NODE_76052_length_232_cov_0.883436_g75642_i0 PRJNA922890 76052 232 0.883436 2.04957152 Citricoccus sp. 1978372 Bacteria Bacteria 146 6.74e-41   NR WP_313823147.1 1978372 g75642 i0 100 1.99137931034483 77 0 99.6 0 232 2 36 112 WP_313823147.1 DegT/DnrJ/EryC1/StrS family aminotransferase, partial [Citricoccus sp.] diamond 462 146 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Citricoccus Citricoccus sp.
27530212 27530212 PRJNA922890_P_NODE_83063_length_228_cov_0.918239_g82653_i0 PRJNA922890 83063 228 0.918239 2.09358492 Tessaracoccus sp. SD287 2782008 Bacteria Bacteria 142 2.0799999999999997e-37   NR WP_207475469.1 2782008 g82653 i0 82.9 1 76 13 100 0 1 228 297 372 WP_207475469.1 excinuclease ABC subunit UvrA [Tessaracoccus sp. SD287] diamond 228 142 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Tessaracoccus Tessaracoccus sp. SD287
29747386 29747386 PRJNA922890_P_NODE_77530_length_231_cov_0.888889_g77120_i0 PRJNA922890 77530 231 0.888889 2.05333359 Streptomyces 1883 Bacteria Bacteria 77.4 1.15e-14   NR WP_030944184.1 1463917 g77120 i0 87.2 3.53246753246753 39 5 50.6 0 119 3 140 178 WP_030944184.1 enoyl-CoA hydratase/isomerase family protein [Streptomyces sp. NRRL S-646] diamond 816 77.8 0.994858611825193 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NRRL S-646
29835074 29835074 PRJNA922890_P_NODE_72391_length_233_cov_1.768293_g71981_i0 PRJNA922890 72391 233 1.768293 4.12012269 Streptomyces sp. V1I6 3042273 Bacteria Bacteria 120 8.639999999999998e-32   NR WP_307706477.1 3042273 g71981 i0 76.3 0.978540772532189 76 18 97.9 0 231 4 131 206 WP_307706477.1 ankyrin repeat domain-containing protein [Streptomyces sp. V1I6] diamond 228 120 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. V1I6
30719720 30719720 PRJNA922890_P_NODE_83654_length_228_cov_0.905660_g83244_i0 PRJNA922890 83654 228 0.90566 2.0649048 Nocardioides jensenii 1843 Bacteria Bacteria 45.4 0.00327   NR WP_067434020.1 1843 g83244 i0 61.8 0.894736842105263 34 13 44.7 0 226 125 302 335 WP_067434020.1 GDP-mannose 4,6-dehydratase [Nocardioides jensenii] diamond 204 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Nocardioides Nocardioides jensenii
30782953 30782953 PRJNA922890_P_NODE_60614_length_250_cov_2.486188_g60204_i0 PRJNA922890 60614 250 2.486188 6.21547 Streptosporangiaceae bacterium 2339230 Bacteria Bacteria 66.2 1.42e-10   NR MBV9445290.1 2339230 g60204 i0 44.4 6.384 81 42 94.8 2 239 3 201 280 MBV9445290.1 hypothetical protein [Streptosporangiaceae bacterium] diamond 1596 66.2 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae   Streptosporangiaceae bacterium
32332906 32332906 PRJNA922890_P_NODE_72339_length_233_cov_2.262195_g71929_i0 PRJNA922890 72339 233 2.262195 5.27091435 Microthrixaceae bacterium 2497627 Bacteria Bacteria 43.5 0.0159   NR MCB1266670.1 2497627 g71929 i0 43.8 1.23605150214592 48 27 61.8 0 1 144 85 132 MCB1266670.1 hypothetical protein [Microthrixaceae bacterium] diamond 288 43.5 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Microthrixaceae   Microthrixaceae bacterium
32743138 32743138 PRJNA922890_P_NODE_54380_length_265_cov_1.265306_g53970_i0 PRJNA922890 54380 265 1.265306 3.3530609 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 44.3 0.00689   NR HKG63208.1 2586742 g53970 i0 39.7 0.769811320754717 68 39 77 2 36 239 58 123 HKG63208.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 204 44.3 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium

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