contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1194475 | 1194475 | PRJNA725806_P_NODE_63941_length_230_cov_3.487047_g63643_i0 | PRJNA725806 | 63941 | 230 | 3.487047 | 8.0202081 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|1084296808|ref|XM_018799744.1| | 6183 | g63643 | i0 | 100 | 8.38260869565217 | 30 | 0 | 13 | 0 | 199 | 228 | 303 | 332 | Schistosoma mansoni hypothetical protein partial mRNA | blastn | 1928 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 1987792 | 1987792 | PRJNA725806_P_NODE_137602_length_174_cov_9.751825_g137300_i0 | PRJNA725806 | 137602 | 174 | 9.751825 | 16.9681755 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 56.5 | 0.001 | NTclustered | gi|393794534|dbj|AK388958.1| | 6161 | g137300 | i0 | 94.595 | 0.21264367816092 | 37 | 1 | 21 | 1 | 106 | 141 | 999 | 1035 | Dugesia japonica cDNA, clone: Dj_aH_000_05268HH.full, full-insert sequence, expressed in adult head | blastn | 37 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 1987933 | 1987933 | PRJNA725806_P_NODE_48702_length_250_cov_9.676056_g48405_i0 | PRJNA725806 | 48702 | 250 | 9.676056 | 24.19014 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.023 | NTclustered | gi|687180857|emb|LN128286.1| | 99802 | g48405 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 79 | 106 | 1453 | 1480 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0118897 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 4540303 | 4540303 | PRJNA725806_P_NODE_4364_length_456_cov_6.274463_g4091_i0 | PRJNA725806 | 4364 | 456 | 6.274463 | 28.61155128 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.044 | NTclustered | gi|687186282|emb|LN161081.1| | 99802 | g4091 | i0 | 100 | 0.12280701754386 | 28 | 0 | 6 | 0 | 329 | 356 | 1652 | 1679 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0144436 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5815325 | 5815325 | PRJNA725806_P_NODE_122685_length_182_cov_13.255172_g122383_i0 | PRJNA725806 | 122685 | 182 | 13.255172 | 24.12441304 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.015 | NTclustered | gi|690567416|emb|LN121433.1| | 99802 | g122383 | i0 | 100 | 0.153846153846154 | 28 | 0 | 15 | 0 | 147 | 174 | 1122 | 1095 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_contig0008224 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5815448 | 5815448 | PRJNA725806_P_NODE_21065_length_313_cov_10.119565_g20769_i0 | PRJNA725806 | 21065 | 313 | 10.119565 | 31.67423845 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.029 | NTclustered | gi|690456599|emb|LN001124.1| | 99802 | g20769 | i0 | 100 | 0.0894568690095847 | 28 | 0 | 9 | 0 | 282 | 309 | 18862 | 18835 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0001114 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 5815502 | 5815502 | PRJNA725806_P_NODE_42405_length_261_cov_2.022321_g42108_i0 | PRJNA725806 | 42405 | 261 | 2.022321 | 5.27825781 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 52.8 | 0.024 | NTclustered | gi|687398267|emb|LK718586.1| | 57078 | g42108 | i0 | 100 | 0.10727969348659 | 28 | 0 | 11 | 0 | 7 | 34 | 634 | 607 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0292937 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 7090701 | 7090701 | PRJNA725806_P_NODE_6106_length_422_cov_3.415584_g5823_i0 | PRJNA725806 | 6106 | 422 | 3.415584 | 14.41376448 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.041 | NTclustered | gi|690507929|emb|LN057301.1| | 99802 | g5823 | i0 | 100 | 0.0663507109004739 | 28 | 0 | 7 | 0 | 68 | 95 | 2800 | 2827 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0055598 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 8847555 | 8847555 | PRJNA725806_P_NODE_79407_length_214_cov_2.429379_g79106_i0 | PRJNA725806 | 79407 | 214 | 2.429379 | 5.19887106 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.019 | NTclustered | gi|687757281|emb|LK417269.1| | 57078 | g79106 | i0 | 100 | 0.261682242990654 | 28 | 0 | 13 | 0 | 130 | 157 | 922 | 949 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0023464 | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 10915796 | 10915796 | PRJNA725806_P_NODE_119969_length_184_cov_3.816327_g119667_i0 | PRJNA725806 | 119969 | 184 | 3.816327 | 7.02204168 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|687162359|emb|LN034991.1| | 99802 | g119667 | i0 | 100 | 0.157608695652174 | 29 | 0 | 16 | 0 | 58 | 86 | 696 | 668 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0034248 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 10915831 | 10915831 | PRJNA725806_P_NODE_139709_length_173_cov_8.375000_g139407_i0 | PRJNA725806 | 139709 | 173 | 8.375 | 14.48875 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.004 | NTclustered | gi|690515232|emb|LN065822.1| | 99802 | g139407 | i0 | 96.875 | 0.184971098265896 | 32 | 1 | 18 | 0 | 116 | 147 | 645 | 676 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0063622 | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 13948414 | 13948414 | PRJNA725806_P_NODE_94191_length_201_cov_7.914634_g93889_i0 | PRJNA725806 | 94191 | 201 | 7.914634 | 15.90841434 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 52.8 | 0.017 | NTclustered | gi|690531946|emb|LN082836.1| | 99802 | g93889 | i0 | 100 | 0.417910447761194 | 28 | 0 | 14 | 0 | 14 | 41 | 2685 | 2712 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0079320 | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 18563667 | 18563667 | PRJNA725806_P_NODE_45095_length_256_cov_6.534247_g44798_i0 | PRJNA725806 | 45095 | 256 | 6.534247 | 16.72767232 | Schistosoma haematobium | 6185 | Platyhelminthes | Platyhelminthes | 52.8 | 0.023 | NTclustered | gi|2318768089|ref|XM_051219304.1| | 6185 | g44798 | i0 | 100 | 0.109375 | 28 | 0 | 11 | 0 | 202 | 229 | 1707 | 1734 | Schistosoma haematobium ELAV-like protein 4 (ELAVL4), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 20320902 | 20320902 | PRJNA725806_P_NODE_40276_length_264_cov_11.541850_g39979_i0 | PRJNA725806 | 40276 | 264 | 11.54185 | 30.470484 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 52.8 | 0.024 | NTclustered | gi|1084310361|ref|XM_018790409.1| | 6183 | g39979 | i0 | 100 | 0.53030303030303 | 28 | 0 | 11 | 0 | 104 | 131 | 2074 | 2101 | Schistosoma mansoni kelch-like protein partial mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 21114262 | 21114262 | PRJNA725806_P_NODE_105597_length_193_cov_5.346154_g105295_i0 | PRJNA725806 | 105597 | 193 | 5.346154 | 10.31807722 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 62.1 | 2.76e-5 | NTclustered | gi|687490580|emb|LK668625.1| | 57078 | g105295 | i0 | 100 | 0.766839378238342 | 33 | 0 | 17 | 0 | 58 | 90 | 22 | 54 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_scaffold0248645 | blastn | 148 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 23664773 | 23664773 | PRJNA725806_P_NODE_132759_length_177_cov_3.221429_g132457_i0 | PRJNA725806 | 132759 | 177 | 3.221429 | 5.70192933 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.001 | NTclustered | gi|690605916|emb|LN160386.1| | 99802 | g132457 | i0 | 100 | 0.169491525423729 | 30 | 0 | 17 | 0 | 32 | 61 | 99 | 128 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0143943 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 23664812 | 23664812 | PRJNA725806_P_NODE_156199_length_166_cov_1.364341_g155897_i0 | PRJNA725806 | 156199 | 166 | 1.364341 | 2.26480606 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52.8 | 0.014 | NTclustered | gi|690660942|emb|LN210380.1| | 99802 | g155897 | i0 | 100 | 0.168674698795181 | 28 | 0 | 17 | 0 | 67 | 94 | 12 | 39 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0176483 | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei |
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);;