contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1196438" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 323267 | 323267 | PRJNA1196438_P_NODE_51781_length_270_cov_2.832487_g51354_i0 | PRJNA1196438 | 51781 | 270 | 2.832487 | 7.6477149 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 255 | 1.76e-63 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g51354 | i0 | 91.005 | 2.48148148148148 | 189 | 17 | 70 | 0 | 60 | 248 | 2280 | 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 | 670 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 2874157 | 2874157 | PRJNA1196438_P_NODE_6263_length_402_cov_3.711246_g5841_i0 | PRJNA1196438 | 6263 | 402 | 3.711246 | 14.91920892 | Ecytonucleospora nucleophila | 1295219 | Fungi | Fungi | 536 | 8.729999999999998e-148 | NTclustered | gi|529283990|gb|KF135643.1| | 1295219 | g5841 | i0 | 90.977 | 88.2014925373134 | 399 | 34 | 99 | 2 | 1 | 398 | 897 | 1294 | Enterospora nucleophila isolate ENTA2 small subunit ribosomal RNA gene, partial sequence | blastn | 35457 | 536 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora nucleophila | |||
| 7976315 | 7976315 | PRJNA1196438_P_NODE_25887_length_303_cov_2.839130_g25461_i0 | PRJNA1196438 | 25887 | 303 | 2.83913 | 8.6025639 | Enterocytozoon sp. ex Acetes sibogae australis | 2881109 | Fungi | Fungi | 385 | 2.45e-102 | NTclustered | gi|2108103202|gb|OK413268.1| | 2881109 | g25461 | i0 | 89.769 | 99.6534653465347 | 303 | 27 | 99 | 3 | 1 | 301 | 791 | 491 | Enterocytozoon sp. ex Acetes sibogae australis isolate RA19015_21 small subunit ribosomal RNA gene, partial sequence | blastn | 30195 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon sp. ex Acetes sibogae australis | |||
| 16900165 | 16900165 | PRJNA1196438_P_NODE_3714_length_506_cov_3.729792_g3303_i0 | PRJNA1196438 | 3714 | 506 | 3.729792 | 18.87274752 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 484 | 4.1199999999999996e-132 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g3303 | i0 | 84.569 | 6.74110671936759 | 499 | 65 | 97 | 12 | 14 | 506 | 1729 | 2221 | 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 | 3411 | 484 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 24549108 | 24549108 | PRJNA1196438_P_NODE_2680_length_592_cov_3.181118_g2279_i0 | PRJNA1196438 | 2680 | 592 | 3.181118 | 18.83221856 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 422 | 3.87e-113 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g2279 | i0 | 95.472 | 14.6570945945946 | 265 | 11 | 82 | 1 | 328 | 591 | 3206 | 3470 | 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 | 8677 | 422 | 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);;