contig_metadata
12 rows where bioproject = "PRJNA760904", tax_kingdom = "Fungi" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10946401 | 10946401 | PRJNA760904_P_NODE_9169_length_296_cov_2.071749_g9112_i0 | PRJNA760904 | 9169 | 296 | 2.071749 | 6.13237704 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 192 | 3.52e-58 | NR | KRH95160.1 | 146866 | g9112 | i0 | 99 | 0.983108108108108 | 97 | 1 | 98.3 | 0 | 294 | 4 | 259 | 355 | KRH95160.1 actin [Pseudoloma neurophilia] | diamond | 291 | 192 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 26609686 | 26609686 | PRJNA760904_P_NODE_11621_length_274_cov_1.278607_g11564_i0 | PRJNA760904 | 11621 | 274 | 1.278607 | 3.50338318 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 195 | 6.959999999999998e-56 | NR | KRH94929.1 | 146866 | g11564 | i0 | 100 | 0.996350364963504 | 91 | 0 | 99.6 | 0 | 274 | 2 | 234 | 324 | KRH94929.1 Elongation factor 2 [Pseudoloma neurophilia] | diamond | 273 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 26831672 | 26831672 | PRJNA760904_P_NODE_9541_length_291_cov_1.894495_g9484_i0 | PRJNA760904 | 9541 | 291 | 1.894495 | 5.51298045 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 146 | 3.05e-38 | NR | KRH94565.1 | 146866 | g9484 | i0 | 99 | 1 | 97 | 1 | 100 | 0 | 291 | 1 | 724 | 820 | KRH94565.1 hypothetical protein M153_2090009003 [Pseudoloma neurophilia] | diamond | 291 | 146 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27147500 | 27147500 | PRJNA760904_P_NODE_11482_length_275_cov_1.366337_g11425_i0 | PRJNA760904 | 11482 | 275 | 1.366337 | 3.75742675 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 71.6 | 3.73e-12 | NR | KRH95319.1 | 146866 | g11425 | i0 | 94.9 | 0.425454545454545 | 39 | 2 | 42.5 | 0 | 118 | 2 | 173 | 211 | KRH95319.1 kinesin [Pseudoloma neurophilia] | diamond | 117 | 71.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27147509 | 27147509 | PRJNA760904_P_NODE_19182_length_243_cov_1.470588_g19125_i0 | PRJNA760904 | 19182 | 243 | 1.470588 | 3.57352884 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 45.1 | 0.00508 | NR | KRH92058.1 | 146866 | g19125 | i0 | 100 | 0.283950617283951 | 23 | 0 | 28.4 | 0 | 70 | 2 | 1 | 23 | KRH92058.1 putative transporter, partial [Pseudoloma neurophilia] | diamond | 69 | 45.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 27590430 | 27590430 | PRJNA760904_P_NODE_5364_length_370_cov_1.656566_g5307_i0 | PRJNA760904 | 5364 | 370 | 1.656566 | 6.1292942 | Nematocida ausubeli | 1913371 | Fungi | Fungi | 47.4 | 0.00361 | NR | EHY65481.1 | 1913371 | g5307 | i0 | 51.1 | 0.689189189189189 | 45 | 20 | 34.9 | 1 | 240 | 368 | 766 | 810 | EHY65481.1 hypothetical protein NERG_01088 [Nematocida ausubeli] | diamond | 255 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida ausubeli | ||||
| 27937630 | 27937630 | PRJNA760904_P_NODE_18265_length_245_cov_0.895349_g18208_i0 | PRJNA760904 | 18265 | 245 | 0.895349 | 2.19360505 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 135 | 9.97e-36 | NR | KRH93795.1 | 146866 | g18208 | i0 | 98.8 | 0.991836734693878 | 81 | 1 | 99.2 | 0 | 3 | 245 | 134 | 214 | KRH93795.1 hypothetical protein M153_5670001766 [Pseudoloma neurophilia] | diamond | 243 | 135 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 28726890 | 28726890 | PRJNA760904_P_NODE_20327_length_241_cov_2.648810_g20270_i0 | PRJNA760904 | 20327 | 241 | 2.64881 | 6.3836321 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 157 | 7.44e-48 | NR | KRH91784.1 | 146866 | g20270 | i0 | 100 | 0.995850622406639 | 80 | 0 | 99.6 | 0 | 240 | 1 | 18 | 97 | KRH91784.1 60S ribosomal protein L31 [Pseudoloma neurophilia] | diamond | 240 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 29863522 | 29863522 | PRJNA760904_P_NODE_15011_length_251_cov_0.865169_g14954_i0 | PRJNA760904 | 15011 | 251 | 0.865169 | 2.17157419 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 163 | 2.09e-49 | NR | KRH92832.1 | 146866 | g14954 | i0 | 100 | 0.99203187250996006 | 83 | 0 | 99.2 | 0 | 251 | 3 | 9 | 91 | KRH92832.1 60S ribosomal protein L19 [Pseudoloma neurophilia] | diamond | 249 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31886335 | 31886335 | PRJNA760904_P_NODE_19737_length_242_cov_1.822485_g19680_i0 | PRJNA760904 | 19737 | 242 | 1.822485 | 4.4104137 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 108 | 3.47e-25 | NR | KRH93353.1 | 146866 | g19680 | i0 | 100 | 0.632231404958678 | 51 | 0 | 63.2 | 0 | 63 | 215 | 338 | 388 | KRH93353.1 26S proteasome regulatory complex, subunit RM153/PSMD2, partial [Pseudoloma neurophilia] | diamond | 153 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 31918034 | 31918034 | PRJNA760904_P_NODE_20117_length_242_cov_0.911243_g20060_i0 | PRJNA760904 | 20117 | 242 | 0.911243 | 2.20520806 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 163 | 3.0699999999999997e-48 | NR | KRH92230.1 | 146866 | g20060 | i0 | 100 | 0.991735537190083 | 80 | 0 | 99.2 | 0 | 3 | 242 | 102 | 181 | KRH92230.1 RNA polymerase III, second largest subunit, partial [Pseudoloma neurophilia] | diamond | 240 | 163 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32582582 | 32582582 | PRJNA760904_P_NODE_10759_length_281_cov_1.475962_g10702_i0 | PRJNA760904 | 10759 | 281 | 1.475962 | 4.14745322 | Anncaliia algerae PRA339 | 1288291 | Fungi | Fungi | 80.1 | 2.9e-15 | NR | KCZ80346.1 | 1288291 | g10702 | i0 | 44.1 | 3.01067615658363 | 93 | 52 | 99.3 | 0 | 3 | 281 | 208 | 300 | KCZ80346.1 actin-1 [Anncaliia algerae PRA339] | diamond | 846 | 80.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Tubulinosematidae | Anncaliia | Anncaliia algerae |
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);;