contig_metadata
19 rows where analysis = "diamond", bioproject = "PRJNA556992" and tax_phylum = "Thermoproteota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27363106 | 27363106 | PRJNA556992_P_NODE_1170043_length_197_cov_4.935484_g1167852_i0 | PRJNA556992 | 1170043 | 197 | 4.935484 | 9.72290348 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 127 | 1.6399999999999999e-34 | NR | MDP9016182.1 | 2056631 | g1167852 | i0 | 95.4 | 2.96954314720812 | 65 | 3 | 99 | 0 | 195 | 1 | 105 | 169 | MDP9016182.1 alpha/beta hydrolase [Thermoproteota archaeon] | diamond | 585 | 127 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27742385 | 27742385 | PRJNA556992_P_NODE_741544_length_249_cov_1.312500_g739355_i0 | PRJNA556992 | 741544 | 249 | 1.3125 | 3.268125 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 140 | 2.5099999999999993e-40 | NR | MDP8906734.1 | 2056631 | g739355 | i0 | 84.1 | 0.987951807228916 | 82 | 13 | 98.8 | 0 | 2 | 247 | 26 | 107 | MDP8906734.1 hypothetical protein [Thermoproteota archaeon] | diamond | 246 | 140 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 27836788 | 27836788 | PRJNA556992_P_NODE_979664_length_232_cov_5.742138_g977474_i0 | PRJNA556992 | 979664 | 232 | 5.742138 | 13.32176016 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 149 | 2.2199999999999998e-42 | NR | MDP9305990.1 | 2056631 | g977474 | i0 | 96.1 | 0.995689655172414 | 77 | 3 | 99.6 | 0 | 2 | 232 | 70 | 146 | MDP9305990.1 PfkB family carbohydrate kinase [Thermoproteota archaeon] | diamond | 231 | 149 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28215281 | 28215281 | PRJNA556992_P_NODE_487866_length_268_cov_2.353846_g485677_i0 | PRJNA556992 | 487866 | 268 | 2.353846 | 6.30830728 | Thermoprotei archaeon | 2250277 | Archaea | Archaea | 97.1 | 2.01e-21 | NR | RLG76926.1 | 2250277 | g485677 | i0 | 53.4 | 0.985074626865672 | 88 | 41 | 98.5 | 0 | 268 | 5 | 55 | 142 | RLG76926.1 MAG: hypothetical protein DRO14_03075, partial [Thermoprotei archaeon] | diamond | 264 | 97.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoprotei archaeon | |||||
| 28499625 | 28499625 | PRJNA556992_P_NODE_1111287_length_210_cov_4.919708_g1109096_i0 | PRJNA556992 | 1111287 | 210 | 4.919708 | 10.3313868 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 144 | 1.13e-42 | NR | MDI9578610.1 | 2056631 | g1109096 | i0 | 100 | 0.985714285714286 | 69 | 0 | 98.6 | 0 | 209 | 3 | 49 | 117 | MDI9578610.1 hypothetical protein [Thermoproteota archaeon] | diamond | 207 | 144 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 28531239 | 28531239 | PRJNA556992_P_NODE_1133867_length_205_cov_4.840909_g1131676_i0 | PRJNA556992 | 1133867 | 205 | 4.840909 | 9.92386345 | Crenarchaeota archaeon 13_1_4 | 2056631 | Archaea | Archaea | 42 | 0.0405 | NR | OLD05705.1 | 1805098 | g1131676 | i0 | 51.3 | 0.570731707317073 | 39 | 18 | 55.6 | 1 | 119 | 6 | 37 | 75 | OLD05705.1 MAG: hypothetical protein AUJ07_00945 [Crenarchaeota archaeon 13_1_40CM_3_53_5] | diamond | 117 | 42 | 1 | Archaea | Thermoproteati | Thermoproteota | Crenarchaeota archaeon 13_1_40CM_3_53_5 | ||||||
| 28577214 | 28577214 | PRJNA556992_P_NODE_99667_length_405_cov_6.620482_g97483_i0 | PRJNA556992 | 99667 | 405 | 6.620482 | 26.8129521 | root | 1 | Root_unresolved | Root_unresolved | 267 | 1.26e-89 | NR | MCY0882245.1 | 12915 | g97483 | i0 | 98.5 | 1.98518518518519 | 134 | 2 | 99.3 | 0 | 404 | 3 | 27 | 160 | MCY0882245.1 topoisomerase C-terminal repeat-containing protein [Acidianus infernus] | diamond | 804 | 267 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Sulfolobales | Sulfolobaceae | Acidianus | Acidianus infernus | ||
| 29478019 | 29478019 | PRJNA556992_P_NODE_136570_length_368_cov_4.149153_g134383_i0 | PRJNA556992 | 136570 | 368 | 4.149153 | 15.26888304 | Desulfurococcales archaeon | 2480821 | Archaea | Archaea | 57 | 1.63e-6 | NR | MCE4609558.1 | 2480821 | g134383 | i0 | 46.9 | 0.521739130434783 | 64 | 31 | 52.2 | 2 | 204 | 13 | 572 | 632 | MCE4609558.1 carboxypeptidase regulatory-like domain-containing protein [Desulfurococcales archaeon] | diamond | 192 | 57 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcales archaeon | ||||
| 30363457 | 30363457 | PRJNA556992_P_NODE_743092_length_249_cov_0.875000_g740903_i0 | PRJNA556992 | 743092 | 249 | 0.875 | 2.17875 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 121 | 5.919999999999999e-32 | NR | MDP8887454.1 | 2056631 | g740903 | i0 | 100 | 0.746987951807229 | 62 | 0 | 74.7 | 0 | 188 | 3 | 1 | 62 | MDP8887454.1 CbtA family protein [Thermoproteota archaeon] | diamond | 186 | 121 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 30787988 | 30787988 | PRJNA556992_P_NODE_313454_length_287_cov_1.313084_g311265_i0 | PRJNA556992 | 313454 | 287 | 1.313084 | 3.76855108 | Thermoproteati | 1783275 | Archaea | Archaea | 81.3 | 1.58e-15 | NR | WP_081246112.1 | 1650659 | g311265 | i0 | 46 | 6.39721254355401 | 87 | 47 | 90.9 | 0 | 26 | 286 | 15 | 101 | WP_081246112.1 translation elongation factor EF-1 subunit alpha [Thermoproteus sp. CP80] | diamond | 1836 | 81.3 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Thermoproteales | Thermoproteaceae | Thermoproteus | Thermoproteus sp. CP80 | ||
| 31405679 | 31405679 | PRJNA556992_P_NODE_1123516_length_207_cov_6.037313_g1121325_i0 | PRJNA556992 | 1123516 | 207 | 6.037313 | 12.49723791 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 128 | 2.45e-33 | NR | MDQ3947548.1 | 2056631 | g1121325 | i0 | 91.2 | 0.985507246376812 | 68 | 6 | 98.6 | 0 | 206 | 3 | 49 | 116 | MDQ3947548.1 arginine--tRNA ligase [Thermoproteota archaeon] | diamond | 204 | 128 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31595950 | 31595950 | PRJNA556992_P_NODE_795076_length_246_cov_1.976879_g792886_i0 | PRJNA556992 | 795076 | 246 | 1.976879 | 4.86312234 | Candidatus Methanomethylicus sp. | 2282147 | Archaea | Archaea | 43.1 | 0.0277 | NR | HPC28503.1 | 2282147 | g792886 | i0 | 63 | 0.329268292682927 | 27 | 10 | 32.9 | 0 | 4 | 84 | 232 | 258 | HPC28503.1 LMBR1 domain-containing protein [Candidatus Methanomethylicus sp.] | diamond | 81 | 43.1 | 1 | Archaea | Thermoproteati | Thermoproteota | Methanosuratincolia | Candidatus Methanomethylicales | Candidatus Methanomethylicaceae | Candidatus Methanomethylicus | Candidatus Methanomethylicus sp. | ||
| 31627345 | 31627345 | PRJNA556992_P_NODE_931736_length_237_cov_5.073171_g929546_i0 | PRJNA556992 | 931736 | 237 | 5.073171 | 12.02341527 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 137 | 2.06e-39 | NR | MDQ3852155.1 | 2056631 | g929546 | i0 | 97.1 | 0.873417721518987 | 69 | 2 | 87.3 | 0 | 207 | 1 | 1 | 69 | MDQ3852155.1 nuclear transport factor 2 family protein [Thermoproteota archaeon] | diamond | 207 | 137 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 31957711 | 31957711 | PRJNA556992_P_NODE_1006117_length_230_cov_2.388535_g1003927_i0 | PRJNA556992 | 1006117 | 230 | 2.388535 | 5.4936305 | Thermoproteati | 1783275 | Archaea | Archaea | 158 | 1.76e-44 | NR | MDQ4012850.1 | 2056631 | g1003927 | i0 | 98.7 | 2.97391304347826 | 76 | 1 | 99.1 | 0 | 230 | 3 | 277 | 352 | MDQ4012850.1 PQQ-dependent sugar dehydrogenase [Thermoproteota archaeon] | diamond | 684 | 158 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32070178 | 32070178 | PRJNA556992_P_NODE_71258_length_451_cov_2.997354_g69083_i0 | PRJNA556992 | 71258 | 451 | 2.997354 | 13.51806654 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 89.4 | 2.05e-18 | NR | HDI86197.1 | 2056631 | g69083 | i0 | 31.4 | 0.931263858093126 | 140 | 95 | 92.5 | 1 | 1 | 417 | 110 | 249 | HDI86197.1 hypothetical protein [Thermoproteota archaeon] | diamond | 420 | 89.4 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32133235 | 32133235 | PRJNA556992_P_NODE_1083698_length_216_cov_7.818182_g1081507_i0 | PRJNA556992 | 1083698 | 216 | 7.818182 | 16.88727312 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 127 | 4.29e-36 | NR | MDQ5863538.1 | 2056631 | g1081507 | i0 | 87.3 | 0.986111111111111 | 71 | 9 | 98.6 | 0 | 2 | 214 | 23 | 93 | MDQ5863538.1 hypothetical protein [Thermoproteota archaeon] | diamond | 213 | 127 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32147758 | 32147758 | PRJNA556992_P_NODE_674418_length_253_cov_1.655556_g672229_i0 | PRJNA556992 | 674418 | 253 | 1.655556 | 4.18855668 | Thermoproteati | 1783275 | Archaea | Archaea | 50.1 | 1.03e-4 | NR | MDQ3903596.1 | 2056631 | g672229 | i0 | 53.7 | 2.4901185770751 | 41 | 18 | 47.4 | 1 | 2 | 121 | 264 | 304 | MDQ3903596.1 PQQ-dependent sugar dehydrogenase [Thermoproteota archaeon] | diamond | 630 | 50.4 | 0.994047619047619 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota archaeon | ||||||
| 32386684 | 32386684 | PRJNA556992_P_NODE_876799_length_242_cov_0.911243_g874609_i0 | PRJNA556992 | 876799 | 242 | 0.911243 | 2.20520806 | Desulfurococcales archaeon | 2480821 | Archaea | Archaea | 43.9 | 0.014 | NR | MDT7895234.1 | 2480821 | g874609 | i0 | 38.9 | 0.892561983471074 | 72 | 38 | 88 | 3 | 17 | 229 | 304 | 370 | MDT7895234.1 N-6 DNA methylase [Desulfurococcales archaeon] | diamond | 216 | 43.9 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoprotei | Desulfurococcales | Desulfurococcales archaeon | ||||
| 32670400 | 32670400 | PRJNA556992_P_NODE_1131220_length_205_cov_9.545455_g1129029_i0 | PRJNA556992 | 1131220 | 205 | 9.545455 | 19.56818275 | Thermoproteota archaeon | 2056631 | Archaea | Archaea | 53.5 | 1.06e-6 | NR | RLG44328.1 | 2056631 | g1129029 | i0 | 43.3 | 0.980487804878049 | 67 | 38 | 98 | 0 | 202 | 2 | 18 | 84 | RLG44328.1 MAG: hypothetical protein DRN81_04790 [Thermoproteota archaeon] | diamond | 201 | 53.5 | 1 | Archaea | Thermoproteati | Thermoproteota | Thermoproteota 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);;