contig_metadata
13 rows where bioproject = "PRJNA758398", tax_kingdom = "Fungi" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12219393 | 12219393 | PRJNA758398_S_NODE_30290_length_193_cov_1.416667_g30149_i0 | PRJNA758398 | 30290 | 193 | 1.416667 | 2.73416731 | Eukaryota | 2759 | Fungi | Fungi | 97.8 | 1.02e-22 | NR | XP_024331730.1 | 40302 | g30149 | i0 | 75 | 6.52849740932642 | 52 | 13 | 80.8 | 0 | 158 | 3 | 36 | 87 | XP_024331730.1 ser thr protein phosphatase 2-a [Vairimorpha ceranae] | diamond | 1260 | 98.2 | 0.995926680244399 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 16042421 | 16042421 | PRJNA758398_S_NODE_32873_length_186_cov_2.233577_g32732_i0 | PRJNA758398 | 32873 | 186 | 2.233577 | 4.15445322 | Fungi | 4751 | Fungi | Fungi | 96.7 | 6.67e-22 | NR | XP_013238373.1 | 1485682 | g32732 | i0 | 69.4 | 2.98387096774194 | 62 | 19 | 100 | 0 | 186 | 1 | 9 | 70 | XP_013238373.1 uncharacterized protein DI09_23p210 [Mitosporidium daphniae] | diamond | 555 | 96.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 21142294 | 21142294 | PRJNA758398_S_NODE_31397_length_190_cov_1.446809_g31256_i0 | PRJNA758398 | 31397 | 190 | 1.446809 | 2.7489371 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 105 | 4.87e-27 | NR | XP_013239437.1 | 1485682 | g31256 | i0 | 76.2 | 17.9052631578947 | 63 | 15 | 99.5 | 0 | 190 | 2 | 23 | 85 | XP_013239437.1 40S ribosomal protein S16 [Mitosporidium daphniae] | diamond | 3402 | 105 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 23692789 | 23692789 | PRJNA758398_S_NODE_39739_length_171_cov_1.672131_g39598_i0 | PRJNA758398 | 39739 | 171 | 1.672131 | 2.85934401 | Vairimorpha ceranae | 40302 | Fungi | Fungi | 54.7 | 0.004 | NTclustered | gi|1372263220|ref|XM_024476112.1| | 40302 | g39598 | i0 | 96.875 | 0.187134502923977 | 32 | 1 | 19 | 0 | 136 | 167 | 1915 | 1884 | Nosema ceranae phospholipid-transporting p-type (AAJ76_600067730), partial mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 27021447 | 27021447 | PRJNA758398_S_NODE_40722_length_169_cov_1.700000_g40581_i0 | PRJNA758398 | 40722 | 169 | 1.7 | 2.873 | Astathelohania contejeani | 164912 | Fungi | Fungi | 72.4 | 3.23e-13 | NR | KAF7684622.1 | 164912 | g40581 | i0 | 63 | 4.81065088757396 | 54 | 18 | 95.9 | 1 | 164 | 3 | 12 | 63 | KAF7684622.1 Tyrosine--tRNA ligase, cytoplasmic [Astathelohania contejeani] | diamond | 813 | 72.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 28442804 | 28442804 | PRJNA758398_S_NODE_4106_length_467_cov_2.050239_g3965_i0 | PRJNA758398 | 4106 | 467 | 2.050239 | 9.57461613 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 132 | 1.5199999999999996e-34 | NR | OQS54628.1 | 646526 | g3965 | i0 | 44.3 | 1.01498929336188 | 158 | 83 | 98.3 | 1 | 467 | 9 | 105 | 262 | OQS54628.1 PSR2 [Enterocytozoon hepatopenaei] | diamond | 474 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 28852880 | 28852880 | PRJNA758398_S_NODE_13128_length_271_cov_1.608108_g12987_i0 | PRJNA758398 | 13128 | 271 | 1.608108 | 4.35797268 | Ordospora colligata OC4 | 1354746 | Fungi | Fungi | 47 | 0.00165 | NR | XP_014564442.1 | 1354746 | g12987 | i0 | 30.3 | 0.985239852398524 | 89 | 57 | 95.2 | 2 | 10 | 267 | 289 | 375 | XP_014564442.1 serine/threonine protein kinase [Ordospora colligata OC4] | diamond | 267 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora colligata | |||
| 29263420 | 29263420 | PRJNA758398_S_NODE_9889_length_308_cov_1.575290_g9748_i0 | PRJNA758398 | 9889 | 308 | 1.57529 | 4.8518932 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 47 | 0.00244 | NR | XP_013239681.1 | 1485682 | g9748 | i0 | 36.4 | 0.964285714285714 | 99 | 59 | 95.5 | 3 | 299 | 6 | 303 | 398 | XP_013239681.1 uncharacterized protein DI09_100p90 [Mitosporidium daphniae] | diamond | 297 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 29673736 | 29673736 | PRJNA758398_S_NODE_3710_length_491_cov_1.846154_g3569_i0 | PRJNA758398 | 3710 | 491 | 1.846154 | 9.06461614 | Trachipleistophora hominis | 72359 | Fungi | Fungi | 46.2 | 0.0239 | NR | ELQ76795.1 | 72359 | g3569 | i0 | 29.4 | 0.818737270875764 | 68 | 48 | 41.5 | 0 | 385 | 182 | 150 | 217 | ELQ76795.1 Puf family RNA-binding protein [Trachipleistophora hominis] | diamond | 402 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Trachipleistophora | Trachipleistophora hominis | |||
| 30021579 | 30021579 | PRJNA758398_S_NODE_20951_length_223_cov_1.339080_g20810_i0 | PRJNA758398 | 20951 | 223 | 1.33908 | 2.9861484 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 62.8 | 2.39e-9 | NR | XP_013238975.1 | 1485682 | g20810 | i0 | 56.8 | 0.591928251121076 | 44 | 19 | 59.2 | 0 | 167 | 36 | 69 | 112 | XP_013238975.1 lysine-tRNA ligase [Mitosporidium daphniae] | diamond | 132 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 30242718 | 30242718 | PRJNA758398_S_NODE_19652_length_229_cov_0.850000_g19511_i0 | PRJNA758398 | 19652 | 229 | 0.85 | 1.9465 | Amphiamblys sp. WSBS2 | 1866961 | Fungi | Fungi | 60.5 | 6.88e-9 | NR | OIR57958.1 | 1866961 | g19511 | i0 | 53.6 | 0.733624454148472 | 56 | 26 | 73.4 | 0 | 55 | 222 | 34 | 89 | OIR57958.1 MAG: GTPase Rab11/YPT3, small G protein superfamily [Amphiamblys sp. WSBS2006] | diamond | 168 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 | |||
| 32370881 | 32370881 | PRJNA758398_S_NODE_41999_length_167_cov_1.296610_g41858_i0 | PRJNA758398 | 41999 | 167 | 1.29661 | 2.1653387 | Eukaryota | 2759 | Fungi | Fungi | 57.4 | 3.08e-8 | NR | XP_007603575.1 | 993615 | g41858 | i0 | 54.7 | 9.64670658682635 | 53 | 24 | 95.2 | 0 | 159 | 1 | 83 | 135 | XP_007603575.1 uncharacterized protein VICG_00122 [Vittaforma corneae ATCC 50505] | diamond | 1611 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 32771178 | 32771178 | PRJNA758398_S_NODE_43340_length_167_cov_0.864407_g43199_i0 | PRJNA758398 | 43340 | 167 | 0.864407 | 1.44355969 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 57.4 | 6.85e-8 | NR | KAG0421929.1 | 279532 | g43199 | i0 | 50.9 | 0.988023952095808 | 55 | 27 | 98.8 | 0 | 167 | 3 | 175 | 229 | KAG0421929.1 hypothetical protein DMUE_6254, partial [Dictyocoela muelleri] | diamond | 165 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri |
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);;