contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA942359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26961817 | 26961817 | PRJNA942359_P_NODE_7062_length_321_cov_1.258065_g6947_i0 | PRJNA942359 | 7062 | 321 | 1.258065 | 4.03838865 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 194 | 5.82e-61 | NR | EOB14106.1 | 578461 | g6947 | i0 | 99.1 | 0.990654205607477 | 106 | 1 | 99.1 | 0 | 2 | 319 | 65 | 170 | EOB14106.1 hypothetical protein NBO_38g0017 [Nosema bombycis CQ1] | diamond | 318 | 194 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 27056939 | 27056939 | PRJNA942359_P_NODE_15142_length_250_cov_0.881356_g15027_i0 | PRJNA942359 | 15142 | 250 | 0.881356 | 2.20339 | Nosema granulosis | 83296 | Fungi | Fungi | 115 | 1.05e-27 | NR | KAF9763186.1 | 83296 | g15027 | i0 | 67.1 | 0.948 | 79 | 26 | 94.8 | 0 | 250 | 14 | 544 | 622 | KAF9763186.1 putative trehalose-phosphatase [Nosema granulosis] | diamond | 237 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 27499348 | 27499348 | PRJNA942359_P_NODE_14883_length_250_cov_0.881356_g14768_i0 | PRJNA942359 | 14883 | 250 | 0.881356 | 2.20339 | Nosema granulosis | 83296 | Fungi | Fungi | 145 | 2.64e-38 | NR | KAF9763467.1 | 83296 | g14768 | i0 | 85.5 | 0.996 | 83 | 12 | 99.6 | 0 | 249 | 1 | 608 | 690 | KAF9763467.1 Ribonucleoside-diphosphate reductase large chain [Nosema granulosis] | diamond | 249 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 27972868 | 27972868 | PRJNA942359_P_NODE_17685_length_246_cov_0.901734_g17570_i0 | PRJNA942359 | 17685 | 246 | 0.901734 | 2.21826564 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 122 | 2.22e-31 | NR | EOB13726.1 | 578461 | g17570 | i0 | 92.9 | 0.853658536585366 | 70 | 4 | 85.4 | 1 | 244 | 35 | 269 | 337 | EOB13726.1 Putative methyltransferase NSUN5 [Nosema bombycis CQ1] | diamond | 210 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 28288428 | 28288428 | PRJNA942359_P_NODE_9426_length_287_cov_0.803738_g9311_i0 | PRJNA942359 | 9426 | 287 | 0.803738 | 2.30672806 | Pancytospora philotis | 1923975 | Fungi | Fungi | 77 | 4.22e-16 | NR | KAI4291603.1 | 1923975 | g9311 | i0 | 38.8 | 1.76655052264808 | 85 | 51 | 88.9 | 1 | 268 | 14 | 4 | 87 | KAI4291603.1 glutaredoxin 3 [Pancytospora philotis] | diamond | 507 | 77 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora philotis | ||||
| 29078093 | 29078093 | PRJNA942359_P_NODE_12208_length_259_cov_1.537634_g12093_i0 | PRJNA942359 | 12208 | 259 | 1.537634 | 3.98247206 | Encephalitozoon intestinalis ATCC 5 | 58839 | Fungi | Fungi | 78.2 | 1.49e-15 | NR | XP_003073460.1 | 876142 | g12093 | i0 | 41.9 | 0.996138996138996 | 86 | 49 | 98.5 | 1 | 255 | 1 | 9 | 94 | XP_003073460.1 uncharacterized protein Eint_081680 [Encephalitozoon intestinalis ATCC 50506] | diamond | 258 | 78.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 29488218 | 29488218 | PRJNA942359_P_NODE_8990_length_291_cov_1.279817_g8875_i0 | PRJNA942359 | 8990 | 291 | 1.279817 | 3.72426747 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 176 | 3.02e-49 | NR | EOB13243.1 | 578461 | g8875 | i0 | 95.5 | 0.917525773195876 | 89 | 4 | 91.8 | 0 | 290 | 24 | 690 | 778 | EOB13243.1 M1 family aminopeptidase 1 [Nosema bombycis CQ1] | diamond | 267 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 29898998 | 29898998 | PRJNA942359_P_NODE_13091_length_253_cov_0.866667_g12976_i0 | PRJNA942359 | 13091 | 253 | 0.866667 | 2.19266751 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 157 | 3.55e-46 | NR | KRH95105.1 | 146866 | g12976 | i0 | 100 | 0.936758893280632 | 79 | 0 | 93.7 | 0 | 17 | 253 | 1 | 79 | KRH95105.1 Transcription factor E2F/dimerization partner (TDP) [Pseudoloma neurophilia] | diamond | 237 | 157 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 30088412 | 30088412 | PRJNA942359_P_NODE_6812_length_326_cov_0.909091_g6697_i0 | PRJNA942359 | 6812 | 326 | 0.909091 | 2.96363666 | Encephalitozoon intestinalis ATCC 5 | 58839 | Fungi | Fungi | 104 | 2.3599999999999997e-25 | NR | XP_003073460.1 | 876142 | g6697 | i0 | 52.3 | 0.809815950920245 | 88 | 42 | 81 | 0 | 322 | 59 | 45 | 132 | XP_003073460.1 uncharacterized protein Eint_081680 [Encephalitozoon intestinalis ATCC 50506] | diamond | 264 | 104 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 30214659 | 30214659 | PRJNA942359_P_NODE_16072_length_248_cov_0.891429_g15957_i0 | PRJNA942359 | 16072 | 248 | 0.891429 | 2.21074392 | Encephalitozoon hellem ATCC 5 | 27973 | Fungi | Fungi | 111 | 1.38e-29 | NR | XP_003887683.1 | 907965 | g15957 | i0 | 72 | 0.991935483870968 | 82 | 23 | 99.2 | 0 | 3 | 248 | 8 | 89 | XP_003887683.1 60S ribosomal protein L35 [Encephalitozoon hellem ATCC 50504] | diamond | 246 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon hellem | |||
| 30348562 | 30348562 | PRJNA942359_P_NODE_16172_length_248_cov_0.891429_g16057_i0 | PRJNA942359 | 16172 | 248 | 0.891429 | 2.21074392 | Encephalitozoon | 6033 | Fungi | Fungi | 69.7 | 1.88e-12 | NR | XP_003073168.1 | 876142 | g16057 | i0 | 48.1 | 1.97177419354839 | 81 | 33 | 98 | 2 | 248 | 6 | 20 | 91 | XP_003073168.1 uncharacterized protein Eint_070440 [Encephalitozoon intestinalis ATCC 50506] | diamond | 489 | 69.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon intestinalis | |||
| 31068099 | 31068099 | PRJNA942359_P_NODE_15295_length_249_cov_1.539773_g15180_i0 | PRJNA942359 | 15295 | 249 | 1.539773 | 3.83403477 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 96.3 | 1.06e-23 | NR | EOB11505.1 | 578461 | g15180 | i0 | 100 | 0.602409638554217 | 50 | 0 | 60.2 | 0 | 248 | 99 | 4 | 53 | EOB11505.1 hypothetical protein NBO_1116g0003 [Nosema bombycis CQ1] | diamond | 150 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 32364922 | 32364922 | PRJNA942359_P_NODE_15379_length_249_cov_0.886364_g15264_i0 | PRJNA942359 | 15379 | 249 | 0.886364 | 2.20704636 | Nosema granulosis | 83296 | Fungi | Fungi | 103 | 5.24e-24 | NR | KAF9763179.1 | 83296 | g15264 | i0 | 61.5 | 0.939759036144578 | 78 | 29 | 94 | 1 | 237 | 4 | 199 | 275 | KAF9763179.1 Solute carrier family 2, facilitated glucose transporter member 3 [Nosema granulosis] | diamond | 234 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 32680339 | 32680339 | PRJNA942359_P_NODE_4560_length_383_cov_1.438710_g4445_i0 | PRJNA942359 | 4560 | 383 | 1.43871 | 5.5102593 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 48.5 | 3.81e-4 | NR | EOB11563.1 | 578461 | g4445 | i0 | 93.3 | 0.234986945169713 | 30 | 1 | 22.7 | 1 | 102 | 16 | 58 | 87 | EOB11563.1 hypothetical protein NBO_1058g0001 [Nosema bombycis CQ1] | diamond | 90 | 48.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis | |||
| 32900887 | 32900887 | PRJNA942359_P_NODE_15520_length_249_cov_0.886364_g15405_i0 | PRJNA942359 | 15520 | 249 | 0.886364 | 2.20704636 | Nosema bombycis CQ1 | 578461 | Fungi | Fungi | 121 | 3.78e-30 | NR | EOB12162.1 | 578461 | g15405 | i0 | 73.2 | 0.987951807228916 | 82 | 22 | 98.8 | 0 | 1 | 246 | 195 | 276 | EOB12162.1 ATP-binding cassette sub-family B member 7, mitochondrial, partial [Nosema bombycis CQ1] | diamond | 246 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema bombycis |
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);;