RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where bioproject = "PRJNA951388" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_kingdom 2

tax_superkingdom 1

  • Archaea · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA951388 · 2 ✖

analysis 1

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
11466540 11466540 PRJNA951388_S_NODE_3429_length_430_cov_7.291317_g3302_i0 PRJNA951388 3429 430 7.291317 31.3526631 root 1 Root_unresolved Root_unresolved 110 1.68e-26   NR WP_015385795.1 2285 g3302 i0 51.3 6.5093023255814 115 56 80.2 0 428 84 112 226 WP_015385795.1 enoyl-CoA hydratase/isomerase family protein [Sulfolobus acidocaldarius] diamond 2799 111 0.990990990990991 Archaea   Thermoproteati Thermoproteota Thermoprotei Sulfolobales Sulfolobaceae Sulfolobus Sulfolobus acidocaldarius
29772732 29772732 PRJNA951388_S_NODE_6911_length_323_cov_7.004000_g6784_i0 PRJNA951388 6911 323 7.004 22.62292 Halobacterium jilantaiense 355548 Archaea Archaea 43.9 0.033   NR WP_089668695.1 355548 g6784 i0 35.6 0.678018575851393 73 46 66.9 1 2 217 98 170 WP_089668695.1 tyrosine-type recombinase/integrase [Halobacterium jilantaiense] diamond 219 43.9 1 Archaea Stenosarchaea group Methanobacteriati Methanobacteriota Halobacteria Halobacteriales Halobacteriaceae Halobacterium Halobacterium jilantaiense

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