contig_metadata
6 rows where bioproject = "PRJNA744060", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3274894 | 3274894 | PRJNA744060_P_NODE_46523_length_249_cov_0.886364_g46194_i0 | PRJNA744060 | 46523 | 249 | 0.886364 | 2.20704636 | Pleistophora mulleri | 249366 | Fungi | Fungi | 350 | 7.14e-92 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g46194 | i0 | 92.339 | 27.9116465863454 | 248 | 15 | 99 | 4 | 1 | 247 | 3452 | 3208 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 6950 | 350 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 27757988 | 27757988 | PRJNA744060_P_NODE_5204_length_692_cov_3.596123_g4898_i0 | PRJNA744060 | 5204 | 692 | 3.596123 | 24.88517116 | root | 1 | Root_unresolved | Root_unresolved | 101 | 9.06e-22 | NR | KAF7684878.1 | 658444 | g4898 | i0 | 33.7 | 1.68208092485549 | 187 | 109 | 80.2 | 2 | 570 | 16 | 46 | 219 | KAF7684878.1 hypothetical protein CDIK_4373 [Cucumispora dikerogammari] | diamond | 1164 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 29768328 | 29768328 | PRJNA744060_P_NODE_7231_length_592_cov_3.173410_g6908_i0 | PRJNA744060 | 7231 | 592 | 3.17341 | 18.7865872 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 153 | 8.159999999999998e-43 | NR | XP_013236563.1 | 1485682 | g6908 | i0 | 60.3 | 2.35135135135135 | 121 | 48 | 61.3 | 0 | 421 | 59 | 71 | 191 | XP_013236563.1 uncharacterized protein DI09_88p90 [Mitosporidium daphniae] | diamond | 1392 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 30779402 | 30779402 | PRJNA744060_P_NODE_25854_length_320_cov_1.263158_g25525_i0 | PRJNA744060 | 25854 | 320 | 1.263158 | 4.0421056 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 135 | 1.9399999999999993e-34 | NR | KAG0442401.1 | 279532 | g25525 | i0 | 65.7 | 0.984375 | 105 | 35 | 98.4 | 1 | 5 | 319 | 137 | 240 | KAG0442401.1 DNA topoisomerase 2 [Dictyocoela muelleri] | diamond | 315 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 30779436 | 30779436 | PRJNA744060_P_NODE_4534_length_740_cov_3.668666_g4238_i0 | PRJNA744060 | 4534 | 740 | 3.668666 | 27.1481284 | Enteropsectra breve | 1912989 | Fungi | Fungi | 83.2 | 2.08e-15 | NR | KAI5151745.1 | 1912989 | g4238 | i0 | 37.2 | 0.912162162162162 | 121 | 71 | 49.1 | 1 | 619 | 257 | 40 | 155 | KAI5151745.1 hypothetical protein ENBRE01_2355 [Enteropsectra breve] | diamond | 675 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 32833867 | 32833867 | PRJNA744060_P_NODE_38880_length_266_cov_2.321244_g38551_i0 | PRJNA744060 | 38880 | 266 | 2.321244 | 6.17450904 | Amphiamblys sp. WSBS2 | 1866961 | Fungi | Fungi | 86.7 | 5.6e-18 | NR | OIR59186.1 | 1866961 | g38551 | i0 | 57.1 | 2.17669172932331 | 63 | 27 | 71.1 | 0 | 196 | 8 | 5 | 67 | OIR59186.1 MAG: translation initiation factor eIF3 subunit 2 [Amphiamblys sp. WSBS2006] | diamond | 579 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 |
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);;