RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA371613" and tax_phylum = "Acidobacteriota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Acidobacteriota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA371613 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
28369660 28369660 PRJNA371613_P_NODE_7086_length_172_cov_1.740741_g6910_i0 PRJNA371613 7086 172 1.740741 2.99407452 Acidobacteriota bacterium 1978231 Bacteria Bacteria 115 2.23e-30   NR MDQ3088195.1 1978231 g6910 i0 98.2 5.86046511627907 56 1 97.7 0 3 170 116 171 MDQ3088195.1 SDR family oxidoreductase [Acidobacteriota bacterium] diamond 1008 115 1 Bacteria   Pseudomonadati Acidobacteriota         Acidobacteriota bacterium
32541255 32541255 PRJNA371613_P_NODE_7599_length_170_cov_0.962406_g7423_i0 PRJNA371613 7599 170 0.962406 1.6360902 Vicinamibacteria bacterium 2793154 Bacteria Bacteria 43.9 0.00544   NR HEY8150658.1 2793154 g7423 i0 44.4 1.55294117647059 45 25 79.4 0 144 10 3 47 HEY8150658.1 sigma-54 dependent transcriptional regulator [Vicinamibacteria bacterium] diamond 264 43.9 1 Bacteria   Pseudomonadati Acidobacteriota Vicinamibacteria       Vicinamibacteria bacterium
32698431 32698431 PRJNA371613_P_NODE_9120_length_162_cov_1.536000_g8944_i0 PRJNA371613 9120 162 1.536 2.48832 Bryobacterales bacterium 2026791 Bacteria Bacteria 77.8 5.56e-15   NR MBK9170500.1 2026791 g8944 i0 64.2 4.92592592592593 53 19 98.1 0 1 159 633 685 MBK9170500.1 hypothetical protein [Bryobacterales bacterium] diamond 798 77.8 1 Bacteria   Pseudomonadati Acidobacteriota Terriglobia Bryobacterales     Bryobacterales 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);;