RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA734348 · 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
2472700 2472700 PRJNA734348_P_NODE_51122_length_289_cov_1.185185_g50425_i0 PRJNA734348 51122 289 1.185185 3.42518465 Candidatus Nitrosocosmicus 1826864 Archaea Archaea 440 4.889999999999998e-119   NTclustered gi|937513727|gb|CP012850.1| 1353260 g50425 i0 94.118 31.0795847750865 289 17 100 0 1 289 848531 848819 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 8982 440 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
4545864 4545864 PRJNA734348_P_NODE_138024_length_235_cov_2.771605_g137326_i0 PRJNA734348 138024 235 2.771605 6.51327175 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 300 6.81e-77   NTclustered gi|808354332|gb|CP011097.2| 1603555 g137326 i0 89.744 1.66808510638298 234 24 99 0 2 235 1357402 1357169 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 392 300 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
12198544 12198544 PRJNA734348_P_NODE_92290_length_251_cov_0.865169_g91592_i0 PRJNA734348 92290 251 0.865169 2.17157419 Candidatus Nitrosocosmicus arcticus 2035267 Archaea Archaea 431 2.4999999999999996e-116   NTclustered gi|1241355791|gb|KX863713.1| 2035267 g91592 i0 97.61 52.7490039840637 251 6 100 0 1 251 350 600 Candidatus Nitrosocosmicus arcticus 23S ribosomal RNA gene, partial sequence blastn 13240 431 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus arcticus
16021161 16021161 PRJNA734348_P_NODE_58773_length_281_cov_1.230769_g58076_i0 PRJNA734348 58773 281 1.230769 3.45846089 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 459 1.31e-124   NTclustered gi|808354332|gb|CP011097.2| 1603555 g58076 i0 96.085 1 281 11 100 0 1 281 1346678 1346958 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 281 459 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
17295695 17295695 PRJNA734348_P_NODE_150854_length_196_cov_4.081301_g150156_i0 PRJNA734348 150854 196 4.081301 7.99934996 Candidatus Nitrosocosmicus hydrocola 1826872 Archaea Archaea 357 3.2099999999999996e-94   NTclustered gi|1100598057|gb|CP017922.1| 1826872 g150156 i0 99.49 28.6785714285714 196 1 100 0 1 196 1790472 1790277 Candidatus Nitrosocosmicus hydrocola strain G61, complete genome blastn 5621 357 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus hydrocola
22394424 22394424 PRJNA734348_P_NODE_110038_length_246_cov_2.751445_g109340_i0 PRJNA734348 110038 246 2.751445 6.7685547 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 455 1.4500000000000002e-123   NTclustered gi|808354332|gb|CP011097.2| 1603555 g109340 i0 100 1 246 0 100 0 1 246 15375 15620 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 246 455 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae

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