RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA1182301", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

  • Nitrososphaerota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1182301 · 5 ✖

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
4145734 4145734 PRJNA1182301_P_NODE_45744_length_254_cov_2.469613_g45619_i0 PRJNA1182301 45744 254 2.469613 6.27281702 Nitrosopumilus sp. 2024843 Archaea Archaea 409 1.19e-109   NTclustered gi|2805380108|emb|OY763927.2| 2024843 g45619 i0 95.669 3.94094488188976 254 11 100 0 1 254 782369 782622 MAG: Nitrosopumilus sp. isolate e501d42f-d10b-4094-a589-3c4c61670bda genome assembly, chromosome: 1 blastn 1001 409 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
27861811 27861811 PRJNA1182301_P_NODE_57745_length_245_cov_0.895349_g57620_i0 PRJNA1182301 57745 245 0.895349 2.19360505 Candidatus Nitrosocosmicus sp. 2109671 Archaea Archaea 160 1.03e-44   NR HEX5519150.1 2109671 g57620 i0 95.1 0.991836734693878 81 4 99.2 0 3 245 387 467 HEX5519150.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Candidatus Nitrosocosmicus sp.] diamond 243 160 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus sp.
29566825 29566825 PRJNA1182301_P_NODE_31630_length_273_cov_1.470000_g31505_i0 PRJNA1182301 31630 273 1.47 4.0131 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 173 2.44e-52   NR HEX6027542.1 2169593 g31505 i0 93.4 3 91 6 100 0 1 273 93 183 HEX6027542.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 819 173 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
31241151 31241151 PRJNA1182301_P_NODE_28355_length_277_cov_2.014706_g28230_i0 PRJNA1182301 28355 277 2.014706 5.58073562 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 147 9.42e-43   NR HKG41931.1 2169593 g28230 i0 89.5 0.931407942238267 86 9 93.1 0 260 3 3 88 HKG41931.1 5-formyltetrahydrofolate cyclo-ligase [Nitrososphaeraceae archaeon] diamond 258 147 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32777819 32777819 PRJNA1182301_P_NODE_25900_length_281_cov_1.182692_g25775_i0 PRJNA1182301 25900 281 1.182692 3.32336452 Thermoproteati 1783275 Archaea Archaea 68.9 1.02e-11   NR HWS20841.1 1971748 g25775 i0 88.9 1.11032028469751 36 4 38.4 0 110 3 16 51 HWS20841.1 histidine phosphatase family protein [Nitrososphaera sp.] diamond 312 68.9 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);;