contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA615351" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17173384 | 17173384 | PRJNA615351_P_NODE_13214_length_1803_cov_17.155543_g9492_i0 | PRJNA615351 | 13214 | 1803 | 17.155543 | 309.31444029 | root | 1 | Root_unresolved | Root_unresolved | 362 | 8.639999999999998e-116 | NR | MDA7464093.1 | 1915863 | g9492 | i0 | 40.1 | 3.86688851913478 | 461 | 268 | 76.7 | 4 | 1778 | 396 | 1 | 453 | MDA7464093.1 DNA photolyase family protein [Candidatus Poseidonia alphae] | diamond | 6972 | 362 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae | ||
| 26731778 | 26731778 | PRJNA615351_P_NODE_107961_length_287_cov_1.757937_g93862_i0 | PRJNA615351 | 107961 | 287 | 1.757937 | 5.04527919 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 44.3 | 0.0181 | NR | RLF51597.1 | 1906666 | g93862 | i0 | 36.5 | 0.543554006968641 | 52 | 32 | 53.3 | 1 | 193 | 41 | 214 | 265 | RLF51597.1 MAG: hypothetical protein DRN19_02510, partial [Thermoplasmata archaeon] | diamond | 156 | 44.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 26890938 | 26890938 | PRJNA615351_P_NODE_78481_length_435_cov_4.797500_g64456_i0 | PRJNA615351 | 78481 | 435 | 4.7975 | 20.869125 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 86.3 | 2.92e-18 | NR | MBN1539331.1 | 2806419 | g64456 | i0 | 37.6 | 3.98620689655172 | 125 | 73 | 85.5 | 4 | 429 | 58 | 26 | 146 | MBN1539331.1 GNAT family N-acetyltransferase [Thermoplasmatota archaeon] | diamond | 1734 | 86.3 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 27428340 | 27428340 | PRJNA615351_P_NODE_39903_length_902_cov_4.453287_g29623_i0 | PRJNA615351 | 39903 | 902 | 4.453287 | 40.16864874 | Methanomethylophilus alvi | 1291540 | Archaea | Archaea | 118 | 9.22e-26 | NR | WP_400225339.1 | 1291540 | g29623 | i0 | 29.1 | 0.947893569844789 | 285 | 153 | 82.5 | 12 | 847 | 104 | 13 | 285 | WP_400225339.1 zinc-ribbon domain-containing protein [Methanomethylophilus alvi] | diamond | 855 | 118 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomethylophilaceae | Methanomethylophilus | Methanomethylophilus alvi | ||
| 28154394 | 28154394 | PRJNA615351_P_NODE_121605_length_246_cov_1.696682_g107505_i0 | PRJNA615351 | 121605 | 246 | 1.696682 | 4.17383772 | Candidatus Aciduliprofundum boonei | 379547 | Archaea | Archaea | 45.8 | 0.00178 | NR | WP_008083872.1 | 379547 | g107505 | i0 | 34.3 | 0.853658536585366 | 70 | 43 | 85.4 | 1 | 215 | 6 | 33 | 99 | WP_008083872.1 RNA 2',3'-cyclic phosphodiesterase [Candidatus Aciduliprofundum boonei] | diamond | 210 | 45.8 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Candidatus Aciduliprofundum boonei | ||||
| 28312163 | 28312163 | PRJNA615351_P_NODE_153426_length_185_cov_1.600000_g139326_i0 | PRJNA615351 | 153426 | 185 | 1.6 | 2.96 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 51.2 | 1.74e-5 | NR | MBU0498155.1 | 2806419 | g139326 | i0 | 41.3 | 1.02162162162162 | 63 | 27 | 90.8 | 2 | 175 | 8 | 245 | 304 | MBU0498155.1 PQQ-binding-like beta-propeller repeat protein [Thermoplasmatota archaeon] | diamond | 189 | 51.2 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28659522 | 28659522 | PRJNA615351_P_NODE_137887_length_210_cov_1.651429_g123787_i0 | PRJNA615351 | 137887 | 210 | 1.651429 | 3.4680009 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 48.1 | 3.12e-4 | NR | HVL48769.1 | 2806419 | g123787 | i0 | 36.9 | 0.928571428571429 | 65 | 41 | 92.9 | 0 | 210 | 16 | 202 | 266 | HVL48769.1 AAA domain-containing protein [Thermoplasmatota archaeon] | diamond | 195 | 48.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 28785652 | 28785652 | PRJNA615351_P_NODE_70687_length_495_cov_2.634783_g56787_i0 | PRJNA615351 | 70687 | 495 | 2.634783 | 13.04217585 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 81.6 | 1.5e-14 | NR | MEF8879813.1 | 2806419 | g56787 | i0 | 36.7 | 2.03636363636364 | 166 | 90 | 97.6 | 5 | 1 | 483 | 474 | 629 | MEF8879813.1 IGHMBP2 family helicase [Thermoplasmatota archaeon] | diamond | 1008 | 81.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29070076 | 29070076 | PRJNA615351_P_NODE_179768_length_156_cov_1.479339_g165668_i0 | PRJNA615351 | 179768 | 156 | 1.479339 | 2.30776884 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 52.4 | 3.05e-7 | NR | MFO7619084.1 | 1906666 | g165668 | i0 | 64.1 | 1.53846153846154 | 39 | 14 | 75 | 0 | 6 | 122 | 39 | 77 | MFO7619084.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Thermoplasmata archaeon] | diamond | 240 | 52.4 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29177682 | 29177682 | PRJNA615351_P_NODE_139209_length_208_cov_1.075145_g125109_i0 | PRJNA615351 | 139209 | 208 | 1.075145 | 2.2363016 | root | 1 | Root_unresolved | Root_unresolved | 47 | 6.85e-4 | NR | RLF25817.1 | 1906666 | g125109 | i0 | 48.9 | 4.44230769230769 | 45 | 23 | 64.9 | 0 | 137 | 3 | 135 | 179 | RLF25817.1 MAG: hypothetical protein DRN14_07790, partial [Thermoplasmata archaeon] | diamond | 924 | 47 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmata archaeon | |||||
| 29795985 | 29795985 | PRJNA615351_P_NODE_34831_length_1011_cov_3.118852_g25657_i0 | PRJNA615351 | 34831 | 1011 | 3.118852 | 31.53159372 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 61.6 | 2.66e-7 | NR | MEE3192512.1 | 2806419 | g25657 | i0 | 31.1 | 0.314540059347181 | 106 | 70 | 31.2 | 3 | 570 | 884 | 19 | 122 | MEE3192512.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 318 | 61.6 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 29954168 | 29954168 | PRJNA615351_P_NODE_59931_length_597_cov_14.969751_g46714_i0 | PRJNA615351 | 59931 | 597 | 14.969751 | 89.36941347 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 60.8 | 1.02e-7 | NR | MEE3192512.1 | 2806419 | g46714 | i0 | 29.8 | 0.57286432160804 | 114 | 76 | 55.8 | 2 | 97 | 429 | 18 | 130 | MEE3192512.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 342 | 60.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30365188 | 30365188 | PRJNA615351_P_NODE_22672_length_1360_cov_4.459623_g16498_i0 | PRJNA615351 | 22672 | 1360 | 4.459623 | 60.6508728 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 102 | 8.5e-21 | NR | MDG6218868.1 | 2806419 | g16498 | i0 | 26.3 | 3.47205882352941 | 304 | 150 | 67.1 | 6 | 1245 | 334 | 4 | 233 | MDG6218868.1 tryptophan-rich sensory protein [Thermoplasmatota archaeon] | diamond | 4722 | 102 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 30554267 | 30554267 | PRJNA615351_P_NODE_64973_length_546_cov_9.859100_g51355_i0 | PRJNA615351 | 64973 | 546 | 9.8591 | 53.830686 | Methanomassiliicoccus sp. | 2528041 | Archaea | Archaea | 72.8 | 4.63e-13 | NR | MDW5563995.1 | 2528041 | g51355 | i0 | 35.2 | 1.12087912087912 | 105 | 67 | 57.7 | 1 | 169 | 483 | 2 | 105 | MDW5563995.1 thioredoxin [Methanomassiliicoccus sp.] | diamond | 612 | 72.8 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Methanomassiliicoccales | Methanomassiliicoccaceae | Methanomassiliicoccus | Methanomassiliicoccus sp. | ||
| 30807105 | 30807105 | PRJNA615351_P_NODE_149114_length_191_cov_1.865385_g135014_i0 | PRJNA615351 | 149114 | 191 | 1.865385 | 3.56288535 | Thermoplasmatales archaeon | 2268204 | Archaea | Archaea | 43.1 | 0.0126 | NR | HEC76766.1 | 2268204 | g135014 | i0 | 48.1 | 0.848167539267016 | 27 | 14 | 42.4 | 0 | 48 | 128 | 35 | 61 | HEC76766.1 alanyl-tRNA editing protein [Thermoplasmatales archaeon] | diamond | 162 | 43.1 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmata | Thermoplasmatales | Thermoplasmatales archaeon | ||||
| 31293966 | 31293966 | PRJNA615351_P_NODE_12055_length_1878_cov_66.186110_g8478_i1 | PRJNA615351 | 12055 | 1878 | 66.18611 | 1242.9751458 | root | 1 | Root_unresolved | Root_unresolved | 402 | 6.769999999999998e-131 | NR | MDA7464093.1 | 1915863 | g8478 | i1 | 43.9 | 6.6741214057508 | 462 | 251 | 73.8 | 4 | 1791 | 406 | 2 | 455 | MDA7464093.1 DNA photolyase family protein [Candidatus Poseidonia alphae] | diamond | 12534 | 405 | 0.992592592592593 | Archaea | Methanobacteriati | Thermoplasmatota | Candidatus Poseidoniia | Candidatus Poseidoniales | Candidatus Poseidoniaceae | Candidatus Poseidonia | Candidatus Poseidonia alphae | ||
| 31818869 | 31818869 | PRJNA615351_P_NODE_94377_length_343_cov_2.876623_g80288_i0 | PRJNA615351 | 94377 | 343 | 2.876623 | 9.86681689 | Thermoplasmatota archaeon | 2806419 | Archaea | Archaea | 44.7 | 0.0194 | NR | MCL4447742.1 | 2806419 | g80288 | i0 | 38.5 | 0.454810495626822 | 52 | 32 | 45.5 | 0 | 334 | 179 | 173 | 224 | MCL4447742.1 hypothetical protein [Thermoplasmatota archaeon] | diamond | 156 | 44.7 | 1 | Archaea | Methanobacteriati | Thermoplasmatota | Thermoplasmatota archaeon | ||||||
| 32293883 | 32293883 | PRJNA615351_P_NODE_69279_length_507_cov_2.330508_g55424_i0 | PRJNA615351 | 69279 | 507 | 2.330508 | 11.81567556 | Aciduliprofundum sp. MAR | 2060325 | Archaea | Archaea | 63.5 | 2.9e-8 | NR | WP_015282595.1 | 673860 | g55424 | i0 | 42.2 | 0.49112426035503 | 83 | 47 | 48.5 | 1 | 278 | 33 | 13 | 95 | WP_015282595.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Aciduliprofundum sp. MAR08-339] | diamond | 249 | 63.5 | 1 | Archaea | DHVE2 group | Methanobacteriati | Thermoplasmatota | Candidatus Aciduliprofundum | Aciduliprofundum sp. MAR08-339 | ||||
| 32703937 | 32703937 | PRJNA615351_P_NODE_19060_length_1503_cov_19.124659_g13794_i0 | PRJNA615351 | 19060 | 1503 | 19.124659 | 287.44362477 | Thermoplasmata archaeon | 1906666 | Archaea | Archaea | 53.5 | 0.00125 | NR | MFQ5909371.1 | 1906666 | g13794 | i0 | 32.3 | 0.191616766467066 | 96 | 65 | 19.2 | 0 | 305 | 592 | 56 | 151 | MFQ5909371.1 GNAT family N-acetyltransferase [Thermoplasmata archaeon] | diamond | 288 | 53.5 | 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);;