contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1877851 | 1877851 | PRJNA630162_P_NODE_143782_length_166_cov_0.888889_g142259_i0 | PRJNA630162 | 143782 | 166 | 0.888889 | 1.47555574 | Schistosoma mattheei | 31246 | Platyhelminthes | Platyhelminthes | 65.9 | 6.61e-12 | NR | VDP63819.1 | 31246 | g142259 | i0 | 55.6 | 5.85542168674699 | 54 | 22 | 94 | 1 | 160 | 5 | 38 | 91 | VDP63819.1 unnamed protein product [Schistosoma mattheei] | diamond | 972 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mattheei | |
| 4429460 | 4429460 | PRJNA630162_P_NODE_151124_length_164_cov_1.408696_g149601_i0 | PRJNA630162 | 151124 | 164 | 1.408696 | 2.31026144 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 82.4 | 1.28e-16 | NR | KAH9282779.1 | 6210 | g149601 | i0 | 92.3 | 19.8475609756098 | 39 | 3 | 71.3 | 0 | 117 | 1 | 380 | 418 | KAH9282779.1 tRNA-splicing ligase RtcB -like protein [Echinococcus granulosus] | diamond | 3255 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 12082068 | 12082068 | PRJNA630162_P_NODE_77270_length_205_cov_0.967949_g75747_i0 | PRJNA630162 | 77270 | 205 | 0.967949 | 1.98429545 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 134 | 1.17e-37 | NR | Q26537.1 | 6183 | g75747 | i0 | 98.5 | 3.98048780487805 | 68 | 1 | 99.5 | 0 | 1 | 204 | 60 | 127 | Q26537.1 RecName: Full=14-3-3 protein homolog 2; Short=14-3-3-2 [Schistosoma mansoni] | diamond | 816 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 26795867 | 26795867 | PRJNA630162_P_NODE_125781_length_171_cov_2.483607_g124258_i0 | PRJNA630162 | 125781 | 171 | 2.483607 | 4.24696797 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 67 | 1.46e-11 | NR | PAA47301.1 | 282301 | g124258 | i0 | 62 | 7.78947368421053 | 50 | 19 | 87.7 | 0 | 169 | 20 | 72 | 121 | PAA47301.1 hypothetical protein BOX15_Mlig018086g7, partial [Macrostomum lignano] | diamond | 1332 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27409686 | 27409686 | PRJNA630162_P_NODE_67763_length_215_cov_1.656627_g66240_i0 | PRJNA630162 | 67763 | 215 | 1.656627 | 3.56174805 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 42.4 | 0.036 | NR | RTG86495.1 | 6184 | g66240 | i0 | 58.1 | 1.75813953488372 | 31 | 13 | 43.3 | 0 | 109 | 17 | 810 | 840 | RTG86495.1 E3 ubiquitin-protein ligase mind-bomb [Schistosoma bovis] | diamond | 378 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 28091406 | 28091406 | PRJNA630162_P_NODE_54185_length_239_cov_3.810526_g52662_i0 | PRJNA630162 | 54185 | 239 | 3.810526 | 9.10715714 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 43.5 | 0.0193 | NR | CDS26308.1 | 85433 | g52662 | i0 | 44.3 | 1.38075313807531 | 61 | 34 | 76.6 | 0 | 202 | 20 | 326 | 386 | CDS26308.1 dnaJ subfamily B [Hymenolepis microstoma] | diamond | 330 | 43.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 28407255 | 28407255 | PRJNA630162_P_NODE_39366_length_284_cov_1.276596_g37843_i0 | PRJNA630162 | 39366 | 284 | 1.276596 | 3.62553264 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 92.8 | 1.19e-22 | NR | PAA52392.1 | 282301 | g37843 | i0 | 72.9 | 0.623239436619718 | 59 | 16 | 62.3 | 0 | 235 | 59 | 1 | 59 | PAA52392.1 hypothetical protein BOX15_Mlig007628g1 [Macrostomum lignano] | diamond | 177 | 92.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29209367 | 29209367 | PRJNA630162_P_NODE_91309_length_191_cov_1.373239_g89786_i0 | PRJNA630162 | 91309 | 191 | 1.373239 | 2.62288649 | Opisthorchiidae | 6196 | Platyhelminthes | Platyhelminthes | 48.5 | 1.69e-4 | NR | XP_009167273.1 | 6198 | g89786 | i0 | 45.2 | 1.97905759162304 | 42 | 23 | 66 | 0 | 65 | 190 | 410 | 451 | XP_009167273.1 hypothetical protein T265_04310 [Opisthorchis viverrini] | diamond | 378 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 29543721 | 29543721 | PRJNA630162_P_NODE_25310_length_363_cov_4.636943_g23790_i0 | PRJNA630162 | 25310 | 363 | 4.636943 | 16.83210309 | Taenia asiatica | 60517 | Platyhelminthes | Platyhelminthes | 59.3 | 9.47e-9 | NR | VDK22860.1 | 60517 | g23790 | i0 | 48.4 | 0.528925619834711 | 64 | 21 | 52.9 | 1 | 195 | 4 | 11 | 62 | VDK22860.1 unnamed protein product [Taenia asiatica] | diamond | 192 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Taenia | Taenia asiatica | |
| 29669644 | 29669644 | PRJNA630162_P_NODE_109830_length_180_cov_1.236641_g108307_i0 | PRJNA630162 | 109830 | 180 | 1.236641 | 2.2259538 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 92 | 4.83e-20 | NR | PAA71470.1 | 282301 | g108307 | i0 | 65.5 | 5.78333333333333 | 58 | 20 | 96.7 | 0 | 174 | 1 | 233 | 290 | PAA71470.1 hypothetical protein BOX15_Mlig022730g1 [Macrostomum lignano] | diamond | 1041 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29777440 | 29777440 | PRJNA630162_P_NODE_78971_length_202_cov_3.241830_g77448_i0 | PRJNA630162 | 78971 | 202 | 3.24183 | 6.5484966 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 41.6 | 0.0107 | NR | TNN12668.1 | 6182 | g77448 | i0 | 52.5 | 1.18811881188119 | 40 | 19 | 59.4 | 0 | 201 | 82 | 5 | 44 | TNN12668.1 hypothetical protein EWB00_003574 [Schistosoma japonicum] | diamond | 240 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29827877 | 29827877 | PRJNA630162_P_NODE_152151_length_164_cov_0.904348_g150628_i0 | PRJNA630162 | 152151 | 164 | 0.904348 | 1.48313072 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 40.4 | 0.0264 | NR | XP_018651663.1 | 6183 | g150628 | i0 | 46.3 | 0.75 | 41 | 21 | 73.2 | 1 | 130 | 11 | 3 | 43 | XP_018651663.1 hypothetical protein Smp_150130 [Schistosoma mansoni] | diamond | 123 | 40.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 31294056 | 31294056 | PRJNA630162_P_NODE_160815_length_162_cov_0.920354_g159292_i0 | PRJNA630162 | 160815 | 162 | 0.920354 | 1.49097348 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 99.4 | 3.9399999999999996e-23 | NR | THD21631.1 | 6192 | g159292 | i0 | 78.8 | 18.2777777777778 | 52 | 11 | 96.3 | 0 | 156 | 1 | 265 | 316 | THD21631.1 Choline-phosphate cytidylyltransferase B [Fasciola hepatica] | diamond | 2961 | 99.8 | 0.995991983967936 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31420632 | 31420632 | PRJNA630162_P_NODE_57836_length_232_cov_1.480874_g56313_i0 | PRJNA630162 | 57836 | 232 | 1.480874 | 3.43562768 | root | 1 | Root_unresolved | Root_unresolved | 70.1 | 7.17e-12 | NR | CAH8455079.1 | 6185 | g56313 | i0 | 45.3 | 4.84913793103448 | 75 | 41 | 97 | 0 | 227 | 3 | 29 | 103 | CAH8455079.1 unnamed protein product [Schistosoma haematobium] | diamond | 1125 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 31736797 | 31736797 | PRJNA630162_P_NODE_77737_length_204_cov_1.851613_g76214_i0 | PRJNA630162 | 77737 | 204 | 1.851613 | 3.77729052 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 55.5 | 2.69e-7 | NR | VDN98320.1 | 102285 | g76214 | i0 | 48.3 | 2.70588235294118 | 58 | 30 | 85.3 | 0 | 19 | 192 | 13 | 70 | VDN98320.1 unnamed protein product [Rodentolepis nana] | diamond | 552 | 55.8 | 0.99462365591397806 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 32736085 | 32736085 | PRJNA630162_P_NODE_38880_length_286_cov_1.578059_g37357_i0 | PRJNA630162 | 38880 | 286 | 1.578059 | 4.51324874 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 47.4 | 2.23e-4 | NR | XP_018645103.1 | 6183 | g37357 | i0 | 56.5 | 0.482517482517482 | 46 | 19 | 48.3 | 1 | 85 | 222 | 7 | 51 | XP_018645103.1 unnamed protein product [Schistosoma mansoni] | diamond | 138 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni |
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);;