contig_metadata
7 rows where bioproject = "PRJNA1126661" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5385334 | 5385334 | PRJNA1126661_P_NODE_1605_length_847_cov_5.501292_g1166_i0 | PRJNA1126661 | 1605 | 847 | 5.501292 | 46.59594324 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 1544 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g1166 | i0 | 99.527 | 96.8819362455726 | 846 | 4 | 99 | 0 | 1 | 846 | 15 | 860 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 82059 | 1544 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 7935493 | 7935493 | PRJNA1126661_P_NODE_4387_length_417_cov_4.136628_g3860_i0 | PRJNA1126661 | 4387 | 417 | 4.136628 | 17.24973876 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 771 | 0 | NTclustered | gi|11993647|gb|AF322654.1| | 146866 | g3860 | i0 | 100 | 90.3693045563549 | 417 | 0 | 100 | 0 | 1 | 417 | 900 | 1316 | Pseudoloma neurophilia small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 37684 | 771 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 23235012 | 23235012 | PRJNA1126661_P_NODE_639_length_1684_cov_3.818746_g429_i0 | PRJNA1126661 | 639 | 1684 | 3.818746 | 64.30768264 | Pleistophora mulleri | 249366 | Fungi | Fungi | 1585 | 0 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g429 | i0 | 83.865 | 35.9649643705463 | 1723 | 209 | 99 | 57 | 1 | 1679 | 1375 | 3072 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 60565 | 1585 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 28207127 | 28207127 | PRJNA1126661_P_NODE_73366_length_245_cov_0.906977_g72836_i0 | PRJNA1126661 | 73366 | 245 | 0.906977 | 2.22209365 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 172 | 9.35e-51 | NR | KRH94220.1 | 146866 | g72836 | i0 | 100 | 0.991836734693878 | 81 | 0 | 99.2 | 0 | 245 | 3 | 20 | 100 | KRH94220.1 hypothetical protein M153_3340007368 [Pseudoloma neurophilia] | diamond | 243 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29407053 | 29407053 | PRJNA1126661_P_NODE_51929_length_294_cov_2.809955_g51400_i0 | PRJNA1126661 | 51929 | 294 | 2.809955 | 8.2612677 | Vairimorpha apis BRL | 35231 | Fungi | Fungi | 42.7 | 0.0329 | NR | EQB62323.1 | 1037528 | g51400 | i0 | 33.3 | 0.612244897959184 | 60 | 39 | 61.2 | 1 | 203 | 24 | 76 | 134 | EQB62323.1 hypothetical protein NAPIS_ORF00099 [Vairimorpha apis BRL 01] | diamond | 180 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha apis | |||
| 31461026 | 31461026 | PRJNA1126661_P_NODE_72976_length_246_cov_0.901734_g72446_i0 | PRJNA1126661 | 72976 | 246 | 0.901734 | 2.21826564 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 101 | 7.249999999999999e-23 | NR | KRH93774.1 | 146866 | g72446 | i0 | 94 | 0.817073170731707 | 67 | 4 | 81.7 | 0 | 1 | 201 | 388 | 454 | KRH93774.1 hypothetical protein M153_5780002796 [Pseudoloma neurophilia] | diamond | 201 | 101 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31935121 | 31935121 | PRJNA1126661_P_NODE_71377_length_250_cov_1.322034_g70847_i0 | PRJNA1126661 | 71377 | 250 | 1.322034 | 3.305085 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 155 | 7.18e-47 | NR | XP_008073948.1 | 948595 | g70847 | i0 | 96.3 | 0.984 | 82 | 3 | 98.4 | 0 | 248 | 3 | 37 | 118 | XP_008073948.1 uncharacterized protein VCUG_00927 [Vavraia culicis subsp. floridensis] | diamond | 246 | 155 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis |
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);;