RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "blastn", bioproject = "PRJNA340009" and tax_phylum = "Nitrososphaerota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Nitrososphaerota · 15 ✖

tax_kingdom 1

bioproject 1

  • PRJNA340009 · 15 ✖

analysis 1

  • blastn · 15 ✖

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
4219350 4219350 PRJNA340009_P_NODE_32044_length_221_cov_1.604651_g31737_i0 PRJNA340009 32044 221 1.604651 3.54627871 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 268 1.79e-67   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g31737 i0 88.636 3.85972850678733 220 25 99 0 2 221 1110035 1109816 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 853 268 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
6769678 6769678 PRJNA340009_P_NODE_30566_length_225_cov_2.772727_g30259_i0 PRJNA340009 30566 225 2.772727 6.23863575 Candidatus Nitrosocosmicus oleophilus 1353260 Archaea Archaea 361 2.9299999999999993e-95   NTclustered gi|937513727|gb|CP012850.1| 1353260 g30259 i0 95.946 0.986666666666667 222 9 99 0 1 222 2526781 2527002 Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome blastn 222 361 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrososphaerales Nitrososphaeraceae Candidatus Nitrosocosmicus Candidatus Nitrosocosmicus oleophilus
8045853 8045853 PRJNA340009_P_NODE_75187_length_161_cov_5.464286_g74880_i0 PRJNA340009 75187 161 5.464286 8.79750046 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 222 9.63e-54   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g74880 i0 91.875 7.96894409937888 160 11 99 2 3 161 363833 363675 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 1283 222 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
10596101 10596101 PRJNA340009_P_NODE_60089_length_169_cov_1.700000_g59782_i0 PRJNA340009 60089 169 1.7 2.873 Candidatus Nitrosopumilus sediminis 1229909 Archaea Archaea 145 2.26e-30   NTclustered gi|407047065|gb|CP003843.1| 1229909 g59782 i0 82.635 1.96449704142012 167 25 97 4 1 164 182904 183069 Candidatus Nitrosopumilus sp. AR2, complete genome blastn 332 145 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Candidatus Nitrosopumilus sediminis
11871086 11871086 PRJNA340009_P_NODE_64270_length_166_cov_0.871795_g63963_i0 PRJNA340009 64270 166 0.871795 1.4471797 Nitrosopumilus adriaticus 1580092 Archaea Archaea 185 1.3099999999999999e-42   NTclustered gi|770478903|gb|CP011070.1| 1580092 g63963 i0 87.5 7.80722891566265 160 20 96 0 7 166 1049945 1049786 Nitrosopumilus adriaticus strain NF5 chromosome, complete genome blastn 1296 185 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus adriaticus
13146047 13146047 PRJNA340009_P_NODE_6271_length_436_cov_6.705426_g5964_i0 PRJNA340009 6271 436 6.705426 29.23565736 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 377 6.12e-100   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g5964 i0 84.375 0.880733944954128 384 60 88 0 46 429 439377 439760 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 384 377 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
15695038 15695038 PRJNA340009_P_NODE_60193_length_169_cov_1.600000_g59886_i0 PRJNA340009 60193 169 1.6 2.704 Nitrosotalea devaniterrae 1078905 Archaea Archaea 189 1.0299999999999998e-43   NTclustered gi|1003583480|emb|LN890280.1| 1078905 g59886 i0 90.78 0.834319526627219 141 13 83 0 27 167 1431944 1432084 Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 blastn 141 189 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Nitrosotalea devaniterrae
16969672 16969672 PRJNA340009_P_NODE_48814_length_185_cov_2.250000_g48507_i0 PRJNA340009 48814 185 2.25 4.1625 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 209 8.86e-50   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g48507 i0 88.439 0.935135135135135 173 20 94 0 1 173 732833 733005 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 173 209 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
18243854 18243854 PRJNA340009_P_NODE_45755_length_190_cov_1.446809_g45448_i0 PRJNA340009 45755 190 1.446809 2.7489371 Candidatus Nitrosotenuis cloacae 1603555 Archaea Archaea 156 1.21e-33   NTclustered gi|808354332|gb|CP011097.2| 1603555 g45448 i0 81.481 0.994736842105263 189 35 99 0 2 190 1030365 1030177 Candidatus Nitrosotenuis cloacae strain SAT1, complete genome blastn 189 156 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis cloacae
18243875 18243875 PRJNA340009_P_NODE_48575_length_185_cov_68.845588_g48268_i0 PRJNA340009 48575 185 68.845588 127.3643378 Candidatus Nitrosotalea okcheonensis 1903276 Archaea Archaea 185 1.49e-42   NTclustered gi|1279331958|emb|LT841358.1| 1903276 g48268 i0 87.898 4.2 157 19 85 0 2 158 993977 994133 Nitrosotalea sp. CS isolate NCS1 genome assembly, chromosome: 1 blastn 777 185 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosotaleales Nitrosotaleaceae Nitrosotalea Candidatus Nitrosotalea okcheonensis
20793326 20793326 PRJNA340009_P_NODE_19197_length_275_cov_1.128319_g18890_i0 PRJNA340009 19197 275 1.128319 3.10287725 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 193 1.43e-44   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g18890 i0 84.817 0.694545454545455 191 29 69 0 84 274 1053257 1053447 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 191 193 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
20793555 20793555 PRJNA340009_P_NODE_37497_length_207_cov_1.132911_g37190_i0 PRJNA340009 37497 207 1.132911 2.34512577 Candidatus Nitrosopumilus sediminis 1229909 Archaea Archaea 206 1.3099999999999999e-48   NTclustered gi|407047065|gb|CP003843.1| 1229909 g37190 i0 86.243 1.77294685990338 189 26 91 0 16 204 1054249 1054061 Candidatus Nitrosopumilus sp. AR2, complete genome blastn 367 206 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Candidatus Nitrosopumilus sediminis
22068787 22068787 PRJNA340009_P_NODE_52078_length_180_cov_1.977099_g51771_i0 PRJNA340009 52078 180 1.977099 3.5587782 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 193 8.62e-45   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g51771 i0 86.364 0.977777777777778 176 24 98 0 2 177 1673519 1673694 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 176 193 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
22068893 22068893 PRJNA340009_P_NODE_60638_length_168_cov_2.453782_g60331_i0 PRJNA340009 60638 168 2.453782 4.12235376 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 237 3.63e-58   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g60331 i0 92.216 0.994047619047619 167 13 99 0 2 168 1093484 1093650 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 167 237 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
23344080 23344080 PRJNA340009_P_NODE_37219_length_207_cov_3.189873_g36912_i0 PRJNA340009 37219 207 3.189873 6.60303711 Candidatus Nitrosotenuis sp. DW1 2259672 Archaea Archaea 209 1.02e-49   NTclustered gi|1869227213|gb|CP030846.1| 2259672 g36912 i0 85.222 0.980676328502415 203 30 98 0 5 207 939904 939702 Candidatus Nitrosotenuis sp. DW1 chromosome, complete genome blastn 203 209 1 Archaea   Thermoproteati Nitrososphaerota       Candidatus Nitrosotenuis Candidatus Nitrosotenuis sp. DW1

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