contig_metadata
8 rows where bioproject = "PRJNA1059246", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3562190 | 3562190 | PRJNA1059246_P_NODE_47303_length_301_cov_1.350877_g46677_i0 | PRJNA1059246 | 47303 | 301 | 1.350877 | 4.06613977 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 172 | 1.2499999999999996e-52 | NR | XP_013237687.1 | 1485682 | g46677 | i0 | 83.3 | 6.71760797342193 | 96 | 16 | 95.7 | 0 | 4 | 291 | 51 | 146 | XP_013237687.1 uncharacterized protein DI09_3p220 [Mitosporidium daphniae] | diamond | 2022 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 14205722 | 14205722 | PRJNA1059246_P_NODE_36872_length_354_cov_1.096085_g36246_i0 | PRJNA1059246 | 36872 | 354 | 1.096085 | 3.8801409 | Amphiamblys sp. WSBS2 | 1866961 | Fungi | Fungi | 152 | 1.62e-44 | NR | OIR57117.1 | 1866961 | g36246 | i0 | 68.7 | 0.974576271186441 | 115 | 35 | 96.6 | 1 | 13 | 354 | 11 | 125 | OIR57117.1 MAG: 60S ribosomal protein L12 [Amphiamblys sp. WSBS2006] | diamond | 345 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 | |||
| 28803676 | 28803676 | PRJNA1059246_P_NODE_38608_length_344_cov_1.782288_g37982_i0 | PRJNA1059246 | 38608 | 344 | 1.782288 | 6.13107072 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 76.6 | 1.6e-13 | NR | KRH94397.1 | 146866 | g37982 | i0 | 44.1 | 1.82267441860465 | 102 | 50 | 88.1 | 4 | 34 | 336 | 646 | 741 | KRH94397.1 phospholipid-translocating P-type ATPase, flippase [Pseudoloma neurophilia] | diamond | 627 | 76.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28921886 | 28921886 | PRJNA1059246_P_NODE_45408_length_310_cov_1.379747_g44782_i0 | PRJNA1059246 | 45408 | 310 | 1.379747 | 4.2772157 | Opisthokonta | 33154 | Fungi | Fungi | 58.2 | 7.89e-8 | NR | KAG0440815.1 | 279532 | g44782 | i0 | 56.8 | 1.3258064516129 | 44 | 19 | 42.6 | 0 | 8 | 139 | 126 | 169 | KAG0440815.1 60S ribosomal protein L11 [Dictyocoela muelleri] | diamond | 411 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 28961996 | 28961996 | PRJNA1059246_P_NODE_29288_length_406_cov_2.126126_g28663_i0 | PRJNA1059246 | 29288 | 406 | 2.126126 | 8.63207156 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 95.1 | 5.81e-22 | NR | XP_007604594.1 | 993615 | g28663 | i0 | 39 | 0.87192118226601 | 118 | 70 | 87.2 | 1 | 402 | 49 | 14 | 129 | XP_007604594.1 uncharacterized protein VICG_01148 [Vittaforma corneae ATCC 50505] | diamond | 354 | 95.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 29309029 | 29309029 | PRJNA1059246_P_NODE_47669_length_299_cov_2.044248_g47043_i0 | PRJNA1059246 | 47669 | 299 | 2.044248 | 6.11230152 | Amphiamblys sp. WSBS2 | 1866961 | Fungi | Fungi | 43.9 | 0.0265 | NR | OIR58068.1 | 1866961 | g47043 | i0 | 31.2 | 0.77257525083612 | 77 | 52 | 76.3 | 1 | 229 | 2 | 70 | 146 | OIR58068.1 MAG: uncharacterized protein A8A55_1155 [Amphiamblys sp. WSBS2006] | diamond | 231 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 | |||
| 29814120 | 29814120 | PRJNA1059246_P_NODE_14551_length_616_cov_2.009208_g13957_i0 | PRJNA1059246 | 14551 | 616 | 2.009208 | 12.37672128 | Astathelohania contejeani | 164912 | Fungi | Fungi | 62.4 | 7.98e-9 | NR | KAF7683453.1 | 164912 | g13957 | i0 | 44.8 | 0.326298701298701 | 67 | 35 | 32.6 | 1 | 202 | 2 | 40 | 104 | KAF7683453.1 AN1-type zinc finger protein 5 [Astathelohania contejeani] | diamond | 201 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 32343575 | 32343575 | PRJNA1059246_P_NODE_70439_length_243_cov_0.905882_g69813_i0 | PRJNA1059246 | 70439 | 243 | 0.905882 | 2.20129326 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 48.9 | 1.84e-4 | NR | XP_007604861.1 | 993615 | g69813 | i0 | 31.1 | 0.91358024691358 | 74 | 51 | 91.4 | 0 | 7 | 228 | 33 | 106 | XP_007604861.1 uncharacterized protein VICG_01415 [Vittaforma corneae ATCC 50505] | diamond | 222 | 48.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae |
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);;