RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA849172", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 4 ✖

tax_phylum 1

  • Nitrososphaerota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA849172 · 4 ✖

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
26643216 26643216 PRJNA849172_P_NODE_96341_length_248_cov_1.782857_g95981_i0 PRJNA849172 96341 248 1.782857 4.42148536 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 130 2.43e-35   NR HYZ59562.1 2169593 g95981 i0 83.1 0.931451612903226 77 12 91.9 1 247 20 28 104 HYZ59562.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 231 130 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
30308119 30308119 PRJNA849172_P_NODE_79372_length_260_cov_3.117647_g79012_i0 PRJNA849172 79372 260 3.117647 8.1058822 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 157 1.99e-44   NR HXW11834.1 2169593 g79012 i0 94.2 0.992307692307692 86 5 99.2 0 259 2 291 376 HXW11834.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 258 157 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31572024 31572024 PRJNA849172_P_NODE_73096_length_266_cov_3.601036_g72736_i0 PRJNA849172 73096 266 3.601036 9.57875576 Nitrososphaerales archaeon 2268197 Archaea Archaea 78.2 1.08e-14   NR HUK74543.1 2268197 g72736 i0 46.4 0.947368421052632 84 45 94.7 0 255 4 216 299 HUK74543.1 DUF455 family protein [Nitrososphaerales archaeon] diamond 252 78.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales     Nitrososphaerales archaeon
31887979 31887979 PRJNA849172_P_NODE_101297_length_245_cov_4.354651_g100937_i0 PRJNA849172 101297 245 4.354651 10.66889495 Candidatus Caldarchaeum sp. 2972665 Archaea Archaea 88.2 4.21e-19   NR MEM4284369.1 2972665 g100937 i0 88.4 1.0530612244898 43 5 52.7 0 116 244 29 71 MEM4284369.1 IS5 family transposase [Candidatus Caldarchaeum sp.] diamond 258 88.2 1 Archaea   Thermoproteati Nitrososphaerota   Candidatus Caldarchaeales Candidatus Caldarchaeaceae Candidatus Caldarchaeum Candidatus Caldarchaeum 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);;