contig_metadata
12 rows where bioproject = "PRJNA849172", tax_clade = "Discoba" and tax_phylum = "Heterolobosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5938814 | 5938814 | PRJNA849172_P_NODE_20465_length_456_cov_14.404700_g20106_i0 | PRJNA849172 | 20465 | 456 | 14.4047 | 65.685432 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 214 | 5.22e-68 | NR | KAL0480982.1 | 1008807 | g20106 | i0 | 67.1 | 0.980263157894737 | 149 | 49 | 98 | 0 | 1 | 447 | 46 | 194 | KAL0480982.1 Ras-related protein Rac [Acrasis kona] | diamond | 447 | 214 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 7213337 | 7213337 | PRJNA849172_P_NODE_140126_length_207_cov_6.477612_g139766_i0 | PRJNA849172 | 140126 | 207 | 6.477612 | 13.40865684 | Tetramitus jugosus | 166959 | Heterolobosea | other_Eukaryota | 370 | 4.4e-98 | NTclustered | gi|2233316042|emb|OW569396.1| | 166959 | g139766 | i0 | 100 | 0.966183574879227 | 200 | 0 | 97 | 0 | 8 | 207 | 40591 | 40392 | Tetramitus jugosus genome assembly, organelle: mitochondrion | blastn | 200 | 370 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Tetramitus | Tetramitus jugosus | ||||
| 9764522 | 9764522 | PRJNA849172_P_NODE_46408_length_306_cov_15.918455_g46048_i0 | PRJNA849172 | 46408 | 306 | 15.918455 | 48.7104723 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 103 | 1.3399999999999999e-24 | NR | YP_007890028.1 | 5763 | g46048 | i0 | 51 | 0.980392156862745 | 100 | 46 | 98 | 1 | 3 | 302 | 74 | 170 | YP_007890028.1 succinate:cytochrome c oxidoreductase subunit 2 [Naegleria fowleri] | diamond | 300 | 103 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 13591520 | 13591520 | PRJNA849172_P_NODE_93251_length_250_cov_0.881356_g92891_i0 | PRJNA849172 | 93251 | 250 | 0.881356 | 2.20339 | root | 1 | Root_unresolved | Root_unresolved | 89.4 | 1.89e-19 | NR | KAL0488991.1 | 1008807 | g92891 | i0 | 59.4 | 11.496 | 64 | 26 | 76.8 | 0 | 43 | 234 | 188 | 251 | KAL0488991.1 ribosomal protein L2 [Acrasis kona] | diamond | 2874 | 89.7 | 0.996655518394649 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 18686103 | 18686103 | PRJNA849172_P_NODE_127475_length_225_cov_7.513158_g127115_i0 | PRJNA849172 | 127475 | 225 | 7.513158 | 16.9046055 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|2119416215|ref|XM_044699845.1| | 51637 | g127115 | i0 | 94.118 | 0.151111111111111 | 34 | 2 | 15 | 0 | 15 | 48 | 194 | 227 | Naegleria lovaniensis uncharacterized protein (C9374_009636), partial mRNA | blastn | 34 | 52.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 26611474 | 26611474 | PRJNA849172_P_NODE_18941_length_475_cov_17.119403_g18582_i0 | PRJNA849172 | 18941 | 475 | 17.119403 | 81.31716425 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 164 | 2.52e-47 | NR | KAL0477182.1 | 1008807 | g18582 | i0 | 65.7 | 0.682105263157895 | 108 | 37 | 68.2 | 0 | 447 | 124 | 166 | 273 | KAL0477182.1 MBL fold metallo-hydrolase [Acrasis kona] | diamond | 324 | 164 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27663581 | 27663581 | PRJNA849172_P_NODE_36324_length_341_cov_10.250000_g35965_i0 | PRJNA849172 | 36324 | 341 | 10.25 | 34.9525 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.4 | 4.44e-11 | NR | CAG4711175.1 | 5763 | g35965 | i0 | 59.3 | 5.92961876832845 | 54 | 21 | 47.5 | 1 | 330 | 169 | 134 | 186 | CAG4711175.1 unnamed protein product [Naegleria fowleri] | diamond | 2022 | 67.8 | 0.994100294985251 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30244533 | 30244533 | PRJNA849172_P_NODE_18352_length_483_cov_11.068293_g17993_i0 | PRJNA849172 | 18352 | 483 | 11.068293 | 53.45985519 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 115 | 5.96e-29 | NR | XP_044552668.1 | 51637 | g17993 | i0 | 39.9 | 0.981366459627329 | 158 | 89 | 98.1 | 3 | 478 | 5 | 40 | 191 | XP_044552668.1 uncharacterized protein C9374_000115 [Naegleria lovaniensis] | diamond | 474 | 115 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 30560105 | 30560105 | PRJNA849172_P_NODE_13813_length_566_cov_2.563895_g13455_i0 | PRJNA849172 | 13813 | 566 | 2.563895 | 14.5116457 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 59.7 | 4.33e-7 | NR | XP_044543127.1 | 51637 | g13455 | i0 | 22.8 | 1.32508833922261 | 123 | 93 | 64.1 | 1 | 533 | 171 | 106 | 228 | XP_044543127.1 uncharacterized protein C9374_011618 [Naegleria lovaniensis] | diamond | 750 | 59.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 31002807 | 31002807 | PRJNA849172_P_NODE_6574_length_855_cov_52.589514_g6259_i0 | PRJNA849172 | 6574 | 855 | 52.589514 | 449.6403447 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 169 | 3.99e-45 | NR | KAL0489666.1 | 1008807 | g6259 | i0 | 36 | 1.04210526315789 | 297 | 157 | 98.9 | 8 | 854 | 9 | 212 | 490 | KAL0489666.1 cytochrome P450 [Acrasis kona] | diamond | 891 | 169 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31793013 | 31793013 | PRJNA849172_P_NODE_80657_length_259_cov_2.387097_g80297_i0 | PRJNA849172 | 80657 | 259 | 2.387097 | 6.18258123 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 100 | 1.23e-24 | NR | KAL0487640.1 | 1008807 | g80297 | i0 | 63 | 0.938223938223938 | 81 | 30 | 93.8 | 0 | 2 | 244 | 82 | 162 | KAL0487640.1 ribosomal protein L21 [Acrasis kona] | diamond | 243 | 100 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32109643 | 32109643 | PRJNA849172_P_NODE_87858_length_253_cov_1.688889_g87498_i0 | PRJNA849172 | 87858 | 253 | 1.688889 | 4.27288917 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 100 | 4.4299999999999996e-24 | NR | KAL0479000.1 | 1008807 | g87498 | i0 | 51.8 | 0.984189723320158 | 83 | 40 | 98.4 | 0 | 1 | 249 | 59 | 141 | KAL0479000.1 hypothetical protein AKO1_007878 [Acrasis kona] | diamond | 249 | 100 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona |
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);;