RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA801875" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 7 ✖

tax_kingdom 1

bioproject 1

  • PRJNA801875 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26778319 26778319 PRJNA801875_P_NODE_2681_length_207_cov_1.755814_g2578_i0 PRJNA801875 2681 207 1.755814 3.63453498 Streptomyces 1883 Bacteria Bacteria 64.3 5.55e-10   NR WP_121175631.1 1938830 g2578 i0 53.7 3.84057971014493 67 31 97.1 0 202 2 238 304 WP_121175631.1 RICIN domain-containing protein [Streptomyces sp. 1114.5] diamond 795 64.7 0.993817619783617 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. 1114.5
27212014 27212014 PRJNA801875_P_NODE_4662_length_152_cov_1.000000_g4559_i0 PRJNA801875 4662 152 1 1.52 Mycobacterium sp. 1785 Bacteria Bacteria 63.5 4.86e-10   NR MDF2581377.1 1785 g4559 i0 60.4 3.61184210526316 48 19 94.7 0 4 147 548 595 MDF2581377.1 hypothetical protein [Mycobacterium sp.] diamond 549 63.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp.
27338759 27338759 PRJNA801875_P_NODE_2403_length_224_cov_2.153439_g2300_i0 PRJNA801875 2403 224 2.153439 4.82370336 Streptomyces chisholmiae 3075540 Bacteria Bacteria 51.6 2.24e-5   NR WP_311669225.1 3075540 g2300 i0 44.2 1.03125 77 37 97.8 2 223 5 554 628 WP_311669225.1 non-ribosomal peptide synthetase, partial [Streptomyces chisholmiae] diamond 231 51.6 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces chisholmiae
29296250 29296250 PRJNA801875_P_NODE_2409_length_224_cov_1.174603_g2306_i0 PRJNA801875 2409 224 1.174603 2.63111072 Micrococcales bacterium 2026762 Bacteria Bacteria 55.1 1.25e-6   NR NBR25029.1 2026762 g2306 i0 50.9 0.763392857142857 57 27 76.3 1 220 50 219 274 NBR25029.1 hypothetical protein [Micrococcales bacterium] diamond 171 55.1 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales     Micrococcales bacterium
30211948 30211948 PRJNA801875_P_NODE_1892_length_269_cov_2.226496_g1789_i0 PRJNA801875 1892 269 2.226496 5.98927424 Actinomycetes bacterium 1883427 Bacteria Bacteria 69.7 3.11e-12   NR MEI6294978.1 1883427 g1789 i0 50.7 0.79182156133829 71 35 79.2 0 224 12 4 74 MEI6294978.1 NAD(P)H-dependent oxidoreductase [Actinomycetes bacterium] diamond 213 69.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes       Actinomycetes bacterium
30970558 30970558 PRJNA801875_P_NODE_874_length_447_cov_3.538835_g772_i0 PRJNA801875 874 447 3.538835 15.81859245 Actinomycetota bacterium 2900548 Bacteria Bacteria 159 3.75e-46   NR MEY2634385.1 2900548 g772 i0 59.9 1.90604026845638 142 57 95.3 0 438 13 66 207 MEY2634385.1 hypothetical protein [Actinomycetota bacterium] diamond 852 159 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
31760857 31760857 PRJNA801875_P_NODE_4797_length_150_cov_1.043478_g4694_i0 PRJNA801875 4797 150 1.043478 1.565217 Marmoricola sp. 1909296 Bacteria Bacteria 47.8 1.74e-4   NR MCW2846527.1 1909296 g4694 i0 45.7 2.8 46 21 92 1 149 12 179 220 MCW2846527.1 transporter [Marmoricola sp.] diamond 420 47.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Nocardioidaceae Marmoricola Marmoricola 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);;