contig_metadata
6 rows where bioproject = "PRJNA884104", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3793128 | 3793128 | PRJNA884104_S_NODE_25163_length_404_cov_1.716012_g24420_i0 | PRJNA884104 | 25163 | 404 | 1.716012 | 6.93268848 | Fungi | 4751 | Fungi | Fungi | 182 | 4.74e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g24420 | i0 | 95.614 | 30.1361386138614 | 114 | 4 | 28 | 1 | 225 | 338 | 5537 | 5649 | Mitosporidium daphniae strain UGP3 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 12175 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 29715616 | 29715616 | PRJNA884104_S_NODE_86350_length_241_cov_0.916667_g85607_i0 | PRJNA884104 | 86350 | 241 | 0.916667 | 2.20916747 | root | 1 | Root_unresolved | Root_unresolved | 95.5 | 1.39e-21 | NR | XP_065330340.1 | 6039 | g85607 | i0 | 59 | 5.77593360995851 | 78 | 31 | 97.1 | 1 | 6 | 239 | 126 | 202 | XP_065330340.1 cyclin-dependent kinase [Vairimorpha necatrix] | diamond | 1392 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha necatrix | |||
| 29771010 | 29771010 | PRJNA884104_S_NODE_84511_length_242_cov_0.911243_g83768_i0 | PRJNA884104 | 84511 | 242 | 0.911243 | 2.20520806 | Astathelohania contejeani | 164912 | Fungi | Fungi | 98.2 | 1.14e-21 | NR | KAF7683634.1 | 164912 | g83768 | i0 | 61.7 | 9.01239669421488 | 81 | 28 | 99.2 | 3 | 242 | 3 | 139 | 217 | KAF7683634.1 DNA-directed RNA polymerase II subunit RPB2 [Astathelohania contejeani] | diamond | 2181 | 98.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 30655682 | 30655682 | PRJNA884104_S_NODE_74433_length_248_cov_0.880000_g73690_i0 | PRJNA884104 | 74433 | 248 | 0.88 | 2.1824 | Edhazardia aedis USNM 41457 | 1003232 | Fungi | Fungi | 62.8 | 1.09e-9 | NR | EJW04091.1 | 1003232 | g73690 | i0 | 68.1 | 1.72983870967742 | 47 | 14 | 56.9 | 1 | 150 | 10 | 46 | 91 | EJW04091.1 small GTP-binding protein domain [Edhazardia aedis USNM 41457] | diamond | 429 | 62.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Culicosporidae | Edhazardia | Edhazardia aedis | |||
| 31066688 | 31066688 | PRJNA884104_S_NODE_13595_length_546_cov_1.465116_g12862_i0 | PRJNA884104 | 13595 | 546 | 1.465116 | 7.99953336 | Anncaliia algerae PRA339 | 1288291 | Fungi | Fungi | 139 | 8.349999999999998e-37 | NR | KCZ80352.1 | 1288291 | g12862 | i0 | 41.4 | 3.97802197802198 | 181 | 95 | 98.9 | 3 | 5 | 544 | 8 | 178 | KCZ80352.1 CMGC/CDK/CDC2 protein kinase [Anncaliia algerae PRA339] | diamond | 2172 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae | |||
| 31604074 | 31604074 | PRJNA884104_S_NODE_25816_length_399_cov_2.349693_g25073_i0 | PRJNA884104 | 25816 | 399 | 2.349693 | 9.37527507 | Encephalitozoon intestinalis | 58839 | Fungi | Fungi | 51.6 | 1.46e-4 | NR | UTX44965.1 | 58839 | g25073 | i0 | 46.8 | 0.353383458646617 | 47 | 25 | 35.3 | 0 | 394 | 254 | 349 | 395 | UTX44965.1 AAA domain-containing protein [Encephalitozoon intestinalis] | diamond | 141 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis |
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);;