contig_metadata
11 rows where analysis = "diamond", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5712812 | 5712812 | PRJNA637328_P_NODE_9105_length_303_cov_1.799213_g8630_i0 | PRJNA637328 | 9105 | 303 | 1.799213 | 5.45161539 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 173 | 1.34e-49 | NR | EED44298.1 | 481877 | g8630 | i0 | 84 | 0.99009900990099 | 100 | 16 | 99 | 0 | 300 | 1 | 19 | 118 | EED44298.1 protein translation elongation factor EF-1A [Enterocytozoon bieneusi H348] | diamond | 300 | 173 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi | |||
| 26954255 | 26954255 | PRJNA637328_P_NODE_18622_length_243_cov_1.386598_g18145_i0 | PRJNA637328 | 18622 | 243 | 1.386598 | 3.36943314 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 167 | 2.0299999999999998e-48 | NR | OQS55742.1 | 646526 | g18145 | i0 | 96.3 | 0.987654320987654 | 80 | 3 | 98.8 | 0 | 242 | 3 | 205 | 284 | OQS55742.1 ribosomal prt L3 [Enterocytozoon hepatopenaei] | diamond | 240 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 27270600 | 27270600 | PRJNA637328_P_NODE_20523_length_230_cov_2.513812_g20046_i0 | PRJNA637328 | 20523 | 230 | 2.513812 | 5.7817676 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 141 | 4.82e-41 | NR | OQS54120.1 | 646526 | g20046 | i0 | 89.5 | 1.98260869565217 | 76 | 8 | 99.1 | 0 | 228 | 1 | 77 | 152 | OQS54120.1 rps14 [Enterocytozoon hepatopenaei] | diamond | 456 | 141 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 28344257 | 28344257 | PRJNA637328_P_NODE_3566_length_470_cov_1.957245_g3097_i0 | PRJNA637328 | 3566 | 470 | 1.957245 | 9.1990515 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 55.8 | 9.68e-6 | NR | OQS54917.1 | 646526 | g3097 | i0 | 24.4 | 0.995744680851064 | 156 | 105 | 92.6 | 3 | 33 | 467 | 85 | 238 | OQS54917.1 hypothetical protein EHP00_968 [Enterocytozoon hepatopenaei] | diamond | 468 | 55.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 28470713 | 28470713 | PRJNA637328_P_NODE_12246_length_275_cov_1.796460_g11770_i0 | PRJNA637328 | 12246 | 275 | 1.79646 | 4.940265 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 60.5 | 2.69e-8 | NR | OQS53967.1 | 646526 | g11770 | i0 | 32.9 | 0.927272727272727 | 85 | 55 | 92.7 | 1 | 262 | 8 | 236 | 318 | OQS53967.1 hypothetical protein EHP00_1737 [Enterocytozoon hepatopenaei] | diamond | 255 | 60.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 29764969 | 29764969 | PRJNA637328_P_NODE_8651_length_311_cov_2.263359_g8176_i0 | PRJNA637328 | 8651 | 311 | 2.263359 | 7.03904649 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 163 | 1.35e-45 | NR | EED44298.1 | 481877 | g8176 | i0 | 78.6 | 0.993569131832797 | 103 | 22 | 99.4 | 0 | 310 | 2 | 197 | 299 | EED44298.1 protein translation elongation factor EF-1A [Enterocytozoon bieneusi H348] | diamond | 309 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi | |||
| 31376725 | 31376725 | PRJNA637328_P_NODE_5636_length_370_cov_2.065421_g5161_i0 | PRJNA637328 | 5636 | 370 | 2.065421 | 7.6420577 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 153 | 1.01e-41 | NR | OQS55417.1 | 646526 | g5161 | i0 | 58.8 | 0.964864864864865 | 119 | 49 | 96.5 | 0 | 366 | 10 | 102 | 220 | OQS55417.1 hypothetical protein EHP00_2548 [Enterocytozoon hepatopenaei] | diamond | 357 | 153 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 32009280 | 32009280 | PRJNA637328_P_NODE_15178_length_258_cov_0.976077_g14701_i0 | PRJNA637328 | 15178 | 258 | 0.976077 | 2.51827866 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 154 | 8.59e-45 | NR | KRH94073.1 | 146866 | g14701 | i0 | 100 | 0.988372093023256 | 85 | 0 | 98.8 | 0 | 3 | 257 | 120 | 204 | KRH94073.1 hypothetical protein M153_3930006449 [Pseudoloma neurophilia] | diamond | 255 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32262654 | 32262654 | PRJNA637328_P_NODE_14758_length_260_cov_0.966825_g14281_i0 | PRJNA637328 | 14758 | 260 | 0.966825 | 2.513745 | Enterocytozoon hepatopenaei | 646526 | Fungi | Fungi | 112 | 1.97e-26 | NR | OQS54990.1 | 646526 | g14281 | i0 | 68.3 | 0.946153846153846 | 82 | 26 | 94.6 | 0 | 259 | 14 | 698 | 779 | OQS54990.1 spt16 [Enterocytozoon hepatopenaei] | diamond | 246 | 112 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Ecytonucleospora | Ecytonucleospora hepatopenaei | |||
| 32388923 | 32388923 | PRJNA637328_P_NODE_13619_length_266_cov_0.940092_g13143_i0 | PRJNA637328 | 13619 | 266 | 0.940092 | 2.50064472 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 160 | 9.3e-44 | NR | KRH93388.1 | 146866 | g13143 | i0 | 96.6 | 0.992481203007519 | 88 | 3 | 99.2 | 0 | 264 | 1 | 253 | 340 | KRH93388.1 hypothetical protein M153_9450002424 [Pseudoloma neurophilia] | diamond | 264 | 160 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32483976 | 32483976 | PRJNA637328_P_NODE_11619_length_280_cov_1.103896_g11143_i0 | PRJNA637328 | 11619 | 280 | 1.103896 | 3.0909088 | Enterospora canceri | 1081671 | Fungi | Fungi | 58.2 | 1.42e-7 | NR | ORD94919.1 | 1081671 | g11143 | i0 | 42.5 | 1.77857142857143 | 73 | 42 | 78.2 | 0 | 62 | 280 | 154 | 226 | ORD94919.1 hypothetical protein ECANGB1_1915 [Enterospora canceri] | diamond | 498 | 58.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterospora | Enterospora canceri |
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);;