contig_metadata
18 rows where bioproject = "PRJNA316313" and tax_kingdom = "Thermoproteati"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1068584 | 1068584 | PRJNA316313_P_NODE_490721_length_150_cov_4.309735_g489335_i0 | PRJNA316313 | 490721 | 150 | 4.309735 | 6.4646025 | Nitrosopumilus | 338191 | Archaea | Archaea | 126 | 7.1e-25 | NTclustered | gi|2518550870|emb|OX638319.1| | 517606 | g489335 | i0 | 93.976 | 6.55333333333333 | 83 | 5 | 55 | 0 | 68 | 150 | 597292 | 597210 | MAG: uncultured Candidatus Nitrosopumilus sp. isolate a9bb1b8d-3405-4f78-8bb0-675615731146 genome assembly, chromosome: 1 | blastn | 983 | 126 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | uncultured Candidatus Nitrosopumilus sp. | ||
| 3619039 | 3619039 | PRJNA316313_P_NODE_431103_length_151_cov_4.307018_g429717_i0 | PRJNA316313 | 431103 | 151 | 4.307018 | 6.50359718 | Nitrosotalea | 1078904 | Archaea | Archaea | 141 | 2.56e-29 | NTclustered | gi|1003583480|emb|LN890280.1| | 1078905 | g429717 | i0 | 100 | 24.2317880794702 | 76 | 0 | 50 | 0 | 76 | 151 | 1604040 | 1604115 | Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 | blastn | 3659 | 141 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea devaniterrae | ||
| 11271753 | 11271753 | PRJNA316313_P_NODE_480129_length_150_cov_6.433628_g478743_i0 | PRJNA316313 | 480129 | 150 | 6.433628 | 9.650442 | Nitrosotalea | 1078904 | Archaea | Archaea | 126 | 7.1e-25 | NTclustered | gi|1003583480|emb|LN890280.1| | 1078905 | g478743 | i0 | 96.104 | 1.02666666666667 | 77 | 3 | 51 | 0 | 74 | 150 | 1773878 | 1773802 | Candidatus Nitrosotalea devanaterra genome assembly, chromosome: 1 | blastn | 154 | 126 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosotaleales | Nitrosotaleaceae | Nitrosotalea | Nitrosotalea devaniterrae | ||
| 15690678 | 15690678 | PRJNA316313_P_NODE_448133_length_151_cov_3.675439_g446747_i0 | PRJNA316313 | 448133 | 151 | 3.675439 | 5.54991289 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 52.8 | 0.012 | NTclustered | gi|2874254015|emb|OY970340.1| | 2026714 | g446747 | i0 | 100 | 0.185430463576159 | 28 | 0 | 19 | 0 | 120 | 147 | 1269362 | 1269389 | MAG: Candidatus Bathyarchaeota archaeon isolate MFD04492.bin.c.5 genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 16964161 | 16964161 | PRJNA316313_P_NODE_249934_length_187_cov_2.853333_g248548_i0 | PRJNA316313 | 249934 | 187 | 2.853333 | 5.33573271 | Nitrosarchaeum sp. AC2 | 2259673 | Archaea | Archaea | 113 | 7.240000000000001e-21 | NTclustered | gi|1869229208|gb|CP030847.1| | 2259673 | g248548 | i0 | 93.421 | 8.09090909090909 | 76 | 5 | 41 | 0 | 1 | 76 | 267575 | 267650 | Nitrosarchaeum sp. AC2 chromosome, complete genome | blastn | 1513 | 113 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. AC2 | ||
| 26757907 | 26757907 | PRJNA316313_P_NODE_40701_length_280_cov_3.786008_g39319_i0 | PRJNA316313 | 40701 | 280 | 3.786008 | 10.6008224 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 100 | 1.15e-22 | NR | HWY33621.1 | 2202732 | g39319 | i0 | 64.1 | 0.835714285714286 | 78 | 27 | 83.6 | 1 | 279 | 46 | 319 | 395 | HWY33621.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 234 | 100 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 27422390 | 27422390 | PRJNA316313_P_NODE_31003_length_310_cov_4.164835_g29622_i0 | PRJNA316313 | 31003 | 310 | 4.164835 | 12.9109885 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 117 | 4.22e-28 | NR | HWY36192.1 | 2202732 | g29622 | i0 | 50.9 | 2.14838709677419 | 110 | 42 | 94.8 | 1 | 8 | 301 | 138 | 247 | HWY36192.1 PAS domain S-box protein [Nitrosopumilaceae archaeon] | diamond | 666 | 117 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 27990664 | 27990664 | PRJNA316313_P_NODE_41065_length_279_cov_4.268595_g39683_i0 | PRJNA316313 | 41065 | 279 | 4.268595 | 11.90938005 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 169 | 1.7999999999999998e-48 | NR | HWY33351.1 | 2202732 | g39683 | i0 | 87 | 1.97849462365591 | 92 | 12 | 98.9 | 0 | 278 | 3 | 86 | 177 | HWY33351.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 552 | 169 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 28559031 | 28559031 | PRJNA316313_P_NODE_418967_length_151_cov_5.035088_g417581_i0 | PRJNA316313 | 418967 | 151 | 5.035088 | 7.60298288 | Zestosphaera sp. | 2303494 | Archaea | Archaea | 51.6 | 7.9e-6 | NR | MFN3268367.1 | 2303494 | g417581 | i0 | 100 | 0.47682119205298 | 24 | 0 | 47.7 | 0 | 147 | 76 | 78 | 101 | MFN3268367.1 RNA-guided endonuclease InsQ/TnpB family protein [Zestosphaera sp.] | diamond | 72 | 51.6 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Zestosphaera | Zestosphaera sp. | ||
| 28874553 | 28874553 | PRJNA316313_P_NODE_421808_length_151_cov_4.789474_g420422_i0 | PRJNA316313 | 421808 | 151 | 4.789474 | 7.23210574 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 47 | 1.18e-4 | NR | HMG38487.1 | 2169593 | g420422 | i0 | 95.5 | 1.33112582781457 | 22 | 1 | 43.7 | 0 | 5 | 70 | 113 | 134 | HMG38487.1 Rieske 2Fe-2S domain-containing protein [Nitrososphaeraceae archaeon] | diamond | 201 | 47 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29158914 | 29158914 | PRJNA316313_P_NODE_335169_length_186_cov_2.536913_g333783_i0 | PRJNA316313 | 335169 | 186 | 2.536913 | 4.71865818 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 52 | 9.63e-6 | NR | HZL24207.1 | 2169593 | g333783 | i0 | 96.2 | 2.09677419354839 | 26 | 0 | 40.3 | 1 | 112 | 186 | 295 | 320 | HZL24207.1 metallophosphoesterase [Nitrososphaeraceae archaeon] | diamond | 390 | 52 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29348335 | 29348335 | PRJNA316313_P_NODE_474069_length_151_cov_2.894737_g472683_i0 | PRJNA316313 | 474069 | 151 | 2.894737 | 4.37105287 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 80.1 | 2.89e-16 | NR | MBP0119973.1 | 2026886 | g472683 | i0 | 61.2 | 1.33112582781457 | 67 | 9 | 99.3 | 1 | 150 | 1 | 3 | 69 | MBP0119973.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 201 | 80.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 29663616 | 29663616 | PRJNA316313_P_NODE_93690_length_210_cov_4.578035_g92304_i0 | PRJNA316313 | 93690 | 210 | 4.578035 | 9.6138735 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 73.9 | 5.55e-14 | NR | MDP6459105.1 | 2026714 | g92304 | i0 | 45.6 | 0.971428571428571 | 68 | 37 | 97.1 | 0 | 7 | 210 | 3 | 70 | MDP6459105.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 204 | 73.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 29853422 | 29853422 | PRJNA316313_P_NODE_109531_length_198_cov_5.186335_g108145_i0 | PRJNA316313 | 109531 | 198 | 5.186335 | 10.2689433 | Zestosphaera sp. | 2303494 | Archaea | Archaea | 79.7 | 1.65e-15 | NR | MFN3268367.1 | 2303494 | g108145 | i0 | 97.5 | 0.606060606060606 | 40 | 1 | 60.6 | 0 | 196 | 77 | 391 | 430 | MFN3268367.1 RNA-guided endonuclease InsQ/TnpB family protein [Zestosphaera sp.] | diamond | 120 | 79.7 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcaceae | Zestosphaera | Zestosphaera sp. | ||
| 30832773 | 30832773 | PRJNA316313_P_NODE_181794_length_187_cov_3.746667_g180408_i0 | PRJNA316313 | 181794 | 187 | 3.746667 | 7.00626729 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 87.4 | 3e-18 | NR | PHY09973.1 | 2026886 | g180408 | i0 | 65.3 | 1.20320855614973 | 75 | 12 | 97.9 | 1 | 3 | 185 | 119 | 193 | PHY09973.1 MAG: excinuclease ABC subunit C [Nitrosarchaeum sp.] | diamond | 225 | 87.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 32129504 | 32129504 | PRJNA316313_P_NODE_241318_length_187_cov_2.933333_g239932_i0 | PRJNA316313 | 241318 | 187 | 2.933333 | 5.48533271 | Candidatus Hecatellales archaeon | 3072965 | Archaea | Archaea | 43.1 | 0.0124 | NR | RLG91102.1 | 3072965 | g239932 | i0 | 70.8 | 0.754010695187166 | 24 | 7 | 38.5 | 0 | 1 | 72 | 222 | 245 | RLG91102.1 MAG: glycosyltransferase [Candidatus Hecatellales archaeon] | diamond | 141 | 43.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Hecatellales | Candidatus Hecatellales archaeon | ||||
| 32841335 | 32841335 | PRJNA316313_P_NODE_252100_length_187_cov_2.833333_g250714_i0 | PRJNA316313 | 252100 | 187 | 2.833333 | 5.29833271 | Candidatus Nitrosocosmicus | 1826864 | Archaea | Archaea | 53.9 | 1.93e-6 | NR | WP_196817905.1 | 1353260 | g250714 | i0 | 92 | 1.20320855614973 | 25 | 2 | 40.1 | 0 | 3 | 77 | 102 | 126 | WP_196817905.1 hypothetical protein [Candidatus Nitrosocosmicus oleophilus] | diamond | 225 | 53.9 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 32886952 | 32886952 | PRJNA316313_P_NODE_372340_length_164_cov_7.582677_g370954_i0 | PRJNA316313 | 372340 | 164 | 7.582677 | 12.43559028 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 70.1 | 2.3e-14 | NR | HEV2876844.1 | 2169593 | g370954 | i0 | 77.8 | 0.823170731707317 | 45 | 10 | 82.3 | 0 | 29 | 163 | 1 | 45 | HEV2876844.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 135 | 70.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon |
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);;