contig_metadata
14 rows where analysis = "diamond", bioproject = "PRJNA666695" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 17210181 | 17210181 | PRJNA666695_S_NODE_32674_length_345_cov_6.605263_g31580_i0 | PRJNA666695 | 32674 | 345 | 6.605263 | 22.78815735 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 126 | 2.42e-34 | NR | KAG0440815.1 | 279532 | g31580 | i0 | 66.3 | 1.44347826086957 | 83 | 28 | 72.2 | 0 | 2 | 250 | 86 | 168 | KAG0440815.1 60S ribosomal protein L11 [Dictyocoela muelleri] | diamond | 498 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 27378345 | 27378345 | PRJNA666695_S_NODE_148783_length_178_cov_2.562044_g147689_i0 | PRJNA666695 | 148783 | 178 | 2.562044 | 4.56043832 | Fungi | 4751 | Fungi | Fungi | 57.4 | 4.04e-8 | NR | KAF7683139.1 | 164912 | g147689 | i0 | 74.4 | 1.31460674157303 | 39 | 10 | 65.7 | 0 | 119 | 3 | 137 | 175 | KAF7683139.1 Set1/Ash2 histone methyltransferase complex subunit ASH2 [Astathelohania contejeani] | diamond | 234 | 57.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Astathelohaniidae | Astathelohania | Astathelohania contejeani | |||
| 27429450 | 27429450 | PRJNA666695_S_NODE_62363_length_269_cov_2.442982_g61269_i0 | PRJNA666695 | 62363 | 269 | 2.442982 | 6.57162158 | Encephalitozoon romaleae SJ-2 | 571949 | Fungi | Fungi | 75.1 | 2.12e-13 | NR | XP_009264165.1 | 1178016 | g61269 | i0 | 43.6 | 3.07806691449814 | 94 | 42 | 93.7 | 3 | 12 | 263 | 339 | 431 | XP_009264165.1 ubiquitin carboxy-terminal hydrolase [Encephalitozoon romaleae SJ-2008] | diamond | 828 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon romaleae | |||
| 27650273 | 27650273 | PRJNA666695_S_NODE_115664_length_204_cov_3.582822_g114570_i0 | PRJNA666695 | 115664 | 204 | 3.582822 | 7.30895688 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 69.3 | 2.53e-12 | NR | XP_013239063.1 | 1485682 | g114570 | i0 | 53.4 | 0.852941176470588 | 58 | 27 | 85.3 | 0 | 4 | 177 | 127 | 184 | XP_013239063.1 ribosomal protein [Mitosporidium daphniae] | diamond | 174 | 69.3 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 27808242 | 27808242 | PRJNA666695_S_NODE_125844_length_196_cov_1.187097_g124750_i0 | PRJNA666695 | 125844 | 196 | 1.187097 | 2.32671012 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 86.7 | 1.5e-19 | NR | XP_013238426.1 | 1485682 | g124750 | i0 | 60.9 | 0.979591836734694 | 64 | 25 | 98 | 0 | 2 | 193 | 91 | 154 | XP_013238426.1 ribosomal protein L12 [Mitosporidium daphniae] | diamond | 192 | 86.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 29197424 | 29197424 | PRJNA666695_S_NODE_114389_length_206_cov_1.115152_g113295_i0 | PRJNA666695 | 114389 | 206 | 1.115152 | 2.29721312 | Nematocida homosporus | 1912981 | Fungi | Fungi | 103 | 6.41e-24 | NR | XP_051346910.1 | 1912981 | g113295 | i0 | 65.7 | 1.96601941747573 | 67 | 23 | 97.6 | 0 | 6 | 206 | 28 | 94 | XP_051346910.1 leucyl-tRNA synthetase [Nematocida homosporus] | diamond | 405 | 103 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida homosporus | ||||
| 29197472 | 29197472 | PRJNA666695_S_NODE_2389_length_993_cov_56.328782_g1827_i0 | PRJNA666695 | 2389 | 993 | 56.328782 | 559.34480526 | Nosema granulosis | 83296 | Fungi | Fungi | 79 | 3.14e-12 | NR | KAF9752809.1 | 83296 | g1827 | i0 | 53.6 | 0.625377643504532 | 69 | 32 | 20.8 | 0 | 543 | 337 | 139 | 207 | KAF9752809.1 Gag-Pol polyprotein [Nosema granulosis] | diamond | 621 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis | |||
| 30219946 | 30219946 | PRJNA666695_S_NODE_94492_length_225_cov_5.250000_g93398_i0 | PRJNA666695 | 94492 | 225 | 5.25 | 11.8125 | Eukaryota | 2759 | Fungi | Fungi | 84.7 | 1.9e-17 | NR | EQB61756.1 | 1037528 | g93398 | i0 | 56.9 | 2.89333333333333 | 72 | 28 | 94.7 | 2 | 3 | 215 | 249 | 318 | EQB61756.1 dna topoisomerase ii [Vairimorpha apis BRL 01] | diamond | 651 | 84.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vairimorpha | Vairimorpha apis | |||
| 30303146 | 30303146 | PRJNA666695_S_NODE_174892_length_162_cov_1.123967_g173798_i0 | PRJNA666695 | 174892 | 162 | 1.123967 | 1.82082654 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 47.4 | 1.66e-4 | NR | XP_013238759.1 | 1485682 | g173798 | i0 | 45.7 | 0.851851851851852 | 46 | 25 | 85.2 | 0 | 158 | 21 | 129 | 174 | XP_013238759.1 60S ribosomal protein L18 [Mitosporidium daphniae] | diamond | 138 | 47.4 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 30662320 | 30662320 | PRJNA666695_S_NODE_130953_length_191_cov_5.520000_g129859_i0 | PRJNA666695 | 130953 | 191 | 5.52 | 10.5432 | Fungi | 4751 | Fungi | Fungi | 67 | 1.12e-11 | NR | OIR57956.1 | 1866961 | g129859 | i0 | 55.7 | 3.78534031413613 | 61 | 27 | 95.8 | 0 | 185 | 3 | 121 | 181 | OIR57956.1 MAG: SNARE protein YKT6, synaptobrevin/VAMP superfamily [Amphiamblys sp. WSBS2006] | diamond | 723 | 67.4 | 0.99406528189911 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Amphiacanthidae | Amphiamblys | Amphiamblys sp. WSBS2006 | |||
| 31187049 | 31187049 | PRJNA666695_S_NODE_152375_length_176_cov_1.362963_g151281_i0 | PRJNA666695 | 152375 | 176 | 1.362963 | 2.39881488 | Hamiltosporidium magnivora | 148818 | Fungi | Fungi | 45.8 | 0.00122 | NR | TBU03811.1 | 148818 | g151281 | i0 | 41.3 | 0.784090909090909 | 46 | 27 | 78.4 | 0 | 1 | 138 | 298 | 343 | TBU03811.1 putative scavenger mRNA decapping enzyme [Hamiltosporidium magnivora] | diamond | 138 | 45.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dubosqiidae | Hamiltosporidium | Hamiltosporidium magnivora | |||
| 31630142 | 31630142 | PRJNA666695_S_NODE_14636_length_468_cov_2.442623_g13549_i0 | PRJNA666695 | 14636 | 468 | 2.442623 | 11.43147564 | Nematocida minor | 1912983 | Fungi | Fungi | 122 | 9.000000000000001e-29 | NR | XP_051334382.1 | 1912983 | g13549 | i0 | 40 | 9.93589743589744 | 155 | 93 | 99.4 | 0 | 3 | 467 | 455 | 609 | XP_051334382.1 uncharacterized protein NEMIN01_2480, partial [Nematocida minor] | diamond | 4650 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida minor | ||||
| 31946263 | 31946263 | PRJNA666695_S_NODE_112997_length_207_cov_1.704819_g111903_i0 | PRJNA666695 | 112997 | 207 | 1.704819 | 3.52897533 | Encephalitozoon cuniculi GB-M1 | 284813 | Fungi | Fungi | 61.6 | 4.72e-9 | NR | NP_586018.1 | 284813 | g111903 | i0 | 41.2 | 2.7536231884058 | 68 | 39 | 97.1 | 1 | 2 | 202 | 285 | 352 | NP_586018.1 uncharacterized protein ECU07_0900 [Encephalitozoon cuniculi GB-M1] | diamond | 570 | 61.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Unikaryonidae | Encephalitozoon | Encephalitozoon cuniculi | |||
| 32180217 | 32180217 | PRJNA666695_S_NODE_130858_length_192_cov_0.993377_g129764_i0 | PRJNA666695 | 130858 | 192 | 0.993377 | 1.90728384 | Fungi | 4751 | Fungi | Fungi | 71.2 | 8.35e-13 | NR | KAF9764033.1 | 83296 | g129764 | i0 | 50.8 | 6.71875 | 61 | 30 | 95.3 | 0 | 191 | 9 | 14 | 74 | KAF9764033.1 Transcription factor prr1 [Nosema granulosis] | diamond | 1290 | 71.2 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Nosema | Nosema granulosis |
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);;