RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1197996" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1197996 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27736244 27736244 PRJNA1197996_S_NODE_29284_length_231_cov_2.139241_g29230_i0 PRJNA1197996 29284 231 2.139241 4.94164671 Actinomycetota bacterium 2900548 Bacteria Bacteria 48.5 2.88e-4   NR NIA31726.1 2900548 g29230 i0 33.3 1.01298701298701 78 46 93.5 3 11 226 8 85 NIA31726.1 prolyl oligopeptidase family serine peptidase [Actinomycetota bacterium] diamond 234 48.5 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27862095 27862095 PRJNA1197996_S_NODE_26345_length_245_cov_1.343023_g26291_i0 PRJNA1197996 26345 245 1.343023 3.29040635 Actinomycetota bacterium 2900548 Bacteria Bacteria 94 1.95e-20   NR NBX70493.1 2900548 g26291 i0 67.2 3.12244897959184 64 21 78.4 0 1 192 144 207 NBX70493.1 bifunctional 3,4-dihydroxy-2-butanone-4-phosphate synthase/GTP cyclohydrolase II [Actinomycetota bacterium] diamond 765 94 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
28702146 28702146 PRJNA1197996_S_NODE_10707_length_327_cov_6.748031_g10653_i0 PRJNA1197996 10707 327 6.748031 22.06606137 Bacteria 2 Bacteria Bacteria 50.1 1.76e-4   NR HEX3832508.1 2586742 g10653 i0 60 1.57798165137615 35 14 32.1 0 14 118 193 227 HEX3832508.1 SDR family oxidoreductase [Solirubrobacteraceae bacterium] diamond 516 50.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
30849703 30849703 PRJNA1197996_S_NODE_20774_length_263_cov_1.215789_g20720_i0 PRJNA1197996 20774 263 1.215789 3.19752507 Thermoleophilia 1497346 Bacteria Bacteria 75.1 1.94e-13   NR MCU0309089.1 2026888 g20720 i0 43.4 12.4334600760456 83 46 94.7 1 262 14 600 681 MCU0309089.1 MMPL family transporter [Thermoleophilia bacterium] diamond 3270 75.1 1 Bacteria   Bacillati Actinomycetota Thermoleophilia       Thermoleophilia bacterium
31450401 31450401 PRJNA1197996_S_NODE_2136_length_546_cov_6.945032_g2085_i0 PRJNA1197996 2136 546 6.945032 37.91987472 Nonomuraea 83681 Bacteria Bacteria 92.4 2.26e-19   NR WP_358132996.1 3154350 g2085 i0 51.8 2.32967032967033 85 37 46.2 2 1 252 147 228 WP_358132996.1 hypothetical protein [Nonomuraea sp. NPDC049152] diamond 1272 93.2 0.991416309012876 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp. NPDC049152
32063931 32063931 PRJNA1197996_S_NODE_12818_length_309_cov_1.254237_g12764_i0 PRJNA1197996 12818 309 1.254237 3.87559233 Nonomuraea sp. G32 3067274 Bacteria Bacteria 57.4 5.01e-7   NR WP_305917510.1 3067274 g12764 i0 58.1 0.41747572815534 43 17 40.8 1 6 131 288 330 WP_305917510.1 hypothetical protein [Nonomuraea sp. G32] diamond 129 57.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Streptosporangiaceae Nonomuraea Nonomuraea sp. G32

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