contig_metadata
22 rows where bioproject = "PRJNA429937" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4254121 | 4254121 | PRJNA429937_P_NODE_65184_length_423_cov_3.271574_g26173_i1 | PRJNA429937 | 65184 | 423 | 3.271574 | 13.83875802 | Acidianus brierleyi | 41673 | Archaea | Archaea | 52.8 | 0.041 | NTclustered | gi|1820310180|gb|CP029289.2| | 41673 | g26173 | i1 | 100 | 0.066193853427896 | 28 | 0 | 7 | 0 | 395 | 422 | 833643 | 833670 | Acidianus brierleyi strain DSM 1651 chromosome, complete genome | blastn | 28 | 52.8 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Acidianus | Acidianus brierleyi | ||
| 5530179 | 5530179 | PRJNA429937_P_NODE_31305_length_650_cov_2.834138_g19109_i0 | PRJNA429937 | 31305 | 650 | 2.834138 | 18.421897 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 1053 | 0 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g19109 | i0 | 99.314 | 0.987692307692308 | 583 | 2 | 98 | 2 | 1 | 581 | 2820740 | 2820158 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 642 | 1053 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 9354629 | 9354629 | PRJNA429937_P_NODE_31308_length_650_cov_2.732689_g19109_i1 | PRJNA429937 | 31308 | 650 | 2.732689 | 17.7624785 | Candidatus Nitrosocosmicus oleophilus | 1353260 | Archaea | Archaea | 1053 | 0 | NTclustered | gi|937513727|gb|CP012850.1| | 1353260 | g19109 | i1 | 99.314 | 0.987692307692308 | 583 | 2 | 98 | 2 | 1 | 581 | 2820740 | 2820158 | Candidatus Nitrosocosmicus oleophilus strain MY3, complete genome | blastn | 642 | 1053 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosocosmicus | Candidatus Nitrosocosmicus oleophilus | ||
| 21489459 | 21489459 | PRJNA429937_P_NODE_5397_length_1489_cov_6.174658_g3183_i0 | PRJNA429937 | 5397 | 1489 | 6.174658 | 91.94065762 | Thermoproteus sp. | 2268139 | Archaea | Archaea | 181 | 2.55e-48 | NR | MFP3199777.1 | 2268139 | g3183 | i0 | 36.3 | 2.29885829415715 | 383 | 203 | 71.7 | 11 | 165 | 1232 | 1 | 369 | MFP3199777.1 glycosyltransferase [Thermoproteus sp.] | diamond | 3423 | 181 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Thermoproteus | Thermoproteus sp. | ||
| 26949059 | 26949059 | PRJNA429937_P_NODE_27182_length_702_cov_3.835067_g15705_i1 | PRJNA429937 | 27182 | 702 | 3.835067 | 26.92217034 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 148 | 1.78e-41 | NR | MDP9197224.1 | 2056631 | g15705 | i1 | 85.6 | 0.384615384615385 | 90 | 13 | 38.5 | 0 | 288 | 19 | 1 | 90 | MDP9197224.1 DUF2203 domain-containing protein [Thermoproteota archaeon] | diamond | 270 | 148 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27107136 | 27107136 | PRJNA429937_P_NODE_41982_length_554_cov_7.554286_g26685_i0 | PRJNA429937 | 41982 | 554 | 7.554286 | 41.85074444 | Candidatus Methanomethylicaceae archaeon | 2282146 | Archaea | Archaea | 195 | 1.8899999999999998e-54 | NR | MEM3365499.1 | 2282146 | g26685 | i0 | 73.4 | 0.774368231046931 | 143 | 38 | 77.4 | 0 | 431 | 3 | 203 | 345 | MEM3365499.1 hypothetical protein [Candidatus Methanomethyliaceae archaeon] | diamond | 429 | 195 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicaceae archaeon | |||
| 27549569 | 27549569 | PRJNA429937_P_NODE_63284_length_432_cov_1.828784_g42943_i0 | PRJNA429937 | 63284 | 432 | 1.828784 | 7.90034688 | Candidatus Caldarchaeum sp. | 2972665 | Archaea | Archaea | 51.2 | 2.54e-4 | NR | MEM4168313.1 | 2972665 | g42943 | i0 | 62.9 | 0.548611111111111 | 35 | 13 | 24.3 | 0 | 202 | 98 | 95 | 129 | MEM4168313.1 hypothetical protein [Candidatus Caldarchaeum sp.] | diamond | 237 | 51.2 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Candidatus Caldarchaeales | Candidatus Caldarchaeaceae | Candidatus Caldarchaeum | Candidatus Caldarchaeum sp. | |||
| 27707989 | 27707989 | PRJNA429937_P_NODE_32524_length_636_cov_5.736409_g19966_i0 | PRJNA429937 | 32524 | 636 | 5.736409 | 36.48356124 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 363 | 1.16e-125 | NR | MEM3368514.1 | 2056631 | g19966 | i0 | 90.2 | 0.962264150943396 | 204 | 20 | 96.2 | 0 | 23 | 634 | 1 | 204 | MEM3368514.1 hypothetical protein [Thermoproteota archaeon] | diamond | 612 | 363 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27928543 | 27928543 | PRJNA429937_P_NODE_110945_length_272_cov_1.995885_g88323_i0 | PRJNA429937 | 110945 | 272 | 1.995885 | 5.4288072 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 65.5 | 1.21e-11 | NR | NOJ27510.1 | 1971748 | g88323 | i0 | 58.1 | 0.683823529411765 | 62 | 22 | 68.4 | 1 | 2 | 187 | 30 | 87 | NOJ27510.1 hypothetical protein [Nitrososphaera sp.] | diamond | 186 | 65.5 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 28370541 | 28370541 | PRJNA429937_P_NODE_74126_length_387_cov_2.019553_g52136_i0 | PRJNA429937 | 74126 | 387 | 2.019553 | 7.81567011 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 57.4 | 3.66e-7 | NR | HYW33679.1 | 3045160 | g52136 | i0 | 46.6 | 0.565891472868217 | 73 | 23 | 46.5 | 2 | 184 | 5 | 58 | 127 | HYW33679.1 GNAT family N-acetyltransferase [Candidatus Bathyarchaeia archaeon] | diamond | 219 | 57.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 28686557 | 28686557 | PRJNA429937_P_NODE_106767_length_283_cov_2.539370_g84147_i0 | PRJNA429937 | 106767 | 283 | 2.53937 | 7.1864171 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 103 | 5.93e-26 | NR | NOJ27511.1 | 1971748 | g84147 | i0 | 50.4 | 1.21908127208481 | 115 | 32 | 95.4 | 1 | 282 | 13 | 7 | 121 | NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] | diamond | 345 | 103 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 28734480 | 28734480 | PRJNA429937_P_NODE_67227_length_414_cov_4.114286_g46129_i0 | PRJNA429937 | 67227 | 414 | 4.114286 | 17.03314404 | root | 1 | Root_unresolved | Root_unresolved | 89.7 | 1.71e-19 | NR | RPI82472.1 | 2026768 | g46129 | i0 | 42.2 | 4.72463768115942 | 102 | 59 | 73.9 | 0 | 76 | 381 | 47 | 148 | RPI82472.1 MAG: hypothetical protein EHM34_06880 [Nitrosopumilales archaeon] | diamond | 1956 | 89.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilales archaeon | ||||
| 29759697 | 29759697 | PRJNA429937_P_NODE_68451_length_409_cov_3.723684_g47158_i0 | PRJNA429937 | 68451 | 409 | 3.723684 | 15.22986756 | Candidatus Bathyarchaeia archaeon | 3045160 | Archaea | Archaea | 254 | 9.149999999999999e-82 | NR | HUW21884.1 | 3045160 | g47158 | i0 | 89.6 | 0.990220048899755 | 135 | 14 | 99 | 0 | 407 | 3 | 66 | 200 | HUW21884.1 alpha/beta fold hydrolase [Candidatus Bathyarchaeia archaeon] | diamond | 405 | 254 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeia | Candidatus Bathyarchaeia archaeon | |||||
| 29822749 | 29822749 | PRJNA429937_P_NODE_28531_length_683_cov_3.877676_g15705_i2 | PRJNA429937 | 28531 | 683 | 3.877676 | 26.48452708 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 148 | 1.42e-41 | NR | MDP9197224.1 | 2056631 | g15705 | i2 | 85.6 | 0.395314787701318 | 90 | 13 | 39.5 | 0 | 396 | 665 | 1 | 90 | MDP9197224.1 DUF2203 domain-containing protein [Thermoproteota archaeon] | diamond | 270 | 148 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 29980955 | 29980955 | PRJNA429937_P_NODE_140071_length_205_cov_3.284091_g117444_i0 | PRJNA429937 | 140071 | 205 | 3.284091 | 6.73238655 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 115 | 5.839999999999999e-31 | NR | NOJ27511.1 | 1971748 | g117444 | i0 | 77.9 | 0.995121951219512 | 68 | 15 | 99.5 | 0 | 204 | 1 | 7 | 74 | NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] | diamond | 204 | 115 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 30201867 | 30201867 | PRJNA429937_P_NODE_6632_length_1365_cov_6.197605_g3901_i0 | PRJNA429937 | 6632 | 1365 | 6.197605 | 84.59730825 | Candidatus Bathyarchaeota archaeon | 2026714 | Archaea | Archaea | 92.4 | 1.67e-18 | NR | MCJ7631221.1 | 2026714 | g3901 | i0 | 45.9 | 0.243956043956044 | 111 | 54 | 24.4 | 2 | 1272 | 940 | 11 | 115 | MCJ7631221.1 hypothetical protein [Candidatus Bathyarchaeota archaeon] | diamond | 333 | 92.4 | 1 | Archaea | Thermoproteati | Candidatus Bathyarchaeota | Candidatus Bathyarchaeota archaeon | ||||||
| 30486519 | 30486519 | PRJNA429937_P_NODE_138993_length_207_cov_2.353933_g116366_i0 | PRJNA429937 | 138993 | 207 | 2.353933 | 4.87264131 | Candidatus Nitrosarchaeum limnium | 1007084 | Archaea | Archaea | 84.7 | 1.8e-17 | NR | WP_048096998.1 | 1007084 | g116366 | i0 | 90.9 | 3.18840579710145 | 44 | 4 | 63.8 | 0 | 76 | 207 | 1 | 44 | WP_048096998.1 AAA family ATPase, partial [Candidatus Nitrosarchaeum limnium] | diamond | 660 | 84.7 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrosopumilales | Nitrosopumilaceae | Nitrosarchaeum | Candidatus Nitrosarchaeum limnium | ||
| 31466385 | 31466385 | PRJNA429937_P_NODE_63876_length_429_cov_2.625000_g43410_i0 | PRJNA429937 | 63876 | 429 | 2.625 | 11.26125 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 48.1 | 0.00302 | NR | MCI0557423.1 | 1971748 | g43410 | i0 | 42 | 0.34965034965035 | 50 | 29 | 35 | 0 | 284 | 135 | 1 | 50 | MCI0557423.1 hypothetical protein [Nitrososphaera sp.] | diamond | 150 | 48.1 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 31624270 | 31624270 | PRJNA429937_P_NODE_148176_length_189_cov_3.531250_g125549_i0 | PRJNA429937 | 148176 | 189 | 3.53125 | 6.6740625 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 89 | 1.29e-20 | NR | NOJ27511.1 | 1971748 | g125549 | i0 | 70.9 | 0.873015873015873 | 55 | 16 | 87.3 | 0 | 15 | 179 | 1 | 55 | NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] | diamond | 165 | 89 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 31845635 | 31845635 | PRJNA429937_P_NODE_26197_length_716_cov_3.887918_g15705_i0 | PRJNA429937 | 26197 | 716 | 3.887918 | 27.83749288 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 148 | 2.02e-41 | NR | MDP9197224.1 | 2056631 | g15705 | i0 | 85.6 | 0.377094972067039 | 90 | 13 | 37.7 | 0 | 288 | 19 | 1 | 90 | MDP9197224.1 DUF2203 domain-containing protein [Thermoproteota archaeon] | diamond | 270 | 148 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31972249 | 31972249 | PRJNA429937_P_NODE_127678_length_230_cov_2.850746_g105051_i0 | PRJNA429937 | 127678 | 230 | 2.850746 | 6.5567158 | Nitrososphaera sp. | 1971748 | Archaea | Archaea | 82.4 | 8.4e-18 | NR | NOJ27511.1 | 1971748 | g105051 | i0 | 73.5 | 0.639130434782609 | 49 | 13 | 63.9 | 0 | 229 | 83 | 7 | 55 | NOJ27511.1 heavy metal-responsive transcriptional regulator [Nitrososphaera sp.] | diamond | 147 | 82.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Nitrososphaera | Nitrososphaera sp. | ||
| 32478774 | 32478774 | PRJNA429937_P_NODE_125999_length_234_cov_1.800000_g103372_i0 | PRJNA429937 | 125999 | 234 | 1.8 | 4.212 | Candidatus Nitrosopolaris wilkensis | 2959594 | Archaea | Archaea | 92.4 | 8.4e-20 | NR | PWU81597.1 | 2959594 | g103372 | i0 | 93.6 | 0.602564102564103 | 47 | 3 | 60.3 | 0 | 232 | 92 | 156 | 202 | PWU81597.1 MAG: succinate-semialdehyde dehydrogenase [Candidatus Nitrosopolaris wilkensis] | diamond | 141 | 92.4 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaeraceae | Candidatus Nitrosopolaris | Candidatus Nitrosopolaris wilkensis |
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);;