contig_metadata
11 rows where bioproject = "PRJNA689790", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5772303 | 5772303 | PRJNA689790_S_NODE_15325_length_156_cov_0.974790_g15210_i0 | PRJNA689790 | 15325 | 156 | 0.97479 | 1.5206724 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 122 | 9.66e-24 | NTclustered | gi|2318772314|ref|XM_012936387.3| | 6185 | g15210 | i0 | 81.169 | 10.1602564102564 | 154 | 27 | 98 | 2 | 3 | 155 | 628 | 780 | Schistosoma haematobium Guanine nucleotide-binding protein G(o) subunit alpha (GNAO1), partial mRNA | blastn | 1585 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 19029817 | 19029817 | PRJNA689790_S_NODE_4955_length_271_cov_15.799145_g4840_i0 | PRJNA689790 | 4955 | 271 | 15.799145 | 42.81568295 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 217 | 8.329999999999999e-52 | NTclustered | gi|393794039|dbj|AK388636.1| | 6161 | g4840 | i0 | 84.071 | 67.3394833948339 | 226 | 35 | 83 | 1 | 45 | 270 | 28 | 252 | Dugesia japonica cDNA, clone: Dj_aH_000_00546HH.full, full-insert sequence, expressed in adult head | blastn | 18249 | 217 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 23621599 | 23621599 | PRJNA689790_S_NODE_2479_length_407_cov_3.048649_g2364_i0 | PRJNA689790 | 2479 | 407 | 3.048649 | 12.40800143 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 243 | 2.16e-59 | NTclustered | gi|1116517974|gb|AY485340.2| | 6183 | g2364 | i0 | 89.231 | 74.4496314496315 | 195 | 19 | 48 | 2 | 214 | 407 | 227 | 34 | Schistosoma mansoni ubiquitin mRNA, partial cds | blastn | 30301 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 23621632 | 23621632 | PRJNA689790_S_NODE_7139_length_222_cov_1.264865_g7024_i0 | PRJNA689790 | 7139 | 222 | 1.264865 | 2.8080003 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 147 | 7.58e-43 | NR | Q26537.1 | 6183 | g7024 | i0 | 97.3 | 4 | 74 | 2 | 100 | 0 | 1 | 222 | 100 | 173 | Q26537.1 RecName: Full=14-3-3 protein homolog 2; Short=14-3-3-2 [Schistosoma mansoni] | diamond | 888 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 27303740 | 27303740 | PRJNA689790_S_NODE_4743_length_278_cov_2.016598_g4628_i0 | PRJNA689790 | 4743 | 278 | 2.016598 | 5.60614244 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 47.4 | 2.43e-4 | NR | PAA50148.1 | 282301 | g4628 | i0 | 38 | 1.95323741007194 | 92 | 44 | 96 | 3 | 2 | 268 | 12 | 93 | PAA50148.1 hypothetical protein BOX15_Mlig023356g3 [Macrostomum lignano] | diamond | 543 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27461722 | 27461722 | PRJNA689790_S_NODE_2263_length_430_cov_4.150127_g2150_i0 | PRJNA689790 | 2263 | 430 | 4.150127 | 17.8455461 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 140 | 5.61e-40 | NR | VDQ10672.1 | 157069 | g2150 | i0 | 63.2 | 1.48604651162791 | 106 | 39 | 74 | 0 | 374 | 57 | 17 | 122 | VDQ10672.1 unnamed protein product [Trichobilharzia regenti] | diamond | 639 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 28219098 | 28219098 | PRJNA689790_S_NODE_13906_length_162_cov_1.192000_g13791_i0 | PRJNA689790 | 13906 | 162 | 1.192 | 1.93104 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 60.8 | 5e-9 | NR | VZI26730.1 | 99802 | g13791 | i0 | 47.1 | 3.64814814814815 | 51 | 27 | 94.4 | 0 | 153 | 1 | 323 | 373 | VZI26730.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 591 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 29809429 | 29809429 | PRJNA689790_S_NODE_15671_length_154_cov_2.000000_g15556_i0 | PRJNA689790 | 15671 | 154 | 2 | 3.08 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 45.8 | 7.95e-4 | NR | RTG89397.1 | 6184 | g15556 | i0 | 56.5 | 8.04545454545454 | 46 | 20 | 89.6 | 0 | 13 | 150 | 73 | 118 | RTG89397.1 nascent polypeptide-associated complex subunit alpha, partial [Schistosoma bovis] | diamond | 1239 | 46.2 | 0.991341991341991 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 31832044 | 31832044 | PRJNA689790_S_NODE_13697_length_163_cov_0.928571_g13582_i0 | PRJNA689790 | 13697 | 163 | 0.928571 | 1.51357073 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 94.4 | 1.6000000000000002e-22 | NR | VDM24574.1 | 6205 | g13582 | i0 | 85.7 | 6.29447852760736 | 49 | 7 | 90.2 | 0 | 149 | 3 | 53 | 101 | VDM24574.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 1026 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 32053690 | 32053690 | PRJNA689790_S_NODE_13678_length_163_cov_1.230159_g13563_i0 | PRJNA689790 | 13678 | 163 | 1.230159 | 2.00515917 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 42.4 | 0.0178 | NR | KAA3677316.1 | 34504 | g13563 | i0 | 47.2 | 3.93865030674847 | 53 | 28 | 97.5 | 0 | 160 | 2 | 712 | 764 | KAA3677316.1 major vault protein [Paragonimus westermani] | diamond | 642 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 32465214 | 32465214 | PRJNA689790_S_NODE_5499_length_256_cov_2.004566_g5384_i0 | PRJNA689790 | 5499 | 256 | 2.004566 | 5.13168896 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 55.5 | 8.93e-8 | NR | CDS25427.1 | 85433 | g5384 | i0 | 41.7 | 5.25 | 84 | 44 | 94.9 | 3 | 5 | 247 | 2 | 83 | CDS25427.1 sec61 beta subunit [Hymenolepis microstoma] | diamond | 1344 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma |
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);;