contig_metadata
23 rows where bioproject = "PRJNA564013" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1828684 | 1828684 | PRJNA564013_P_NODE_96422_length_416_cov_8.081690_g93589_i0 | PRJNA564013 | 96422 | 416 | 8.08169 | 33.6198304 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 730 | 0 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g93589 | i0 | 98.554 | 0.997596153846154 | 415 | 3 | 99 | 3 | 5 | 416 | 1649352 | 1649766 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 415 | 730 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 5656775 | 5656775 | PRJNA564013_P_NODE_86125_length_437_cov_42.335106_g83295_i0 | PRJNA564013 | 86125 | 437 | 42.335106 | 185.00441322 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 197 | 4.41e-58 | NR | HEY7108885.1 | 2169593 | g83295 | i0 | 84.8 | 0.768878718535469 | 112 | 17 | 76.9 | 0 | 9 | 344 | 351 | 462 | HEY7108885.1 ABC transporter permease [Nitrososphaeraceae archaeon] | diamond | 336 | 197 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 12032224 | 12032224 | PRJNA564013_P_NODE_91110_length_426_cov_33.493151_g88277_i0 | PRJNA564013 | 91110 | 426 | 33.493151 | 142.68082326 | Nitrosarchaeum sp. | 2026886 | Archaea | Archaea | 57 | 6.82e-8 | NR | MDW7641988.1 | 2026886 | g88277 | i0 | 53.2 | 0.330985915492958 | 47 | 17 | 29.6 | 1 | 196 | 321 | 16 | 62 | MDW7641988.1 hypothetical protein [Nitrosarchaeum sp.] | diamond | 141 | 57 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Nitrosarchaeum sp. | ||
| 18405069 | 18405069 | PRJNA564013_P_NODE_87635_length_434_cov_9.983914_g84805_i0 | PRJNA564013 | 87635 | 434 | 9.983914 | 43.33018676 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 148 | 1.32e-39 | NR | MEM4204517.1 | 3058293 | g84805 | i0 | 82 | 0.615207373271889 | 89 | 16 | 61.5 | 0 | 277 | 11 | 76 | 164 | MEM4204517.1 hypothetical protein [Candidatus Methanomethylicaceae archaeon] | diamond | 267 | 148 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 20949281 | 20949281 | PRJNA564013_P_NODE_134357_length_367_cov_1.447712_g131509_i0 | PRJNA564013 | 134357 | 367 | 1.447712 | 5.31310304 | Pyrobaculum aerophilum | 13773 | Archaea | Archaea | 610 | 4.59e-170 | NTclustered | gi|18308975|gb|AE009441.1| | 178306 | g131509 | i0 | 99.405 | 1.41961852861035 | 336 | 2 | 92 | 0 | 16 | 351 | 92718 | 93053 | Pyrobaculum aerophilum str. IM2, complete genome | blastn | 521 | 610 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Pyrobaculum | Pyrobaculum aerophilum | ||
| 21533861 | 21533861 | PRJNA564013_P_NODE_198257_length_308_cov_2.020243_g195406_i0 | PRJNA564013 | 198257 | 308 | 2.020243 | 6.22234844 | Saccharolobus | 2100760 | Archaea | Archaea | 52.8 | 0.029 | NTclustered | gi|1496296112|gb|CP011055.2| | 2287 | g195406 | i0 | 100 | 1.27272727272727 | 28 | 0 | 9 | 0 | 237 | 264 | 1111878 | 1111851 | Saccharolobus solfataricus strain SARC-B chromosome, complete genome | blastn | 392 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Saccharolobus | Saccharolobus solfataricus | ||
| 26858146 | 26858146 | PRJNA564013_P_NODE_67861_length_489_cov_14.885514_g65055_i0 | PRJNA564013 | 67861 | 489 | 14.885514 | 72.79016346 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 221 | 3.05e-65 | NR | MEM4204518.1 | 3058293 | g65055 | i0 | 75 | 0.858895705521472 | 140 | 35 | 85.9 | 0 | 424 | 5 | 1 | 140 | MEM4204518.1 ribonuclease HIII [Candidatus Methanomethylicaceae archaeon] | diamond | 420 | 221 | 1 | Archaea | Thermoproteati | Candidatus Methanomethylicota | Candidatus Methanomethylicia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 26889624 | 26889624 | PRJNA564013_P_NODE_156501_length_345_cov_33.873239_g153652_i0 | PRJNA564013 | 156501 | 345 | 33.873239 | 116.86267455 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 85.9 | 2.31e-18 | NR | MCW3981605.1 | 2026714 | g153652 | i0 | 82.7 | 1.80869565217391 | 52 | 9 | 45.2 | 0 | 324 | 169 | 118 | 169 | MCW3981605.1 transcription initiation factor IIB [Candidatus Bathyarchaeota archaeon] | diamond | 624 | 85.9 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27142066 | 27142066 | PRJNA564013_P_NODE_182062_length_323_cov_2.648855_g179212_i0 | PRJNA564013 | 182062 | 323 | 2.648855 | 8.55580165 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 55.5 | 3.1e-6 | NR | MCJ7767095.1 | 2026714 | g179212 | i0 | 31.6 | 0.882352941176471 | 95 | 60 | 84.5 | 2 | 323 | 51 | 236 | 329 | MCJ7767095.1 DUF2341 domain-containing protein [Candidatus Bathyarchaeota archaeon] | diamond | 285 | 55.5 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 27237273 | 27237273 | PRJNA564013_P_NODE_49023_length_563_cov_21.523904_g46269_i0 | PRJNA564013 | 49023 | 563 | 21.523904 | 121.17957952 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 103 | 1.06e-21 | NR | MEM4674760.1 | 2026795 | g46269 | i0 | 51.9 | 0.55417406749556 | 104 | 45 | 54.4 | 4 | 3 | 308 | 974 | 1074 | MEM4674760.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 312 | 103 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 27805978 | 27805978 | PRJNA564013_P_NODE_32424_length_671_cov_4.344262_g29811_i0 | PRJNA564013 | 32424 | 671 | 4.344262 | 29.14999802 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 350 | 5.499999999999999e-117 | NR | MEM1953505.1 | 2972665 | g29811 | i0 | 95.8 | 0.858420268256334 | 192 | 5 | 84.5 | 1 | 671 | 105 | 244 | 435 | MEM1953505.1 O-antigen ligase family protein [Candidatus Caldarchaeum sp.] | diamond | 576 | 350 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 28089871 | 28089871 | PRJNA564013_P_NODE_175325_length_329_cov_3.257463_g172475_i0 | PRJNA564013 | 175325 | 329 | 3.257463 | 10.71705327 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 180 | 4.1199999999999996e-54 | NR | MDW0209989.1 | 2169593 | g172475 | i0 | 96.8 | 3.42857142857143 | 94 | 3 | 85.7 | 0 | 305 | 24 | 29 | 122 | MDW0209989.1 toprim domain-containing protein [Nitrososphaeraceae archaeon] | diamond | 1128 | 180 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 28469052 | 28469052 | PRJNA564013_P_NODE_50166_length_558_cov_6.851107_g47411_i0 | PRJNA564013 | 50166 | 558 | 6.851107 | 38.22917706 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 113 | 8.75e-26 | NR | MEM1953505.1 | 2972665 | g47411 | i0 | 75.6 | 0.462365591397849 | 86 | 15 | 46.2 | 1 | 259 | 2 | 32 | 111 | MEM1953505.1 O-antigen ligase family protein [Candidatus Caldarchaeum sp.] | diamond | 258 | 113 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 28766722 | 28766722 | PRJNA564013_P_NODE_160407_length_342_cov_5.530249_g157557_i0 | PRJNA564013 | 160407 | 342 | 5.530249 | 18.91345158 | root | 1 | Root_unresolved | Root_unresolved | 79 | 7.37e-17 | NR | WP_238027530.1 | 99938 | g157557 | i0 | 97.5 | 0.701754385964912 | 40 | 1 | 35.1 | 0 | 321 | 202 | 23 | 62 | WP_238027530.1 hypothetical protein, partial [Metallosphaera javensis (ex Hofmann et al. 2022)] | diamond | 240 | 79 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Metallosphaera | Metallosphaera javensis (ex Hofmann et al. 2022) | ||
| 29100413 | 29100413 | PRJNA564013_P_NODE_285248_length_235_cov_2.137931_g282396_i0 | PRJNA564013 | 285248 | 235 | 2.137931 | 5.02413785 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 42.4 | 0.0408 | NR | MEM2338583.1 | 2268197 | g282396 | i0 | 47.1 | 0.434042553191489 | 34 | 18 | 43.4 | 0 | 198 | 97 | 105 | 138 | MEM2338583.1 SLC13 family permease [Nitrososphaerales archaeon] | diamond | 102 | 42.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 29163747 | 29163747 | PRJNA564013_P_NODE_45789_length_579_cov_7.725869_g43046_i0 | PRJNA564013 | 45789 | 579 | 7.725869 | 44.73278151 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 220 | 1.01e-68 | NR | MEM3063177.1 | 2026795 | g43046 | i0 | 51.7 | 2.08290155440414 | 201 | 87 | 99 | 1 | 7 | 579 | 23 | 223 | MEM3063177.1 eukaryotic translation initiation factor 4E [Nitrososphaerota archaeon] | diamond | 1206 | 220 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota archaeon | ||||||
| 29257919 | 29257919 | PRJNA564013_P_NODE_105849_length_401_cov_3.558824_g103011_i0 | PRJNA564013 | 105849 | 401 | 3.558824 | 14.270884240000001 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 220 | 1.24e-70 | NR | HET7243038.1 | 2169593 | g103011 | i0 | 98.1 | 1.571072319202 | 105 | 2 | 78.6 | 0 | 401 | 87 | 100 | 204 | HET7243038.1 DUF5996 family protein [Nitrososphaeraceae archaeon] | diamond | 630 | 220 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 29636719 | 29636719 | PRJNA564013_P_NODE_47890_length_569_cov_4.641732_g45139_i0 | PRJNA564013 | 47890 | 569 | 4.641732 | 26.41145508 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 330 | 2.1599999999999993e-110 | NR | MEM3368591.1 | 2056631 | g45139 | i0 | 95.4 | 0.917398945518453 | 174 | 8 | 91.7 | 0 | 563 | 42 | 201 | 374 | MEM3368591.1 PhoH family protein [Thermoproteota archaeon] | diamond | 522 | 330 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30047468 | 30047468 | PRJNA564013_P_NODE_23751_length_765_cov_28.349432_g21360_i0 | PRJNA564013 | 23751 | 765 | 28.349432 | 216.8731548 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 120 | 2.02e-27 | NR | MEM0489409.1 | 3045160 | g21360 | i0 | 49.6 | 0.513725490196078 | 131 | 59 | 49 | 3 | 735 | 361 | 317 | 446 | MEM0489409.1 AAA family ATPase [Candidatus Bathyarchaeia archaeon] | diamond | 393 | 120 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 30869073 | 30869073 | PRJNA564013_P_NODE_43174_length_594_cov_2.378987_g40444_i0 | PRJNA564013 | 43174 | 594 | 2.378987 | 14.13118278 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 110 | 2.52e-28 | NR | HEY9388019.1 | 2169593 | g40444 | i0 | 85.5 | 0.277777777777778 | 55 | 8 | 27.8 | 0 | 538 | 374 | 1 | 55 | HEY9388019.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 165 | 110 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 31437968 | 31437968 | PRJNA564013_P_NODE_169016_length_334_cov_13.901099_g166166_i0 | PRJNA564013 | 169016 | 334 | 13.901099 | 46.42967066 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 180 | 8.29e-53 | NR | HZD35164.1 | 2169593 | g166166 | i0 | 85.1 | 2.68562874251497 | 101 | 15 | 90.7 | 0 | 313 | 11 | 294 | 394 | HZD35164.1 adenosylhomocysteinase [Nitrososphaeraceae archaeon] | diamond | 897 | 180 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32608446 | 32608446 | PRJNA564013_P_NODE_192600_length_313_cov_3.996032_g189749_i0 | PRJNA564013 | 192600 | 313 | 3.996032 | 12.50758016 | Nitrososphaeraceae archaeon | 2169593 | Archaea | Archaea | 93.6 | 2.99e-21 | NR | HEU4468027.1 | 2169593 | g189749 | i0 | 91.5 | 1.31309904153355 | 47 | 4 | 45 | 0 | 151 | 291 | 135 | 181 | HEU4468027.1 hypothetical protein [Nitrososphaeraceae archaeon] | diamond | 411 | 93.6 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaeraceae archaeon | |||
| 32608512 | 32608512 | PRJNA564013_P_NODE_91400_length_426_cov_5.284932_g88567_i0 | PRJNA564013 | 91400 | 426 | 5.284932 | 22.51381032 | Nitrososphaerota archaeon | 2026795 | Archaea | Archaea | 72.8 | 8.08e-12 | NR | MDE1830603.1 | 2026795 | g88567 | i0 | 39.4 | 0.964788732394366 | 137 | 76 | 93.7 | 4 | 408 | 10 | 1 | 134 | MDE1830603.1 hypothetical protein [Nitrososphaerota archaeon] | diamond | 411 | 72.8 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaerota 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);;