contig_metadata
10 rows where bioproject = "PRJNA493828", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1749954 | 1749954 | PRJNA493828_P_NODE_6682_length_429_cov_11.078652_g6276_i0 | PRJNA493828 | 6682 | 429 | 11.078652 | 47.52741708 | Microsporidium sp. 3 NR-2013 | 1333714 | Fungi | Fungi | 732 | 0 | NTclustered | gi|499157845|gb|JX839890.1| | 1333714 | g6276 | i0 | 97.436 | 81.6596736596737 | 429 | 11 | 100 | 0 | 1 | 429 | 1222 | 794 | Microsporidium sp. 3 NR-2013 small subunit ribosomal RNA gene, partial sequence | blastn | 35032 | 732 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. 3 NR-2013 | ||||
| 3025573 | 3025573 | PRJNA493828_P_NODE_27243_length_263_cov_17.484211_g26824_i0 | PRJNA493828 | 27243 | 263 | 17.484211 | 45.98347493 | Vittaforma corneae | 42399 | Fungi | Fungi | 154 | 6.4e-33 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g26824 | i0 | 83.051 | 24.6653992395437 | 177 | 22 | 66 | 6 | 90 | 263 | 2361 | 2190 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 6487 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 6852668 | 6852668 | PRJNA493828_P_NODE_6406_length_437_cov_14.969780_g6006_i0 | PRJNA493828 | 6406 | 437 | 14.96978 | 65.4179386 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 571 | 2.6199999999999993e-158 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g6006 | i0 | 90.698 | 90.2151029748284 | 430 | 38 | 98 | 2 | 9 | 437 | 1294 | 866 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 39424 | 571 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila | |||
| 6852684 | 6852684 | PRJNA493828_P_NODE_7446_length_410_cov_3.296736_g7034_i0 | PRJNA493828 | 7446 | 410 | 3.296736 | 13.5166176 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 211 | 6.14e-50 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g7034 | i0 | 83.621 | 14.4292682926829 | 232 | 30 | 71 | 4 | 125 | 356 | 5271 | 5494 | 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 | 5916 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 10678105 | 10678105 | PRJNA493828_P_NODE_1669_length_828_cov_9.002649_g1358_i0 | PRJNA493828 | 1669 | 828 | 9.002649 | 74.54193372 | Microsporidium sp. LVPEI.SMW V3S1-FR | 1734473 | Fungi | Fungi | 1469 | 0 | NTclustered | gi|937656209|gb|KR303710.1| | 1734473 | g1358 | i0 | 99.875 | 90.6980676328502 | 799 | 0 | 96 | 1 | 1 | 799 | 798 | 1 | Microsporidium sp. LVPEI.SMW V3S1-FR small subunit ribosomal RNA gene, partial sequence | blastn | 75098 | 1469 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. LVPEI.SMW V3S1-FR | ||||
| 10678413 | 10678413 | PRJNA493828_P_NODE_369_length_1587_cov_7.037649_g240_i0 | PRJNA493828 | 369 | 1587 | 7.037649 | 111.68748963 | Vittaforma corneae | 42399 | Fungi | Fungi | 1748 | 0 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g240 | i0 | 86.621 | 13.296786389414 | 1592 | 200 | 100 | 12 | 1 | 1587 | 12 | 1595 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 21102 | 1748 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 14503402 | 14503402 | PRJNA493828_P_NODE_26712_length_265_cov_2.385417_g26293_i0 | PRJNA493828 | 26712 | 265 | 2.385417 | 6.32135505 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 444 | 3.42e-120 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g26293 | i0 | 96.981 | 37.0566037735849 | 265 | 7 | 100 | 1 | 1 | 265 | 3923 | 3660 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 9820 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 15777147 | 15777147 | PRJNA493828_P_NODE_1733_length_812_cov_11.642760_g1421_i0 | PRJNA493828 | 1733 | 812 | 11.642760000000001 | 94.5392112 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 1003 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g1421 | i0 | 89.038 | 95.5406403940887 | 821 | 75 | 99 | 11 | 2 | 812 | 826 | 11 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 77579 | 1003 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 15777407 | 15777407 | PRJNA493828_P_NODE_353_length_1618_cov_17.886731_g228_i0 | PRJNA493828 | 353 | 1618 | 17.886731 | 289.40730758 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 721 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g228 | i0 | 84.924 | 12.1081582200247 | 723 | 97 | 93 | 12 | 1 | 716 | 1751 | 2468 | Enterocytozoon hepatopenaei strain SHFX2 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 19591 | 721 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 17684511 | 17684511 | PRJNA493828_P_NODE_6274_length_441_cov_6.502717_g5875_i0 | PRJNA493828 | 6274 | 441 | 6.502717 | 28.67698197 | Fungi | 4751 | Fungi | Fungi | 182 | 5.21e-41 | NTclustered | gi|1378896647|gb|MF278562.1| | 1485682 | g5875 | i0 | 95.614 | 27.6077097505669 | 114 | 4 | 26 | 1 | 71 | 184 | 5649 | 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 | 12175 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae |
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);;