contig_metadata
20 rows where analysis = "blastn", bioproject = "PRJNA942359" and tax_superkingdom = "Archaea"
This data as json, CSV (advanced)
| 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 | ||
| 10187546 | 10187546 | PRJNA942359_P_NODE_20768_length_207_cov_4.455224_g20653_i0 | PRJNA942359 | 20768 | 207 | 4.455224 | 9.22231368 | Methanosarcina | 2207 | Archaea | Archaea | 383 | 5.65e-102 | NTclustered | gi|827396966|gb|CP008746.1| | 796385 | g20653 | i0 | 100 | 40.9227053140097 | 207 | 0 | 100 | 0 | 1 | 207 | 4158541 | 4158747 | Methanosarcina barkeri CM1, complete genome | blastn | 8471 | 383 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri | |
| 10187580 | 10187580 | PRJNA942359_P_NODE_6668_length_328_cov_8.874510_g6553_i0 | PRJNA942359 | 6668 | 328 | 8.87451 | 29.1083928 | Nitrosarchaeum | 1007082 | Archaea | Archaea | 601 | 2.4399999999999998e-167 | NTclustered | gi|341867114|gb|JN202421.1| | 115547 | g6553 | i0 | 99.695 | 99.780487804878 | 328 | 1 | 100 | 0 | 1 | 328 | 131 | 458 | Uncultured archaeon clone ch-gj80 16S ribosomal RNA gene, partial sequence | blastn | 32728 | 601 | 1 | Archaea | uncultured archaeon | ||||||||
| 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 | ||
| 16561392 | 16561392 | PRJNA942359_P_NODE_7153_length_319_cov_3.373984_g7038_i0 | PRJNA942359 | 7153 | 319 | 3.373984 | 10.76300896 | Thermoproteati | 1783275 | Archaea | Archaea | 590 | 5.1299999999999986e-164 | NTclustered | gi|325984321|gb|JF262218.1| | 29281 | g7038 | i0 | 100 | 100 | 319 | 0 | 100 | 0 | 1 | 319 | 1026 | 1344 | Uncultured crenarchaeote clone YLA018 16S ribosomal RNA gene, partial sequence | blastn | 31900 | 590 | 1 | Archaea | Thermoproteati | Thermoproteota | uncultured crenarchaeote | ||||||
| 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 | ||
| 22599965 | 22599965 | PRJNA942359_P_NODE_16058_length_248_cov_0.891429_g15943_i0 | PRJNA942359 | 16058 | 248 | 0.891429 | 2.21074392 | Methanothrix sp. | 90426 | Archaea | Archaea | 436 | 5.3e-118 | NTclustered | gi|2621703957|emb|OY762912.1| | 90426 | g15943 | i0 | 98.387 | 1 | 248 | 4 | 100 | 0 | 1 | 248 | 1275697 | 1275944 | MAG: Methanothrix sp. isolate 80880379-7421-4bc7-b5fd-f9f5169ec620 genome assembly, chromosome: 1 | blastn | 248 | 436 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanothrix | Methanothrix sp. | |
| 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 | ||
| 25485403 | 25485403 | PRJNA942359_P_NODE_20220_length_242_cov_0.923077_g20105_i0 | PRJNA942359 | 20220 | 242 | 0.923077 | 2.23384634 | Methanosarcina | 2207 | Archaea | Archaea | 448 | 2.3799999999999995e-121 | NTclustered | gi|827396966|gb|CP008746.1| | 796385 | g20105 | i0 | 100 | 12 | 242 | 0 | 100 | 0 | 1 | 242 | 4371282 | 4371041 | Methanosarcina barkeri CM1, complete genome | blastn | 2904 | 448 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanosarcinales | Methanosarcinaceae | Methanosarcina | Methanosarcina barkeri |
Advanced export
JSON shape: default, array, newline-delimited
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);;