contig_metadata
21 rows where bioproject = "PRJNA1120060" and tax_phylum = "Thermoplasmatota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14271615 | 14271615 | PRJNA1120060_P_NODE_1768712_length_282_cov_1.923445_g1750701_i0 | PRJNA1120060 | 1768712 | 282 | 1.923445 | 5.4241149 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 52.8 | 0.026 | NTclustered | gi|2108181953|gb|CP070712.1| | 2268204 | g1750701 | i0 | 100 | 0.099290780141844 | 28 | 0 | 10 | 0 | 141 | 168 | 780525 | 780498 | MAG: Thermoplasmatales archaeon isolate bin50 chromosome | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 24478619 | 24478619 | PRJNA1120060_P_NODE_2513780_length_253_cov_2.827778_g2495708_i0 | PRJNA1120060 | 2513780 | 253 | 2.827778 | 7.15427834 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 52.8 | 0.023 | NTclustered | gi|2108430933|gb|CP070629.1| | 1906666 | g2495708 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 72 | 99 | 791687 | 791714 | MAG: Thermoplasmata archaeon isolate bin983 chromosome | blastn | 28 | 52.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26688816 | 26688816 | PRJNA1120060_P_NODE_1943981_length_275_cov_1.504950_g1925957_i0 | PRJNA1120060 | 1943981 | 275 | 1.50495 | 4.1386125 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 46.2 | 0.00124 | NR | MCK5561356.1 | 1906666 | g1925957 | i0 | 42.1 | 0.621818181818182 | 57 | 33 | 62.2 | 0 | 66 | 236 | 3 | 59 | MCK5561356.1 ribonuclease HI family protein [Thermoplasmata archaeon] | diamond | 171 | 46.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26805967 | 26805967 | PRJNA1120060_P_NODE_1881361_length_277_cov_3.617647_g1863342_i0 | PRJNA1120060 | 1881361 | 277 | 3.617647 | 10.02088219 | Candidatus Thalassarchaeum | 3134675 | Archaea | Archaea | 43.9 | 0.0192 | NR | DAC38991.1 | 2163009 | g1863342 | i0 | 39.5 | 1.33212996389892 | 43 | 26 | 46.6 | 0 | 189 | 61 | 174 | 216 | DAC38991.1 MAG TPA: hypothetical protein D7H83_05530, partial [Candidatus Poseidoniales archaeon] | diamond | 369 | 43.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 26848027 | 26848027 | PRJNA1120060_P_NODE_2960181_length_242_cov_1.911243_g2942087_i0 | PRJNA1120060 | 2960181 | 242 | 1.911243 | 4.62520806 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 42.4 | 0.0493 | NR | MFP3300690.1 | 2268204 | g2942087 | i0 | 51.2 | 0.533057851239669 | 43 | 21 | 53.3 | 0 | 200 | 72 | 339 | 381 | MFP3300690.1 SMC family ATPase [Thermoplasmatales archaeon] | diamond | 129 | 42.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 28016417 | 28016417 | PRJNA1120060_P_NODE_1969005_length_274_cov_1.502488_g1950979_i0 | PRJNA1120060 | 1969005 | 274 | 1.502488 | 4.11681712 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 50.4 | 7.26e-6 | NR | MCI4360654.1 | 1906666 | g1950979 | i0 | 55.8 | 0.470802919708029 | 43 | 18 | 46 | 1 | 5 | 130 | 20 | 62 | MCI4360654.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 129 | 50.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28111024 | 28111024 | PRJNA1120060_P_NODE_2180945_length_265_cov_5.395833_g2162893_i0 | PRJNA1120060 | 2180945 | 265 | 5.395833 | 14.29895745 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.9 | 0.00206 | NR | HUS57006.1 | 1906666 | g2162893 | i0 | 42.3 | 0.588679245283019 | 52 | 30 | 58.9 | 0 | 201 | 46 | 5 | 56 | HUS57006.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 156 | 43.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28142722 | 28142722 | PRJNA1120060_P_NODE_1912965_length_276_cov_2.261084_g1894943_i0 | PRJNA1120060 | 1912965 | 276 | 2.261084 | 6.24059184 | Candidatus Methanoprimaticola hominis | 1820007 | Archaea | Archaea | 43.1 | 0.038 | NR | TQS85700.1 | 1820007 | g1894943 | i0 | 30.8 | 0.706521739130435 | 65 | 44 | 70.7 | 1 | 199 | 5 | 8 | 71 | TQS85700.1 MAG: hypothetical protein A3208_01545 [Candidatus Methanoprimaticola hominis] | diamond | 195 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanoprimaticola | Candidatus Methanoprimaticola hominis | ||
| 28206352 | 28206352 | PRJNA1120060_P_NODE_3173546_length_232_cov_5.383648_g3155440_i0 | PRJNA1120060 | 3173546 | 232 | 5.383648 | 12.49006336 | Candidatus Poseidoniales archaeon | 2163009 | Archaea | Archaea | 55.1 | 1.33e-6 | NR | MEK9694273.1 | 2163009 | g3155440 | i0 | 36.5 | 1.74568965517241 | 63 | 39 | 81.5 | 1 | 18 | 206 | 252 | 313 | MEK9694273.1 hypothetical protein [Candidatus Poseidoniales archaeon] | diamond | 405 | 55.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniales archaeon | ||||
| 28679720 | 28679720 | PRJNA1120060_P_NODE_2335407_length_260_cov_1.267380_g2317347_i0 | PRJNA1120060 | 2335407 | 260 | 1.26738 | 3.295188 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.1 | 0.0335 | NR | MEM4728244.1 | 1906666 | g2317347 | i0 | 36.1 | 0.703846153846154 | 61 | 36 | 66.9 | 2 | 10 | 183 | 380 | 440 | MEM4728244.1 ferrous iron transport protein B [Thermoplasmata archaeon] | diamond | 183 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28837139 | 28837139 | PRJNA1120060_P_NODE_1973308_length_274_cov_1.194030_g1955282_i0 | PRJNA1120060 | 1973308 | 274 | 1.19403 | 3.2716422 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.5 | 0.0291 | NR | MCK5561700.1 | 1906666 | g1955282 | i0 | 39.2 | 0.558394160583942 | 51 | 30 | 54.7 | 1 | 62 | 211 | 503 | 553 | MCK5561700.1 FG-GAP repeat protein [Thermoplasmata archaeon] | diamond | 153 | 43.5 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 28963622 | 28963622 | PRJNA1120060_P_NODE_1872508_length_278_cov_1.282927_g1854492_i0 | PRJNA1120060 | 1872508 | 278 | 1.282927 | 3.56653706 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.1 | 0.0249 | NR | MCK5037954.1 | 1906666 | g1854492 | i0 | 34.5 | 0.62589928057554 | 58 | 32 | 56.1 | 1 | 157 | 2 | 63 | 120 | MCK5037954.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 174 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29026622 | 29026622 | PRJNA1120060_P_NODE_1495988_length_293_cov_4.150000_g1478000_i0 | PRJNA1120060 | 1495988 | 293 | 4.15 | 12.1595 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.4 | 0.00751 | NR | HLE45587.1 | 1906666 | g1478000 | i0 | 34 | 1.02389078498294 | 100 | 53 | 92.2 | 3 | 10 | 279 | 142 | 238 | HLE45587.1 Ig-like domain-containing protein [Thermoplasmata archaeon] | diamond | 300 | 45.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 30058916 | 30058916 | PRJNA1120060_P_NODE_1057271_length_311_cov_4.075630_g1039336_i0 | PRJNA1120060 | 1057271 | 311 | 4.07563 | 12.6752093 | root | 1 | Root_unresolved | Root_unresolved | 81.3 | 1.35e-15 | NR | MCJ7572587.1 | 2806419 | g1039336 | i0 | 57.8 | 6.86816720257235 | 64 | 26 | 61.7 | 1 | 308 | 117 | 70 | 132 | MCJ7572587.1 DNA (cytosine-5-)-methyltransferase [Thermoplasmatota archaeon] | diamond | 2136 | 81.6 | 0.996323529411765 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30227112 | 30227112 | PRJNA1120060_P_NODE_2707692_length_248_cov_2.125714_g2689609_i0 | PRJNA1120060 | 2707692 | 248 | 2.125714 | 5.27177072 | Candidatus Poseidoniia archaeon | 2666348 | Archaea | Archaea | 43.1 | 0.0287 | NR | MCH2431452.1 | 2666348 | g2689609 | i0 | 34.6 | 0.979838709677419 | 81 | 38 | 88.3 | 3 | 228 | 10 | 24 | 97 | MCH2431452.1 arginine--tRNA ligase [Candidatus Poseidoniia archaeon] | diamond | 243 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniia archaeon | |||||
| 30321910 | 30321910 | PRJNA1120060_P_NODE_1773372_length_282_cov_1.382775_g1755361_i0 | PRJNA1120060 | 1773372 | 282 | 1.382775 | 3.8994255 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 45.4 | 0.00269 | NR | MCK5259230.1 | 2268204 | g1755361 | i0 | 31.8 | 2.82978723404255 | 66 | 45 | 70.2 | 0 | 275 | 78 | 63 | 128 | MCK5259230.1 ribonuclease HI family protein [Thermoplasmatales archaeon] | diamond | 798 | 45.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 30985054 | 30985054 | PRJNA1120060_P_NODE_1911094_length_276_cov_2.546798_g1893072_i0 | PRJNA1120060 | 1911094 | 276 | 2.546798 | 7.02916248 | Thermoplasmata archaeon M9B1D | 1933279 | Archaea | Archaea | 45.1 | 0.00764 | NR | PNX47578.1 | 1933279 | g1893072 | i0 | 35 | 0.652173913043478 | 60 | 37 | 65.2 | 1 | 202 | 23 | 43 | 100 | PNX47578.1 MAG: hypothetical protein BV457_05415 [Thermoplasmata archaeon M9B1D] | diamond | 180 | 45.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon M9B1D | |||||
| 31396818 | 31396818 | PRJNA1120060_P_NODE_3037636_length_239_cov_2.536145_g3019536_i0 | PRJNA1120060 | 3037636 | 239 | 2.536145 | 6.06138655 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 44.3 | 0.00983 | NR | HEX7391434.1 | 1906666 | g3019536 | i0 | 39.7 | 1.64435146443515 | 68 | 37 | 85.4 | 3 | 227 | 24 | 153 | 216 | HEX7391434.1 M20 family metallo-hydrolase [Thermoplasmata archaeon] | diamond | 393 | 44.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 31521987 | 31521987 | PRJNA1120060_P_NODE_1033696_length_311_cov_7.617647_g1015761_i0 | PRJNA1120060 | 1033696 | 311 | 7.617647 | 23.69088217 | Methanomassiliicoccales archaeon | 1906667 | Archaea | Archaea | 47 | 0.00272 | NR | MEM0449682.1 | 1906667 | g1015761 | i0 | 51.1 | 0.916398713826367 | 47 | 23 | 45.3 | 0 | 3 | 143 | 597 | 643 | MEM0449682.1 tetratricopeptide repeat protein [Methanomassiliicoccales archaeon] | diamond | 285 | 47 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon | ||||
| 32124306 | 32124306 | PRJNA1120060_P_NODE_2854358_length_245_cov_0.889535_g2836272_i0 | PRJNA1120060 | 2854358 | 245 | 0.889535 | 2.17936075 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 44.3 | 0.0107 | NR | HKM13945.1 | 2517205 | g2836272 | i0 | 35.6 | 0.722448979591837 | 59 | 37 | 71 | 1 | 205 | 32 | 119 | 177 | HKM13945.1 aldehyde dehydrogenase family protein [Candidatus Methanomethylophilaceae archaeon] | diamond | 177 | 44.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae archaeon | |||
| 32377262 | 32377262 | PRJNA1120060_P_NODE_2732039_length_247_cov_6.620690_g2713955_i0 | PRJNA1120060 | 2732039 | 247 | 6.62069 | 16.3531043 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.1 | 0.0277 | NR | HEY1197604.1 | 1906666 | g2713955 | i0 | 52.9 | 0.412955465587045 | 34 | 16 | 41.3 | 0 | 207 | 106 | 119 | 152 | HEY1197604.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 102 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata 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);;