contig_metadata
15 rows where bioproject = "PRJEB6584", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25795774 | 25795774 | PRJEB6584h_S_NODE_20915_length_178_cov_3.706294_g20853_i0 | PRJEB6584 | 20915 | 178 | 3.706294 | 6.59720332 | Ichthyosporidium weissii | 1172315 | Fungi | Fungi | 228 | 2.3299999999999995e-55 | NTclustered | gi|384232434|gb|JQ062988.1| | 1172315 | g20853 | i0 | 90.23 | 97.061797752809 | 174 | 17 | 98 | 0 | 1 | 174 | 1551 | 1378 | Ichthyosporidium weissii small subunit ribosomal RNA gene, partial sequence; small subunit rRNA-large subunit rRNA intergenic spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 17277 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Ichthyosporidium | Ichthyosporidium weissii | |||
| 25795806 | 25795806 | PRJEB6584h_S_NODE_57203_length_162_cov_1.259843_g57141_i0 | PRJEB6584 | 57203 | 162 | 1.259843 | 2.04094566 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 196 | 5.89e-46 | NTclustered | gi|667636757|ref|XR_552273.1| | 948595 | g57141 | i0 | 90.541 | 1.81481481481481 | 148 | 14 | 91 | 0 | 15 | 162 | 2636 | 2489 | Vavraia culicis subsp. floridensis 28S ribosomal RNA (VCUG_02832), partial rRNA | blastn | 294 | 196 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 25932093 | 25932093 | PRJEB6584h_S_NODE_8068_length_214_cov_3.837989_g8006_i0 | PRJEB6584 | 8068 | 214 | 3.837989 | 8.21329646 | Pleistophora sp. 1 | 73787 | Fungi | Fungi | 156 | 1.4e-33 | NTclustered | gi|3033524|gb|AF044394.1| | 73787 | g8006 | i0 | 81.553 | 57.7429906542056 | 206 | 22 | 91 | 10 | 3 | 197 | 1346 | 1146 | Pleistophora sp.1 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 12357 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora sp. 1 | |||
| 26068029 | 26068029 | PRJEB6584h_S_NODE_1949_length_330_cov_5.420339_g1887_i0 | PRJEB6584 | 1949 | 330 | 5.420339 | 17.8871187 | Fusasporis stethaprioni | 2777717 | Fungi | Fungi | 488 | 2e-133 | NTclustered | gi|1914073495|gb|MW077214.1| | 2777717 | g1887 | i0 | 93.353 | 95.7333333333333 | 331 | 21 | 100 | 1 | 1 | 330 | 465 | 795 | Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence | blastn | 31592 | 488 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Fusasporis | Fusasporis stethaprioni | |||
| 26204362 | 26204362 | PRJEB6584h_S_NODE_6294_length_229_cov_11.453608_g6232_i0 | PRJEB6584 | 6294 | 229 | 11.453608 | 26.22876232 | Microsporidium sp. LVPEI.SMW V3S1-FR | 1734473 | Fungi | Fungi | 374 | 3.8399999999999996e-99 | NTclustered | gi|937656209|gb|KR303710.1| | 1734473 | g6232 | i0 | 96.46 | 100.519650655022 | 226 | 8 | 99 | 0 | 4 | 229 | 978 | 753 | Microsporidium sp. LVPEI.SMW V3S1-FR small subunit ribosomal RNA gene, partial sequence | blastn | 23019 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Microsporidium | Microsporidium sp. LVPEI.SMW V3S1-FR | ||||
| 26204370 | 26204370 | PRJEB6584h_S_NODE_8222_length_213_cov_3.730337_g8160_i0 | PRJEB6584 | 8222 | 213 | 3.730337 | 7.94561781 | Endoreticulatus sp. CHW-2 | 133530 | Fungi | Fungi | 152 | 1.8e-32 | NTclustered | gi|63095238|gb|AY960111.1| | 262393 | g8160 | i0 | 83.14 | 1.1830985915493 | 172 | 24 | 80 | 4 | 20 | 189 | 562 | 394 | Endoreticulatus sp. CHW-2004 Taiwan large subunit ribosomal RNA gene, complete sequence | blastn | 252 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Endoreticulatus | Endoreticulatus sp. CHW-2004 Taiwan | ||||
| 26204376 | 26204376 | PRJEB6584h_S_NODE_9798_length_204_cov_2.112426_g9736_i0 | PRJEB6584 | 9798 | 204 | 2.112426 | 4.30934904 | Glugoides intestinalis | 174680 | Fungi | Fungi | 257 | 3.51e-64 | NTclustered | gi|113470857|gb|DQ680158.2| | 174680 | g9736 | i0 | 89.655 | 8.65686274509804 | 203 | 19 | 99 | 2 | 1 | 202 | 71 | 272 | Glugoides intestinalis isolate Gi3 23S ribosomal RNA gene, partial sequence; 23S-16S ribosomal RNA spacer, complete sequence; and 16S ribosomal RNA gene, partial sequence | blastn | 1766 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugoides | Glugoides intestinalis | |||
| 26340127 | 26340127 | PRJEB6584h_S_NODE_21919_length_177_cov_2.845070_g21857_i0 | PRJEB6584 | 21919 | 177 | 2.84507 | 5.0357739 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 182 | 1.83e-41 | NTclustered | gi|667639983|ref|XR_552275.1| | 993615 | g21857 | i0 | 85.475 | 4.11299435028249 | 179 | 20 | 99 | 5 | 2 | 177 | 967 | 1142 | Vittaforma corneae ATCC 50505 28S ribosomal RNA (VICG_02297), rRNA | blastn | 728 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 26568100 | 26568100 | PRJEB6584h_S_NODE_1216_length_378_cov_2.862974_g1154_i0 | PRJEB6584 | 1216 | 378 | 2.862974 | 10.82204172 | Vittaforma | 42398 | Fungi | Fungi | 603 | 7.929999999999999e-168 | NTclustered | gi|38489197|gb|AY375043.1| | 255593 | g1154 | i0 | 100 | 86.7592592592593 | 326 | 0 | 86 | 0 | 53 | 378 | 470 | 145 | Vittaforma-like parasite isolate 5830 small subunit ribosomal RNA gene, partial sequence | blastn | 32795 | 603 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma-like parasite isolate 5830 | |||
| 32929157 | 32929157 | PRJEB6584h_S_NODE_6153_length_231_cov_2.836735_g6091_i0 | PRJEB6584 | 6153 | 231 | 2.836735 | 6.55285785 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 72 | 1.52e-12 | NR | XP_008073558.1 | 948595 | g6091 | i0 | 55 | 0.779220779220779 | 60 | 27 | 77.9 | 0 | 2 | 181 | 593 | 652 | XP_008073558.1 uncharacterized protein VCUG_00538 [Vavraia culicis subsp. floridensis] | diamond | 180 | 72 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 32929161 | 32929161 | PRJEB6584h_S_NODE_73865_length_156_cov_1.446281_g73803_i0 | PRJEB6584 | 73865 | 156 | 1.446281 | 2.25619836 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 49.7 | 3.94e-5 | NR | KRH93450.1 | 146866 | g73803 | i0 | 59.5 | 2.46153846153846 | 42 | 16 | 78.8 | 1 | 9 | 131 | 109 | 150 | KRH93450.1 RRM domain protein [Pseudoloma neurophilia] | diamond | 384 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia | ||||
| 32963460 | 32963460 | PRJEB6584h_S_NODE_53354_length_163_cov_2.750000_g53292_i0 | PRJEB6584 | 53354 | 163 | 2.75 | 4.4825 | Trachipleistophora hominis | 72359 | Fungi | Fungi | 59.7 | 1.31e-8 | NR | ELQ76698.1 | 72359 | g53292 | i0 | 72 | 1.76687116564417 | 50 | 10 | 84.7 | 2 | 162 | 25 | 423 | 472 | ELQ76698.1 Translation elongation factor EF-1 alpha/Tu [Trachipleistophora hominis] | diamond | 288 | 59.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Trachipleistophora | Trachipleistophora hominis | |||
| 32963465 | 32963465 | PRJEB6584h_S_NODE_78674_length_154_cov_1.344538_g78612_i0 | PRJEB6584 | 78674 | 154 | 1.344538 | 2.07058852 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 59.3 | 1.38e-8 | NR | XP_007604187.1 | 993615 | g78612 | i0 | 60 | 0.974025974025974 | 50 | 20 | 97.4 | 0 | 152 | 3 | 144 | 193 | XP_007604187.1 uncharacterized protein VICG_00736 [Vittaforma corneae ATCC 50505] | diamond | 150 | 59.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 33048562 | 33048562 | PRJEB6584h_S_NODE_5365_length_241_cov_1.946602_g5303_i0 | PRJEB6584 | 5365 | 241 | 1.946602 | 4.69131082 | Vavraia culicis subsp. floridensis | 948595 | Fungi | Fungi | 49.7 | 1.27e-4 | NR | XP_008073558.1 | 948595 | g5303 | i0 | 51.9 | 0.647302904564315 | 52 | 23 | 62.2 | 1 | 239 | 90 | 171 | 222 | XP_008073558.1 uncharacterized protein VCUG_00538 [Vavraia culicis subsp. floridensis] | diamond | 156 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 33150981 | 33150981 | PRJEB6584h_S_NODE_49552_length_164_cov_2.170543_g49490_i0 | PRJEB6584 | 49552 | 164 | 2.170543 | 3.55969052 | Pseudoloma neurophilia | 146866 | Fungi | Fungi | 89.7 | 4.15e-21 | NR | KRH93328.1 | 146866 | g49490 | i0 | 66.7 | 1.97560975609756 | 54 | 18 | 98.8 | 0 | 164 | 3 | 95 | 148 | KRH93328.1 Ubiquitin/40S ribosomal protein S27a fusion [Pseudoloma neurophilia] | diamond | 324 | 89.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pseudoloma | Pseudoloma neurophilia |
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);;