RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA934472" and tax_clade = "Stenosarchaea group"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_kingdom 1

tax_clade 1

  • Stenosarchaea group · 2 ✖

bioproject 1

  • PRJNA934472 · 2 ✖

analysis 1

  • blastn · 2 ✖
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
6359506 6359506 PRJNA934472_P_NODE_17305_length_347_cov_2.905109_g16928_i0 PRJNA934472 17305 347 2.905109 10.08072823 Methanocorpusculum 2192 Archaea Archaea 503 7.55e-138   NTclustered gi|470481509|ref|NR_076479.1| 83984 g16928 i0 92.795 126.968299711816 347 25 100 0 1 347 1453 1799 Methanocorpusculum labreanum strain Z 23S ribosomal RNA gene, complete sequence blastn 44058 503 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Methanomicrobia Methanomicrobiales Methanocorpusculaceae Methanocorpusculum Methanocorpusculum labreanum
17489315 17489315 PRJNA934472_P_NODE_27674_length_281_cov_1.442308_g27296_i0 PRJNA934472 27674 281 1.442308 4.05288548 Halococcus dombrowskii 179637 Archaea Archaea 220 6.71e-53   NTclustered gi|2221489803|gb|CP095005.1| 179637 g27296 i0 80.919 1.00711743772242 283 50 100 4 1 281 235585 235305 Halococcus dombrowskii strain H4 chromosome, complete genome blastn 283 220 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii

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