RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1085664" and tax_phylum = "Actinomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Actinomycetota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1085664 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
27162089 27162089 PRJNA1085664_S_NODE_32362_length_157_cov_1.026316_g31943_i0 PRJNA1085664 32362 157 1.026316 1.61131612 Cutibacterium acnes 1747 Bacteria Bacteria 60.8 4.04e-9   NR MES6284439.1 1747 g31943 i0 62 1.8343949044586 50 19 95.5 0 6 155 109 158 MES6284439.1 hypothetical protein [Cutibacterium acnes] diamond 288 60.8 1 Bacteria   Bacillati Actinomycetota Actinomycetes Propionibacteriales Propionibacteriaceae Cutibacterium Cutibacterium acnes
27794193 27794193 PRJNA1085664_S_NODE_9304_length_284_cov_2.564315_g8885_i0 PRJNA1085664 9304 284 2.564315 7.2826546 Streptomyces sp. NPDC 1931 Bacteria Bacteria 42.7 0.0425   NR WP_366067297.1 3155153 g8885 i0 38.9 0.76056338028169 72 43 75 1 37 249 15 86 WP_366067297.1 hypothetical protein [Streptomyces sp. NPDC049577] diamond 216 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Kitasatosporales Streptomycetaceae Streptomyces Streptomyces sp. NPDC049577
28994150 28994150 PRJNA1085664_S_NODE_16768_length_212_cov_2.272189_g16349_i0 PRJNA1085664 16768 212 2.272189 4.81704068 Micromonospora sp. NPDC 1876 Bacteria Bacteria 42.7 0.0246   NR WP_393523195.1 3364269 g16349 i0 41.2 0.721698113207547 51 29 72.2 1 158 6 227 276 WP_393523195.1 aspartate aminotransferase family protein [Micromonospora sp. NPDC049282] diamond 153 42.7 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micromonosporales Micromonosporaceae Micromonospora Micromonospora sp. NPDC049282
31647581 31647581 PRJNA1085664_S_NODE_19457_length_198_cov_0.870968_g19038_i0 PRJNA1085664 19457 198 0.870968 1.72451664 Actinomycetota bacterium 2900548 Bacteria Bacteria 42.4 0.0232   NR MEA2843586.1 2900548 g19038 i0 48.6 0.560606060606061 37 19 56.1 0 24 134 61 97 MEA2843586.1 purine-nucleoside/S-methyl-5-thioadenosine phosphorylase / adenosine deaminase [Actinomycetota bacterium] diamond 111 42.4 1 Bacteria   Bacillati Actinomycetota         Actinomycetota 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);;