contig_metadata
16 rows where tax_phylum = "Candidatus Undinarchaeota" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3095871 | 3095871 | PRJNA560932_P_NODE_9143_length_575_cov_2.252988_g8790_i0 | PRJNA560932 | 9143 | 575 | 2.252988 | 12.954681 | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | 2756142 | Archaea | Archaea | 239 | 1.33e-73 | NR | HIK01832.1 | 2756142 | g8790 | i0 | 64.2 | 0.991304347826087 | 190 | 66 | 99.1 | 1 | 571 | 2 | 163 | 350 | HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71] | diamond | 570 | 239 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | ||||
| 12317651 | 12317651 | PRJNA849822_P_NODE_10130_length_470_cov_1.239295_g9957_i0 | PRJNA849822 | 10130 | 470 | 1.239295 | 5.8246865 | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | 2756142 | Archaea | Archaea | 192 | 5.3499999999999995e-56 | NR | HIK01832.1 | 2756142 | g9957 | i0 | 70.5 | 0.887234042553191 | 139 | 41 | 88.7 | 0 | 422 | 6 | 4 | 142 | HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71] | diamond | 417 | 192 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | ||||
| 24892437 | 24892437 | PRJNA685607_P_NODE_46380_length_285_cov_2.188679_g46021_i0 | PRJNA685607 | 46380 | 285 | 2.188679 | 6.23773515 | Candidatus Naiadarchaeum limnaeum | 2756139 | Archaea | Archaea | 80.1 | 2.47e-16 | NR | HIK00950.1 | 2756139 | g46021 | i0 | 52.1 | 3.61052631578947 | 71 | 34 | 74.7 | 0 | 30 | 242 | 70 | 140 | HIK00950.1 30S ribosomal protein S19e [Candidatus Naiadarchaeum limnaeum] | diamond | 1029 | 80.1 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Naiadarchaeales | Candidatus Naiadarchaeaceae | Candidatus Naiadarchaeum | Candidatus Naiadarchaeum limnaeum | ||
| 25634356 | 25634356 | PRJNA816047b_S_NODE_42577_length_262_cov_7.164021_g40265_i0 | PRJNA816047 | 42577 | 262 | 7.164021 | 18.76973502 | Candidatus Naiadarchaeum limnaeum | 2756139 | Archaea | Archaea | 82.4 | 2.4e-17 | NR | HIK00950.1 | 2756139 | g40265 | i0 | 53.4 | 3.29770992366412 | 73 | 34 | 83.6 | 0 | 32 | 250 | 68 | 140 | HIK00950.1 30S ribosomal protein S19e [Candidatus Naiadarchaeum limnaeum] | diamond | 864 | 82.4 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Naiadarchaeales | Candidatus Naiadarchaeaceae | Candidatus Naiadarchaeum | Candidatus Naiadarchaeum limnaeum | ||
| 26735644 | 26735644 | PRJNA741997_P_NODE_88521_length_241_cov_2.053571_g87401_i0 | PRJNA741997 | 88521 | 241 | 2.053571 | 4.94910611 | Candidatus Undinarchaeales archaeon | 3042728 | Archaea | Archaea | 42.7 | 0.0374 | NR | MDP7079473.1 | 3042728 | g87401 | i0 | 60.9 | 0.286307053941909 | 23 | 9 | 28.6 | 0 | 4 | 72 | 258 | 280 | MDP7079473.1 hypothetical protein [Candidatus Undinarchaeales archaeon] | diamond | 69 | 42.7 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon | ||||
| 26771841 | 26771841 | PRJNA939415_P_NODE_104901_length_227_cov_2.967532_g104479_i0 | PRJNA939415 | 104901 | 227 | 2.967532 | 6.73629764 | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | 2756142 | Archaea | Archaea | 73.9 | 2.96e-13 | NR | HIK01832.1 | 2756142 | g104479 | i0 | 67.9 | 0.700440528634361 | 53 | 17 | 70 | 0 | 161 | 3 | 86 | 138 | HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71] | diamond | 159 | 73.9 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | ||||
| 26785701 | 26785701 | PRJNA1136957_S_NODE_17481_length_208_cov_1.865772_g17384_i0 | PRJNA1136957 | 17481 | 208 | 1.865772 | 3.88080576 | Candidatus Naiadarchaeales archaeon SRR2090153.bin1042 | 2756137 | Archaea | Archaea | 84.7 | 3.87e-17 | NR | HIJ98657.1 | 2756137 | g17384 | i0 | 56.5 | 0.995192307692308 | 69 | 30 | 99.5 | 0 | 207 | 1 | 54 | 122 | HIJ98657.1 hypothetical protein [Candidatus Naiadarchaeales archaeon SRR2090153.bin1042] | diamond | 207 | 84.7 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Naiadarchaeales | Candidatus Naiadarchaeales archaeon SRR2090153.bin1042 | ||||
| 27176413 | 27176413 | PRJNA674308_P_NODE_33782_length_174_cov_1.664000_g33547_i0 | PRJNA674308 | 33782 | 174 | 1.664 | 2.89536 | Candidatus Undinarchaeales archaeon | 3042728 | Archaea | Archaea | 41.6 | 0.0383 | NR | MDP7282413.1 | 3042728 | g33547 | i0 | 42.9 | 1.08620689655172 | 63 | 26 | 94.8 | 3 | 3 | 167 | 1883 | 1943 | MDP7282413.1 LamG domain-containing protein [Candidatus Undinarchaeales archaeon] | diamond | 189 | 41.6 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon | ||||
| 27190732 | 27190732 | PRJEB11748_P_NODE_189442_length_293_cov_3.021552_g187259_i0 | PRJEB11748 | 189442 | 293 | 3.021552 | 8.85314736 | Candidatus Undinarchaeota archaeon | 2847861 | Archaea | Archaea | 52.8 | 2.07e-5 | NR | MFC1454496.1 | 2847861 | g187259 | i0 | 41.5 | 1.74061433447099 | 82 | 47 | 82.9 | 1 | 51 | 293 | 728 | 809 | MFC1454496.1 putative Ig domain-containing protein [Candidatus Undinarchaeota archaeon] | diamond | 510 | 52.8 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeota archaeon | ||||||
| 27716607 | 27716607 | PRJNA752278_P_NODE_604_length_1313_cov_3.528226_g482_i0 | PRJNA752278 | 604 | 1313 | 3.528226 | 46.32560738 | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | 2756142 | Archaea | Archaea | 459 | 1.27e-155 | NR | HIK01832.1 | 2756142 | g482 | i0 | 61 | 0.872810357958873 | 382 | 137 | 87.3 | 2 | 3 | 1148 | 105 | 474 | HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71] | diamond | 1146 | 459 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | ||||
| 28690375 | 28690375 | PRJNA575566_P_NODE_3807_length_535_cov_0.917722_g3611_i0 | PRJNA575566 | 3807 | 535 | 0.917722 | 4.9098127 | Candidatus Undinarchaeales archaeon | 3042728 | Archaea | Archaea | 63.5 | 4.04e-8 | NR | MDP7078847.1 | 3042728 | g3611 | i0 | 30.1 | 5.41121495327103 | 206 | 97 | 98.1 | 11 | 9 | 533 | 509 | 698 | MDP7078847.1 hypothetical protein [Candidatus Undinarchaeales archaeon] | diamond | 2895 | 63.5 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon | ||||
| 29485415 | 29485415 | PRJNA800090_P_NODE_55770_length_472_cov_1.925558_g53586_i0 | PRJNA800090 | 55770 | 472 | 1.925558 | 9.08863376 | Candidatus Undinarchaeales archaeon | 3042728 | Archaea | Archaea | 77.8 | 2.61e-13 | NR | MDP7078847.1 | 3042728 | g53586 | i0 | 32.4 | 2.8093220338983 | 173 | 75 | 99.2 | 7 | 2 | 469 | 549 | 696 | MDP7078847.1 hypothetical protein [Candidatus Undinarchaeales archaeon] | diamond | 1326 | 77.8 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon | ||||
| 30058599 | 30058599 | PRJNA1035005_P_NODE_46671_length_261_cov_1.553191_g46265_i0 | PRJNA1035005 | 46671 | 261 | 1.553191 | 4.05382851 | Candidatus Naiadarchaeum | 2821828 | Archaea | Archaea | 87.4 | 1.22e-19 | NR | HIJ98521.1 | 2756137 | g46265 | i0 | 48.1 | 1.77011494252874 | 77 | 38 | 88.5 | 1 | 246 | 16 | 67 | 141 | HIJ98521.1 SET domain-containing protein-lysine N-methyltransferase [Candidatus Naiadarchaeales archaeon SRR2090153.bin1042] | diamond | 462 | 87.4 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Naiadarchaeales | Candidatus Naiadarchaeales archaeon SRR2090153.bin1042 | ||||
| 31107172 | 31107172 | PRJEB14664_P_NODE_11195_length_224_cov_1.253968_g11065_i0 | PRJEB14664 | 11195 | 224 | 1.253968 | 2.80888832 | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | 2756142 | Archaea | Archaea | 109 | 3.96e-26 | NR | HIK01832.1 | 2756142 | g11065 | i0 | 68.5 | 0.977678571428571 | 73 | 23 | 97.8 | 0 | 4 | 222 | 204 | 276 | HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71] | diamond | 219 | 109 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | ||||
| 32533513 | 32533513 | PRJNA1067370_P_NODE_16859_length_453_cov_1.615789_g16311_i0 | PRJNA1067370 | 16859 | 453 | 1.615789 | 7.31952417 | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | 2756142 | Archaea | Archaea | 152 | 8.67e-41 | NR | HIK01832.1 | 2756142 | g16311 | i0 | 50.7 | 0.993377483443709 | 150 | 69 | 99.3 | 1 | 451 | 2 | 23 | 167 | HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71] | diamond | 450 | 152 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | ||||
| 32637369 | 32637369 | PRJNA494251_P_NODE_34820_length_256_cov_2.382514_g34506_i0 | PRJNA494251 | 34820 | 256 | 2.382514 | 6.09923584 | Candidatus Undinarchaeales archaeon SRR5007147.bin71 | 2756142 | Archaea | Archaea | 112 | 6.380000000000001e-27 | NR | HIK01832.1 | 2756142 | g34506 | i0 | 67.1 | 0.99609375 | 85 | 28 | 99.6 | 0 | 1 | 255 | 205 | 289 | HIK01832.1 IMP dehydrogenase [Candidatus Undinarchaeales archaeon SRR5007147.bin71] | diamond | 255 | 112 | 1 | Archaea | Nanobdellati | Candidatus Undinarchaeota | Candidatus Undinarchaeia | Candidatus Undinarchaeales | Candidatus Undinarchaeales archaeon SRR5007147.bin71 |
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);;