RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 5 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1240804 · 5 ✖

analysis 1

  • blastn · 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
8001569 8001569 PRJNA1240804_P_NODE_41967_length_233_cov_2.467391_g41601_i0 PRJNA1240804 41967 233 2.467391 5.74902103 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 405 1.39e-108   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g41601 i0 100 26.3991416309013 219 0 94 0 1 219 1790464 1790246 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 6151 405 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
10552623 10552623 PRJNA1240804_P_NODE_58149_length_207_cov_2.063291_g57783_i0 PRJNA1240804 58149 207 2.063291 4.27101237 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 344 2.67e-90   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g57783 i0 98.958 13.9710144927536 192 2 93 0 15 206 1792025 1792216 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 2892 344 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
14378211 14378211 PRJNA1240804_P_NODE_87932_length_181_cov_1.454545_g87566_i0 PRJNA1240804 87932 181 1.454545 2.63272645 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 305 1.07e-78   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g87566 i0 100 8.1491712707182309 165 0 91 0 15 179 1790848 1791012 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 1475 305 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
16352442 16352442 PRJNA1240804_P_NODE_137933_length_164_cov_0.904348_g137567_i0 PRJNA1240804 137933 164 0.904348 1.48313072 Nitrososphaera 497726 Archaea Archaea 252 1.26e-62   NTclustered gi|300521484|gb|GU797787.1| 497727 g137567 i0 95 41.609756097561 160 8 98 0 5 164 1693 1852 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 6824 252 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
18901961 18901961 PRJNA1240804_P_NODE_92755_length_178_cov_1.294574_g92389_i0 PRJNA1240804 92755 178 1.294574 2.30434172 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 292 8.15e-75   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g92389 i0 98.78 17.4101123595506 164 2 92 0 15 178 1789689 1789852 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 3099 292 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola

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);;