contig_metadata
11 rows where bioproject = "PRJNA534016", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26824798 | 26824798 | PRJNA534016_P_NODE_8281_length_295_cov_1.139640_g8191_i0 | PRJNA534016 | 8281 | 295 | 1.13964 | 3.361938 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 130 | 2.09e-34 | NR | XP_007603882.1 | 993615 | g8191 | i0 | 62.1 | 0.966101694915254 | 95 | 35 | 96.6 | 1 | 10 | 294 | 77 | 170 | XP_007603882.1 uncharacterized protein VICG_00429 [Vittaforma corneae ATCC 50505] | diamond | 285 | 130 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 27425701 | 27425701 | PRJNA534016_P_NODE_8303_length_294_cov_3.470588_g8213_i0 | PRJNA534016 | 8303 | 294 | 3.470588 | 10.20352872 | Enteropsectra breve | 1912989 | Fungi | Fungi | 166 | 7.32e-51 | NR | KAI5148834.1 | 1912989 | g8213 | i0 | 85.6 | 1.98979591836735 | 97 | 14 | 99 | 0 | 293 | 3 | 8 | 104 | KAI5148834.1 histone H2A [Enteropsectra breve] | diamond | 585 | 166 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 27488632 | 27488632 | PRJNA534016_P_NODE_12763_length_257_cov_2.989130_g12673_i0 | PRJNA534016 | 12763 | 257 | 2.98913 | 7.6820641 | Pancytospora epiphaga | 1938578 | Fungi | Fungi | 58.5 | 9.98e-8 | NR | KAI5174646.1 | 1938578 | g12673 | i0 | 48.1 | 0.630350194552529 | 54 | 28 | 63 | 0 | 1 | 162 | 176 | 229 | KAI5174646.1 hypothetical protein PAEPH01_2092 [Pancytospora epiphaga] | diamond | 162 | 58.5 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora epiphaga | ||||
| 27819460 | 27819460 | PRJNA534016_P_NODE_14204_length_250_cov_0.870056_g14114_i0 | PRJNA534016 | 14204 | 250 | 0.870056 | 2.17514 | Pancytospora | 1939651 | Fungi | Fungi | 128 | 1.85e-34 | NR | KAI4292607.1 | 1923975 | g14114 | i0 | 75.9 | 1.968 | 83 | 20 | 99.6 | 0 | 249 | 1 | 104 | 186 | KAI4292607.1 large subunit ribosomal protein LP0 [Pancytospora philotis] | diamond | 492 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora philotis | ||||
| 27867339 | 27867339 | PRJNA534016_P_NODE_18245_length_241_cov_0.916667_g18155_i0 | PRJNA534016 | 18245 | 241 | 0.916667 | 2.20916747 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 114 | 1.39e-29 | NR | XP_007604189.1 | 993615 | g18155 | i0 | 68.8 | 0.995850622406639 | 80 | 25 | 99.6 | 0 | 1 | 240 | 10 | 89 | XP_007604189.1 uncharacterized protein VICG_00738 [Vittaforma corneae ATCC 50505] | diamond | 240 | 114 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 28404264 | 28404264 | PRJNA534016_P_NODE_3066_length_466_cov_1.870229_g2976_i0 | PRJNA534016 | 3066 | 466 | 1.870229 | 8.71526714 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 46.6 | 0.0132 | NR | XP_007603882.1 | 993615 | g2976 | i0 | 27.7 | 0.766094420600858 | 119 | 83 | 76.6 | 2 | 108 | 464 | 233 | 348 | XP_007603882.1 uncharacterized protein VICG_00429 [Vittaforma corneae ATCC 50505] | diamond | 357 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 29035929 | 29035929 | PRJNA534016_P_NODE_18308_length_241_cov_0.916667_g18218_i0 | PRJNA534016 | 18308 | 241 | 0.916667 | 2.20916747 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 46.6 | 0.0014 | NR | XP_007604893.1 | 993615 | g18218 | i0 | 52.4 | 0.522821576763486 | 42 | 20 | 52.3 | 0 | 112 | 237 | 1 | 42 | XP_007604893.1 uncharacterized protein VICG_01447 [Vittaforma corneae ATCC 50505] | diamond | 126 | 46.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 29351555 | 29351555 | PRJNA534016_P_NODE_13729_length_251_cov_0.865169_g13639_i0 | PRJNA534016 | 13729 | 251 | 0.865169 | 2.17157419 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 107 | 1.14e-25 | NR | XP_007604125.1 | 993615 | g13639 | i0 | 62.7 | 0.99203187250996006 | 83 | 30 | 98 | 1 | 251 | 6 | 97 | 179 | XP_007604125.1 uncharacterized protein VICG_00674 [Vittaforma corneae ATCC 50505] | diamond | 249 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 29856640 | 29856640 | PRJNA534016_P_NODE_17391_length_243_cov_0.905882_g17301_i0 | PRJNA534016 | 17391 | 243 | 0.905882 | 2.20129326 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 108 | 8.989999999999999e-28 | NR | XP_007605294.1 | 993615 | g17301 | i0 | 60.8 | 0.975308641975309 | 79 | 31 | 97.5 | 0 | 237 | 1 | 48 | 126 | XP_007605294.1 uncharacterized protein VICG_01849 [Vittaforma corneae ATCC 50505] | diamond | 237 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 30077645 | 30077645 | PRJNA534016_P_NODE_4092_length_407_cov_1.946108_g4002_i0 | PRJNA534016 | 4092 | 407 | 1.946108 | 7.92065956 | Vittaforma corneae ATCC 5 | 42399 | Fungi | Fungi | 51.6 | 1.49e-4 | NR | XP_007604125.1 | 993615 | g4002 | i0 | 29.3 | 0.98034398034398 | 133 | 78 | 95.8 | 4 | 405 | 16 | 124 | 243 | XP_007604125.1 uncharacterized protein VICG_00674 [Vittaforma corneae ATCC 50505] | diamond | 399 | 51.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 31531722 | 31531722 | PRJNA534016_P_NODE_9636_length_282_cov_1.291866_g9546_i0 | PRJNA534016 | 9636 | 282 | 1.291866 | 3.64306212 | Pancytospora epiphaga | 1938578 | Fungi | Fungi | 79 | 1.81e-15 | NR | KAI5168652.1 | 1938578 | g9546 | i0 | 46.8 | 1 | 94 | 46 | 96.8 | 3 | 275 | 3 | 106 | 198 | KAI5168652.1 hypothetical protein PAEPH01_0305 [Pancytospora epiphaga] | diamond | 282 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora epiphaga |
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);;