contig_metadata
21 rows where bioproject = "PRJNA879314", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2133181 | 2133181 | PRJNA879314_P_NODE_222_length_867_cov_9.944584_g186_i0 | PRJNA879314 | 222 | 867 | 9.944584 | 86.21954328 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 1044 | 0 | NTclustered | gi|393794550|dbj|AK388974.1| | 6161 | g186 | i0 | 88.634 | 27.9515570934256 | 871 | 81 | 100 | 11 | 1 | 867 | 78 | 934 | Dugesia japonica cDNA, clone: Dj_aH_000_05707HH.full, full-insert sequence, expressed in adult head | blastn | 24234 | 1044 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 2133185 | 2133185 | PRJNA879314_P_NODE_2402_length_309_cov_1.131356_g2352_i0 | PRJNA879314 | 2402 | 309 | 1.131356 | 3.49589004 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 459 | 1.46e-124 | NTclustered | gi|393794084|dbj|AK388681.1| | 6161 | g2352 | i0 | 95.789 | 0.922330097087379 | 285 | 11 | 92 | 1 | 1 | 285 | 308 | 25 | Dugesia japonica cDNA, clone: Dj_aH_000_00806HN.full, full-insert sequence, expressed in adult head | blastn | 285 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 4686243 | 4686243 | PRJNA879314_P_NODE_3324_length_278_cov_1.136585_g3274_i0 | PRJNA879314 | 3324 | 278 | 1.136585 | 3.1597063 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 486 | 5.919999999999998e-133 | NTclustered | gi|393794643|dbj|AK389067.1| | 6161 | g3274 | i0 | 98.201 | 97.6079136690647 | 278 | 5 | 100 | 0 | 1 | 278 | 424 | 701 | Dugesia japonica cDNA, clone: Dj_aH_000_07236HH.full, full-insert sequence, expressed in adult head | blastn | 27135 | 486 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 4686283 | 4686283 | PRJNA879314_P_NODE_704_length_501_cov_2.128505_g654_i0 | PRJNA879314 | 704 | 501 | 2.128505 | 10.66381005 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 926 | 0 | NTclustered | gi|1473282894|gb|MH720463.1| | 6161 | g654 | i0 | 100 | 1 | 501 | 0 | 100 | 0 | 1 | 501 | 568 | 68 | Dugesia japonica glutathione S-transferase (GST) mRNA, complete cds | blastn | 501 | 926 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 5961119 | 5961119 | PRJNA879314_P_NODE_605_length_539_cov_1.339056_g555_i0 | PRJNA879314 | 605 | 539 | 1.339056 | 7.21751184 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 963 | 0 | NTclustered | gi|393794039|dbj|AK388636.1| | 6161 | g555 | i0 | 98.887 | 97.9721706864564 | 539 | 6 | 100 | 0 | 1 | 539 | 292 | 830 | Dugesia japonica cDNA, clone: Dj_aH_000_00546HH.full, full-insert sequence, expressed in adult head | blastn | 52807 | 963 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 7235979 | 7235979 | PRJNA879314_P_NODE_1486_length_365_cov_1.171233_g1436_i0 | PRJNA879314 | 1486 | 365 | 1.171233 | 4.27500045 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 675 | 0 | NTclustered | gi|1777427952|gb|MK882931.1| | 6161 | g1436 | i0 | 100 | 18.4931506849315 | 365 | 0 | 100 | 0 | 1 | 365 | 640 | 1004 | Dugesia japonica heat shock protein 70-1 mRNA, complete cds | blastn | 6750 | 675 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 9785668 | 9785668 | PRJNA879314_P_NODE_10468_length_243_cov_0.917647_g10418_i0 | PRJNA879314 | 10468 | 243 | 0.917647 | 2.22988221 | Fasciola gigantica | 46835 | Platyhelminthes | Platyhelminthes | 58.4 | 4.71e-4 | NTclustered | gi|1033730147|dbj|LC128326.1| | 46835 | g10418 | i0 | 94.737 | 13.2510288065844 | 38 | 0 | 16 | 2 | 3 | 40 | 33 | 68 | Fasciola gigantica mitochondrial nad1 gene for NADH dehydrogenase subunit 1, partial cds, haplotype: ND1-IN13 | blastn | 3220 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 11061554 | 11061554 | PRJNA879314_P_NODE_8049_length_247_cov_0.896552_g7999_i0 | PRJNA879314 | 8049 | 247 | 0.896552 | 2.21448344 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 73.1 | 1.71e-8 | NTclustered | gi|24796393|gb|AY066900.1| | 79327 | g7999 | i0 | 82.927 | 0.663967611336032 | 82 | 12 | 33 | 2 | 166 | 246 | 186 | 106 | Schmidtea mediterranea clone H.17.9d(T3) unknown mRNA sequence | blastn | 164 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 13611486 | 13611486 | PRJNA879314_P_NODE_2611_length_300_cov_1.030837_g2561_i0 | PRJNA879314 | 2611 | 300 | 1.030837 | 3.092511 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 549 | 8.119999999999997e-152 | NTclustered | gi|317018627|gb|GU479914.1| | 6161 | g2561 | i0 | 99.667 | 26.3966666666667 | 300 | 1 | 100 | 0 | 1 | 300 | 798 | 499 | Dugesia japonica glyceraldehyde 3-phosphate dehydrogenase mRNA, complete cds | blastn | 7919 | 549 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 19984534 | 19984534 | PRJNA879314_P_NODE_3396_length_276_cov_1.536946_g3346_i0 | PRJNA879314 | 3396 | 276 | 1.536946 | 4.24197096 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 433 | 7.76e-117 | NTclustered | gi|393794211|dbj|AK388808.1| | 6161 | g3346 | i0 | 94.928 | 1 | 276 | 14 | 100 | 0 | 1 | 276 | 61 | 336 | Dugesia japonica cDNA, clone: Dj_aH_000_02773HH.full, full-insert sequence, expressed in adult head | blastn | 276 | 433 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 21259891 | 21259891 | PRJNA879314_P_NODE_3097_length_284_cov_1.265403_g3047_i0 | PRJNA879314 | 3097 | 284 | 1.265403 | 3.59374452 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 470 | 6.109999999999999e-128 | NTclustered | gi|1777427954|gb|MK882932.1| | 6161 | g3047 | i0 | 95.946 | 1.69014084507042 | 296 | 0 | 100 | 1 | 1 | 284 | 2063 | 1768 | Dugesia japonica heat shock protein 70-2 mRNA, complete cds | blastn | 480 | 470 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 24191873 | 24191873 | PRJNA879314_P_NODE_3939_length_263_cov_1.168421_g3889_i0 | PRJNA879314 | 3939 | 263 | 1.168421 | 3.07294723 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 481 | 2.58e-131 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g3889 | i0 | 99.62 | 100 | 263 | 1 | 100 | 0 | 1 | 263 | 128 | 390 | Schistosoma japonicum unknown mRNA | blastn | 26300 | 481 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 25083945 | 25083945 | PRJNA879314_P_NODE_3700_length_269_cov_1.204082_g3650_i0 | PRJNA879314 | 3700 | 269 | 1.204082 | 3.23898058 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 442 | 1.2499999999999994e-119 | NTclustered | gi|393794084|dbj|AK388681.1| | 6161 | g3650 | i0 | 96.296 | 1.00371747211896 | 270 | 8 | 100 | 2 | 1 | 269 | 279 | 547 | Dugesia japonica cDNA, clone: Dj_aH_000_00806HN.full, full-insert sequence, expressed in adult head | blastn | 270 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 25084020 | 25084020 | PRJNA879314_P_NODE_9620_length_245_cov_0.889535_g9570_i0 | PRJNA879314 | 9620 | 245 | 0.889535 | 2.17936075 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 58.4 | 4.75e-4 | NTclustered | gi|690820157|emb|LN314824.1| | 99802 | g9570 | i0 | 92.683 | 1.00408163265306 | 41 | 1 | 16 | 2 | 131 | 170 | 464 | 425 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0094685 | blastn | 246 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 27308356 | 27308356 | PRJNA879314_P_NODE_663_length_516_cov_1.948081_g613_i0 | PRJNA879314 | 663 | 516 | 1.948081 | 10.05209796 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 94.4 | 3.11e-21 | NR | XP_051073430.1 | 6185 | g613 | i0 | 37.5 | 2.34302325581395 | 136 | 78 | 75.6 | 3 | 27 | 416 | 1 | 135 | XP_051073430.1 Cofilin-2, variant 2 [Schistosoma haematobium] | diamond | 1209 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 27474147 | 27474147 | PRJNA879314_P_NODE_7443_length_248_cov_0.891429_g7393_i0 | PRJNA879314 | 7443 | 248 | 0.891429 | 2.21074392 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 99.8 | 3.5700000000000003e-22 | NR | CAH8434418.1 | 39320 | g7393 | i0 | 59.8 | 16.8629032258065 | 82 | 32 | 98 | 1 | 245 | 3 | 861 | 942 | CAH8434418.1 unnamed protein product [Heterobilharzia americana] | diamond | 4182 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 31105818 | 31105818 | PRJNA879314_P_NODE_975_length_428_cov_1.583099_g925_i0 | PRJNA879314 | 975 | 428 | 1.583099 | 6.77566372 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 137 | 9.31e-37 | NR | TNN11975.1 | 6182 | g925 | i0 | 49.6 | 4.85046728971963 | 133 | 66 | 92.5 | 1 | 31 | 426 | 155 | 287 | TNN11975.1 DM9 domain-containing protein [Schistosoma japonicum] | diamond | 2076 | 138 | 0.992753623188406 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31327192 | 31327192 | PRJNA879314_P_NODE_2055_length_325_cov_1.547619_g2005_i0 | PRJNA879314 | 2055 | 325 | 1.547619 | 5.02976175 | Fasciola | 6191 | Platyhelminthes | Platyhelminthes | 105 | 7.19e-26 | NR | THD27201.1 | 6192 | g2005 | i0 | 46.3 | 1.99384615384615 | 108 | 58 | 99.7 | 0 | 325 | 2 | 88 | 195 | THD27201.1 DM9 domain-containing protein [Fasciola hepatica] | diamond | 648 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31359011 | 31359011 | PRJNA879314_P_NODE_3016_length_286_cov_2.197183_g2966_i0 | PRJNA879314 | 3016 | 286 | 2.197183 | 6.28394338 | root | 1 | Root_unresolved | Root_unresolved | 111 | 9.51e-27 | NR | BAA08663.1 | 6161 | g2966 | i0 | 52.1 | 2.93706293706294 | 94 | 45 | 98.6 | 0 | 1 | 282 | 149 | 242 | BAA08663.1 elongation factor-1alpha, partial [Dugesia japonica] | diamond | 840 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 31825142 | 31825142 | PRJNA879314_P_NODE_8077_length_247_cov_0.896552_g8027_i0 | PRJNA879314 | 8077 | 247 | 0.896552 | 2.21448344 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 104 | 4.52e-24 | NR | AKG62128.1 | 79327 | g8027 | i0 | 61.5 | 0.947368421052632 | 78 | 30 | 94.7 | 0 | 6 | 239 | 230 | 307 | AKG62128.1 serrate RNA effector molecule, partial [Schmidtea mediterranea] | diamond | 234 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 32844399 | 32844399 | PRJNA879314_P_NODE_11500_length_230_cov_2.050955_g11450_i0 | PRJNA879314 | 11500 | 230 | 2.050955 | 4.7171965 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 118 | 1.9099999999999997e-30 | NR | VDP98910.1 | 157069 | g11450 | i0 | 78.2 | 6.10434782608696 | 78 | 15 | 99.1 | 1 | 2 | 229 | 196 | 273 | VDP98910.1 unnamed protein product [Trichobilharzia regenti] | diamond | 1404 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti |
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);;