contig_metadata
20 rows where bioproject = "PRJNA532380" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 503861 | 503861 | PRJNA532380_P_NODE_22901_length_187_cov_2.202899_g22576_i0 | PRJNA532380 | 22901 | 187 | 2.202899 | 4.11942113 | Neobenedenia melleni | 280695 | Platyhelminthes | Platyhelminthes | 95.3 | 2.62e-15 | NTclustered | gi|335353832|emb|FN908505.1| | 280695 | g22576 | i0 | 98.148 | 24.8342245989305 | 54 | 1 | 29 | 0 | 81 | 134 | 1762 | 1709 | Neobenedenia melleni mRNA for heat shock protein 60 (hsp60 gene) | blastn | 4644 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Capsalidea | Capsalidae | Neobenedenia | Neobenedenia melleni | |
| 18968957 | 18968957 | PRJNA532380_P_NODE_10975_length_278_cov_1.873362_g10650_i0 | PRJNA532380 | 10975 | 278 | 1.873362 | 5.20794636 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 106 | 1.94e-18 | NTclustered | gi|28273274|gb|AY157162.1| | 66825 | g10650 | i0 | 84.545 | 40.4172661870504 | 110 | 14 | 39 | 3 | 162 | 270 | 405 | 298 | Provortex psammophilus 28S large subunit ribosomal RNA gene, partial sequence | blastn | 11236 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Rhabdocoela | Provorticidae | Provortex | Provortex psammophilus | |
| 23455662 | 23455662 | PRJNA532380_P_NODE_12759_length_254_cov_2.741463_g12434_i0 | PRJNA532380 | 12759 | 254 | 2.741463 | 6.96331602 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 204 | 6.02e-48 | NTclustered | gi|393794643|dbj|AK389067.1| | 6161 | g12434 | i0 | 83.036 | 17.7716535433071 | 224 | 38 | 88 | 0 | 2 | 225 | 266 | 43 | Dugesia japonica cDNA, clone: Dj_aH_000_07236HH.full, full-insert sequence, expressed in adult head | blastn | 4514 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 24729753 | 24729753 | PRJNA532380_P_NODE_22120_length_191_cov_1.098592_g21795_i0 | PRJNA532380 | 22120 | 191 | 1.098592 | 2.09831072 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 121 | 2.7899999999999996e-31 | NR | WFL37650.1 | 6161 | g21795 | i0 | 88.9 | 101.921465968586 | 63 | 7 | 99 | 0 | 1 | 189 | 149 | 211 | WFL37650.1 casein kinase I isoform alpha [Dugesia japonica] | diamond | 19467 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 26665779 | 26665779 | PRJNA532380_P_NODE_12721_length_255_cov_1.189320_g12396_i0 | PRJNA532380 | 12721 | 255 | 1.18932 | 3.032766 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 63.2 | 8.66e-10 | NR | WMQ53803.1 | 79327 | g12396 | i0 | 46.6 | 1.72941176470588 | 73 | 39 | 85.9 | 0 | 15 | 233 | 3 | 75 | WMQ53803.1 ferritin C [Schmidtea mediterranea] | diamond | 441 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 26776367 | 26776367 | PRJNA532380_P_NODE_17061_length_218_cov_1.142012_g16736_i0 | PRJNA532380 | 17061 | 218 | 1.142012 | 2.48958616 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 77.8 | 1.09e-14 | NR | VDM01430.1 | 70667 | g16736 | i0 | 52.2 | 4.69266055045872 | 67 | 32 | 92.2 | 0 | 216 | 16 | 274 | 340 | VDM01430.1 unnamed protein product [Schistocephalus solidus] | diamond | 1023 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 26839785 | 26839785 | PRJNA532380_P_NODE_29181_length_167_cov_0.881356_g28856_i0 | PRJNA532380 | 29181 | 167 | 0.881356 | 1.47186452 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 78.6 | 9e-17 | NR | THD18458.1 | 6192 | g28856 | i0 | 65.5 | 7.90419161676647 | 55 | 19 | 98.8 | 0 | 166 | 2 | 15 | 69 | THD18458.1 Ribosomal protein S16 [Fasciola hepatica] | diamond | 1320 | 79.3 | 0.991172761664565 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 27393811 | 27393811 | PRJNA532380_P_NODE_2823_length_629_cov_4.813793_g2524_i0 | PRJNA532380 | 2823 | 629 | 4.813793 | 30.27875797 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 126 | 2.17e-32 | NR | WMQ53805.1 | 79327 | g2524 | i0 | 40.8 | 2.58982511923688 | 184 | 107 | 87.8 | 2 | 19 | 570 | 9 | 190 | WMQ53805.1 ferritin A [Schmidtea mediterranea] | diamond | 1629 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 27867142 | 27867142 | PRJNA532380_P_NODE_24385_length_181_cov_1.166667_g24060_i0 | PRJNA532380 | 24385 | 181 | 1.166667 | 2.11166727 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 114 | 2.44e-28 | NR | KAA3673210.1 | 34504 | g24060 | i0 | 83.3 | 0.994475138121547 | 60 | 10 | 99.4 | 0 | 180 | 1 | 155 | 214 | KAA3673210.1 pleiotropic regulator 1, partial [Paragonimus westermani] | diamond | 180 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 29303146 | 29303146 | PRJNA532380_P_NODE_20369_length_199_cov_1.386667_g20044_i0 | PRJNA532380 | 20369 | 199 | 1.386667 | 2.75946733 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 72 | 1.93e-13 | NR | KAH8872457.1 | 6182 | g20044 | i0 | 59.1 | 9.94974874371859 | 66 | 20 | 99.5 | 1 | 199 | 2 | 24 | 82 | KAH8872457.1 Leucine rich repeat flightless interacting [Schistosoma japonicum] | diamond | 1980 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29414297 | 29414297 | PRJNA532380_P_NODE_2889_length_623_cov_2.303136_g2588_i0 | PRJNA532380 | 2889 | 623 | 2.303136 | 14.34853728 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 121 | 2.5199999999999997e-30 | NR | WMQ53805.1 | 79327 | g2588 | i0 | 36.2 | 2.65329052969502 | 199 | 120 | 94.9 | 3 | 622 | 32 | 9 | 202 | WMQ53805.1 ferritin A [Schmidtea mediterranea] | diamond | 1653 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 29761580 | 29761580 | PRJNA532380_P_NODE_28151_length_168_cov_0.873950_g27826_i0 | PRJNA532380 | 28151 | 168 | 0.87395 | 1.468236 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 54.3 | 3.09e-7 | NR | ARM37839.1 | 79327 | g27826 | i0 | 40.4 | 0.928571428571429 | 52 | 31 | 92.9 | 0 | 158 | 3 | 3 | 54 | ARM37839.1 C-type lectin-like protein [Schmidtea mediterranea] | diamond | 156 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 29919753 | 29919753 | PRJNA532380_P_NODE_29931_length_166_cov_0.888889_g29606_i0 | PRJNA532380 | 29931 | 166 | 0.888889 | 1.47555574 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 53.9 | 1.44e-6 | NR | CAL5136326.1 | 300641 | g29606 | i0 | 46.4 | 1.01204819277108 | 56 | 28 | 97.6 | 1 | 164 | 3 | 294 | 349 | CAL5136326.1 unnamed protein product [Calicophoron daubneyi] | diamond | 168 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 29982824 | 29982824 | PRJNA532380_P_NODE_20891_length_196_cov_2.945578_g20566_i0 | PRJNA532380 | 20891 | 196 | 2.945578 | 5.77333288 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 52.8 | 3.54e-6 | NR | PAA57943.1 | 282301 | g20566 | i0 | 46.8 | 0.719387755102041 | 47 | 23 | 71.9 | 1 | 55 | 195 | 16 | 60 | PAA57943.1 hypothetical protein BOX15_Mlig007275g2 [Macrostomum lignano] | diamond | 141 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30045833 | 30045833 | PRJNA532380_P_NODE_15211_length_231_cov_2.021978_g14886_i0 | PRJNA532380 | 15211 | 231 | 2.021978 | 4.67076918 | Fasciola gigantica | 46835 | Platyhelminthes | Platyhelminthes | 69.3 | 3.01e-13 | NR | TPP60137.1 | 46835 | g14886 | i0 | 59.3 | 1.37662337662338 | 54 | 22 | 70.1 | 0 | 40 | 201 | 42 | 95 | TPP60137.1 Ribosomal protein mitochondrial [Fasciola gigantica] | diamond | 318 | 69.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 30977490 | 30977490 | PRJNA532380_P_NODE_17034_length_218_cov_1.230769_g16709_i0 | PRJNA532380 | 17034 | 218 | 1.230769 | 2.68307642 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 95.1 | 2.5200000000000004e-21 | NR | XP_018653107.1 | 6183 | g16709 | i0 | 63.1 | 7.15596330275229 | 65 | 24 | 89.4 | 0 | 1 | 195 | 271 | 335 | XP_018653107.1 putative reticulocalbin [Schistosoma mansoni] | diamond | 1560 | 95.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 31119920 | 31119920 | PRJNA532380_P_NODE_28015_length_168_cov_1.327731_g27690_i0 | PRJNA532380 | 28015 | 168 | 1.327731 | 2.23058808 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 53.9 | 1.49e-6 | NR | VDP69874.1 | 27848 | g27690 | i0 | 44.4 | 1.92857142857143 | 54 | 30 | 96.4 | 0 | 163 | 2 | 185 | 238 | VDP69874.1 unnamed protein product [Echinostoma caproni] | diamond | 324 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 31752628 | 31752628 | PRJNA532380_P_NODE_2837_length_628_cov_4.514680_g2537_i0 | PRJNA532380 | 2837 | 628 | 4.51468 | 28.3521904 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 127 | 1.3e-32 | NR | WMQ53804.1 | 79327 | g2537 | i0 | 40.8 | 0.878980891719745 | 184 | 107 | 87.9 | 2 | 611 | 60 | 4 | 185 | WMQ53804.1 ferritin B [Schmidtea mediterranea] | diamond | 552 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 32621801 | 32621801 | PRJNA532380_P_NODE_14500_length_238_cov_1.010582_g14175_i0 | PRJNA532380 | 14500 | 238 | 1.010582 | 2.40518516 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 115 | 2.68e-30 | NR | VDM34204.1 | 6205 | g14175 | i0 | 67.1 | 11.8487394957983 | 79 | 26 | 99.6 | 0 | 237 | 1 | 70 | 148 | VDM34204.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 2820 | 116 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 32764179 | 32764179 | PRJNA532380_P_NODE_9840_length_297_cov_1.887097_g9515_i0 | PRJNA532380 | 9840 | 297 | 1.887097 | 5.60467809 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 63.2 | 3.43e-9 | NR | CAH8601556.1 | 39320 | g9515 | i0 | 52.5 | 1.16161616161616 | 61 | 27 | 61.6 | 1 | 183 | 1 | 43 | 101 | CAH8601556.1 unnamed protein product [Heterobilharzia americana] | diamond | 345 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana |
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);;