RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA942359 · 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
3473883 3473883 PRJNA942359_P_NODE_4943_length_371_cov_1.325503_g4828_i0 PRJNA942359 4943 371 1.325503 4.91761613 Nitrosopumilus sp. 2024843 Archaea Archaea 198 4.279999999999999e-46   NTclustered gi|2805380108|emb|OY763927.2| 2024843 g4828 i0 84.577 3.94070080862534 201 29 54 2 2 201 1728036 1727837 MAG: Nitrosopumilus sp. isolate e501d42f-d10b-4094-a589-3c4c61670bda genome assembly, chromosome: 1 blastn 1462 198 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
6026165 6026165 PRJNA942359_P_NODE_19385_length_243_cov_0.917647_g19270_i0 PRJNA942359 19385 243 0.917647 2.22988221 Nitrosopumilus sp. 2024843 Archaea Archaea 183 7.44e-42   NTclustered gi|2805380108|emb|OY763927.2| 2024843 g19270 i0 81.532 3.67901234567901 222 41 91 0 1 222 944397 944176 MAG: Nitrosopumilus sp. isolate e501d42f-d10b-4094-a589-3c4c61670bda genome assembly, chromosome: 1 blastn 894 183 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp.
7300935 7300935 PRJNA942359_P_NODE_11846_length_262_cov_9.910053_g11731_i0 PRJNA942359 11846 262 9.910053 25.96433886 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 440 4.369999999999998e-119   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g11731 i0 96.947 40.4236641221374 262 8 100 0 1 262 578376 578637 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 10591 440 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
8575744 8575744 PRJNA942359_P_NODE_107_length_1838_cov_16.643626_g86_i0 PRJNA942359 107 1838 16.643626 305.90984588 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 3330 0   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g86 i0 99.402 94.5625680087051 1838 8 99 3 1 1837 1087534 1085699 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 173806 3330 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
11126804 11126804 PRJNA942359_P_NODE_9_length_3698_cov_10.394759_g6_i0 PRJNA942359 9 3698 10.394759 384.39818782 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 3701 0   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g6 i0 88.766 13.9226608977826 3071 282 83 44 1 3053 1517726 1520751 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 51486 3701 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
13676784 13676784 PRJNA942359_P_NODE_4971_length_370_cov_1.548822_g4856_i0 PRJNA942359 4971 370 1.548822 5.7306414 uncultured marine thaumarchaeote 1167203 Archaea Archaea 584 2.7999999999999987e-162   NTclustered gi|381214692|gb|JN257642.1| 1167203 g4856 i0 95.135 100.656756756757 370 18 100 0 1 370 729 360 Uncultured marine thaumarchaeote clone BG20_24 copper-containing nitrite reductase (nirK) gene, partial cds blastn 37243 584 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote
14951113 14951113 PRJNA942359_P_NODE_8832_length_292_cov_1.780822_g8717_i0 PRJNA942359 8832 292 1.780822 5.20000024 Nitrosopumilus sp. K4 2795383 Archaea Archaea 209 1.52e-49   NTclustered gi|2028944715|gb|CP067007.1| 2795383 g8717 i0 79.795 10.2808219178082 292 55 99 4 3 292 102647 102358 Nitrosopumilus sp. K4 chromosome, complete genome blastn 3002 209 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus sp. K4
16226051 16226051 PRJNA942359_P_NODE_6493_length_332_cov_1.451737_g6378_i0 PRJNA942359 6493 332 1.451737 4.81976684 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 603 6.889999999999997e-168   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g6378 i0 99.398 33.7710843373494 332 2 100 0 1 332 1473140 1472809 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 11212 603 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
18774590 18774590 PRJNA942359_P_NODE_11535_length_265_cov_3.536458_g11420_i0 PRJNA942359 11535 265 3.536458 9.3716137 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 473 4.3599999999999987e-129   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g11420 i0 98.868 53.9584905660377 265 3 100 0 1 265 1087842 1087578 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 14299 473 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
18774788 18774788 PRJNA942359_P_NODE_20615_length_230_cov_2.866242_g20500_i0 PRJNA942359 20615 230 2.866242 6.5923566 Nitrosopumilus ureiphilus 1470067 Archaea Archaea 307 3.97e-79   NTclustered gi|1869224726|gb|CP026995.1| 1470067 g20500 i0 90.83 20.1782608695652 229 21 99 0 1 229 1951786 1951558 Nitrosopumilus ureiphilus strain PS0 chromosome, complete genome blastn 4641 307 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosopumilus Nitrosopumilus ureiphilus
18774929 18774929 PRJNA942359_P_NODE_8815_length_292_cov_5.264840_g8700_i0 PRJNA942359 8815 292 5.26484 15.3733328 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 529 1.0299999999999996e-145   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g8700 i0 99.315 44.8493150684931 292 2 100 0 1 292 125013 125304 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 13096 529 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
21325274 21325274 PRJNA942359_P_NODE_9657_length_284_cov_1.478673_g9542_i0 PRJNA942359 9657 284 1.478673 4.19943132 uncultured Nitrososphaerota archaeon 651141 Archaea Archaea 514 2.78e-141   NTclustered gi|829465045|gb|KM595935.1| 651141 g9542 i0 99.296 99.9366197183099 284 2 100 0 1 284 303 20 Uncultured thaumarchaeote clone P01-A58 AmoA (amoA) gene, partial cds blastn 28382 514 1 Archaea   Thermoproteati Nitrososphaerota         uncultured Nitrososphaerota archaeon
22599853 22599853 PRJNA942359_P_NODE_10198_length_279_cov_1.087379_g10083_i0 PRJNA942359 10198 279 1.087379 3.03378741 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 470 5.99e-128   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g10083 i0 97.122 21.3584229390681 278 8 99 0 1 278 1632381 1632104 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 5959 470 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2
25149098 25149098 PRJNA942359_P_NODE_13460_length_252_cov_1.664804_g13345_i0 PRJNA942359 13460 252 1.664804 4.19530608 uncultured marine thaumarchaeote 1167203 Archaea Archaea 435 1.94e-117   NTclustered gi|381214652|gb|JN257622.1| 1167203 g13345 i0 98 74.5238095238095 250 5 99 0 3 252 981 732 Uncultured marine thaumarchaeote clone BA10_25 copper-containing nitrite reductase (nirK) gene, partial cds blastn 18780 435 1 Archaea   Thermoproteati Nitrososphaerota         uncultured marine thaumarchaeote
25149154 25149154 PRJNA942359_P_NODE_15880_length_248_cov_2.742857_g15765_i0 PRJNA942359 15880 248 2.742857 6.80228536 Nitrosarchaeum sp. AC2 2259673 Archaea Archaea 442 1.1399999999999995e-119   NTclustered gi|1869229208|gb|CP030847.1| 2259673 g15765 i0 98.79 28.9637096774194 248 3 100 0 1 248 1473113 1473360 Nitrosarchaeum sp. AC2 chromosome, complete genome blastn 7183 442 1 Archaea   Thermoproteati Nitrososphaerota Nitrososphaeria Nitrosopumilales Nitrosopumilaceae Nitrosarchaeum Nitrosarchaeum sp. AC2

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