contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA549880" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 511948 | 511948 | PRJNA549880_P_NODE_9021_length_270_cov_1.766497_g8928_i0 | PRJNA549880 | 9021 | 270 | 1.766497 | 4.7695419 | Ordospora pajunii | 3039483 | Fungi | Fungi | 204 | 6.459999999999998e-48 | NTclustered | gi|2607439339|ref|XM_060421342.1| | 3039483 | g8928 | i0 | 80.989 | 2.35555555555556 | 263 | 44 | 96 | 6 | 3 | 262 | 1123 | 1382 | Ordospora pajunii MCMP-loop domain-containing protein (HK407_09g13800), partial mRNA | blastn | 636 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora pajunii | |||
| 3062757 | 3062757 | PRJNA549880_P_NODE_1423_length_593_cov_2.369231_g1332_i0 | PRJNA549880 | 1423 | 593 | 2.369231 | 14.04953983 | Enterocytozoon sp. ex Acetes sibogae australis | 2881109 | Fungi | Fungi | 754 | 0 | NTclustered | gi|2108103202|gb|OK413268.1| | 2881109 | g1332 | i0 | 89.731 | 99.1652613827993 | 594 | 55 | 99 | 5 | 1 | 592 | 856 | 267 | Enterocytozoon sp. ex Acetes sibogae australis isolate RA19015_21 small subunit ribosomal RNA gene, partial sequence | blastn | 58805 | 754 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon sp. ex Acetes sibogae australis | |||
| 3062846 | 3062846 | PRJNA549880_P_NODE_4423_length_359_cov_1.877622_g4330_i0 | PRJNA549880 | 4423 | 359 | 1.877622 | 6.74066298 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 403 | 8.15e-108 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g4330 | i0 | 92.254 | 69.9637883008357 | 284 | 22 | 79 | 0 | 1 | 284 | 284 | 1 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 25117 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila | |||
| 5615722 | 5615722 | PRJNA549880_P_NODE_325_length_1128_cov_5.782938_g275_i0 | PRJNA549880 | 325 | 1128 | 5.782938 | 65.23154064 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 721 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g275 | i0 | 85 | 6.79875886524823 | 720 | 96 | 99 | 12 | 1 | 713 | 1754 | 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 | 7669 | 721 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 9440163 | 9440163 | PRJNA549880_P_NODE_11868_length_248_cov_1.074286_g11775_i0 | PRJNA549880 | 11868 | 248 | 1.074286 | 2.66422928 | Ordospora pajunii | 3039483 | Fungi | Fungi | 204 | 5.849999999999999e-48 | NTclustered | gi|2607439653|ref|XM_060421499.1| | 3039483 | g11775 | i0 | 85 | 3.11290322580645 | 200 | 30 | 81 | 0 | 1 | 200 | 745 | 944 | Ordospora pajunii AAA ATPase (HK407_09g15430), partial mRNA | blastn | 772 | 204 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora pajunii | |||
| 13265862 | 13265862 | PRJNA549880_P_NODE_7031_length_300_cov_1.321586_g6938_i0 | PRJNA549880 | 7031 | 300 | 1.321586 | 3.964758 | Endoreticulatus sp. Zhenjiang | 550794 | Fungi | Fungi | 224 | 5.59e-54 | NTclustered | gi|671183987|gb|KJ784483.1| | 550794 | g6938 | i0 | 83.197 | 7.56333333333333 | 244 | 41 | 81 | 0 | 56 | 299 | 1004 | 1247 | Endoreticulatus sp. Zhenjiang alpha-tubulin mRNA, complete cds | blastn | 2269 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. Zhenjiang | ||||
| 19638216 | 19638216 | PRJNA549880_P_NODE_6416_length_312_cov_1.694561_g6323_i0 | PRJNA549880 | 6416 | 312 | 1.694561 | 5.28703032 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 449 | 8.85e-122 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g6323 | i0 | 93.182 | 97.2532051282051 | 308 | 17 | 98 | 3 | 1 | 307 | 1222 | 918 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 30343 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila | |||
| 24737909 | 24737909 | PRJNA549880_P_NODE_1760_length_539_cov_5.581545_g1668_i0 | PRJNA549880 | 1760 | 539 | 5.581545 | 30.08452755 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 523 | 9.339999999999997e-144 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g1668 | i0 | 95.706 | 29.8497217068646 | 326 | 13 | 80 | 1 | 1 | 325 | 3531 | 3206 | 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 | 16089 | 523 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei |
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);;