RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJEB73599" and tax_phylum = "Planctomycetota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Planctomycetota · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJEB73599 · 3 ✖

analysis 1

  • diamond · 3 ✖
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
10338204 10338204 PRJEB73599_P_NODE_2089_length_513_cov_1.938017_g1833_i0 PRJEB73599 2089 513 1.938017 9.94202721 Planctomycetota bacterium 2026780 Bacteria Bacteria 177 1.09e-51   NR MFM7522431.1 2026780 g1833 i0 53.3 1.92982456140351 165 76 96.5 1 19 513 33 196 MFM7522431.1 glutamine synthetase type III [Planctomycetota bacterium] diamond 990 177 1 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
26868902 26868902 PRJEB73599_P_NODE_361_length_1213_cov_2.868243_g281_i0 PRJEB73599 361 1213 2.868243 34.79178759 Bacteria 2 Bacteria Bacteria 75.1 1.92e-10   NR MBM4090603.1 2026780 g281 i0 42.2 0.722176422093982 83 47 20.3 1 624 379 52 134 MBM4090603.1 tetratricopeptide repeat protein [Planctomycetota bacterium] diamond 876 75.5 0.994701986754967 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota bacterium
31227443 31227443 PRJEB73599_P_NODE_3535_length_376_cov_3.360231_g3249_i0 PRJEB73599 3535 376 3.360231 12.63446856 Bacteria 2 Bacteria Bacteria 61.6 9.69e-9   NR MDP6849681.1 2026780 g3249 i0 32.6 7.48404255319149 132 71 93.4 3 365 15 54 182 MDP6849681.1 guanylate kinase [Planctomycetota bacterium] diamond 2814 62 0.993548387096774 Bacteria PVC group Pseudomonadati Planctomycetota         Planctomycetota 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);;