RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where bioproject = "PRJNA939369", tax_phylum = "Nitrososphaerota" and tax_superkingdom = "Archaea"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

  • Archaea · 10 ✖

tax_phylum 1

  • Nitrososphaerota · 10 ✖

tax_kingdom 1

bioproject 1

  • PRJNA939369 · 10 ✖

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
2189624 2189624 PRJNA939369_S_NODE_24382_length_319_cov_1.020325_g23965_i0 PRJNA939369 24382 319 1.020325 3.25483675 Candidatus Nitrosopumilus sp. SW 2508726 Archaea Archaea 233 9.950000000000001e-57   NTclustered gi|1699461107|gb|CP035425.1| 2508726 g23965 i0 82.288 9.36050156739812 271 46 85 2 1 270 1026123 1025854 Candidatus Nitrosopumilus sp. SW chromosome, complete genome blastn 2986 233 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Candidatus Nitrosopumilus sp. SW
3808123 3808123 PRJNA939369_S_NODE_58363_length_249_cov_1.352273_g57946_i0 PRJNA939369 58363 249 1.352273 3.36715977 Nitrosopumilus 338191 Archaea Archaea 213 9.77e-51   NTclustered gi|1869224726|gb|CP026995.1| 1470067 g57946 i0 82.857 35.405622489959804 245 35 98 6 1 243 1660936 1660697 Nitrosopumilus ureiphilus strain PS0 chromosome, complete genome blastn 8816 213 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus ureiphilus
7292321 7292321 PRJNA939369_S_NODE_11666_length_403_cov_1.278788_g11249_i0 PRJNA939369 11666 403 1.278788 5.15351564 Nitrosopumilus zosterae 718286 Archaea Archaea 327 5.730000000000001e-85   NTclustered gi|2289589374|dbj|AP026695.1| 718286 g11249 i0 84.32 1.80893300248139 338 49 83 4 4 339 207010 206675 Nitrosopumilus zosterae NM25 DNA, complete genome blastn 729 327 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus zosterae
8567263 8567263 PRJNA939369_S_NODE_40287_length_276_cov_1.137931_g39870_i0 PRJNA939369 40287 276 1.137931 3.14068956 Nitrosopumilus sp. 2024843 Archaea Archaea 87.4 1.1e-17   NR MBC8517168.1 2024843 g39870 i0 62.1 0.945652173913043 87 30 94.6 2 9 269 181 264 MBC8517168.1 hypothetical protein [Nitrosopumilus sp.] diamond 261 87.4 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
12735465 12735465 PRJNA939369_S_NODE_3850_length_598_cov_1.598095_g3444_i0 PRJNA939369 3850 598 1.598095 9.5566081 Nitrosopumilus 338191 Archaea Archaea 756 0   NTclustered gi|2289589374|dbj|AP026695.1| 718286 g3444 i0 89.482 22.685618729097 599 61 100 2 1 598 207854 207257 Nitrosopumilus zosterae NM25 DNA, complete genome blastn 13566 756 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus zosterae
14942170 14942170 PRJNA939369_S_NODE_23732_length_321_cov_1.524194_g23315_i0 PRJNA939369 23732 321 1.524194 4.89266274 Nitrosopumilus maritimus 338192 Archaea Archaea 228 4.659999999999999e-55   NTclustered gi|160338813|gb|CP000866.1| 436308 g23315 i0 80.063 2.70404984423676 316 55 96 4 13 321 1413014 1413328 Nitrosopumilus maritimus SCM1, complete genome blastn 868 228 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus maritimus
22591451 22591451 PRJNA939369_S_NODE_50658_length_257_cov_1.135870_g50241_i0 PRJNA939369 50658 257 1.13587 2.9191859 Archaea 2157 Archaea Archaea 138 9.34e-36   NR WP_179371471.1 1470067 g50241 i0 80 2.97665369649805 85 17 99.2 0 255 1 721 805 WP_179371471.1 hypothetical protein [Nitrosopumilus ureiphilus] diamond 765 138 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus ureiphilus
25482649 25482649 PRJNA939369_S_NODE_4980_length_543_cov_2.627660_g4564_i0 PRJNA939369 4980 543 2.62766 14.2681938 Nitrosopumilus 338191 Archaea Archaea 726 0   NTclustered gi|756791811|gb|CP010868.1| 1582439 g4564 i0 90.826 34.2338858195212 545 46 100 4 1 543 1691497 1692039 Nitrosopumilus piranensis strain D3C chromosome, complete genome blastn 18589 732 0.991803278688525 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus piranensis
28699004 28699004 PRJNA939369_S_NODE_907_length_1094_cov_4.144956_g639_i0 PRJNA939369 907 1094 4.144956 45.34581864 uncultured marine thaumarchaeote KM3_53_F 1167203 Archaea Archaea 89 6.12e-18   NR AIF11849.1 1456186 g639 i0 75.9 0.148080438756856 54 13 14.8 0 813 652 40 93 AIF11849.1 hypothetical protein [uncultured marine thaumarchaeote KM3_53_F08] diamond 162 89 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote KM3_53_F08
32238236 32238236 PRJNA939369_S_NODE_21498_length_331_cov_0.937984_g21081_i0 PRJNA939369 21498 331 0.937984 3.10472704 Nitrososphaerota archaeon 2026795 Archaea Archaea 188 1.6299999999999997e-57   NR TLX90744.1 2026795 g21081 i0 81.5 0.978851963746224 108 20 97.9 0 329 6 123 230 TLX90744.1 MAG: hypothetical protein E6K93_05615 [Nitrososphaerota archaeon] diamond 324 188 1 Archaea   Thermoproteati Nitrososphaerota         Nitrososphaerota 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);;