RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA631119 · 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
26777134 26777134 PRJNA631119_P_NODE_32221_length_249_cov_1.750000_g32103_i0 PRJNA631119 32221 249 1.75 4.3575 Nitrosopumilus 338191 Archaea Archaea 45.4 0.00449   NR WP_371504934.1 1580092 g32103 i0 42.9 2.60240963855422 42 24 50.6 0 143 18 315 356 WP_371504934.1 polysaccharide deacetylase family protein [Nitrosopumilus adriaticus] diamond 648 45.8 0.991266375545852 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus adriaticus
28660064 28660064 PRJNA631119_P_NODE_9467_length_391_cov_1.452830_g9349_i0 PRJNA631119 9467 391 1.45283 5.6805653 Nitrosopumilus sp. 2024843 Archaea Archaea 50.1 5.12e-4   NR MDH3489676.1 2024843 g9349 i0 33.3 0.552429667519182 72 47 55.2 1 283 68 319 389 MDH3489676.1 polysaccharide deacetylase family protein [Nitrosopumilus sp.] diamond 216 50.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
29954537 29954537 PRJNA631119_P_NODE_19311_length_301_cov_1.026316_g19193_i0 PRJNA631119 19311 301 1.026316 3.08921116 Nitrosopumilaceae archaeon 2202732 Archaea Archaea 67 2.18e-10   NR MCE2497419.1 2202732 g19193 i0 39.1 0.916943521594684 92 55 91.7 1 1 276 197 287 MCE2497419.1 VWA domain-containing protein [Nitrosopumilaceae archaeon] diamond 276 67 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae   Nitrosopumilaceae 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);;