contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA637219" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3706685 | 3706685 | PRJNA637219_S_NODE_1743_length_339_cov_1.458621_g1698_i0 | PRJNA637219 | 1743 | 339 | 1.458621 | 4.94472519 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 153 | 4.279999999999999e-43 | NR | ABL74967.1 | 5755 | g1698 | i0 | 62.4 | 1.0353982300885 | 117 | 40 | 100 | 1 | 339 | 1 | 83 | 199 | ABL74967.1 cysteine protease [Acanthamoeba castellanii] | diamond | 351 | 153 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26744973 | 26744973 | PRJNA637219_S_NODE_10801_length_167_cov_0.864407_g10756_i0 | PRJNA637219 | 10801 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 75.5 | 2.38e-14 | NR | AAL67857.1 | 65661 | g10756 | i0 | 61.5 | 2.82035928143713 | 52 | 20 | 93.4 | 0 | 6 | 161 | 183 | 234 | AAL67857.1 cysteine proteinase [Acanthamoeba healyi] | diamond | 471 | 75.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba healyi | |||
| 27554693 | 27554693 | PRJNA637219_S_NODE_14404_length_163_cov_1.342105_g14359_i0 | PRJNA637219 | 14404 | 163 | 1.342105 | 2.18763115 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 54.3 | 1.73e-7 | NR | 1PRQ_A | 5755 | g14359 | i0 | 75.8 | 2.39263803680982 | 33 | 8 | 60.7 | 0 | 5 | 103 | 93 | 125 | 1PRQ_A Chain A, PROFILIN IA [Acanthamoeba castellanii] | diamond | 390 | 54.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27713204 | 27713204 | PRJNA637219_S_NODE_1424_length_368_cov_1.968652_g1379_i0 | PRJNA637219 | 1424 | 368 | 1.968652 | 7.24463936 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 162 | 3.09e-45 | NR | XP_004342296.1 | 1257118 | g1379 | i0 | 68.1 | 0.970108695652174 | 119 | 38 | 97 | 0 | 361 | 5 | 113 | 231 | XP_004342296.1 carboxypeptidase Ylike protein [Acanthamoeba castellanii str. Neff] | diamond | 357 | 162 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28312829 | 28312829 | PRJNA637219_S_NODE_14686_length_163_cov_0.894737_g14641_i0 | PRJNA637219 | 14686 | 163 | 0.894737 | 1.45842131 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 71.2 | 4.79e-13 | NR | ABD46543.1 | 5755 | g14641 | i0 | 64 | 0.920245398773006 | 50 | 18 | 92 | 0 | 1 | 150 | 56 | 105 | ABD46543.1 rhodanese-related sulfurtransferase, partial [Acanthamoeba castellanii] | diamond | 150 | 71.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29322974 | 29322974 | PRJNA637219_S_NODE_9009_length_177_cov_1.195312_g8964_i0 | PRJNA637219 | 9009 | 177 | 1.195312 | 2.11570224 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 82 | 5.14e-17 | NR | XP_003292664.1 | 5786 | g8964 | i0 | 62.1 | 0.983050847457627 | 58 | 19 | 98.3 | 1 | 3 | 176 | 161 | 215 | XP_003292664.1 uncharacterized protein DICPUDRAFT_157402 [Dictyostelium purpureum] | diamond | 174 | 82 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 29954649 | 29954649 | PRJNA637219_S_NODE_4951_length_220_cov_9.789474_g4906_i0 | PRJNA637219 | 4951 | 220 | 9.789474 | 21.5368428 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 41.6 | 0.0445 | NR | XP_004339586.1 | 1257118 | g4906 | i0 | 50 | 1.2 | 44 | 22 | 60 | 0 | 142 | 11 | 22 | 65 | XP_004339586.1 uncharacterized protein ACA1_063370 [Acanthamoeba castellanii str. Neff] | diamond | 264 | 41.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31060738 | 31060738 | PRJNA637219_S_NODE_6175_length_204_cov_0.987097_g6130_i0 | PRJNA637219 | 6175 | 204 | 0.987097 | 2.01367788 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 42 | 0.021 | NR | XP_004342208.1 | 1257118 | g6130 | i0 | 44.6 | 0.823529411764706 | 56 | 28 | 82.4 | 1 | 199 | 32 | 65 | 117 | XP_004342208.1 LIM domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 168 | 42 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31598218 | 31598218 | PRJNA637219_S_NODE_7356_length_191_cov_1.077465_g7311_i0 | PRJNA637219 | 7356 | 191 | 1.077465 | 2.05795815 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 47.8 | 3.2e-4 | NR | XP_004333504.1 | 1257118 | g7311 | i0 | 33.9 | 0.973821989528796 | 62 | 41 | 97.4 | 0 | 1 | 186 | 131 | 192 | XP_004333504.1 uncharacterized protein ACA1_027160, partial [Acanthamoeba castellanii str. Neff] | diamond | 186 | 47.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31661085 | 31661085 | PRJNA637219_S_NODE_11857_length_166_cov_0.871795_g11812_i0 | PRJNA637219 | 11857 | 166 | 0.871795 | 1.4471797 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 63.2 | 8.23e-10 | NR | XP_004352734.1 | 1257118 | g11812 | i0 | 58.6 | 1.04819277108434 | 58 | 21 | 99.4 | 1 | 1 | 165 | 8 | 65 | XP_004352734.1 WD repeatcontaining protein [Acanthamoeba castellanii str. Neff] | diamond | 174 | 63.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31661086 | 31661086 | PRJNA637219_S_NODE_12377_length_165_cov_1.318966_g12332_i0 | PRJNA637219 | 12377 | 165 | 1.318966 | 2.1762939 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 93.2 | 1.66e-20 | NR | XP_004341068.1 | 1257118 | g12332 | i0 | 83.3 | 3.92727272727273 | 54 | 9 | 98.2 | 0 | 163 | 2 | 7 | 60 | XP_004341068.1 polyadenylate-binding protein family protein [Acanthamoeba castellanii str. Neff] | diamond | 648 | 93.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32578896 | 32578896 | PRJNA637219_S_NODE_8479_length_181_cov_1.159091_g8434_i0 | PRJNA637219 | 8479 | 181 | 1.159091 | 2.09795471 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 73.9 | 4.37e-15 | NR | 1PRQ_A | 5755 | g8434 | i0 | 61 | 1.93922651933702 | 59 | 23 | 97.8 | 0 | 3 | 179 | 24 | 82 | 1PRQ_A Chain A, PROFILIN IA [Acanthamoeba castellanii] | diamond | 351 | 73.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32874500 | 32874500 | PRJNA637219_S_NODE_3640_length_249_cov_1.325000_g3595_i0 | PRJNA637219 | 3640 | 249 | 1.325 | 3.29925 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 142 | 7.22e-41 | NR | AFX73089.1 | 497998 | g3595 | i0 | 79.3 | 2.96385542168675 | 82 | 17 | 98.8 | 0 | 247 | 2 | 25 | 106 | AFX73089.1 elongation factor 2 alpha, partial [Arcella hemisphaerica] | diamond | 738 | 143 | 0.993006993006993 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Arcellidae | Arcella | Arcella hemisphaerica |
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);;