contig_metadata
11 rows where bioproject = "PRJNA741997", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3272800 | 3272800 | PRJNA741997_P_NODE_40583_length_341_cov_1.111940_g39463_i0 | PRJNA741997 | 40583 | 341 | 1.11194 | 3.7917154 | Cucumispora dikerogammari | 658444 | Fungi | Fungi | 83.2 | 6.63e-17 | NR | KAF7700562.1 | 658444 | g39463 | i0 | 42 | 5.39296187683284 | 100 | 40 | 88 | 1 | 302 | 3 | 8 | 89 | KAF7700562.1 Ras-related protein Rab2BV [Cucumispora dikerogammari] | diamond | 1839 | 83.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Cucumispora | Cucumispora dikerogammari | ||||
| 13952142 | 13952142 | PRJNA741997_P_NODE_89971_length_241_cov_0.916667_g88851_i0 | PRJNA741997 | 89971 | 241 | 0.916667 | 2.20916747 | Eukaryota | 2759 | Fungi | Fungi | 279 | 9.14e-71 | NTclustered | gi|272477332|gb|FJ756014.1| | 698107 | g88851 | i0 | 88.841 | 98.5477178423236 | 233 | 18 | 97 | 4 | 1 | 233 | 483 | 707 | Microsporidium sp. BFAS6 small subunit ribosomal RNA gene, partial sequence | blastn | 23750 | 279 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. BFAS6 | ||||
| 22398829 | 22398829 | PRJNA741997_P_NODE_29198_length_406_cov_1.387387_g28078_i0 | PRJNA741997 | 29198 | 406 | 1.387387 | 5.63279122 | Heterosporis sp. NBDP-2013a | 1289055 | Fungi | Fungi | 75 | 8.31e-9 | NTclustered | gi|448278458|gb|KC137554.1| | 1289055 | g28078 | i0 | 95.652 | 0.113300492610837 | 46 | 2 | 11 | 0 | 33 | 78 | 2917 | 2962 | Heterosporis sp. NBDP-2013a isolate MN/CISCO small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 46 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 23674520 | 23674520 | PRJNA741997_P_NODE_45159_length_323_cov_1.084000_g44039_i0 | PRJNA741997 | 45159 | 323 | 1.084 | 3.50132 | Opisthokonta | 33154 | Fungi | Fungi | 107 | 1.42e-24 | NR | KAF7683634.1 | 164912 | g44039 | i0 | 62.2 | 8.46130030959752 | 90 | 31 | 82.7 | 3 | 55 | 321 | 135 | 222 | KAF7683634.1 DNA-directed RNA polymerase II subunit RPB2 [Astathelohania contejeani] | diamond | 2733 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 26999209 | 26999209 | PRJNA741997_P_NODE_58342_length_281_cov_2.221154_g57222_i0 | PRJNA741997 | 58342 | 281 | 2.221154 | 6.24144274 | Eukaryota | 2759 | Fungi | Fungi | 126 | 5.32e-33 | NR | XP_024330457.1 | 40302 | g57222 | i0 | 63 | 8.81850533807829 | 92 | 34 | 98.2 | 0 | 276 | 1 | 55 | 146 | XP_024330457.1 dna repair protein rad51 [Vairimorpha ceranae] | diamond | 2478 | 127 | 0.992125984251969 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha ceranae | |||
| 27873808 | 27873808 | PRJNA741997_P_NODE_69205_length_256_cov_2.142077_g68085_i0 | PRJNA741997 | 69205 | 256 | 2.142077 | 5.48371712 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 44.7 | 0.00694 | NR | OQS53680.1 | 646526 | g68085 | i0 | 39.7 | 1.546875 | 68 | 39 | 79.7 | 1 | 209 | 6 | 64 | 129 | OQS53680.1 nero [Enterocytozoon hepatopenaei] | diamond | 396 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 28568329 | 28568329 | PRJNA741997_P_NODE_22107_length_481_cov_2.674020_g20989_i0 | PRJNA741997 | 22107 | 481 | 2.67402 | 12.8620362 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 80.9 | 1.92e-16 | NR | XP_013237325.1 | 1485682 | g20989 | i0 | 58.3 | 0.854469854469854 | 72 | 30 | 44.9 | 0 | 28 | 243 | 1 | 72 | XP_013237325.1 uncharacterized protein DI09_51p90 [Mitosporidium daphniae] | diamond | 411 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 28568368 | 28568368 | PRJNA741997_P_NODE_63707_length_269_cov_1.571429_g62587_i0 | PRJNA741997 | 63707 | 269 | 1.571429 | 4.22714401 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 96.3 | 7.68e-21 | NR | XP_013239425.1 | 1485682 | g62587 | i0 | 52.8 | 0.992565055762082 | 89 | 42 | 99.3 | 0 | 2 | 268 | 511 | 599 | XP_013239425.1 uncharacterized protein DI09_11p10 [Mitosporidium daphniae] | diamond | 267 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 28673347 | 28673347 | PRJNA741997_P_NODE_47807_length_313_cov_1.279167_g46687_i0 | PRJNA741997 | 47807 | 313 | 1.279167 | 4.00379271 | Opisthokonta | 33154 | Fungi | Fungi | 62 | 6.86e-9 | NR | KAG5858651.1 | 27973 | g46687 | i0 | 33.3 | 2.69329073482428 | 72 | 40 | 69 | 1 | 302 | 87 | 29 | 92 | KAG5858651.1 CHY zinc finger [Encephalitozoon hellem] | diamond | 843 | 62 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon hellem | |||
| 31379872 | 31379872 | PRJNA741997_P_NODE_66176_length_263_cov_2.378947_g65056_i0 | PRJNA741997 | 66176 | 263 | 2.378947 | 6.25663061 | Astathelohania contejeani | 164912 | Fungi | Fungi | 43.5 | 0.0249 | NR | KAF7678001.1 | 164912 | g65056 | i0 | 43.5 | 0.524714828897338 | 46 | 25 | 52.5 | 1 | 21 | 158 | 254 | 298 | KAF7678001.1 putative cell cycle serine/threonine-protein kinase CDC5 like protein [Astathelohania contejeani] | diamond | 138 | 43.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 31379877 | 31379877 | PRJNA741997_P_NODE_74836_length_249_cov_1.750000_g73716_i0 | PRJNA741997 | 74836 | 249 | 1.75 | 4.3575 | Pancytospora epiphaga | 1938578 | Fungi | Fungi | 47 | 0.00125 | NR | KAI5168486.1 | 1938578 | g73716 | i0 | 41.2 | 0.819277108433735 | 68 | 31 | 80.7 | 3 | 248 | 48 | 320 | 379 | KAI5168486.1 hypothetical protein PAEPH01_0174 [Pancytospora epiphaga] | diamond | 204 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora epiphaga |
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);;