contig_metadata
8 rows where bioproject = "PRJNA986481", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2248851 | 2248851 | PRJNA986481_P_NODE_3902_length_779_cov_4.801370_g3509_i0 | PRJNA986481 | 3902 | 779 | 4.80137 | 37.4026723 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 327 | 5.969999999999999e-109 | NR | XP_013239209.1 | 1485682 | g3509 | i0 | 64.9 | 0.955070603337612 | 248 | 84 | 95.1 | 2 | 768 | 28 | 67 | 312 | XP_013239209.1 mitochondrial phosphate carrier protein 2 [Mitosporidium daphniae] | diamond | 744 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 22650526 | 22650526 | PRJNA986481_P_NODE_28498_length_307_cov_1.980620_g27973_i0 | PRJNA986481 | 28498 | 307 | 1.98062 | 6.0805034 | Astathelohania contejeani | 164912 | Fungi | Fungi | 150 | 8.79e-44 | NR | KAF7683006.1 | 164912 | g27973 | i0 | 69.7 | 0.96742671009772 | 99 | 30 | 96.7 | 0 | 302 | 6 | 73 | 171 | KAF7683006.1 60S ribosomal protein L11 [Astathelohania contejeani] | diamond | 297 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 22949782 | 22949782 | PRJNA986481_P_NODE_2998_length_864_cov_3343.741104_g870_i2 | PRJNA986481 | 2998 | 864 | 3343.741104 | 28889.92313856 | Fungi | 4751 | Fungi | Fungi | 183 | 2.96e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g870 | i2 | 95.652 | 15.21875 | 115 | 4 | 13 | 1 | 7 | 121 | 5650 | 5537 | 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 | 13149 | 183 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 23926545 | 23926545 | PRJNA986481_P_NODE_7259_length_601_cov_2.134058_g6763_i0 | PRJNA986481 | 7259 | 601 | 2.134058 | 12.82568858 | Nematocida displodere | 1805483 | Fungi | Fungi | 56.5 | 0.005 | NTclustered | gi|2797489297|ref|XM_067688031.1| | 1805483 | g6763 | i0 | 100 | 0.0499168053244592 | 30 | 0 | 5 | 0 | 125 | 154 | 1799 | 1828 | Nematocida displodere uncharacterized protein (NEDG_00613), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida displodere | ||||
| 28731838 | 28731838 | PRJNA986481_P_NODE_44547_length_258_cov_1.933014_g44022_i0 | PRJNA986481 | 44547 | 258 | 1.933014 | 4.98717612 | Enteropsectra breve | 1912989 | Fungi | Fungi | 53.9 | 4.98e-6 | NR | KAI5150356.1 | 1912989 | g44022 | i0 | 33.3 | 1.86046511627907 | 81 | 47 | 94.2 | 1 | 15 | 257 | 30 | 103 | KAI5150356.1 hypothetical protein ENBRE01_1449 [Enteropsectra breve] | diamond | 480 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 30816243 | 30816243 | PRJNA986481_P_NODE_17134_length_396_cov_1.610951_g16609_i0 | PRJNA986481 | 17134 | 396 | 1.610951 | 6.37936596 | Astathelohania contejeani | 164912 | Fungi | Fungi | 58.9 | 4.24e-7 | NR | KAF7684054.1 | 164912 | g16609 | i0 | 31.3 | 0.606060606060606 | 80 | 54 | 59.8 | 1 | 2 | 238 | 341 | 420 | KAF7684054.1 ABC transporter G family member 7 [Astathelohania contejeani] | diamond | 240 | 58.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 31163569 | 31163569 | PRJNA986481_P_NODE_34915_length_276_cov_3.295154_g34390_i0 | PRJNA986481 | 34915 | 276 | 3.295154 | 9.09462504 | Edhazardia aedis USNM 41457 | 1003232 | Fungi | Fungi | 44.7 | 0.0115 | NR | EJW02701.1 | 1003232 | g34390 | i0 | 29.6 | 1.06521739130435 | 98 | 54 | 90.2 | 4 | 1 | 249 | 257 | 354 | EJW02701.1 hypothetical protein EDEG_02885 [Edhazardia aedis USNM 41457] | diamond | 294 | 44.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Culicosporidae | Edhazardia | Edhazardia aedis | |||
| 31543453 | 31543453 | PRJNA986481_P_NODE_556_length_1547_cov_2.751669_g431_i0 | PRJNA986481 | 556 | 1547 | 2.751669 | 42.56831943 | Nosema granulosis | 83296 | Fungi | Fungi | 100 | 4.57e-18 | NR | KAF9760669.1 | 83296 | g431 | i0 | 32.8 | 0.467356173238526 | 241 | 142 | 46.3 | 5 | 717 | 1 | 445 | 667 | KAF9760669.1 Transposon Tf2-6 polyprotein [Nosema granulosis] | diamond | 723 | 100 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis |
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);;