contig_metadata
15 rows where bioproject = "PRJNA615351" and tax_phylum = "Candidatus Micrarchaeota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9524166 | 9524166 | PRJNA615351_P_NODE_3408_length_3045_cov_5.317276_g2376_i1 | PRJNA615351 | 3408 | 3045 | 5.317276 | 161.9110542 | Candidatus Micrarchaeaceae archaeon | 2953041 | Archaea | Archaea | 585 | 2.0399999999999993e-194 | NR | MEM0150161.1 | 2953041 | g2376 | i1 | 58.9 | 1.14778325123153 | 587 | 176 | 54.3 | 11 | 2875 | 1223 | 24 | 581 | MEM0150161.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon] | diamond | 3495 | 585 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeales | Candidatus Micrarchaeaceae | Candidatus Micrarchaeaceae archaeon | |||
| 12075069 | 12075069 | PRJNA615351_P_NODE_3390_length_3051_cov_5.206233_g2376_i0 | PRJNA615351 | 3390 | 3051 | 5.206233 | 158.84216883 | Candidatus Micrarchaeaceae archaeon | 2953041 | Archaea | Archaea | 585 | 2.1599999999999993e-194 | NR | MEM0150161.1 | 2953041 | g2376 | i0 | 58.9 | 1.24483775811209 | 587 | 176 | 54.2 | 11 | 171 | 1823 | 24 | 581 | MEM0150161.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon] | diamond | 3798 | 585 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeales | Candidatus Micrarchaeaceae | Candidatus Micrarchaeaceae archaeon | |||
| 21551853 | 21551853 | PRJNA615351_P_NODE_143937_length_199_cov_2.463415_g129837_i0 | PRJNA615351 | 143937 | 199 | 2.463415 | 4.90219585 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 105 | 1.68e-24 | NR | MBU1681720.1 | 2250274 | g129837 | i0 | 82.8 | 0.874371859296482 | 58 | 8 | 85.9 | 2 | 28 | 198 | 247 | 303 | MBU1681720.1 methionine--tRNA ligase [Candidatus Micrarchaeota archaeon] | diamond | 174 | 105 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 27491407 | 27491407 | PRJNA615351_P_NODE_89223_length_369_cov_19.065868_g75145_i0 | PRJNA615351 | 89223 | 369 | 19.065868 | 70.35305292 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 54.3 | 2.73e-6 | NR | MCX8205853.1 | 2250274 | g75145 | i0 | 38.1 | 3.98373983739837 | 84 | 49 | 68.3 | 1 | 77 | 328 | 65 | 145 | MCX8205853.1 elongation factor 1-alpha [Candidatus Micrarchaeota archaeon] | diamond | 1470 | 54.3 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 28691330 | 28691330 | PRJNA615351_P_NODE_70407_length_497_cov_7.177489_g27357_i1 | PRJNA615351 | 70407 | 497 | 7.177489 | 35.67212033 | Candidatus Bilamarchaeaceae archaeon | 2886391 | Archaea | Archaea | 62.8 | 1.64e-8 | NR | MEM4272234.1 | 2886391 | g27357 | i1 | 29.3 | 1.841046277666 | 147 | 78 | 86.3 | 5 | 53 | 481 | 9 | 133 | MEM4272234.1 hypothetical protein [Candidatus Bilamarchaeaceae archaeon] | diamond | 915 | 62.8 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Bilamarchaeaceae | Candidatus Bilamarchaeaceae archaeon | |||
| 28944061 | 28944061 | PRJNA615351_P_NODE_93288_length_348_cov_21.028754_g79202_i0 | PRJNA615351 | 93288 | 348 | 21.028754 | 73.18006392 | Candidatus Anstonellales archaeon | 3058027 | Archaea | Archaea | 48.1 | 0.0015 | NR | MEM2948061.1 | 3058027 | g79202 | i0 | 30 | 1.91379310344828 | 110 | 74 | 94.8 | 1 | 1 | 330 | 275 | 381 | MEM2948061.1 translation elongation factor EF-1 subunit alpha [Candidatus Anstonellales archaeon] | diamond | 666 | 48.1 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Anstonellales | Candidatus Anstonellales archaeon | ||||
| 29398533 | 29398533 | PRJNA615351_P_NODE_33609_length_1040_cov_3.724378_g4488_i3 | PRJNA615351 | 33609 | 1040 | 3.724378 | 38.7335312 | root | 1 | Root_unresolved | Root_unresolved | 50.1 | 0.0151 | NR | MCX8200393.1 | 2250274 | g4488 | i3 | 29.6 | 0.822115384615385 | 162 | 89 | 46.4 | 10 | 256 | 738 | 203 | 340 | MCX8200393.1 dockerin type I domain-containing protein [Candidatus Micrarchaeota archaeon] | diamond | 855 | 50.1 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 29701123 | 29701123 | PRJNA615351_P_NODE_75690_length_456_cov_1.686461_g61688_i0 | PRJNA615351 | 75690 | 456 | 1.686461 | 7.69026216 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 95.5 | 1.41e-19 | NR | MBI5225085.1 | 2250274 | g61688 | i0 | 41.5 | 3.85526315789474 | 147 | 83 | 95.4 | 3 | 445 | 11 | 14 | 159 | MBI5225085.1 elongation factor EF-2 [Candidatus Micrarchaeota archaeon] | diamond | 1758 | 95.5 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 30902091 | 30902091 | PRJNA615351_P_NODE_88414_length_374_cov_1.716814_g74337_i0 | PRJNA615351 | 88414 | 374 | 1.716814 | 6.42088436 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 47.4 | 0.00385 | NR | MCX8175023.1 | 2250274 | g74337 | i0 | 43.5 | 0.497326203208556 | 62 | 28 | 49.7 | 2 | 9 | 194 | 790 | 844 | MCX8175023.1 AAA family ATPase [Candidatus Micrarchaeota archaeon] | diamond | 186 | 47.4 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 31344510 | 31344510 | PRJNA615351_P_NODE_46116_length_788_cov_3.409031_g4488_i5 | PRJNA615351 | 46116 | 788 | 3.409031 | 26.86316428 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 48.9 | 0.0173 | NR | MCX8200393.1 | 2250274 | g4488 | i5 | 29.6 | 0.616751269035533 | 162 | 89 | 61.3 | 10 | 4 | 486 | 203 | 340 | MCX8200393.1 dockerin type I domain-containing protein [Candidatus Micrarchaeota archaeon] | diamond | 486 | 48.9 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 31597775 | 31597775 | PRJNA615351_P_NODE_88516_length_373_cov_3.431953_g74439_i0 | PRJNA615351 | 88516 | 373 | 3.431953 | 12.80118469 | Candidatus Micrarchaeaceae archaeon | 2953041 | Archaea | Archaea | 142 | 1.0400000000000001e-36 | NR | MEM0150161.1 | 2953041 | g74439 | i0 | 62.8 | 1.03753351206434 | 129 | 24 | 99.7 | 4 | 373 | 2 | 203 | 312 | MEM0150161.1 hypothetical protein [Candidatus Micrarchaeaceae archaeon] | diamond | 387 | 142 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeales | Candidatus Micrarchaeaceae | Candidatus Micrarchaeaceae archaeon | |||
| 31597777 | 31597777 | PRJNA615351_P_NODE_90316_length_364_cov_1.978723_g76237_i0 | PRJNA615351 | 90316 | 364 | 1.978723 | 7.20255172 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 50.4 | 2.58e-4 | NR | MEW6722035.1 | 2250274 | g76237 | i0 | 39.1 | 0.815934065934066 | 64 | 39 | 52.7 | 0 | 364 | 173 | 38 | 101 | MEW6722035.1 Kazal-type serine protease inhibitor family protein [Candidatus Micrarchaeota archaeon] | diamond | 297 | 50.4 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 31660481 | 31660481 | PRJNA615351_P_NODE_181217_length_155_cov_1.325000_g167117_i0 | PRJNA615351 | 181217 | 155 | 1.325 | 2.05375 | Candidatus Micrarchaeota archaeon | 2250274 | Archaea | Archaea | 41.2 | 0.0396 | NR | NUN11753.1 | 2250274 | g167117 | i0 | 61.9 | 0.812903225806452 | 42 | 16 | 81.3 | 0 | 128 | 3 | 51 | 92 | NUN11753.1 serine--tRNA ligase [Candidatus Micrarchaeota archaeon] | diamond | 126 | 41.2 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 31705242 | 31705242 | PRJNA615351_P_NODE_70037_length_500_cov_15.494624_g56157_i0 | PRJNA615351 | 70037 | 500 | 15.494624 | 77.47312 | Nanobdellati | 1783276 | Archaea | Archaea | 61.2 | 1.66e-7 | NR | MBI5223728.1 | 2250274 | g56157 | i0 | 35.6 | 3.504 | 104 | 64 | 62.4 | 1 | 2 | 313 | 319 | 419 | MBI5223728.1 translation elongation factor EF-1 subunit alpha [Candidatus Micrarchaeota archaeon] | diamond | 1752 | 61.2 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeota archaeon | ||||||
| 32704031 | 32704031 | PRJNA615351_P_NODE_70920_length_493_cov_6.089520_g57010_i0 | PRJNA615351 | 70920 | 493 | 6.08952 | 30.0213336 | Candidatus Micrarchaeaceae archaeon | 2953041 | Archaea | Archaea | 198 | 1.17e-61 | NR | MEM0150155.1 | 2953041 | g57010 | i0 | 69.1 | 0.906693711967546 | 149 | 46 | 90.7 | 0 | 456 | 10 | 13 | 161 | MEM0150155.1 EF-hand domain-containing protein [Candidatus Micrarchaeaceae archaeon] | diamond | 447 | 198 | 1 | Archaea | Nanobdellati | Candidatus Micrarchaeota | Candidatus Micrarchaeia | Candidatus Micrarchaeales | Candidatus Micrarchaeaceae | Candidatus Micrarchaeaceae 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);;