RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA550047" 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

  • PRJNA550047 · 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
1790389 1790389 PRJNA550047_P_NODE_301002_length_297_cov_7.236607_g299033_i0 PRJNA550047 301002 297 7.236607 21.49272279 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 315 3.19e-81   NTclustered gi|937513727|gb|CP012850.1| 1353260 g299033 i0 85.953 1.00673400673401 299 36 99 4 1 294 2124246 2124543 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 299 315 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
4345452 4345452 PRJNA550047_P_NODE_596344_length_199_cov_7.865079_g594371_i0 PRJNA550047 596344 199 7.865079 15.65150721 Candidatus Nitrosocosmicus franklandianus 1798806 Archaea Archaea 255 1.23e-63   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g594371 i0 90.674 51.2361809045226 193 17 97 1 1 193 1595 1404 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 10196 255 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus
5617478 5617478 PRJNA550047_P_NODE_206345_length_325_cov_11.980159_g204377_i0 PRJNA550047 206345 325 11.980159 38.93551675 Candidatus Nitrosocosmicus franklandianus 1798806 Archaea Archaea 520 6.969999999999998e-143   NTclustered gi|1599533355|emb|LR216287.1| 1798806 g204377 i0 95.679 20.0338461538462 324 12 99 2 2 325 2025 2346 Candidatus Nitrosocosmicus franklandus isolate NFRAN1 genome assembly, chromosome: NFRAN blastn 6511 520 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus franklandianus
11325060 11325060 PRJNA550047_P_NODE_527389_length_221_cov_9.378378_g525416_i0 PRJNA550047 527389 221 9.378378 20.72621538 Nitrosopumilus 338191 Archaea Archaea 89.8 1.49e-13   NTclustered gi|507148339|ref|NR_103142.1| 338192 g525416 i0 87.342 34.7737556561086 79 8 36 2 85 163 514 438 Nitrosopumilus maritimus strain SCM1 23S ribosomal RNA gene, complete sequence blastn 7685 89.8 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus maritimus
20915661 20915661 PRJNA550047_P_NODE_197837_length_343_cov_13.711111_g195876_i0 PRJNA550047 197837 343 13.711111 47.02911073 Candidatus Nitrososphaera evergladensis 1459637 Archaea Archaea 73.1 2.49e-8   NTclustered gi|665992324|gb|CP007174.1| 1459636 g195876 i0 80.645 0.556851311953353 93 18 27 0 33 125 1288267 1288175 Candidatus Nitrososphaera evergladensis SR1, complete genome blastn 191 73.1 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera evergladensis
24073077 24073077 PRJNA550047_P_NODE_342899_length_288_cov_4.516279_g340929_i0 PRJNA550047 342899 288 4.516279 13.00688352 Nitrososphaera 497726 Archaea Archaea 486 6.159999999999999e-133   NTclustered gi|300521484|gb|GU797787.1| 497727 g340929 i0 97.213 103.006944444444 287 8 99 0 1 287 2135 1849 Candidatus Nitrososphaera gargensis 23S ribosomal RNA gene, partial sequence blastn 29666 486 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Nitrososphaera Candidatus Nitrososphaera gargensis

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