contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1005695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2703697 | 2703697 | PRJNA1005695_P_NODE_23483_length_310_cov_1.940928_g22631_i0 | PRJNA1005695 | 23483 | 310 | 1.940928 | 6.0168768 | Nosema maddoxi | 2044473 | Fungi | Fungi | 62.1 | 4.81e-5 | NTclustered | gi|1255097405|gb|KY783613.1| | 2044473 | g22631 | i0 | 77.273 | 17.7483870967742 | 110 | 21 | 35 | 4 | 58 | 165 | 267 | 160 | Nosema maddoxi clone 3 large subunit ribosomal RNA gene gene, partial sequence | blastn | 5502 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema maddoxi | |||
| 6531572 | 6531572 | PRJNA1005695_P_NODE_15406_length_387_cov_2.522293_g14554_i0 | PRJNA1005695 | 15406 | 387 | 2.522293 | 9.76127391 | Ordospora pajunii | 3039483 | Fungi | Fungi | 291 | 7.19e-74 | NTclustered | gi|2607439653|ref|XM_060421499.1| | 3039483 | g14554 | i0 | 80.362 | 8.28165374677003 | 387 | 72 | 99 | 4 | 3 | 387 | 442 | 826 | Ordospora pajunii AAA ATPase (HK407_09g15430), partial mRNA | blastn | 3205 | 291 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora pajunii | |||
| 9081082 | 9081082 | PRJNA1005695_P_NODE_36248_length_249_cov_227.840909_g35396_i0 | PRJNA1005695 | 36248 | 249 | 227.840909 | 567.32386341 | Vittaforma corneae | 42399 | Fungi | Fungi | 161 | 3.59e-35 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g35396 | i0 | 83.425 | 27.6586345381526 | 181 | 22 | 71 | 6 | 72 | 249 | 2361 | 2186 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 6887 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 11631950 | 11631950 | PRJNA1005695_P_NODE_10310_length_483_cov_107.107317_g9458_i0 | PRJNA1005695 | 10310 | 483 | 107.107317 | 517.32834111 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 669 | 0 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g9458 | i0 | 91.718 | 92.3105590062112 | 483 | 38 | 99 | 2 | 1 | 482 | 809 | 1290 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 44586 | 669 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila | |||
| 18005273 | 18005273 | PRJNA1005695_P_NODE_2815_length_951_cov_190.194761_g2231_i0 | PRJNA1005695 | 2815 | 951 | 190.194761 | 1808.75217711 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 1016 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g2231 | i0 | 89.049 | 81.8664563617245 | 831 | 76 | 86 | 11 | 1 | 821 | 826 | 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 | 77855 | 1016 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 19279033 | 19279033 | PRJNA1005695_P_NODE_20336_length_334_cov_4.398467_g19484_i0 | PRJNA1005695 | 20336 | 334 | 4.398467 | 14.69087978 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 544 | 4.26e-150 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g19484 | i0 | 96.131 | 107.224550898204 | 336 | 8 | 99 | 3 | 1 | 332 | 3660 | 3994 | 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 | 35813 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 19279239 | 19279239 | PRJNA1005695_P_NODE_836_length_1671_cov_742.887985_g566_i0 | PRJNA1005695 | 836 | 1671 | 742.887985 | 12413.65822935 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 741 | 0 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g566 | i0 | 84.873 | 13.3040095751047 | 747 | 99 | 92 | 14 | 19 | 758 | 1729 | 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 | 22231 | 741 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 24379486 | 24379486 | PRJNA1005695_P_NODE_20580_length_332_cov_3.934363_g19728_i0 | PRJNA1005695 | 20580 | 332 | 3.934363 | 13.06208516 | Ordospora pajunii | 3039483 | Fungi | Fungi | 244 | 4.81e-60 | NTclustered | gi|2607439339|ref|XM_060421342.1| | 3039483 | g19728 | i0 | 80.615 | 2.18373493975904 | 325 | 55 | 97 | 8 | 11 | 331 | 1338 | 1018 | Ordospora pajunii MCMP-loop domain-containing protein (HK407_09g13800), partial mRNA | blastn | 725 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora pajunii |
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);;