contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1186363" and tax_clade = "Discoba"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2870608 | 2870608 | PRJNA1186363_P_NODE_40743_length_248_cov_0.891429_g39855_i0 | PRJNA1186363 | 40743 | 248 | 0.891429 | 2.21074392 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 119 | 3.26e-33 | NR | QLA09593.1 | 3039 | g39855 | i0 | 81.6 | 0.919354838709677 | 76 | 7 | 83.5 | 2 | 243 | 37 | 1 | 76 | QLA09593.1 40S small subunit ribosomal protein eS28 [Euglena gracilis] | diamond | 228 | 119 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 4146680 | 4146680 | PRJNA1186363_P_NODE_35524_length_273_cov_1.170000_g34636_i0 | PRJNA1186363 | 35524 | 273 | 1.17 | 3.1941 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 2.26e-32 | NR | KAJ9458038.1 | 91374 | g34636 | i0 | 63.3 | 6.92307692307692 | 90 | 33 | 98.9 | 0 | 271 | 2 | 158 | 247 | KAJ9458038.1 Elongation factor 1-alpha [Diplonema papillatum] | diamond | 1890 | 125 | 0.992 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 14348783 | 14348783 | PRJNA1186363_P_NODE_29492_length_321_cov_0.943548_g28604_i0 | PRJNA1186363 | 29492 | 321 | 0.943548 | 3.02878908 | root | 1 | Root_unresolved | Root_unresolved | 130 | 1.48e-35 | NR | KAF0852490.1 | 505711 | g28604 | i0 | 61.3 | 8.93457943925234 | 93 | 34 | 86.9 | 1 | 14 | 292 | 116 | 206 | KAF0852490.1 mitochondrial iron/manganese superoxide dismutase [Andalucia godoyi] | diamond | 2868 | 130 | 1 | Eukaryota | Discoba | Jakobida | Andaluciidae | Andalucia | Andalucia godoyi | ||||
| 16896942 | 16896942 | PRJNA1186363_P_NODE_40854_length_248_cov_0.891429_g39966_i0 | PRJNA1186363 | 40854 | 248 | 0.891429 | 2.21074392 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 154 | 2.36e-41 | NR | XP_002675895.1 | 5762 | g39966 | i0 | 85.2 | 6.93145161290323 | 81 | 12 | 98 | 0 | 248 | 6 | 80 | 160 | XP_002675895.1 alanyl-tRNA synthetase [Naegleria gruberi] | diamond | 1719 | 154 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 24545715 | 24545715 | PRJNA1186363_P_NODE_23880_length_376_cov_1.019802_g22992_i0 | PRJNA1186363 | 23880 | 376 | 1.019802 | 3.83445552 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 169 | 1.5799999999999998e-47 | NR | TPP48826.1 | 5661 | g22992 | i0 | 74 | 22.5797872340426 | 123 | 29 | 98.1 | 2 | 374 | 6 | 156 | 275 | TPP48826.1 succinate-CoA ligase, alpha subunit family protein [Leishmania donovani] | diamond | 8490 | 169 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania donovani | ||
| 26851025 | 26851025 | PRJNA1186363_P_NODE_39181_length_251_cov_1.859551_g38293_i0 | PRJNA1186363 | 39181 | 251 | 1.859551 | 4.66747301 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 54.3 | 3.35e-6 | NR | XP_044545604.1 | 51637 | g38293 | i0 | 42.3 | 0.932270916334661 | 78 | 42 | 93.2 | 1 | 249 | 16 | 16 | 90 | XP_044545604.1 uncharacterized protein C9374_008485 [Naegleria lovaniensis] | diamond | 234 | 54.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 27198514 | 27198514 | PRJNA1186363_P_NODE_39102_length_252_cov_0.871508_g38214_i0 | PRJNA1186363 | 39102 | 252 | 0.871508 | 2.19620016 | Euglena gracilis | 3039 | Euglenozoa | other_Eukaryota | 135 | 7.329999999999998e-35 | NR | AAF71706.1 | 3039 | g38214 | i0 | 70.2 | 1 | 84 | 25 | 100 | 0 | 1 | 252 | 539 | 622 | AAF71706.1 elongation factor 2, partial [Euglena gracilis] | diamond | 252 | 135 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena gracilis | ||
| 27217581 | 27217581 | PRJNA1186363_P_NODE_38042_length_254_cov_1.292818_g37154_i0 | PRJNA1186363 | 38042 | 254 | 1.292818 | 3.28375772 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 123 | 8.06e-33 | NR | KAF0852660.1 | 505711 | g37154 | i0 | 71.6 | 6.74409448818898 | 81 | 23 | 95.7 | 0 | 247 | 5 | 64 | 144 | KAF0852660.1 60S large subunit ribosomal protein uL30 (rpL7) [Andalucia godoyi] | diamond | 1713 | 123 | 1 | Eukaryota | Discoba | Jakobida | Andaluciidae | Andalucia | Andalucia godoyi | ||||
| 27546257 | 27546257 | PRJNA1186363_P_NODE_26544_length_348_cov_1.134545_g25656_i0 | PRJNA1186363 | 26544 | 348 | 1.134545 | 3.9482166 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 44.3 | 0.0254 | NR | XP_002683048.1 | 5762 | g25656 | i0 | 34.2 | 0.655172413793103 | 76 | 46 | 62.9 | 2 | 82 | 300 | 26 | 100 | XP_002683048.1 uncharacterized protein NAEGRDRAFT_44969 [Naegleria gruberi] | diamond | 228 | 44.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 27672751 | 27672751 | PRJNA1186363_P_NODE_43084_length_243_cov_1.305882_g42196_i0 | PRJNA1186363 | 43084 | 243 | 1.305882 | 3.17329326 | Diplonema papillatum | 91374 | Euglenozoa | other_Eukaryota | 73.6 | 3.42e-13 | NR | KAJ9458764.1 | 91374 | g42196 | i0 | 42.9 | 2.07407407407407 | 84 | 44 | 98.8 | 1 | 2 | 241 | 126 | 209 | KAJ9458764.1 Purple acid phosphatase 7 [Diplonema papillatum] | diamond | 504 | 73.6 | 1 | Eukaryota | Discoba | Euglenozoa | Diplonemea | Diplonemidae | Diplonema | Diplonema papillatum | |||
| 28039031 | 28039031 | PRJNA1186363_P_NODE_35585_length_272_cov_1.959799_g34697_i0 | PRJNA1186363 | 35585 | 272 | 1.959799 | 5.33065328 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 153 | 7.88e-43 | NR | XP_044561356.1 | 5763 | g34697 | i0 | 83 | 11.7242647058824 | 88 | 15 | 97.1 | 0 | 4 | 267 | 48 | 135 | XP_044561356.1 uncharacterized protein FDP41_004542 [Naegleria fowleri] | diamond | 3189 | 154 | 0.993506493506494 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28493561 | 28493561 | PRJNA1186363_P_NODE_27527_length_339_cov_0.962406_g26639_i0 | PRJNA1186363 | 27527 | 339 | 0.962406 | 3.26255634 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 46.2 | 0.00695 | NR | XP_044567221.1 | 5763 | g26639 | i0 | 35.8 | 1.69911504424779 | 81 | 49 | 69.9 | 2 | 294 | 58 | 90 | 169 | XP_044567221.1 uncharacterized protein FDP41_011438 [Naegleria fowleri] | diamond | 576 | 46.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29648809 | 29648809 | PRJNA1186363_P_NODE_37790_length_256_cov_1.278689_g36902_i0 | PRJNA1186363 | 37790 | 256 | 1.278689 | 3.27344384 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.2 | 2.68e-9 | NR | XP_002682561.1 | 5762 | g36902 | i0 | 58 | 3.55078125 | 50 | 21 | 58.6 | 0 | 250 | 101 | 305 | 354 | XP_002682561.1 uncharacterized protein NAEGRDRAFT_60237 [Naegleria gruberi] | diamond | 909 | 63.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30230279 | 30230279 | PRJNA1186363_P_NODE_42752_length_244_cov_0.912281_g41864_i0 | PRJNA1186363 | 42752 | 244 | 0.912281 | 2.22596564 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 156 | 1.0399999999999997e-42 | NR | XP_002678813.1 | 5762 | g41864 | i0 | 96.3 | 0.995901639344262 | 81 | 3 | 99.6 | 0 | 244 | 2 | 402 | 482 | XP_002678813.1 uncharacterized protein NAEGRDRAFT_65854 [Naegleria gruberi] | diamond | 243 | 156 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30344712 | 30344712 | PRJNA1186363_P_NODE_15372_length_503_cov_1.632558_g14486_i0 | PRJNA1186363 | 15372 | 503 | 1.632558 | 8.21176674 | Naegleria | 5761 | Heterolobosea | other_Eukaryota | 97.4 | 2.71e-20 | NR | XP_002672949.1 | 5762 | g14486 | i0 | 43.1 | 1.5506958250497 | 102 | 56 | 59.6 | 1 | 420 | 121 | 1 | 102 | XP_002672949.1 uncharacterized protein NAEGRDRAFT_51924 [Naegleria gruberi] | diamond | 780 | 98.2 | 0.991853360488798 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30483113 | 30483113 | PRJNA1186363_P_NODE_40993_length_248_cov_0.891429_g40105_i0 | PRJNA1186363 | 40993 | 248 | 0.891429 | 2.21074392 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 122 | 3.2300000000000004e-33 | NR | XP_002682474.1 | 5762 | g40105 | i0 | 80 | 0.967741935483871 | 80 | 14 | 95.6 | 2 | 10 | 246 | 42 | 120 | XP_002682474.1 uncharacterized protein NAEGRDRAFT_30019 [Naegleria gruberi] | diamond | 240 | 122 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30483122 | 30483122 | PRJNA1186363_P_NODE_43773_length_242_cov_0.923077_g42885_i0 | PRJNA1186363 | 43773 | 242 | 0.923077 | 2.23384634 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 134 | 2.84e-35 | NR | XP_002680092.1 | 5762 | g42885 | i0 | 80 | 0.991735537190083 | 80 | 16 | 99.2 | 0 | 240 | 1 | 374 | 453 | XP_002680092.1 uncharacterized protein NAEGRDRAFT_47246 [Naegleria gruberi] | diamond | 240 | 134 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31873907 | 31873907 | PRJNA1186363_P_NODE_28077_length_333_cov_2.011538_g27189_i0 | PRJNA1186363 | 28077 | 333 | 2.011538 | 6.69842154 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 79.3 | 1.53e-14 | NR | XP_002673568.1 | 5762 | g27189 | i0 | 40.4 | 1.69369369369369 | 94 | 54 | 84.7 | 1 | 320 | 39 | 729 | 820 | XP_002673568.1 alpha-actinin [Naegleria gruberi] | diamond | 564 | 79.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi |
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);;