RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA1065838" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1065838 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
10383382 10383382 PRJNA1065838_S_NODE_33589_length_166_cov_0.888889_g33487_i0 PRJNA1065838 33589 166 0.888889 1.47555574 Actinomycetota bacterium 2900548 Bacteria Bacteria 94.4 3.2e-21   NR MDP9480559.1 2900548 g33487 i0 88.5 0.939759036144578 52 6 94 0 6 161 133 184 MDP9480559.1 DUF2723 domain-containing protein [Actinomycetota bacterium] diamond 156 94.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27477912 27477912 PRJNA1065838_S_NODE_18983_length_205_cov_2.019231_g18881_i0 PRJNA1065838 18983 205 2.019231 4.13942355 Actinomycetota bacterium 2900548 Bacteria Bacteria 41.6 0.0321   NR MEM9711618.1 2900548 g18881 i0 46.3 0.6 41 22 60 0 66 188 72 112 MEM9711618.1 SRPBCC family protein [Actinomycetota bacterium] diamond 123 41.6 1 Bacteria   Bacillati Actinomycetota         Actinomycetota bacterium
27541191 27541191 PRJNA1065838_S_NODE_23764_length_192_cov_1.041958_g23662_i0 PRJNA1065838 23764 192 1.041958 2.00055936 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 43.9 0.00734   NR MET0661992.1 2497619 g23662 i0 44.7 0.59375 38 21 59.4 0 56 169 106 143 MET0661992.1 hypothetical protein [Ilumatobacteraceae bacterium] diamond 114 43.9 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
28203930 28203930 PRJNA1065838_S_NODE_33526_length_166_cov_0.888889_g33424_i0 PRJNA1065838 33526 166 0.888889 1.47555574 Solirubrobacteraceae bacterium 2586742 Bacteria Bacteria 54.7 2.36e-7   NR MDX6679988.1 2586742 g33424 i0 42.3 0.939759036144578 52 30 94 0 158 3 55 106 MDX6679988.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 156 54.7 1 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
28456866 28456866 PRJNA1065838_S_NODE_8786_length_260_cov_1.417062_g8684_i0 PRJNA1065838 8786 260 1.417062 3.6843612 Mycobacterium tuberculosis 1773 Bacteria Bacteria 143 5.669999999999999e-42   NR WP_214608624.1 1773 g8684 i0 98.7 0.9 78 1 90 0 258 25 47 124 WP_214608624.1 hypothetical protein, partial [Mycobacterium tuberculosis] diamond 234 143 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis
28930393 28930393 PRJNA1065838_S_NODE_31828_length_169_cov_0.866667_g31726_i0 PRJNA1065838 31828 169 0.866667 1.46466723 Mycobacterium sp. UM_WGJ 1370120 Bacteria Bacteria 92.8 3.19e-20   NR WP_024441286.1 1370120 g31726 i0 85.5 2.92899408284024 55 8 97.6 0 5 169 107 161 WP_024441286.1 SNF2-related protein [Mycobacterium sp. UM_WGJ] diamond 495 92.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium sp. UM_WGJ
29940932 29940932 PRJNA1065838_S_NODE_35691_length_163_cov_0.912281_g35589_i0 PRJNA1065838 35691 163 0.912281 1.48701803 Nocardiopsis sp. JB363 1434837 Bacteria Bacteria 113 4.600000000000001e-28   NR WP_087104054.1 1434837 g35589 i0 100 0.993865030674847 54 0 99.4 0 1 162 212 265 WP_087104054.1 ABC transporter substrate-binding protein [Nocardiopsis sp. JB363] diamond 162 113 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Nocardiopsidaceae Nocardiopsis Nocardiopsis sp. JB363
29972337 29972337 PRJNA1065838_S_NODE_23351_length_193_cov_1.076389_g23249_i0 PRJNA1065838 23351 193 1.076389 2.07743077 Micrococcus 1269 Bacteria Bacteria 115 1.67e-29   NR WP_206450741.1 1269 g23249 i0 100 0.979274611398964 63 0 97.9 0 3 191 48 110 WP_206450741.1 MULTISPECIES: LysR family transcriptional regulator [Micrococcus] diamond 189 115 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Micrococcus  
30225074 30225074 PRJNA1065838_S_NODE_32212_length_168_cov_1.277311_g32110_i0 PRJNA1065838 32212 168 1.277311 2.14588248 Lawsonella clevelandensis 1528099 Bacteria Bacteria 125 4.1799999999999996e-32   NR WP_394268147.1 1528099 g32110 i0 100 1 56 0 100 0 1 168 397 452 WP_394268147.1 DNA polymerase IV [Lawsonella clevelandensis] diamond 168 125 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Lawsonellaceae Lawsonella Lawsonella clevelandensis
31552726 31552726 PRJNA1065838_S_NODE_33076_length_167_cov_0.864407_g32974_i0 PRJNA1065838 33076 167 0.864407 1.44355969 Corynebacterium matruchotii 43768 Bacteria Bacteria 44.7 0.00274   NR WP_005520162.1 43768 g32974 i0 87 0.413173652694611 23 3 41.3 0 72 4 1 23 WP_005520162.1 hypothetical protein [Corynebacterium matruchotii] diamond 69 44.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium matruchotii
31963616 31963616 PRJNA1065838_S_NODE_31558_length_169_cov_1.300000_g31456_i0 PRJNA1065838 31558 169 1.3 2.197 Mycobacterium tuberculosis 1773 Bacteria Bacteria 121 3.54e-34   NR MXI72407.1 1773 g31456 i0 100 2.92899408284024 55 0 97.6 0 167 3 49 103 MXI72407.1 arginyltransferase [Mycobacterium tuberculosis] diamond 495 121 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Mycobacteriaceae Mycobacterium Mycobacterium tuberculosis

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