RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA556992" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA556992 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
3072769 3072769 PRJNA556992_P_NODE_1003663_length_230_cov_3.019108_g1001473_i0 PRJNA556992 1003663 230 3.019108 6.9439484 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 211 3.2e-50   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g1001473 i0 83.621 17.0739130434783 232 31 99 6 1 229 1791044 1790817 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 3927 211 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
6231430 6231430 PRJNA556992_P_NODE_854665_length_243_cov_1.629412_g852475_i0 PRJNA556992 854665 243 1.629412 3.95947116 Nitrosopumilus 338191 Archaea Archaea 52.8 0.022   NTclustered gi|407047065|gb|CP003843.1| 1229909 g852475 i0 100 0.230452674897119 28 0 12 0 172 199 854190 854163 Candidatus Nitrosopumilus sp. AR2, complete genome blastn 56 52.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Candidatus Nitrosopumilus sediminis
15155689 15155689 PRJNA556992_P_NODE_832152_length_244_cov_2.228070_g829962_i0 PRJNA556992 832152 244 2.22807 5.4364908 Nitrososphaera 497726 Archaea Archaea 357 4.16e-94   NTclustered gi|300521484|gb|GU797787.1| 497727 g829962 i0 93.033 35.6434426229508 244 17 100 0 1 244 1530 1773 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 8697 357 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis
18976428 18976428 PRJNA556992_P_NODE_160795_length_350_cov_10.324910_g158607_i0 PRJNA556992 160795 350 10.32491 36.137185 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 619 7.23e-173   NTclustered gi|937513727|gb|CP012850.1| 1353260 g158607 i0 98.575 95.7857142857143 351 4 100 1 1 350 850681 850331 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 33525 619 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
24754070 24754070 PRJNA556992_P_NODE_367220_length_280_cov_1.850242_g365031_i0 PRJNA556992 367220 280 1.850242 5.1806776 Candidatus Nitrosocosmicus franklandianus 1798806 Archaea Archaea 268 2.3499999999999994e-67   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g365031 i0 84.099 43.4321428571429 283 40 99 3 1 278 2447 2729 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 12161 268 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus
25352479 25352479 PRJNA556992_P_NODE_386360_length_278_cov_1.502439_g384171_i0 PRJNA556992 386360 278 1.502439 4.17678042 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 411 3.659999999999999e-110   NTclustered gi|937513727|gb|CP012850.1| 1353260 g384171 i0 93.214 18.0395683453237 280 17 100 2 1 278 850403 850682 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 5015 411 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus

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