contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA330616" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 24021206 | 24021206 | PRJNA330616_P_NODE_29239_length_164_cov_0.886957_g28830_i0 | PRJNA330616 | 29239 | 164 | 0.886957 | 1.45460948 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 100 | 5.09e-26 | NR | KAL0489140.1 | 1008807 | g28830 | i0 | 81.5 | 1.97560975609756 | 54 | 10 | 98.8 | 0 | 164 | 3 | 29 | 82 | KAL0489140.1 ribosomal protein S27 [Acrasis kona] | diamond | 324 | 100 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 26599465 | 26599465 | PRJNA330616_P_NODE_29721_length_163_cov_0.894737_g29312_i0 | PRJNA330616 | 29721 | 163 | 0.894737 | 1.45842131 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 42.7 | 0.0129 | NR | XP_002670719.1 | 5762 | g29312 | i0 | 53.1 | 0.588957055214724 | 32 | 15 | 58.9 | 0 | 52 | 147 | 218 | 249 | XP_002670719.1 uncharacterized protein NAEGRDRAFT_59623 [Naegleria gruberi] | diamond | 96 | 42.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27832657 | 27832657 | PRJNA330616_P_NODE_27584_length_165_cov_0.879310_g27175_i0 | PRJNA330616 | 27584 | 165 | 0.87931 | 1.4508615 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 87 | 1.97e-18 | NR | KAL0479499.1 | 1008807 | g27175 | i0 | 72.7 | 1 | 55 | 15 | 100 | 0 | 165 | 1 | 312 | 366 | KAL0479499.1 S-adenosylmethionine synthase [Acrasis kona] | diamond | 165 | 87 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28022326 | 28022326 | PRJNA330616_P_NODE_32365_length_161_cov_0.910714_g31956_i0 | PRJNA330616 | 32365 | 161 | 0.910714 | 1.46624954 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 79.7 | 1.12e-15 | NR | KAL0486907.1 | 1008807 | g31956 | i0 | 75 | 0.968944099378882 | 52 | 12 | 96.9 | 1 | 1 | 156 | 868 | 918 | KAL0486907.1 Ras GTPase activating protein [Acrasis kona] | diamond | 156 | 79.7 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28464316 | 28464316 | PRJNA330616_P_NODE_30986_length_162_cov_0.902655_g30577_i0 | PRJNA330616 | 30986 | 162 | 0.902655 | 1.4623011 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 91.7 | 7.13e-20 | NR | KAL0489982.1 | 1008807 | g30577 | i0 | 82.7 | 0.962962962962963 | 52 | 9 | 96.3 | 0 | 157 | 2 | 92 | 143 | KAL0489982.1 26S proteasome subunit Rpn2 [Acrasis kona] | diamond | 156 | 91.7 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28653680 | 28653680 | PRJNA330616_P_NODE_15687_length_211_cov_1.259259_g15278_i0 | PRJNA330616 | 15687 | 211 | 1.259259 | 2.65703649 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 112 | 1.1e-29 | NR | KAL0480477.1 | 1008807 | g15278 | i0 | 82.6 | 1.96208530805687 | 69 | 12 | 98.1 | 0 | 209 | 3 | 19 | 87 | KAL0480477.1 ribosomal protein L27 [Acrasis kona] | diamond | 414 | 112 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 28874608 | 28874608 | PRJNA330616_P_NODE_27728_length_165_cov_0.879310_g27319_i0 | PRJNA330616 | 27728 | 165 | 0.87931 | 1.4508615 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 45.4 | 0.00125 | NR | KAL0486503.1 | 1008807 | g27319 | i0 | 80.6 | 0.563636363636364 | 31 | 6 | 56.4 | 0 | 4 | 96 | 62 | 92 | KAL0486503.1 hypothetical protein AKO1_001491 [Acrasis kona] | diamond | 93 | 45.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29001341 | 29001341 | PRJNA330616_P_NODE_23008_length_176_cov_1.606299_g22599_i0 | PRJNA330616 | 23008 | 176 | 1.606299 | 2.82708624 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 108 | 1.62e-28 | NR | KAL0487070.1 | 1008807 | g22599 | i0 | 82.8 | 0.988636363636364 | 58 | 10 | 98.9 | 0 | 1 | 174 | 38 | 95 | KAL0487070.1 ribosomal protein L32 [Acrasis kona] | diamond | 174 | 108 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 29316674 | 29316674 | PRJNA330616_P_NODE_26749_length_166_cov_0.871795_g26340_i0 | PRJNA330616 | 26749 | 166 | 0.871795 | 1.4471797 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 60.5 | 6.7e-9 | NR | CAG4717704.1 | 5763 | g26340 | i0 | 75 | 1.30120481927711 | 36 | 9 | 65.1 | 0 | 109 | 2 | 29 | 64 | CAG4717704.1 unnamed protein product, partial [Naegleria fowleri] | diamond | 216 | 60.5 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30106112 | 30106112 | PRJNA330616_P_NODE_29892_length_163_cov_0.894737_g29483_i0 | PRJNA330616 | 29892 | 163 | 0.894737 | 1.45842131 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 48.5 | 1.17e-4 | NR | KAL0483879.1 | 1008807 | g29483 | i0 | 38.9 | 0.993865030674847 | 54 | 33 | 99.4 | 0 | 163 | 2 | 705 | 758 | KAL0483879.1 importin-beta [Acrasis kona] | diamond | 162 | 48.5 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 30927832 | 30927832 | PRJNA330616_P_NODE_25654_length_167_cov_0.864407_g25245_i0 | PRJNA330616 | 25654 | 167 | 0.864407 | 1.44355969 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 47.8 | 8.26e-5 | NR | KAL0481581.1 | 1008807 | g25245 | i0 | 56.4 | 0.70059880239521 | 39 | 17 | 70.1 | 0 | 145 | 29 | 104 | 142 | KAL0481581.1 hypothetical protein AKO1_012499 [Acrasis kona] | diamond | 117 | 47.8 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32477640 | 32477640 | PRJNA330616_P_NODE_30439_length_163_cov_0.894737_g30030_i0 | PRJNA330616 | 30439 | 163 | 0.894737 | 1.45842131 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 77.8 | 5.57e-15 | NR | KAL0479639.1 | 1008807 | g30030 | i0 | 73.2 | 1.03067484662577 | 56 | 13 | 99.4 | 1 | 2 | 163 | 97 | 152 | KAL0479639.1 26S proteasome subunit ECM29 [Acrasis kona] | diamond | 168 | 77.8 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 32572586 | 32572586 | PRJNA330616_P_NODE_26899_length_166_cov_0.871795_g26490_i0 | PRJNA330616 | 26899 | 166 | 0.871795 | 1.4471797 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 50.8 | 1.86e-5 | NR | XP_002670129.1 | 5762 | g26490 | i0 | 98.2 | 0.993975903614458 | 55 | 1 | 99.4 | 0 | 166 | 2 | 781 | 835 | XP_002670129.1 uncharacterized protein NAEGRDRAFT_81954 [Naegleria gruberi] | diamond | 165 | 50.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32635056 | 32635056 | PRJNA330616_P_NODE_25760_length_167_cov_0.864407_g25351_i0 | PRJNA330616 | 25760 | 167 | 0.864407 | 1.44355969 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 86.7 | 3.33e-18 | NR | KAL0479857.1 | 1008807 | g25351 | i0 | 80 | 0.988023952095808 | 55 | 10 | 98.8 | 1 | 3 | 167 | 337 | 390 | KAL0479857.1 hypothetical protein AKO1_000709, partial [Acrasis kona] | diamond | 165 | 86.7 | 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);;