RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA599026" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 4 ✖

tax_kingdom 1

bioproject 1

  • PRJNA599026 · 4 ✖

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
20973802 20973802 PRJNA599026_S_NODE_26177_length_211_cov_2.882716_g25721_i0 PRJNA599026 26177 211 2.882716 6.08253076 Candidatus Nitrosomarinus catalinensis 1898749 Archaea Archaea 52.8 0.019   NTclustered gi|1196088602|gb|CP021324.1| 1898749 g25721 i0 100 0.132701421800948 28 0 13 0 157 184 1213542 1213515 Candidatus Nitrosomarinus catalina strain SPOT01 chromosome, complete genome blastn 28 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Candidatus Nitrosomarinus Candidatus Nitrosomarinus catalinensis
30079684 30079684 PRJNA599026_S_NODE_12652_length_279_cov_3.000000_g12196_i0 PRJNA599026 12652 279 3 8.37 Nitrososphaera sp. 1971748 Archaea Archaea 45.1 0.00845   NR HVX03469.1 1971748 g12196 i0 40.3 0.666666666666667 62 29 66.7 2 89 274 405 458 HVX03469.1 glycosyltransferase family 2 protein [Nitrososphaera sp.] diamond 186 45.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Nitrososphaera sp.
31533835 31533835 PRJNA599026_S_NODE_46296_length_172_cov_2.073171_g45840_i0 PRJNA599026 46296 172 2.073171 3.56585412 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 40 0.0312   NR HJR84952.1 2169593 g45840 i0 55.2 0.505813953488372 29 13 50.6 0 169 83 22 50 HJR84952.1 hypothetical protein [Nitrososphaeraceae archaeon] diamond 87 40 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae archaeon
32671938 32671938 PRJNA599026_S_NODE_27140_length_209_cov_1.075000_g26684_i0 PRJNA599026 27140 209 1.075 2.24675 Nitrososphaeria archaeon 2268198 Archaea Archaea 43.1 0.0113   NR MEM0385417.1 2268198 g26684 i0 40.4 2.89952153110048 52 31 74.6 0 209 54 26 77 MEM0385417.1 ATP-binding cassette domain-containing protein [Nitrososphaeria archaeon] diamond 606 43.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria       Nitrososphaeria 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);;