contig_metadata
26 rows where analysis = "diamond", bioproject = "PRJNA1067370" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 180803 | 180803 | PRJNA1067370_P_NODE_31581_length_349_cov_0.956522_g31033_i0 | PRJNA1067370 | 31581 | 349 | 0.956522 | 3.33826178 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 171 | 2.88e-50 | NR | HEU5121164.1 | 2109671 | g31033 | i0 | 71 | 4.59885386819484 | 107 | 31 | 92 | 0 | 1 | 321 | 156 | 262 | HEU5121164.1 reverse transcriptase family protein [Candidatus Nitrosocosmicus sp.] | diamond | 1605 | 171 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 12934838 | 12934838 | PRJNA1067370_P_NODE_79471_length_251_cov_0.870787_g78922_i0 | PRJNA1067370 | 79471 | 251 | 0.870787 | 2.18567537 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 139 | 2.1999999999999998e-38 | NR | HEU5121164.1 | 2109671 | g78922 | i0 | 75.6 | 0.9800796812749 | 82 | 20 | 98 | 0 | 249 | 4 | 135 | 216 | HEU5121164.1 reverse transcriptase family protein [Candidatus Nitrosocosmicus sp.] | diamond | 246 | 139 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 18032465 | 18032465 | PRJNA1067370_P_NODE_26555_length_373_cov_1.163333_g26007_i0 | PRJNA1067370 | 26555 | 373 | 1.163333 | 4.33923209 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 193 | 9.999999999999997e-59 | NR | HEU5121164.1 | 2109671 | g26007 | i0 | 73.3 | 0.96514745308311 | 120 | 32 | 96.5 | 0 | 373 | 14 | 182 | 301 | HEU5121164.1 reverse transcriptase family protein [Candidatus Nitrosocosmicus sp.] | diamond | 360 | 193 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 18032646 | 18032646 | PRJNA1067370_P_NODE_51175_length_294_cov_1.176471_g50626_i0 | PRJNA1067370 | 51175 | 294 | 1.176471 | 3.45882474 | Candidatus Nitrosocosmicus sp. | 2109671 | Archaea | Archaea | 152 | 3.13e-43 | NR | HEU5121164.1 | 2109671 | g50626 | i0 | 69.3 | 1.03061224489796 | 101 | 27 | 99 | 1 | 2 | 292 | 153 | 253 | HEU5121164.1 reverse transcriptase family protein [Candidatus Nitrosocosmicus sp.] | diamond | 303 | 152 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus sp. | ||
| 26623930 | 26623930 | PRJNA1067370_P_NODE_2001_length_1163_cov_6.103670_g1677_i0 | PRJNA1067370 | 2001 | 1163 | 6.10367 | 70.9856821 | Candidatus Nezhaarchaeales archaeon | 2952944 | Archaea | Archaea | 63.2 | 1.42e-7 | NR | MEM4700450.1 | 2952944 | g1677 | i0 | 26.3 | 1.43164230438521 | 171 | 115 | 43.9 | 5 | 1127 | 618 | 25 | 185 | MEM4700450.1 Rab family GTPase [Candidatus Nezhaarchaeales archaeon] | diamond | 1665 | 63.2 | 1 | Archaea | Thermoproteati | Candidatus Nezhaarchaeota | Candidatus Nezhaarchaeia | Candidatus Nezhaarchaeales | Candidatus Nezhaarchaeales archaeon | ||||
| 26805658 | 26805658 | PRJNA1067370_P_NODE_41201_length_316_cov_0.860082_g40653_i0 | PRJNA1067370 | 41201 | 316 | 0.860082 | 2.71785912 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 6.02e-5 | NR | WP_294804384.1 | 759874 | g40653 | i0 | 34.1 | 4.38607594936709 | 88 | 52 | 83.5 | 2 | 274 | 11 | 4 | 85 | WP_294804384.1 SRPBCC domain-containing protein [uncultured Nitrososphaera sp.] | diamond | 1386 | 50.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | uncultured Nitrososphaera sp. | ||
| 27951648 | 27951648 | PRJNA1067370_P_NODE_2245_length_1114_cov_13.555235_g1894_i0 | PRJNA1067370 | 2245 | 1114 | 13.555235 | 151.0053179 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 241 | 9.879999999999999e-74 | NR | HEX6294714.1 | 2169593 | g1894 | i0 | 44.5 | 1.36804308797127 | 254 | 136 | 67.6 | 5 | 997 | 245 | 6 | 257 | HEX6294714.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 1524 | 241 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28267191 | 28267191 | PRJNA1067370_P_NODE_75326_length_257_cov_0.951087_g74777_i0 | PRJNA1067370 | 75326 | 257 | 0.951087 | 2.44429359 | Thermofilaceae archaeon | 2268203 | Archaea | Archaea | 86.3 | 1.59e-17 | NR | MEM2592699.1 | 2268203 | g74777 | i0 | 42.9 | 1.96108949416342 | 84 | 48 | 98.1 | 0 | 6 | 257 | 276 | 359 | MEM2592699.1 DUF1116 domain-containing protein [Thermofilaceae archaeon] | diamond | 504 | 86.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermofilales | Thermofilaceae | Thermofilaceae archaeon | |||
| 28425405 | 28425405 | PRJNA1067370_P_NODE_81466_length_251_cov_0.865169_g80917_i0 | PRJNA1067370 | 81466 | 251 | 0.865169 | 2.17157419 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 76.3 | 4.5e-14 | NR | MDW0269769.1 | 2169593 | g80917 | i0 | 60.7 | 1.43426294820717 | 61 | 22 | 70.5 | 1 | 189 | 13 | 162 | 222 | MDW0269769.1 IS630 family transposase [Nitrososphaeraceae archaeon] | diamond | 360 | 76.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28741017 | 28741017 | PRJNA1067370_P_NODE_87287_length_249_cov_0.875000_g86738_i0 | PRJNA1067370 | 87287 | 249 | 0.875 | 2.17875 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 50.4 | 2.44e-5 | NR | MCH8022838.1 | 2026795 | g86738 | i0 | 37 | 1.79518072289157 | 73 | 44 | 86.7 | 2 | 29 | 244 | 5 | 76 | MCH8022838.1 SRPBCC family protein [Nitrososphaerota archaeon] | diamond | 447 | 50.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 28953887 | 28953887 | PRJNA1067370_P_NODE_46268_length_306_cov_1.304721_g45720_i0 | PRJNA1067370 | 46268 | 306 | 1.304721 | 3.99244626 | root | 1 | Root_unresolved | Root_unresolved | 108 | 4.64e-26 | NR | HEX6294714.1 | 2169593 | g45720 | i0 | 45.6 | 2.01960784313725 | 103 | 55 | 100 | 1 | 306 | 1 | 10 | 112 | HEX6294714.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 618 | 109 | 0.990825688073395 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28962212 | 28962212 | PRJNA1067370_P_NODE_31708_length_348_cov_1.643636_g31160_i0 | PRJNA1067370 | 31708 | 348 | 1.643636 | 5.71985328 | Candidatus Brockarchaeota archaeon | 2815303 | Archaea | Archaea | 114 | 1.08e-28 | NR | MBO3768827.1 | 2815303 | g31160 | i0 | 54.1 | 5.74137931034483 | 111 | 50 | 94.8 | 1 | 2 | 331 | 116 | 226 | MBO3768827.1 UMP kinase [Candidatus Brockarchaeota archaeon] | diamond | 1998 | 114 | 1 | Archaea | Thermoproteati | Candidatus Brockarchaeota | Candidatus Brockarchaeota archaeon | ||||||
| 29719505 | 29719505 | PRJNA1067370_P_NODE_49730_length_297_cov_1.375000_g49182_i0 | PRJNA1067370 | 49730 | 297 | 1.375 | 4.08375 | Nitrosopumilus sp. | 2024843 | Archaea | Archaea | 47 | 0.00223 | NR | WP_297593624.1 | 2024843 | g49182 | i0 | 30.6 | 0.858585858585859 | 85 | 54 | 85.9 | 1 | 292 | 38 | 86 | 165 | WP_297593624.1 VWA domain-containing protein [Nitrosopumilus sp.] | diamond | 255 | 47 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosopumilus | Nitrosopumilus sp. | ||
| 29814339 | 29814339 | PRJNA1067370_P_NODE_115291_length_241_cov_0.916667_g114742_i0 | PRJNA1067370 | 115291 | 241 | 0.916667 | 2.20916747 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 46.6 | 0.00142 | NR | MEM1569474.1 | 3045160 | g114742 | i0 | 43.4 | 1.9792531120332 | 53 | 28 | 66 | 1 | 213 | 55 | 213 | 263 | MEM1569474.1 serine protein kinase RIO [Candidatus Bathyarchaeia archaeon] | diamond | 477 | 46.6 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29869326 | 29869326 | PRJNA1067370_P_NODE_11391_length_540_cov_1.974304_g10848_i0 | PRJNA1067370 | 11391 | 540 | 1.974304 | 10.6612416 | root | 1 | Root_unresolved | Root_unresolved | 153 | 4.869999999999999e-42 | NR | HEX6294714.1 | 2169593 | g10848 | i0 | 43.1 | 5.02222222222222 | 181 | 98 | 98.3 | 3 | 536 | 6 | 28 | 207 | HEX6294714.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 2712 | 153 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 30888673 | 30888673 | PRJNA1067370_P_NODE_2254_length_1112_cov_12.803657_g1894_i1 | PRJNA1067370 | 2254 | 1112 | 12.803657 | 142.37666584 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 241 | 1.91e-73 | NR | HEX6294714.1 | 2169593 | g1894 | i1 | 44.9 | 1.3705035971223 | 254 | 135 | 67.7 | 5 | 116 | 868 | 6 | 257 | HEX6294714.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 1524 | 241 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31267975 | 31267975 | PRJNA1067370_P_NODE_80595_length_251_cov_0.865169_g80046_i0 | PRJNA1067370 | 80595 | 251 | 0.865169 | 2.17157419 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 85.9 | 1.29e-19 | NR | MDQ4072896.1 | 2056631 | g80046 | i0 | 63.2 | 0.681274900398406 | 57 | 21 | 68.1 | 0 | 173 | 3 | 20 | 76 | MDQ4072896.1 hypothetical protein [Thermoproteota archaeon] | diamond | 171 | 85.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31426055 | 31426055 | PRJNA1067370_P_NODE_79156_length_251_cov_1.415730_g78607_i0 | PRJNA1067370 | 79156 | 251 | 1.41573 | 3.5534823 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 85.1 | 3.48e-18 | NR | MBL7118446.1 | 2026714 | g78607 | i0 | 56.7 | 1.45816733067729 | 60 | 26 | 71.7 | 0 | 251 | 72 | 145 | 204 | MBL7118446.1 endonuclease III [Candidatus Bathyarchaeota archaeon] | diamond | 366 | 85.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31647269 | 31647269 | PRJNA1067370_P_NODE_22337_length_401_cov_1.384146_g21789_i0 | PRJNA1067370 | 22337 | 401 | 1.384146 | 5.55042546 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 48.1 | 0.00275 | NR | MCW4043417.1 | 2026714 | g21789 | i0 | 31.6 | 1.31670822942643 | 114 | 70 | 83.8 | 4 | 3 | 338 | 552 | 659 | MCW4043417.1 AAA family ATPase [Candidatus Bathyarchaeota archaeon] | diamond | 528 | 48.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 31805514 | 31805514 | PRJNA1067370_P_NODE_11837_length_531_cov_1.849345_g11293_i0 | PRJNA1067370 | 11837 | 531 | 1.849345 | 9.82002195 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 134 | 1.22e-34 | NR | HEX6294714.1 | 2169593 | g11293 | i0 | 43.6 | 0.790960451977401 | 140 | 77 | 78.5 | 2 | 108 | 524 | 6 | 144 | HEX6294714.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 420 | 134 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31837069 | 31837069 | PRJNA1067370_P_NODE_68517_length_267_cov_1.190722_g67968_i0 | PRJNA1067370 | 68517 | 267 | 1.190722 | 3.17922774 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 50.8 | 6.48e-5 | NR | HUI86004.1 | 2268197 | g67968 | i0 | 36.4 | 2.70786516853933 | 66 | 36 | 74.2 | 2 | 214 | 17 | 236 | 295 | HUI86004.1 transposase [Nitrososphaerales archaeon] | diamond | 723 | 50.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 32430141 | 32430141 | PRJNA1067370_P_NODE_8959_length_605_cov_1.278195_g8429_i0 | PRJNA1067370 | 8959 | 605 | 1.278195 | 7.73307975 | Candidatus Nitrosocaldus | 498374 | Archaea | Archaea | 265 | 1.4499999999999999e-84 | NR | MEM4351308.1 | 2697468 | g8429 | i0 | 67.2 | 11.9603305785124 | 201 | 66 | 99.7 | 0 | 603 | 1 | 88 | 288 | MEM4351308.1 IMP dehydrogenase [Candidatus Nitrosocaldus sp.] | diamond | 7236 | 267 | 0.99250936329588 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Candidatus Nitrosocaldales | Candidatus Nitrosocaldaceae | Candidatus Nitrosocaldus | Candidatus Nitrosocaldus sp. | ||
| 32438631 | 32438631 | PRJNA1067370_P_NODE_22839_length_397_cov_2.913580_g22291_i0 | PRJNA1067370 | 22839 | 397 | 2.91358 | 11.5669126 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 103 | 8.18e-24 | NR | HEX6294714.1 | 2169593 | g22291 | i0 | 52.9 | 0.642317380352645 | 85 | 40 | 64.2 | 0 | 279 | 25 | 6 | 90 | HEX6294714.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 255 | 103 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32659097 | 32659097 | PRJNA1067370_P_NODE_10120_length_571_cov_1.594378_g9582_i0 | PRJNA1067370 | 10120 | 571 | 1.594378 | 9.10389838 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 48.1 | 0.00987 | NR | TMI60447.1 | 2026714 | g9582 | i0 | 30.5 | 0.688266199649737 | 131 | 72 | 63.6 | 6 | 411 | 49 | 290 | 411 | TMI60447.1 MAG: hypothetical protein E6H14_00625 [Candidatus Bathyarchaeota archaeon] | diamond | 393 | 48.1 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 32722435 | 32722435 | PRJNA1067370_P_NODE_26440_length_374_cov_0.794020_g25892_i0 | PRJNA1067370 | 26440 | 374 | 0.79402 | 2.9696348 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 44.3 | 0.0384 | NR | MEE8186674.1 | 2268197 | g25892 | i0 | 29.9 | 0.537433155080214 | 67 | 46 | 52.9 | 1 | 135 | 332 | 219 | 285 | MEE8186674.1 cupredoxin domain-containing protein [Nitrososphaerales archaeon] | diamond | 201 | 44.3 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 32816780 | 32816780 | PRJNA1067370_P_NODE_14280_length_488_cov_1.725301_g13733_i0 | PRJNA1067370 | 14280 | 488 | 1.725301 | 8.41946888 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 122 | 2.07e-30 | NR | HEX6294714.1 | 2169593 | g13733 | i0 | 47.9 | 1.41393442622951 | 117 | 60 | 71.3 | 1 | 391 | 44 | 2 | 118 | HEX6294714.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 690 | 122 | 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);;