RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Archaea · 5 ✖

tax_phylum 1

  • Nitrososphaerota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA743294 · 5 ✖

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
27842168 27842168 PRJNA743294_P_NODE_9524_length_511_cov_2.141553_g9068_i0 PRJNA743294 9524 511 2.141553 10.94333583 Nitrososphaerota archaeon 2026795 Archaea Archaea 57 1.25e-6   NR MEM3062687.1 2026795 g9068 i0 37.8 0.575342465753425 98 52 53.4 3 311 39 24 119 MEM3062687.1 putative dsRNA-binding protein [Nitrososphaerota archaeon] diamond 294 57 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota archaeon
29042317 29042317 PRJNA743294_P_NODE_49408_length_249_cov_1.965909_g48952_i0 PRJNA743294 49408 249 1.965909 4.8951134100000004 Nitrosopumilus sp. 2024843 Archaea Archaea 71.2 6.47e-13   NR MBA3284293.1 2024843 g48952 i0 45.3 0.903614457831325 75 39 90.4 1 3 227 130 202 MBA3284293.1 class I SAM-dependent methyltransferase [Nitrosopumilus sp.] diamond 225 71.2 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
31411529 31411529 PRJNA743294_P_NODE_59476_length_227_cov_3.863636_g59020_i0 PRJNA743294 59476 227 3.863636 8.77045372 Nitrosopumilus sp. 2024843 Archaea Archaea 44.3 0.00544   NR MBT8252157.1 2024843 g59020 i0 43.5 0.819383259911894 62 21 81.9 2 6 191 93 140 MBT8252157.1 hypothetical protein [Nitrosopumilus sp.] diamond 186 44.3 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
31664317 31664317 PRJNA743294_P_NODE_12457_length_451_cov_2.854497_g12001_i0 PRJNA743294 12457 451 2.854497 12.87378147 Nitrosopumilus sp. 2024843 Archaea Archaea 99.4 2.48e-21   NR MDA7940732.1 2024843 g12001 i0 68.4 2.04878048780488 57 18 37.9 0 270 100 343 399 MDA7940732.1 multicopper oxidase domain-containing protein [Nitrosopumilus sp.] diamond 924 99.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
32170926 32170926 PRJNA743294_P_NODE_9958_length_501_cov_1.640187_g9502_i0 PRJNA743294 9958 501 1.640187 8.21733687 Nitrososphaeraceae archaeon 2169593 Archaea Archaea 201 1.14e-59   NR HVD36003.1 2169593 g9502 i0 59.4 2.95209580838323 165 67 98.8 0 498 4 9 173 HVD36003.1 ammonium transporter [Nitrososphaeraceae archaeon] diamond 1479 201 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae   Nitrososphaeraceae 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);;