RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA835051", 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

  • PRJNA835051 · 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
27086320 27086320 PRJNA835051_S_NODE_50482_length_216_cov_1.907514_g50186_i0 PRJNA835051 50482 216 1.907514 4.12023024 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 45.8 4.25e-4   NR HYP43214.1 2109671 g50186 i0 90.5 0.291666666666667 21 2 29.2 0 147 209 1 21 HYP43214.1 hypothetical protein [Candidatus Nitrosocosmicus sp.] diamond 63 45.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
29139137 29139137 PRJNA835051_S_NODE_12509_length_308_cov_46.935849_g12213_i0 PRJNA835051 12509 308 46.935849 144.56241492 uncultured marine thaumarchaeote KM3_53_F 1167203 Archaea Archaea 55.8 3.66e-8   NR AIF11850.1 1456186 g12213 i0 75 0.350649350649351 36 9 35.1 0 193 300 1 36 AIF11850.1 hypothetical protein, partial [uncultured marine thaumarchaeote KM3_53_F08] diamond 108 55.8 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_53_F08
30876095 30876095 PRJNA835051_S_NODE_121974_length_155_cov_2.098214_g121678_i0 PRJNA835051 121974 155 2.098214 3.2522317 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 43.1 0.00825   NR HYP42844.1 2109671 g121678 i0 86.4 0.425806451612903 22 3 42.6 0 71 6 432 453 HYP42844.1 RNase H family protein [Candidatus Nitrosocosmicus sp.] diamond 66 43.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
32109405 32109405 PRJNA835051_S_NODE_18878_length_280_cov_2.405063_g18582_i0 PRJNA835051 18878 280 2.405063 6.7341764 Nitrososphaerota archaeon 2026795 Archaea Archaea 43.9 0.0202   NR MER3602033.1 2026795 g18582 i0 39.7 0.835714285714286 78 44 80.4 1 33 257 119 196 MER3602033.1 hypothetical protein [Nitrososphaerota archaeon] diamond 234 43.9 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota 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);;