RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA728642" 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 · 6 ✖

bioproject 1

  • PRJNA728642 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
8366174 8366174 PRJNA728642_P_NODE_2687_length_635_cov_1.411032_g2423_i0 PRJNA728642 2687 635 1.411032 8.9600532 Halococcus dombrowskii 179637 Archaea Archaea 924 0   NTclustered gi|2221492933|gb|CP095007.1| 179637 g2423 i0 92.936 146.71811023622 637 42 100 3 1 635 130226 129591 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 93166 924 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
12674552 12674552 PRJNA728642_P_NODE_19690_length_241_cov_0.916667_g19419_i0 PRJNA728642 19690 241 0.916667 2.20916747 Halobacteriales 2235 Archaea Archaea 390 4.05e-104   NTclustered gi|1675273172|gb|MN000365.1| 29284 g19419 i0 95.851 99.253112033195 241 10 100 0 1 241 6 246 Halorubrum trapanicum strain ISD451 16S ribosomal RNA gene, partial sequence blastn 23920 390 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Haloferacaceae Halorubrum Halorubrum trapanicum
17772659 17772659 PRJNA728642_P_NODE_12594_length_284_cov_1.402844_g12323_i0 PRJNA728642 12594 284 1.402844 3.98407696 Halococcus 2249 Archaea Archaea 479 1.01e-130   NTclustered gi|2221492933|gb|CP095007.1| 179637 g12323 i0 97.183 180.316901408451 284 7 100 1 1 284 129274 129556 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 51210 479 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus dombrowskii
19839663 19839663 PRJNA728642_P_NODE_11316_length_301_cov_1.276316_g11045_i0 PRJNA728642 11316 301 1.276316 3.84171116 Halococcus qingdaonensis 224402 Archaea Archaea 460 3.9299999999999997e-125   NTclustered gi|2281256326|gb|CP101943.1| 224402 g11045 i0 94.631 164.328903654485 298 14 99 2 5 301 2645385 2645681 Halococcus qingdaonensis strain CGMCC 1.4243 chromosome, complete genome blastn 49463 460 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halococcaceae Halococcus Halococcus qingdaonensis
20321662 20321662 PRJNA728642_P_NODE_8796_length_343_cov_1.425926_g8525_i0 PRJNA728642 8796 343 1.425926 4.89092618 Halococcus 2249 Archaea Archaea 617 2.55e-172   NTclustered gi|2746137121|gb|PP939405.1| 29295 g8525 i0 99.125 99.6705539358601 343 3 100 0 1 343 12 354 Halophilic archaeon strain SDF51 16S ribosomal RNA gene, partial sequence blastn 34187 617 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales     halophilic archaeon
25421527 25421527 PRJNA728642_P_NODE_16760_length_248_cov_2.640000_g16489_i0 PRJNA728642 16760 248 2.64 6.5472 Halococcus 2249 Archaea Archaea 431 2.47e-116   NTclustered gi|2221492933|gb|CP095007.1| 179637 g16489 i0 97.984 161.983870967742 248 5 100 0 1 248 130842 131089 Halococcus dombrowskii strain H4 plasmid unnamed2, complete sequence blastn 40172 431 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);;