contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1204310" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6707299 | 6707299 | PRJNA1204310_P_NODE_49026_length_259_cov_1.967742_g48729_i0 | PRJNA1204310 | 49026 | 259 | 1.967742 | 5.09645178 | Ordospora pajunii | 3039483 | Fungi | Fungi | 202 | 2.2099999999999997e-47 | NTclustered | gi|2607439653|ref|XM_060421499.1| | 3039483 | g48729 | i0 | 80.695 | 10.1274131274131 | 259 | 50 | 100 | 0 | 1 | 259 | 638 | 896 | Ordospora pajunii AAA ATPase (HK407_09g15430), partial mRNA | blastn | 2623 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora pajunii | |||
| 10532475 | 10532475 | PRJNA1204310_P_NODE_13289_length_484_cov_13.236010_g12992_i0 | PRJNA1204310 | 13289 | 484 | 13.23601 | 64.0622884 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 449 | 1.4299999999999995e-121 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g12992 | i0 | 84.067 | 6.86570247933884 | 477 | 64 | 97 | 12 | 1 | 471 | 2199 | 1729 | 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 | 3323 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 13082960 | 13082960 | PRJNA1204310_P_NODE_40891_length_290_cov_1.078341_g40594_i0 | PRJNA1204310 | 40891 | 290 | 1.078341 | 3.1271889 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 466 | 8.09e-127 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g40594 | i0 | 95.578 | 17.3241379310345 | 294 | 8 | 100 | 3 | 1 | 290 | 3973 | 3681 | 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 | 5024 | 466 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 18180514 | 18180514 | PRJNA1204310_P_NODE_2415_length_1026_cov_1.924449_g2217_i0 | PRJNA1204310 | 2415 | 1026 | 1.924449 | 19.74484674 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 1051 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g2217 | i0 | 89.294 | 77.7153996101365 | 850 | 76 | 82 | 11 | 1 | 840 | 845 | 1 | 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 | 79736 | 1051 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 23280895 | 23280895 | PRJNA1204310_P_NODE_1799_length_1149_cov_9.026022_g1624_i0 | PRJNA1204310 | 1799 | 1149 | 9.026022 | 103.70899278 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 516 | 3.45e-141 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g1624 | i0 | 86.214 | 13.579634464752 | 486 | 56 | 90 | 10 | 258 | 738 | 2533 | 3012 | 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 | 15603 | 516 | 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);;