RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA692200" 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

  • PRJNA692200 · 6 ✖

analysis 1

  • blastn · 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
1179261 1179261 PRJNA692200_S_NODE_20521_length_165_cov_4.336207_g20464_i0 PRJNA692200 20521 165 4.336207 7.15474155 Corynebacterium 1716 Bacteria Bacteria 287 3.47e-73   NTclustered gi|2547420364|gb|CP073093.1| 38304 g20464 i0 98.758 356.175757575758 161 2 98 0 1 161 760146 759986 Corynebacterium tuberculostearicum strain CTNIH12 chromosome, complete genome blastn 58769 287 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium tuberculostearicum
5776342 5776342 PRJNA692200_S_NODE_3085_length_337_cov_5.892361_g3028_i0 PRJNA692200 3085 337 5.892361 19.85725657 Streptomyces sp. NBC_00857 2975851 Bacteria Bacteria 54.7 0.009   NTclustered gi|2655540414|gb|CP108829.1| 2975851 g3028 i0 100 0.086053412462908 29 0 9 0 253 281 2448791 2448819 Streptomyces sp. NBC_00857 chromosome, complete genome blastn 29 54.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NBC_00857
9601140 9601140 PRJNA692200_S_NODE_17668_length_175_cov_1.357143_g17611_i0 PRJNA692200 17668 175 1.357143 2.37500025 Dactylosporangium thailandense 47849 Bacteria Bacteria 52.8 0.015   NTclustered gi|2666977426|dbj|AP029195.1| 47849 g17611 i0 100 0.16 28 0 16 0 137 164 7382693 7382720 Dactylosporangium thailandense JCM 3084 DNA, complete genome blastn 28 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Dactylosporangium Dactylosporangium thailandense
14701682 14701682 PRJNA692200_S_NODE_17852_length_174_cov_1.928000_g17795_i0 PRJNA692200 17852 174 1.928 3.35472 Embleya sp. NBC_00888 2975960 Bacteria Bacteria 52.8 0.015   NTclustered gi|2655411662|gb|CP108785.1| 2975960 g17795 i0 100 0.160919540229885 28 0 16 0 98 125 2988534 2988561 Embleya sp. NBC_00888 plasmid unnamed1, complete sequence blastn 28 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Embleya Embleya sp. NBC_00888
17757084 17757084 PRJNA692200_S_NODE_12674_length_202_cov_0.993464_g12617_i0 PRJNA692200 12674 202 0.993464 2.00679728 Streptomyces 1883 Bacteria Bacteria 52.8 0.018   NTclustered gi|1751485547|gb|CP023693.1| 67260 g12617 i0 100 0.415841584158416 28 0 14 0 95 122 3959630 3959603 Streptomyces cinereoruber strain ATCC 19740 chromosome, complete genome blastn 84 52.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces cinereoruber
25405718 25405718 PRJNA692200_S_NODE_18420_length_172_cov_1.097561_g18363_i0 PRJNA692200 18420 172 1.097561 1.88780492 Corynebacterium 1716 Bacteria Bacteria 309 7.75e-80   NTclustered gi|1403572617|emb|LS483460.1| 38301 g18363 i0 99.412 360.877906976744 170 1 99 0 1 170 145169 145000 Corynebacterium minutissimum strain NCTC10288 genome assembly, chromosome: 1 blastn 62071 309 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium Corynebacterium minutissimum

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