contig_metadata
10 rows where analysis = "diamond", bioproject = "PRJNA630162" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21004330 | 21004330 | PRJNA630162_P_NODE_163737_length_160_cov_2.873874_g162214_i0 | PRJNA630162 | 163737 | 160 | 2.873874 | 4.5981984 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 90.1 | 1.01e-20 | NR | XP_013238907.1 | 1485682 | g162214 | i0 | 79.6 | 9.375 | 49 | 10 | 91.9 | 0 | 7 | 153 | 79 | 127 | XP_013238907.1 40S ribosomal protein S8 [Mitosporidium daphniae] | diamond | 1500 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 28407214 | 28407214 | PRJNA630162_P_NODE_164466_length_159_cov_5.072727_g162943_i0 | PRJNA630162 | 164466 | 159 | 5.072727 | 8.06563593 | Pancytospora epiphaga | 1938578 | Fungi | Fungi | 54.7 | 7.36e-7 | NR | KAI5177932.1 | 1938578 | g162943 | i0 | 56 | 0.943396226415094 | 50 | 22 | 94.3 | 0 | 4 | 153 | 20 | 69 | KAI5177932.1 hypothetical protein PAEPH01_2511, partial [Pancytospora epiphaga] | diamond | 150 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pancytospora | Pancytospora epiphaga | ||||
| 29259436 | 29259436 | PRJNA630162_P_NODE_156049_length_163_cov_0.912281_g154526_i0 | PRJNA630162 | 156049 | 163 | 0.912281 | 1.48701803 | Mitosporidium daphniae | 1485682 | Fungi | Fungi | 66.6 | 3.7e-12 | NR | XP_013238239.1 | 1485682 | g154526 | i0 | 65.4 | 0.957055214723926 | 52 | 18 | 95.7 | 0 | 157 | 2 | 1 | 52 | XP_013238239.1 uncharacterized protein DI09_26p120 [Mitosporidium daphniae] | diamond | 156 | 66.6 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 30080651 | 30080651 | PRJNA630162_P_NODE_90232_length_191_cov_4.309859_g88709_i0 | PRJNA630162 | 90232 | 191 | 4.309859 | 8.23183069 | Dictyocoela muelleri | 279532 | Fungi | Fungi | 42.7 | 0.0151 | NR | KAG0435366.1 | 279532 | g88709 | i0 | 66.7 | 1.3979057591623 | 27 | 9 | 42.4 | 0 | 5 | 85 | 76 | 102 | KAG0435366.1 Casein kinase II subunit beta [Dictyocoela muelleri] | diamond | 267 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Dictyocoela | Dictyocoela muelleri | ||||
| 30302242 | 30302242 | PRJNA630162_P_NODE_104652_length_183_cov_1.246269_g103129_i0 | PRJNA630162 | 104652 | 183 | 1.246269 | 2.28067227 | Enteropsectra breve | 1912989 | Fungi | Fungi | 85.1 | 2.28e-18 | NR | KAI5152583.1 | 1912989 | g103129 | i0 | 67.8 | 0.967213114754098 | 59 | 19 | 96.7 | 0 | 5 | 181 | 145 | 203 | KAI5152583.1 large subunit ribosomal protein L7e [Enteropsectra breve] | diamond | 177 | 85.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enteropsectra | Enteropsectra breve | ||||
| 30378137 | 30378137 | PRJNA630162_P_NODE_135072_length_168_cov_1.310924_g133549_i0 | PRJNA630162 | 135072 | 168 | 1.310924 | 2.20235232 | Nosematidae | 27974 | Fungi | Fungi | 75.1 | 3.98e-15 | NR | XP_007605176.1 | 993615 | g133549 | i0 | 58.5 | 1.89285714285714 | 53 | 22 | 94.6 | 0 | 9 | 167 | 109 | 161 | XP_007605176.1 uncharacterized protein VICG_01731 [Vittaforma corneae ATCC 50505] | diamond | 318 | 75.1 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nosematidae | Vittaforma | Vittaforma corneae | |||
| 30838948 | 30838948 | PRJNA630162_P_NODE_129414_length_169_cov_12.933333_g127891_i0 | PRJNA630162 | 129414 | 169 | 12.933333 | 21.85733277 | Nematocida sp. LUAm3 | 2670340 | Fungi | Fungi | 47 | 2.94e-5 | NR | KAI5170948.1 | 2670340 | g127891 | i0 | 58.8 | 0.603550295857988 | 34 | 14 | 60.4 | 0 | 48 | 149 | 2 | 35 | KAI5170948.1 hypothetical protein NEFER03_0350 [Nematocida sp. LUAm3] | diamond | 102 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. LUAm3 | ||||
| 30915037 | 30915037 | PRJNA630162_P_NODE_160014_length_162_cov_1.327434_g158491_i0 | PRJNA630162 | 160014 | 162 | 1.327434 | 2.15044308 | Opisthokonta | 33154 | Fungi | Fungi | 80.9 | 1.41e-16 | NR | XP_013237233.1 | 1485682 | g158491 | i0 | 73.1 | 13.462962962963 | 52 | 14 | 96.3 | 0 | 7 | 162 | 47 | 98 | XP_013237233.1 uncharacterized protein DI09_55p30 [Mitosporidium daphniae] | diamond | 2181 | 80.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Mitosporidium | Mitosporidium daphniae | ||||
| 31312977 | 31312977 | PRJNA630162_P_NODE_137635_length_167_cov_2.474576_g136112_i0 | PRJNA630162 | 137635 | 167 | 2.474576 | 4.13254192 | Enterocytozoon bieneusi H348 | 481877 | Fungi | Fungi | 52.8 | 3.88e-6 | NR | EDQ31028.1 | 481877 | g136112 | i0 | 45.3 | 0.952095808383233 | 53 | 29 | 95.2 | 0 | 159 | 1 | 15 | 67 | EDQ31028.1 DNA-directed RNA polymerase [Enterocytozoon bieneusi H348] | diamond | 159 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Enterocytozoonidae | Enterocytozoon | Enterocytozoon bieneusi | |||
| 31724150 | 31724150 | PRJNA630162_P_NODE_172917_length_150_cov_5.990099_g171394_i0 | PRJNA630162 | 172917 | 150 | 5.990099 | 8.9851485 | Nematocida sp. LUAm3 | 2670340 | Fungi | Fungi | 38.9 | 0.0378 | NR | KAI5170948.1 | 2670340 | g171394 | i0 | 51.5 | 0.66 | 33 | 16 | 66 | 0 | 28 | 126 | 1 | 33 | KAI5170948.1 hypothetical protein NEFER03_0350 [Nematocida sp. LUAm3] | diamond | 99 | 38.9 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Nematocida | Nematocida sp. LUAm3 |
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);;