contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA1120771" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13030278 | 13030278 | PRJNA1120771_S_NODE_19451_length_264_cov_1.574661_g19051_i0 | PRJNA1120771 | 19451 | 264 | 1.574661 | 4.15710504 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 88.6 | 3.66e-18 | NR | XP_002679892.1 | 5762 | g19051 | i0 | 53 | 0.943181818181818 | 83 | 32 | 93.2 | 2 | 262 | 17 | 1408 | 1484 | XP_002679892.1 serine/threonine protein kinase [Naegleria gruberi] | diamond | 249 | 88.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 26837999 | 26837999 | PRJNA1120771_S_NODE_29561_length_223_cov_2.416667_g29161_i0 | PRJNA1120771 | 29561 | 223 | 2.416667 | 5.38916741 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.4 | 1.14e-5 | NR | XP_002678133.1 | 5762 | g29161 | i0 | 62.5 | 0.914798206278027 | 32 | 12 | 43 | 0 | 223 | 128 | 431 | 462 | XP_002678133.1 disulfide isomerase family protein [Naegleria gruberi] | diamond | 204 | 52.4 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 26975135 | 26975135 | PRJNA1120771_S_NODE_24522_length_241_cov_2.616162_g24122_i0 | PRJNA1120771 | 24522 | 241 | 2.616162 | 6.30495042 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 67.4 | 7.34e-11 | NR | KAL0488817.1 | 1008807 | g24122 | i0 | 50.9 | 1.43153526970954 | 53 | 26 | 66 | 0 | 68 | 226 | 400 | 452 | KAL0488817.1 25/26-hydroxycholesterol 7alpha-hydroxylase [Acrasis kona] | diamond | 345 | 67.4 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 27670536 | 27670536 | PRJNA1120771_S_NODE_4104_length_461_cov_37.033493_g3709_i0 | PRJNA1120771 | 4104 | 461 | 37.033493 | 170.72440273 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 207 | 1.26e-63 | NR | XP_044557880.1 | 5763 | g3709 | i0 | 86.8 | 0.741865509761388 | 114 | 15 | 74.2 | 0 | 460 | 119 | 203 | 316 | XP_044557880.1 uncharacterized protein FDP41_008374 [Naegleria fowleri] | diamond | 342 | 207 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28259317 | 28259317 | PRJNA1120771_S_NODE_11746_length_317_cov_15.540146_g11346_i0 | PRJNA1120771 | 11746 | 317 | 15.540146 | 49.26226282 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 126 | 1.3499999999999999e-34 | NR | XP_044564077.1 | 5763 | g11346 | i0 | 71.8 | 3.23659305993691 | 85 | 24 | 80.4 | 0 | 5 | 259 | 66 | 150 | XP_044564077.1 uncharacterized protein FDP41_001707 [Naegleria fowleri] | diamond | 1026 | 126 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 28965051 | 28965051 | PRJNA1120771_S_NODE_6088_length_400_cov_4.173669_g5688_i0 | PRJNA1120771 | 6088 | 400 | 4.173669 | 16.694676 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 70.9 | 1.31e-11 | NR | XP_002674912.1 | 5762 | g5688 | i0 | 43 | 0.5925 | 79 | 40 | 55.5 | 1 | 397 | 176 | 190 | 268 | XP_002674912.1 uncharacterized protein NAEGRDRAFT_70015 [Naegleria gruberi] | diamond | 237 | 70.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29143883 | 29143883 | PRJNA1120771_S_NODE_28689_length_226_cov_1.420765_g28289_i0 | PRJNA1120771 | 28689 | 226 | 1.420765 | 3.2109289 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 129 | 4.74e-35 | NR | XP_002680585.1 | 5762 | g28289 | i0 | 75.3 | 2.92035398230089 | 73 | 18 | 96.9 | 0 | 221 | 3 | 160 | 232 | XP_002680585.1 uncharacterized protein NAEGRDRAFT_31260 [Naegleria gruberi] | diamond | 660 | 130 | 0.992307692307692 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 29248935 | 29248935 | PRJNA1120771_S_NODE_33869_length_211_cov_1.035714_g33469_i0 | PRJNA1120771 | 33869 | 211 | 1.035714 | 2.18535654 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 59.7 | 2.62e-8 | NR | XP_044550565.1 | 51637 | g33469 | i0 | 43.8 | 1.03791469194313 | 73 | 38 | 99.5 | 2 | 210 | 1 | 1035 | 1107 | XP_044550565.1 uncharacterized protein C9374_002317 [Naegleria lovaniensis] | diamond | 219 | 59.7 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 29680015 | 29680015 | PRJNA1120771_S_NODE_19010_length_266_cov_2.730942_g18610_i0 | PRJNA1120771 | 19010 | 266 | 2.730942 | 7.26430572 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 76.6 | 3.93e-14 | NR | XP_044566448.1 | 5763 | g18610 | i0 | 47 | 6.32706766917293 | 83 | 40 | 90.2 | 2 | 15 | 254 | 255 | 336 | XP_044566448.1 uncharacterized protein FDP41_012392 [Naegleria fowleri] | diamond | 1683 | 76.6 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 29943868 | 29943868 | PRJNA1120771_S_NODE_17951_length_272_cov_3.039301_g17551_i0 | PRJNA1120771 | 17951 | 272 | 3.039301 | 8.26689872 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 49.3 | 1.32e-4 | NR | XP_044566043.1 | 5763 | g17551 | i0 | 42.6 | 0.595588235294118 | 54 | 31 | 59.6 | 0 | 107 | 268 | 107 | 160 | XP_044566043.1 uncharacterized protein FDP41_012590 [Naegleria fowleri] | diamond | 162 | 49.3 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri | ||||
| 30512391 | 30512391 | PRJNA1120771_S_NODE_17313_length_276_cov_1.866953_g16913_i0 | PRJNA1120771 | 17313 | 276 | 1.866953 | 5.15279028 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 97.8 | 6.51e-22 | NR | XP_002682998.1 | 5762 | g16913 | i0 | 59.7 | 0.782608695652174 | 72 | 28 | 77.2 | 1 | 276 | 64 | 277 | 348 | XP_002682998.1 RNA polymerase II transcription factor TFIIH subunit [Naegleria gruberi] | diamond | 216 | 97.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30544070 | 30544070 | PRJNA1120771_S_NODE_5773_length_408_cov_3.282192_g5373_i0 | PRJNA1120771 | 5773 | 408 | 3.282192 | 13.39134336 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 68.9 | 1.57e-10 | NR | XP_002683316.1 | 5762 | g5373 | i0 | 32.3 | 1.86764705882353 | 130 | 87 | 94.9 | 1 | 407 | 21 | 219 | 348 | XP_002683316.1 uncharacterized protein NAEGRDRAFT_61653 [Naegleria gruberi] | diamond | 762 | 68.9 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 30859976 | 30859976 | PRJNA1120771_S_NODE_32274_length_215_cov_2.418605_g31874_i0 | PRJNA1120771 | 32274 | 215 | 2.418605 | 5.20000075 | Naegleria lovaniensis | 51637 | Heterolobosea | other_Eukaryota | 82.8 | 1.07e-16 | NR | XP_044551175.1 | 51637 | g31874 | i0 | 56.9 | 1.78604651162791 | 65 | 28 | 90.7 | 0 | 2 | 196 | 283 | 347 | XP_044551175.1 uncharacterized protein C9374_001515 [Naegleria lovaniensis] | diamond | 384 | 82.8 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria lovaniensis | ||||
| 30954999 | 30954999 | PRJNA1120771_S_NODE_7074_length_379_cov_29.702381_g6674_i0 | PRJNA1120771 | 7074 | 379 | 29.702381 | 112.57202399 | Acrasis kona | 1008807 | Heterolobosea | other_Eukaryota | 109 | 1.89e-27 | NR | KAL0487640.1 | 1008807 | g6674 | i0 | 55.4 | 9.46701846965699 | 101 | 43 | 78.4 | 1 | 379 | 83 | 58 | 158 | KAL0487640.1 ribosomal protein L21 [Acrasis kona] | diamond | 3588 | 109 | 1 | Eukaryota | Discoba | Heterolobosea | Acrasidae | Acrasis | Acrasis kona | ||||
| 31018029 | 31018029 | PRJNA1120771_S_NODE_18895_length_267_cov_1.165179_g18495_i0 | PRJNA1120771 | 18895 | 267 | 1.165179 | 3.11102793 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 149 | 2.39e-39 | NR | XP_002679736.1 | 5762 | g18495 | i0 | 84.1 | 0.98876404494382 | 88 | 14 | 98.9 | 0 | 265 | 2 | 11 | 98 | XP_002679736.1 uncharacterized protein NAEGRDRAFT_65043 [Naegleria gruberi] | diamond | 264 | 149 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 31555705 | 31555705 | PRJNA1120771_S_NODE_26276_length_234_cov_2.277487_g25876_i0 | PRJNA1120771 | 26276 | 234 | 2.277487 | 5.32931958 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 61.2 | 9.88e-9 | NR | XP_002673817.1 | 5762 | g25876 | i0 | 48.7 | 1 | 78 | 37 | 98.7 | 2 | 233 | 3 | 664 | 739 | XP_002673817.1 uncharacterized protein NAEGRDRAFT_71078 [Naegleria gruberi] | diamond | 234 | 61.2 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32125076 | 32125076 | PRJNA1120771_S_NODE_33698_length_211_cov_2.589286_g33298_i0 | PRJNA1120771 | 33698 | 211 | 2.589286 | 5.46339346 | Naegleria gruberi | 5762 | Heterolobosea | other_Eukaryota | 116 | 3e-28 | NR | XP_002681196.1 | 5762 | g33298 | i0 | 84.3 | 1.99052132701422 | 70 | 11 | 99.5 | 0 | 210 | 1 | 556 | 625 | XP_002681196.1 HSP70 family protein [Naegleria gruberi] | diamond | 420 | 116 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria gruberi | ||||
| 32882587 | 32882587 | PRJNA1120771_S_NODE_7780_length_367_cov_1.836420_g7380_i0 | PRJNA1120771 | 7780 | 367 | 1.83642 | 6.7396614 | Naegleria fowleri | 5763 | Heterolobosea | other_Eukaryota | 105 | 1.73e-26 | NR | CAG4719120.1 | 5763 | g7380 | i0 | 49.5 | 0.776566757493188 | 95 | 46 | 76.8 | 2 | 3 | 284 | 23 | 116 | CAG4719120.1 unnamed protein product [Naegleria fowleri] | diamond | 285 | 105 | 1 | Eukaryota | Discoba | Heterolobosea | Vahlkampfiidae | Naegleria | Naegleria fowleri |
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);;