contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA637328" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 609101 | 609101 | PRJNA637328_P_NODE_6241_length_353_cov_2.894737_g5766_i0 | PRJNA637328 | 6241 | 353 | 2.894737 | 10.21842161 | Encephalitozoon intestinalis | 58839 | Fungi | Fungi | 219 | 3.1099999999999993e-52 | NTclustered | gi|1253338741|ref|XR_002670131.1| | 876142 | g5766 | i0 | 81.229 | 41.943342776204 | 293 | 35 | 81 | 15 | 68 | 353 | 1284 | 1563 | Encephalitozoon intestinalis ATCC 50506 5.8S-23S ribosomal RNA (Eint_010010), rRNA | blastn | 14806 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 3159838 | 3159838 | PRJNA637328_P_NODE_10543_length_289_cov_3.137500_g10068_i0 | PRJNA637328 | 10543 | 289 | 3.1375 | 9.067375 | Microsporidium sp. BIOB | 308919 | Fungi | Fungi | 268 | 2.44e-67 | NTclustered | gi|74831882|emb|AJ871391.1| | 308919 | g10068 | i0 | 85.882 | 58.6851211072664 | 255 | 32 | 88 | 4 | 1 | 254 | 835 | 1086 | Microsporidium sp. BIOB partial 16S rRNA gene and ITS1, clone BIOB | blastn | 16960 | 268 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. BIOB | ||||
| 6258769 | 6258769 | PRJNA637328_P_NODE_2345_length_595_cov_2.005495_g1922_i0 | PRJNA637328 | 2345 | 595 | 2.005495 | 11.93269525 | Enterocytozoonidae | 27970 | Fungi | Fungi | 708 | 0 | NTclustered | gi|768803446|gb|KP759285.1| | 546761 | g1922 | i0 | 88.889 | 96.7764705882353 | 585 | 52 | 97 | 9 | 20 | 595 | 1027 | 447 | Uncultured Enterocytozoonidae clone pEHP-SSU-rRNA-1 18S ribosomal RNA gene, partial sequence | blastn | 57582 | 715 | 0.99020979020979 | Eukaryota | Opisthokonta | Fungi | Microsporidia | uncultured Enterocytozoonidae | |||||
| 12088498 | 12088498 | PRJNA637328_P_NODE_3390_length_482_cov_2.251732_g2924_i0 | PRJNA637328 | 3390 | 482 | 2.251732 | 10.85334824 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 255 | 3.33e-63 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g2924 | i0 | 91.005 | 4.07261410788382 | 189 | 17 | 86 | 0 | 233 | 421 | 2468 | 2280 | 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 | 1963 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 14637902 | 14637902 | PRJNA637328_P_NODE_15012_length_258_cov_4.540670_g14535_i0 | PRJNA637328 | 15012 | 258 | 4.54067 | 11.7149286 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 318 | 2.1e-82 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g14535 | i0 | 95.939 | 1.31007751937985 | 197 | 7 | 76 | 1 | 1 | 196 | 3402 | 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 | 338 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 17186924 | 17186924 | PRJNA637328_P_NODE_1514_length_764_cov_5.377622_g1142_i0 | PRJNA637328 | 1514 | 764 | 5.377622 | 41.08503208 | Microsporidium sp. Loire | 1032359 | Fungi | Fungi | 710 | 0 | NTclustered | gi|333036714|gb|HM566198.1| | 1032359 | g1142 | i0 | 85.818 | 79.2696335078534 | 691 | 72 | 89 | 24 | 86 | 764 | 132 | 808 | Microsporidium sp. Loire small subunit ribosomal RNA gene, partial sequence | blastn | 60562 | 710 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. Loire | ||||
| 19735890 | 19735890 | PRJNA637328_P_NODE_7196_length_332_cov_5.826855_g6721_i0 | PRJNA637328 | 7196 | 332 | 5.826855 | 19.3451586 | Ordospora colligata | 174685 | Fungi | Fungi | 250 | 1.03e-61 | NTclustered | gi|953401030|ref|XR_001377307.1| | 1354746 | g6721 | i0 | 80.588 | 60.0180722891566 | 340 | 53 | 100 | 10 | 1 | 332 | 2005 | 1671 | Ordospora colligata OC4 5.8S-23S ribosomal RNA (M896_150020), rRNA | blastn | 19926 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Ordosporidae | Ordospora | Ordospora colligata | |||
| 22286095 | 22286095 | PRJNA637328_P_NODE_1518_length_763_cov_4.082633_g1146_i0 | PRJNA637328 | 1518 | 763 | 4.082633 | 31.15048979 | Encephalitozoon hellem | 27973 | Fungi | Fungi | 333 | 2.44e-86 | NTclustered | gi|2582629463|ref|XR_009467964.1| | 907965 | g1146 | i0 | 75.923 | 9.84796854521625 | 731 | 130 | 94 | 37 | 13 | 731 | 1233 | 537 | Encephalitozoon hellem ATCC 50504 5.8S-23S ribosomal RNA (EHEL_010010), rRNA | blastn | 7514 | 333 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon hellem | |||
| 23561737 | 23561737 | PRJNA637328_P_NODE_5479_length_375_cov_3.981595_g5004_i0 | PRJNA637328 | 5479 | 375 | 3.981595 | 14.93098125 | Ecytonucleospora hepatopenaei | 646526 | Fungi | Fungi | 377 | 5.18e-100 | NTclustered | gi|2522768008|gb|OR162445.1| | 646526 | g5004 | i0 | 85.519 | 7.67733333333333 | 366 | 47 | 97 | 6 | 1 | 362 | 2201 | 1838 | 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 | 2879 | 377 | 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);;