contig_metadata
22 rows where bioproject = "PRJNA870096" and tax_superkingdom = "Archaea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3789217 | 3789217 | PRJNA870096_S_NODE_50543_length_248_cov_1.170732_g48879_i0 | PRJNA870096 | 50543 | 248 | 1.170732 | 2.90341536 | archaeon | 1906665 | Archaea | Archaea | 74.3 | 2.86e-13 | NR | MDP2436795.1 | 1906665 | g48879 | i0 | 65.4 | 0.629032258064516 | 52 | 18 | 62.9 | 0 | 92 | 247 | 5 | 56 | MDP2436795.1 isocitrate/isopropylmalate family dehydrogenase [archaeon] | diamond | 156 | 74.3 | 1 | Archaea | archaeon | ||||||||
| 4678820 | 4678820 | PRJNA870096_S_NODE_70084_length_209_cov_1.734940_g68420_i0 | PRJNA870096 | 70084 | 209 | 1.73494 | 3.6260246 | archaeon | 1906665 | Archaea | Archaea | 101 | 1.95e-25 | NR | MDP2437401.1 | 1906665 | g68420 | i0 | 76.5 | 1.96650717703349 | 68 | 16 | 97.6 | 0 | 5 | 208 | 50 | 117 | MDP2437401.1 NFYB/HAP3 family transcription factor subunit [archaeon] | diamond | 411 | 101 | 1 | Archaea | archaeon | ||||||||
| 6341252 | 6341252 | PRJNA870096_S_NODE_46785_length_258_cov_1.967442_g45121_i0 | PRJNA870096 | 46785 | 258 | 1.967442 | 5.07600036 | archaeon | 1906665 | Archaea | Archaea | 105 | 1.72e-24 | NR | NCQ52386.1 | 1906665 | g45121 | i0 | 58.1 | 3.65116279069767 | 86 | 36 | 100 | 0 | 258 | 1 | 199 | 284 | NCQ52386.1 elongation factor Tu [archaeon] | diamond | 942 | 105 | 1 | Archaea | archaeon | ||||||||
| 7228376 | 7228376 | PRJNA870096_S_NODE_49986_length_249_cov_1.742718_g48322_i0 | PRJNA870096 | 49986 | 249 | 1.742718 | 4.33936782 | archaeon | 1906665 | Archaea | Archaea | 129 | 8.05e-34 | NR | MDP2436427.1 | 1906665 | g48322 | i0 | 75.9 | 2 | 83 | 20 | 100 | 0 | 249 | 1 | 301 | 383 | MDP2436427.1 DEAD/DEAH box helicase [archaeon] | diamond | 498 | 129 | 1 | Archaea | archaeon | ||||||||
| 9777802 | 9777802 | PRJNA870096_S_NODE_19448_length_411_cov_3.551630_g17792_i0 | PRJNA870096 | 19448 | 411 | 3.55163 | 14.5971993 | archaeon | 1906665 | Archaea | Archaea | 91.3 | 1.3e-20 | NR | NCQ52385.1 | 1906665 | g17792 | i0 | 58.9 | 0.532846715328467 | 73 | 30 | 53.3 | 0 | 219 | 1 | 18 | 90 | NCQ52385.1 hypothetical protein [archaeon] | diamond | 219 | 91.3 | 1 | Archaea | archaeon | ||||||||
| 26865622 | 26865622 | PRJNA870096_S_NODE_40981_length_277_cov_2.256410_g39317_i0 | PRJNA870096 | 40981 | 277 | 2.25641 | 6.2502557 | archaeon | 1906665 | Archaea | Archaea | 83.6 | 7.32e-17 | NR | MDP2439181.1 | 1906665 | g39317 | i0 | 50.5 | 1.0072202166065 | 93 | 42 | 97.5 | 2 | 3 | 272 | 190 | 281 | MDP2439181.1 hypothetical protein [archaeon] | diamond | 279 | 83.6 | 1 | Archaea | archaeon | ||||||||
| 27750407 | 27750407 | PRJNA870096_S_NODE_81424_length_194_cov_3.139073_g79760_i0 | PRJNA870096 | 81424 | 194 | 3.139073 | 6.08980162 | archaeon | 1906665 | Archaea | Archaea | 73.6 | 6.47e-14 | NR | RYH27822.1 | 1906665 | g79760 | i0 | 53.1 | 0.989690721649485 | 64 | 28 | 97.4 | 2 | 1 | 189 | 126 | 188 | RYH27822.1 MAG: type 1 glutamine amidotransferase domain-containing protein [archaeon] | diamond | 192 | 73.6 | 1 | Archaea | archaeon | ||||||||
| 28350045 | 28350045 | PRJNA870096_S_NODE_42686_length_271_cov_1.842105_g41022_i0 | PRJNA870096 | 42686 | 271 | 1.842105 | 4.99210455 | Methanotrichaceae archaeon | 2595067 | Archaea | Archaea | 51.2 | 4.71e-5 | NR | MDD1757580.1 | 2595067 | g41022 | i0 | 38.9 | 0.797047970479705 | 72 | 42 | 79.7 | 2 | 249 | 34 | 61 | 130 | MDD1757580.1 CBS domain-containing protein [Methanotrichaceae archaeon] | diamond | 216 | 51.2 | 1 | Archaea | Stenosarchaea group | Methanobacteriati | Methanobacteriota | Methanomicrobia | Methanotrichales | Methanotrichaceae | Methanotrichaceae archaeon | ||
| 28697553 | 28697553 | PRJNA870096_S_NODE_24367_length_365_cov_3.298137_g22703_i0 | PRJNA870096 | 24367 | 365 | 3.298137 | 12.03820005 | archaeon | 1906665 | Archaea | Archaea | 120 | 3.89e-30 | NR | MDP2434421.1 | 1906665 | g22703 | i0 | 62.6 | 0.747945205479452 | 91 | 34 | 74.8 | 0 | 5 | 277 | 262 | 352 | MDP2434421.1 class I SAM-dependent methyltransferase [archaeon] | diamond | 273 | 120 | 1 | Archaea | archaeon | ||||||||
| 29139681 | 29139681 | PRJNA870096_S_NODE_126709_length_158_cov_1.669565_g125045_i0 | PRJNA870096 | 126709 | 158 | 1.669565 | 2.6379127000000002 | archaeon | 1906665 | Archaea | Archaea | 96.7 | 5.76e-22 | NR | NCQ52386.1 | 1906665 | g125045 | i0 | 84.6 | 0.987341772151899 | 52 | 8 | 98.7 | 0 | 157 | 2 | 69 | 120 | NCQ52386.1 elongation factor Tu [archaeon] | diamond | 156 | 96.7 | 1 | Archaea | archaeon | ||||||||
| 29305285 | 29305285 | PRJNA870096_S_NODE_115629_length_165_cov_1.729508_g113965_i0 | PRJNA870096 | 115629 | 165 | 1.729508 | 2.8536882 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 8.62e-6 | NR | MDP2439874.1 | 1906665 | g113965 | i0 | 43.5 | 2.54545454545455 | 46 | 26 | 83.6 | 0 | 2 | 139 | 91 | 136 | MDP2439874.1 hypothetical protein [archaeon] | diamond | 420 | 51.6 | 0.992248062015504 | Archaea | archaeon | ||||||||
| 29423368 | 29423368 | PRJNA870096_S_NODE_35249_length_300_cov_3.330739_g33585_i0 | PRJNA870096 | 35249 | 300 | 3.330739 | 9.992217 | archaeon | 1906665 | Archaea | Archaea | 98.2 | 3.8e-22 | NR | MDP2434961.1 | 1906665 | g33585 | i0 | 48.4 | 3.9 | 93 | 48 | 93 | 0 | 3 | 281 | 215 | 307 | MDP2434961.1 pirin family protein [archaeon] | diamond | 1170 | 98.2 | 1 | Archaea | archaeon | ||||||||
| 29486492 | 29486492 | PRJNA870096_S_NODE_94530_length_181_cov_1.753623_g92866_i0 | PRJNA870096 | 94530 | 181 | 1.753623 | 3.17405763 | archaeon | 1906665 | Archaea | Archaea | 74.3 | 1.47e-14 | NR | MDP2434407.1 | 1906665 | g92866 | i0 | 62.1 | 0.961325966850829 | 58 | 21 | 96.1 | 1 | 3 | 176 | 118 | 174 | MDP2434407.1 DnaJ C-terminal domain-containing protein [archaeon] | diamond | 174 | 74.3 | 1 | Archaea | archaeon | ||||||||
| 29707312 | 29707312 | PRJNA870096_S_NODE_50070_length_249_cov_1.398058_g48406_i0 | PRJNA870096 | 50070 | 249 | 1.398058 | 3.48116442 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 140 | 2.84e-39 | NR | MFH1447465.1 | 2250274 | g48406 | i0 | 79.7 | 15.433734939759 | 79 | 16 | 95.2 | 0 | 9 | 245 | 150 | 228 | MFH1447465.1 2,3-diphosphoglycerate-dependent phosphoglycerate mutase [Candidatus Micrarchaeota archaeon] | diamond | 3843 | 140 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 30340096 | 30340096 | PRJNA870096_S_NODE_79732_length_196_cov_2.313725_g78068_i0 | PRJNA870096 | 79732 | 196 | 2.313725 | 4.534901 | archaeon | 1906665 | Archaea | Archaea | 43.1 | 0.0151 | NR | MDP2435572.1 | 1906665 | g78068 | i0 | 52.8 | 0.979591836734694 | 36 | 17 | 55.1 | 0 | 29 | 136 | 209 | 244 | MDP2435572.1 filamin/ABP280 repeat domain-containing protein [archaeon] | diamond | 192 | 43.1 | 1 | Archaea | archaeon | ||||||||
| 31160677 | 31160677 | PRJNA870096_S_NODE_82315_length_193_cov_4.966667_g80651_i0 | PRJNA870096 | 82315 | 193 | 4.966667 | 9.58566731 | archaeon | 1906665 | Archaea | Archaea | 106 | 4.92e-27 | NR | MDP2435966.1 | 1906665 | g80651 | i0 | 73.4 | 2.95336787564767 | 64 | 17 | 99.5 | 0 | 193 | 2 | 97 | 160 | MDP2435966.1 nucleoside-diphosphate kinase [archaeon] | diamond | 570 | 106 | 1 | Archaea | archaeon | ||||||||
| 31192249 | 31192249 | PRJNA870096_S_NODE_17435_length_436_cov_3.173028_g15787_i0 | PRJNA870096 | 17435 | 436 | 3.173028 | 13.83440208 | archaeon | 1906665 | Archaea | Archaea | 86.3 | 1.1e-17 | NR | MDP2436265.1 | 1906665 | g15787 | i0 | 48.2 | 0.571100917431193 | 83 | 43 | 57.1 | 0 | 32 | 280 | 100 | 182 | MDP2436265.1 universal stress protein [archaeon] | diamond | 249 | 86.3 | 1 | Archaea | archaeon | ||||||||
| 31509074 | 31509074 | PRJNA870096_S_NODE_80196_length_196_cov_1.254902_g78532_i0 | PRJNA870096 | 80196 | 196 | 1.254902 | 2.45960792 | archaeon | 1906665 | Archaea | Archaea | 97.4 | 7.249999999999999e-24 | NR | MDP2435772.1 | 1906665 | g78532 | i0 | 69.2 | 0.994897959183674 | 65 | 20 | 99.5 | 0 | 2 | 196 | 38 | 102 | MDP2435772.1 hypothetical protein [archaeon] | diamond | 195 | 97.4 | 1 | Archaea | archaeon | ||||||||
| 31572337 | 31572337 | PRJNA870096_S_NODE_25476_length_357_cov_2.175159_g23812_i0 | PRJNA870096 | 25476 | 357 | 2.175159 | 7.76531763 | Nitrososphaerales archaeon | 2268197 | Archaea | Archaea | 104 | 3.259999999999999e-23 | NR | MEE9586260.1 | 2268197 | g23812 | i0 | 46.2 | 0.873949579831933 | 104 | 55 | 87.4 | 1 | 348 | 37 | 488 | 590 | MEE9586260.1 phosphoenolpyruvate carboxykinase (GTP) [Nitrososphaerales archaeon] | diamond | 312 | 104 | 1 | Archaea | Thermoproteati | Nitrososphaerota | Nitrososphaeria | Nitrososphaerales | Nitrososphaerales archaeon | ||||
| 31928166 | 31928166 | PRJNA870096_S_NODE_69457_length_210_cov_1.622754_g67793_i0 | PRJNA870096 | 69457 | 210 | 1.622754 | 3.4077834 | root | 1 | Root_unresolved | Root_unresolved | 99.4 | 2.5699999999999998e-23 | NR | MDP2435588.1 | 1906665 | g67793 | i0 | 70.6 | 8.88571428571429 | 68 | 20 | 97.1 | 0 | 204 | 1 | 23 | 90 | MDP2435588.1 glutathione binding-like protein [archaeon] | diamond | 1866 | 99.4 | 1 | Archaea | archaeon | ||||||||
| 32015049 | 32015049 | PRJNA870096_S_NODE_68898_length_211_cov_1.428571_g67234_i0 | PRJNA870096 | 68898 | 211 | 1.428571 | 3.01428481 | archaeon | 1906665 | Archaea | Archaea | 47.4 | 5.66e-4 | NR | MDP2439412.1 | 1906665 | g67234 | i0 | 35.5 | 2.34597156398104 | 62 | 40 | 88.2 | 0 | 192 | 7 | 195 | 256 | MDP2439412.1 hypothetical protein [archaeon] | diamond | 495 | 47.4 | 1 | Archaea | archaeon | ||||||||
| 32553240 | 32553240 | PRJNA870096_S_NODE_53419_length_240_cov_3.502538_g51755_i0 | PRJNA870096 | 53419 | 240 | 3.502538 | 8.4060912 | Candidatus Aenigmatarchaeota archaeon | 3121606 | Archaea | Archaea | 79 | 4.16e-15 | NR | UCD07325.1 | 3121606 | g51755 | i0 | 52.9 | 1.7 | 68 | 32 | 85 | 0 | 240 | 37 | 287 | 354 | UCD07325.1 MAG: polyprenyl synthetase family protein [Candidatus Aenigmatarchaeota archaeon] | diamond | 408 | 79 | 1 | Archaea | Nanobdellati | Candidatus Aenigmatarchaeota | Candidatus Aenigmatarchaeota 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);;