RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA806354 · 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
22482954 22482954 PRJNA806354_P_NODE_32758_length_260_cov_1.443850_g32649_i0 PRJNA806354 32758 260 1.44385 3.75401 Arthrobacter sp. efr-133-TYG-118 3040279 Bacteria Bacteria 144 4.68e-40   NR WP_284981519.1 3040279 g32649 i0 87.2 0.992307692307692 86 11 99.2 0 260 3 3 88 WP_284981519.1 aldo/keto reductase [Arthrobacter sp. efr-133-TYG-118] diamond 258 144 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter sp. efr-133-TYG-118
27906747 27906747 PRJNA806354_P_NODE_34885_length_252_cov_1.564246_g34776_i0 PRJNA806354 34885 252 1.564246 3.94189992 Actinomadura lepetitiana 2126066 Bacteria Bacteria 169 9.97e-51   NR NDU78054.1 2126066 g34776 i0 94 1.97619047619048 83 5 98.8 0 2 250 123 205 NDU78054.1 alanine racemase [Actinomadura lepetitiana] diamond 498 169 1 Bacteria   Bacillati Actinomycetota Actinomycetes Streptosporangiales Thermomonosporaceae Actinomadura Actinomadura lepetitiana
29485449 29485449 PRJNA806354_P_NODE_33330_length_257_cov_3.548913_g33221_i0 PRJNA806354 33330 257 3.548913 9.12070641 uncultured Corynebacterium sp. 159447 Bacteria Bacteria 108 3.2300000000000003e-27   NR WP_296212864.1 159447 g33221 i0 56.5 0.992217898832685 85 37 99.2 0 256 2 107 191 WP_296212864.1 hypothetical protein [uncultured Corynebacterium sp.] diamond 255 108 1 Bacteria   Bacillati Actinomycetota Actinomycetes Mycobacteriales Corynebacteriaceae Corynebacterium uncultured Corynebacterium sp.
30053986 30053986 PRJNA806354_P_NODE_39331_length_244_cov_0.900585_g39222_i0 PRJNA806354 39331 244 0.900585 2.1974274 Ilumatobacteraceae bacterium 2497619 Bacteria Bacteria 160 7.51e-45   NR MBP6489525.1 2497619 g39222 i0 96.2 0.971311475409836 79 3 97.1 0 4 240 276 354 MBP6489525.1 terminase family protein [Ilumatobacteraceae bacterium] diamond 237 160 1 Bacteria   Bacillati Actinomycetota Acidimicrobiia Acidimicrobiales Ilumatobacteraceae   Ilumatobacteraceae bacterium
30591227 30591227 PRJNA806354_P_NODE_2813_length_799_cov_2.140496_g2716_i0 PRJNA806354 2813 799 2.140496 17.10256304 Cutibacterium acnes 1747 Bacteria Bacteria 45.4 0.0153   NR MCQ8209668.1 1734925 g2716 i0 93.2 0.165206508135169 44 3 16.5 0 641 510 1 44 MCQ8209668.1 hypothetical protein [Cutibacterium acnes subsp. acnes] diamond 132 45.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
32362327 32362327 PRJNA806354_P_NODE_36919_length_248_cov_0.880000_g36810_i0 PRJNA806354 36919 248 0.88 2.1824 Candidatus Nanopelagicaceae bacterium 2518609 Bacteria Bacteria 73.9 1.97e-15   NR MFA9201950.1 2518609 g36810 i0 87.8 0.495967741935484 41 5 49.6 0 1 123 18 58 MFA9201950.1 hypothetical protein [Candidatus Nanopelagicaceae bacterium] diamond 123 73.9 1 Bacteria   Bacillati Actinomycetota Actinomycetes Candidatus Nanopelagicales Candidatus Nanopelagicaceae   Candidatus Nanopelagicaceae 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);;