RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA760904", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 3 ✖

tax_phylum 1

  • Nitrososphaerota · 3 ✖

tax_kingdom 1

bioproject 1

  • PRJNA760904 · 3 ✖

analysis 1

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
26831648 26831648 PRJNA760904_P_NODE_13021_length_263_cov_1.621053_g12964_i0 PRJNA760904 13021 263 1.621053 4.26336939 Nitrosarchaeum sp. 2026886 Archaea Archaea 89 2.64e-18   NR HSA76138.1 2026886 g12964 i0 51.2 0.958174904942966 84 39 94.7 2 253 5 744 826 HSA76138.1 alpha-ketoglutarate-dependent dioxygenase AlkB [Nitrosarchaeum sp.] diamond 252 89 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp.
29895271 29895271 PRJNA760904_P_NODE_20671_length_241_cov_0.916667_g20614_i0 PRJNA760904 20671 241 0.916667 2.20916747 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 41.6 0.0427   NR MBD0359782.1 2169593 g20614 i0 38.2 0.846473029045643 68 39 82.2 2 200 3 5 71 MBD0359782.1 fused MFS/spermidine synthase [Nitrososphaeraceae archaeon] diamond 204 41.6 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30052988 30052988 PRJNA760904_P_NODE_2751_length_492_cov_1.112172_g2694_i0 PRJNA760904 2751 492 1.112172 5.47188624 Nitrososphaeria archaeon 2268198 Archaea Archaea 46.2 0.0231   NR NDF30529.1 2268198 g2694 i0 31 0.884146341463415 145 77 76.8 6 3 380 161 301 NDF30529.1 hypothetical protein [Nitrososphaeria archaeon] diamond 435 46.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria archaeon

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