contig_metadata
11 rows where bioproject = "PRJEB20058" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25785049 | 25785049 | PRJEB20058_P_NODE_104947_length_396_cov_1.122388_g102139_i0 | PRJEB20058 | 104947 | 396 | 1.122388 | 4.44465648 | root | 1 | Root_unresolved | Root_unresolved | 124 | 2.3e-30 | NR | MEE9151390.1 | 1906666 | g102139 | i0 | 67.1 | 9.93181818181818 | 82 | 27 | 62.1 | 0 | 248 | 3 | 1 | 82 | MEE9151390.1 class I SAM-dependent DNA methyltransferase [Thermoplasmata archaeon] | diamond | 3933 | 124 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 32309712 | 32309712 | PRJEB20058_S_NODE_4239_length_307_cov_2.890244_g4201_i0 | PRJEB20058 | 4239 | 307 | 2.890244 | 8.87304908 | Methanomassiliicoccus luminyensis | 1080712 | Archaea | Archaea | 106 | 3.17e-24 | NR | WP_019176361.1 | 1080712 | g4201 | i0 | 57 | 1.70032573289902 | 86 | 37 | 84 | 0 | 14 | 271 | 418 | 503 | WP_019176361.1 methylamine methyltransferase corrinoid protein reductive activase [Methanomassiliicoccus luminyensis] | diamond | 522 | 106 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccus | Methanomassiliicoccus luminyensis | ||
| 32945525 | 32945525 | PRJEB20058_P_NODE_35146_length_709_cov_6.785494_g32572_i0 | PRJEB20058 | 35146 | 709 | 6.785494 | 48.10915246 | Aciduliprofundum boonei T469 | 439481 | Archaea | Archaea | 200 | 1.2399999999999998e-55 | NR | EDY34769.1 | 439481 | g32572 | i0 | 55.1 | 0.706629055007052 | 167 | 65 | 70.2 | 2 | 212 | 709 | 376 | 533 | EDY34769.1 N-6 DNA Methylase family [Aciduliprofundum boonei T469] | diamond | 501 | 200 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 33013048 | 33013048 | PRJEB20058_P_NODE_120900_length_363_cov_1.841060_g118083_i0 | PRJEB20058 | 120900 | 363 | 1.84106 | 6.6830478 | Methanomassiliicoccus sp. | 2528041 | Archaea | Archaea | 203 | 2.32e-62 | NR | NLT37046.1 | 2528041 | g118083 | i0 | 88.5 | 0.933884297520661 | 113 | 13 | 93.4 | 0 | 355 | 17 | 83 | 195 | NLT37046.1 HAMP domain-containing histidine kinase [Methanomassiliicoccus sp.] | diamond | 339 | 203 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccus | Methanomassiliicoccus sp. | ||
| 33047214 | 33047214 | PRJEB20058_P_NODE_136429_length_334_cov_62.362637_g133609_i0 | PRJEB20058 | 136429 | 334 | 62.362637 | 208.29120758 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 50.4 | 1.96e-4 | NR | MFP4050341.1 | 1906666 | g133609 | i0 | 58.3 | 0.323353293413174 | 36 | 15 | 32.3 | 0 | 21 | 128 | 73 | 108 | MFP4050341.1 tetratricopeptide repeat protein [Thermoplasmata archaeon] | diamond | 108 | 50.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 33047738 | 33047738 | PRJEB20058_P_NODE_227757_length_234_cov_22.612717_g224932_i0 | PRJEB20058 | 227757 | 234 | 22.612717 | 52.91375778 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 43.9 | 0.013 | NR | UCF09071.1 | 1906666 | g224932 | i0 | 40.3 | 0.858974358974359 | 67 | 38 | 83.3 | 1 | 204 | 10 | 3 | 69 | UCF09071.1 MAG: radical SAM protein [Thermoplasmata archaeon] | diamond | 201 | 43.9 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 33099432 | 33099432 | PRJEB20058_P_NODE_90310_length_432_cov_7.253369_g87512_i0 | PRJEB20058 | 90310 | 432 | 7.253369 | 31.33455408 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 113 | 6.27e-30 | NR | MDI9378930.1 | 2806419 | g87512 | i0 | 100 | 0.75 | 54 | 0 | 37.5 | 0 | 182 | 21 | 14 | 67 | MDI9378930.1 fructose-bisphosphate aldolase [Thermoplasmatota archaeon] | diamond | 324 | 113 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 33110601 | 33110601 | PRJEB20058_P_NODE_118086_length_368_cov_3.941368_g115271_i0 | PRJEB20058 | 118086 | 368 | 3.941368 | 14.50423424 | Methanomassiliicoccus | 1080709 | Archaea | Archaea | 103 | 3.25e-26 | NR | OPY32388.1 | 1811729 | g115271 | i0 | 87.7 | 0.929347826086957 | 57 | 7 | 46.5 | 0 | 43 | 213 | 1 | 57 | OPY32388.1 MAG: hypothetical protein A4E31_00106 [Methanomassiliicoccales archaeon PtaU1.Bin030] | diamond | 342 | 104 | 0.990384615384615 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccales archaeon PtaU1.Bin030 | ||||
| 33116041 | 33116041 | PRJEB20058_P_NODE_243279_length_208_cov_9.061224_g240454_i0 | PRJEB20058 | 243279 | 208 | 9.061224 | 18.84734592 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 45.4 | 0.00244 | NR | MBE3122026.1 | 1906666 | g240454 | i0 | 44.3 | 1.77403846153846 | 61 | 34 | 88 | 0 | 24 | 206 | 142 | 202 | MBE3122026.1 hypothetical protein [Thermoplasmata archaeon] | diamond | 369 | 45.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 33133624 | 33133624 | PRJEB20058_P_NODE_89295_length_435_cov_4.082888_g86497_i0 | PRJEB20058 | 89295 | 435 | 4.082888 | 17.7605628 | Candidatus Thalassarchaeum sp. | 3134679 | Archaea | Archaea | 103 | 1.29e-22 | NR | NRB12194.1 | 3134679 | g86497 | i0 | 40.9 | 0.944827586206897 | 137 | 79 | 93.8 | 2 | 427 | 20 | 931 | 1066 | NRB12194.1 LamG domain-containing protein [Candidatus Thalassarchaeum sp.] | diamond | 411 | 103 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Thalassarchaeaceae | Candidatus Thalassarchaeum | Candidatus Thalassarchaeum sp. | ||
| 33149470 | 33149470 | PRJEB20058_P_NODE_116344_length_371_cov_26.103226_g113529_i0 | PRJEB20058 | 116344 | 371 | 26.103226 | 96.84296846 | Candidatus Methanomethylophilaceae archaeon | 2517205 | Archaea | Archaea | 92.8 | 4.89e-21 | NR | MDD2411087.1 | 2517205 | g113529 | i0 | 52.7 | 1.47169811320755 | 91 | 43 | 73.6 | 0 | 97 | 369 | 1 | 91 | MDD2411087.1 hypothetical protein [Candidatus Methanomethylophilaceae archaeon] | diamond | 546 | 92.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Candidatus Methanomethylophilaceae 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);;