RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA944150", 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

  • PRJNA944150 · 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
28004697 28004697 PRJNA944150_P_NODE_8125_length_301_cov_2.301587_g7874_i0 PRJNA944150 8125 301 2.301587 6.92777687 Candidatus Caldarchaeales archaeon 3071590 Archaea Archaea 42.4 0.0149   NR MDT7879130.1 3071590 g7874 i0 43.6 0.388704318936877 39 22 38.9 0 184 300 4 42 MDT7879130.1 antibiotic biosynthesis monooxygenase [Candidatus Caldarchaeales archaeon] diamond 117 42.4 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales     Candidatus Caldarchaeales archaeon
28572755 28572755 PRJNA944150_P_NODE_46447_length_157_cov_3.620370_g46196_i0 PRJNA944150 46447 157 3.62037 5.6839809 Candidatus Nitrosothermus koennekii 2927315 Archaea Archaea 77 9.39e-15   NR RMF31295.1 2927315 g46196 i0 69.2 0.993630573248408 52 16 99.4 0 156 1 415 466 RMF31295.1 MAG: hypothetical protein D6752_02430, partial [Candidatus Nitrosothermus koennekii] diamond 156 77 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Candidatus Nitrosocaldales Candidatus Nitrosocaldaceae Candidatus Nitrosothermus Candidatus Nitrosothermus koennekii
29431795 29431795 PRJNA944150_P_NODE_41769_length_163_cov_0.894737_g41518_i0 PRJNA944150 41769 163 0.894737 1.45842131 Thermoproteati 1783275 Archaea Archaea 106 3.3100000000000004e-26   NR MBD0298742.1 1971748 g41518 i0 98.1 4.96932515337423 54 1 99.4 0 163 2 102 155 MBD0298742.1 class I SAM-dependent methyltransferase family protein [Nitrososphaera sp.] diamond 810 106 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.

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