contig_metadata
15 rows where bioproject = "PRJNA557436" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12014643 | 12014643 | PRJNA557436_S_NODE_2930_length_225_cov_1.747368_g2882_i0 | PRJNA557436 | 2930 | 225 | 1.747368 | 3.931578 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 52.8 | 0.02 | NTclustered | gi|2893358431|emb|OZ220723.1| | 2202732 | g2882 | i0 | 100 | 0.124444444444444 | 28 | 0 | 12 | 0 | 81 | 108 | 1811484 | 1811457 | MAG: Nitrosopumilaceae archaeon isolate 679b85a9-901a-4549-bbbb-e934c43a20cf genome assembly, chromosome: 1 | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 26889214 | 26889214 | PRJNA557436_S_NODE_701_length_425_cov_2.000000_g653_i0 | PRJNA557436 | 701 | 425 | 2 | 8.5 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 137 | 4.18e-36 | NR | MCI0556866.1 | 1971748 | g653 | i0 | 61.7 | 1.54588235294118 | 107 | 41 | 75.5 | 0 | 90 | 410 | 1 | 107 | MCI0556866.1 hypothetical protein [Nitrososphaera sp.] | diamond | 657 | 137 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 26952086 | 26952086 | PRJNA557436_S_NODE_1582_length_294_cov_2.532819_g1534_i0 | PRJNA557436 | 1582 | 294 | 2.532819 | 7.44648786 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 84.3 | 1.14e-16 | NR | MBT7913600.1 | 2026714 | g1534 | i0 | 51.2 | 1.80612244897959 | 82 | 38 | 83.7 | 2 | 247 | 2 | 12 | 91 | MBT7913600.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 531 | 84.3 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27205034 | 27205034 | PRJNA557436_S_NODE_7782_length_159_cov_1.451613_g7734_i0 | PRJNA557436 | 7782 | 159 | 1.451613 | 2.30806467 | Nitrosopumilaceae archaeon | 2202732 | Archaea | Archaea | 54.3 | 2.39e-7 | NR | HWY36519.1 | 2202732 | g7734 | i0 | 64.1 | 0.735849056603774 | 39 | 14 | 73.6 | 0 | 42 | 158 | 4 | 42 | HWY36519.1 hypothetical protein [Nitrosopumilaceae archaeon] | diamond | 117 | 54.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilaceae archaeon | |||
| 27521144 | 27521144 | PRJNA557436_S_NODE_363_length_570_cov_2.742056_g322_i0 | PRJNA557436 | 363 | 570 | 2.742056 | 15.6297192 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 67 | 2.32e-10 | NR | MDE1813920.1 | 2026795 | g322 | i0 | 36.4 | 0.678947368421053 | 129 | 68 | 63.2 | 5 | 155 | 514 | 14 | 137 | MDE1813920.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 387 | 67 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28215581 | 28215581 | PRJNA557436_S_NODE_2286_length_250_cov_2.632558_g2238_i0 | PRJNA557436 | 2286 | 250 | 2.632558 | 6.581395 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 107 | 1.11e-26 | NR | MCI0562694.1 | 1971748 | g2238 | i0 | 60.2 | 0.996 | 83 | 33 | 99.6 | 0 | 1 | 249 | 16 | 98 | MCI0562694.1 hypothetical protein [Nitrososphaera sp.] | diamond | 249 | 107 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 29447016 | 29447016 | PRJNA557436_S_NODE_7150_length_163_cov_1.687500_g7102_i0 | PRJNA557436 | 7150 | 163 | 1.6875 | 2.750625 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 60.8 | 5.13e-9 | NR | HEY3527490.1 | 2169593 | g7102 | i0 | 52.5 | 1.12269938650307 | 61 | 22 | 99.4 | 1 | 162 | 1 | 260 | 320 | HEY3527490.1 DNA methyltransferase [Nitrososphaeraceae archaeon] | diamond | 183 | 60.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29857632 | 29857632 | PRJNA557436_S_NODE_1651_length_289_cov_1.952756_g1603_i0 | PRJNA557436 | 1651 | 289 | 1.952756 | 5.64346484 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 47.4 | 2.55e-4 | NR | MEE8113276.1 | 2268197 | g1603 | i0 | 52.4 | 0.86159169550173 | 42 | 20 | 43.6 | 0 | 164 | 289 | 1 | 42 | MEE8113276.1 hypothetical protein [Nitrososphaerales archaeon] | diamond | 249 | 47.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 30521144 | 30521144 | PRJNA557436_S_NODE_653_length_438_cov_2.454094_g605_i0 | PRJNA557436 | 653 | 438 | 2.454094 | 10.74893172 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 104 | 7.27e-24 | NR | MEM3097506.1 | 2268197 | g605 | i0 | 48.6 | 1.50684931506849 | 109 | 50 | 73.3 | 2 | 412 | 92 | 215 | 319 | MEM3097506.1 RNA ligase (ATP) [Nitrososphaerales archaeon] | diamond | 660 | 104 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 31469488 | 31469488 | PRJNA557436_S_NODE_5336_length_180_cov_1.917241_g5288_i0 | PRJNA557436 | 5336 | 180 | 1.917241 | 3.4510338 | Saccharolobus sp. | 2100761 | Archaea | Archaea | 45.1 | 0.00119 | NR | MEM4884130.1 | 2100761 | g5288 | i0 | 35.2 | 4.35 | 54 | 35 | 90 | 0 | 172 | 11 | 94 | 147 | MEM4884130.1 helix-turn-helix domain-containing protein [Saccharolobus sp.] | diamond | 783 | 45.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Saccharolobus | Saccharolobus sp. | ||
| 31627396 | 31627396 | PRJNA557436_S_NODE_4336_length_194_cov_1.710692_g4288_i0 | PRJNA557436 | 4336 | 194 | 1.710692 | 3.31874248 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 98.6 | 4.04e-22 | NR | MEK0324793.1 | 2024843 | g4288 | i0 | 71 | 0.958762886597938 | 62 | 18 | 95.9 | 0 | 1 | 186 | 421 | 482 | MEK0324793.1 hypothetical protein [Nitrosopumilus sp.] | diamond | 186 | 98.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 31658907 | 31658907 | PRJNA557436_S_NODE_5617_length_177_cov_1.190141_g5569_i0 | PRJNA557436 | 5617 | 177 | 1.190141 | 2.10654957 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 43.1 | 0.0014 | NR | MDO8640851.1 | 2026886 | g5569 | i0 | 41.7 | 0.813559322033898 | 48 | 27 | 79.7 | 1 | 17 | 157 | 12 | 59 | MDO8640851.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 144 | 43.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 32038756 | 32038756 | PRJNA557436_S_NODE_3898_length_201_cov_2.475904_g3850_i0 | PRJNA557436 | 3898 | 201 | 2.475904 | 4.97656704 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 50.1 | 2.15e-5 | NR | MBT7915248.1 | 2026714 | g3850 | i0 | 36.4 | 0.985074626865672 | 66 | 42 | 98.5 | 0 | 1 | 198 | 15 | 80 | MBT7915248.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 198 | 50.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32133762 | 32133762 | PRJNA557436_S_NODE_4578_length_190_cov_1.412903_g4530_i0 | PRJNA557436 | 4578 | 190 | 1.412903 | 2.6845157 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 66.6 | 5.03e-11 | NR | MFI5404910.1 | 2268197 | g4530 | i0 | 51.6 | 1.01052631578947 | 64 | 28 | 97.9 | 2 | 190 | 5 | 183 | 245 | MFI5404910.1 hypothetical protein [Nitrososphaerales archaeon] | diamond | 192 | 66.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 32228737 | 32228737 | PRJNA557436_S_NODE_4638_length_189_cov_1.298701_g4590_i0 | PRJNA557436 | 4638 | 189 | 1.298701 | 2.45454489 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 107 | 3.64e-26 | NR | MBP0119264.1 | 2026886 | g4590 | i0 | 79 | 1.96825396825397 | 62 | 13 | 98.4 | 0 | 187 | 2 | 200 | 261 | MBP0119264.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 372 | 107 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. |
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);;