contig_metadata
11 rows where bioproject = "PRJEB14175", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 25501520 | 25501520 | PRJEB14175_P_NODE_112657_length_332_cov_10.435424_g110391_i0 | PRJEB14175 | 112657 | 332 | 10.435424 | 34.64560768 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 187 | 8.219999999999999e-43 | NTclustered | gi|690681150|emb|LN233574.1| | 99802 | g110391 | i0 | 88.462 | 67.8493975903614 | 156 | 17 | 47 | 1 | 159 | 313 | 302 | 147 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0188913 | blastn | 22526 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 25916158 | 25916158 | PRJEB14175_P_NODE_257788_length_201_cov_2.164286_g255520_i0 | PRJEB14175 | 257788 | 201 | 2.164286 | 4.35021486 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 62.1 | 2.9e-5 | NTclustered | gi|690506172|emb|LN055201.1| | 99802 | g255520 | i0 | 93.023 | 0.213930348258706 | 43 | 2 | 21 | 1 | 78 | 119 | 2460 | 2418 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0053601 | blastn | 43 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 26182719 | 26182719 | PRJEB14175_P_NODE_127126_length_308_cov_2.809717_g124859_i0 | PRJEB14175 | 127126 | 308 | 2.809717 | 8.65392836 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 102 | 2.81e-17 | NTclustered | gi|687789777|emb|LK829830.1| | 57078 | g124859 | i0 | 96.721 | 19.6038961038961 | 61 | 2 | 20 | 0 | 3 | 63 | 597 | 537 | Dicrocoelium dendriticum genome assembly D_dendriticum_Leon_v1_0_4, scaffold DDEL_contig0063667 | blastn | 6038 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 26183503 | 26183503 | PRJEB14175_P_NODE_143686_length_284_cov_14.139013_g141419_i0 | PRJEB14175 | 143686 | 284 | 14.139013 | 40.15479692 | Urastoma cyprinae | 84118 | Platyhelminthes | Platyhelminthes | 111 | 4.27e-20 | NTclustered | gi|14530194|emb|AJ313230.1| | 84118 | g141419 | i0 | 82.443 | 48.1866197183099 | 131 | 20 | 46 | 3 | 131 | 261 | 815 | 688 | Urastoma cyprinae partial 28S rRNA gene | blastn | 13685 | 111 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Urastomidae | Urastoma | Urastoma cyprinae | ||
| 26321099 | 26321099 | PRJEB14175_P_NODE_184839_length_240_cov_7.843575_g182572_i0 | PRJEB14175 | 184839 | 240 | 7.843575 | 18.82458 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 54.7 | 0.006 | NTclustered | gi|690543326|emb|LN096236.1| | 99802 | g182572 | i0 | 100 | 0.120833333333333 | 29 | 0 | 12 | 0 | 44 | 72 | 929 | 901 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0091419 | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 32939582 | 32939582 | PRJEB14175_P_NODE_162873_length_262_cov_1.273632_g160606_i0 | PRJEB14175 | 162873 | 262 | 1.273632 | 3.33691584 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 47.8 | 7.87e-4 | NR | TNN13271.1 | 6182 | g160606 | i0 | 95.5 | 456.458015267176 | 22 | 1 | 25.2 | 0 | 260 | 195 | 318 | 339 | TNN13271.1 Protein FEV [Schistosoma japonicum] | diamond | 119592 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32956675 | 32956675 | PRJEB14175_P_NODE_101450_length_354_cov_16.071672_g99184_i0 | PRJEB14175 | 101450 | 354 | 16.071672 | 56.89371888 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 65.5 | 5.8e-11 | NR | AAP06323.1 | 6182 | g99184 | i0 | 74.4 | 7.04237288135593 | 43 | 11 | 36.4 | 0 | 206 | 334 | 66 | 108 | AAP06323.1 SJCHGC06193 protein [Schistosoma japonicum] | diamond | 2493 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32974197 | 32974197 | PRJEB14175_P_NODE_80266_length_407_cov_16.670520_g78004_i0 | PRJEB14175 | 80266 | 407 | 16.67052 | 67.8490164 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.026 | NR | THD26651.1 | 6192 | g78004 | i0 | 29.3 | 1.98280098280098 | 99 | 69 | 73 | 1 | 336 | 40 | 342 | 439 | THD26651.1 hypothetical protein D915_002490 [Fasciola hepatica] | diamond | 807 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 32978304 | 32978304 | PRJEB14175_P_NODE_277899_length_173_cov_8.000000_g275631_i0 | PRJEB14175 | 277899 | 173 | 8 | 13.84 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 61.2 | 4.49e-10 | NR | AAW27122.1 | 6182 | g275631 | i0 | 87.1 | 0.53757225433526 | 31 | 4 | 53.8 | 0 | 33 | 125 | 19 | 49 | AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] | diamond | 93 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 33041884 | 33041884 | PRJEB14175_P_NODE_101620_length_354_cov_3.587031_g99354_i0 | PRJEB14175 | 101620 | 354 | 3.587031 | 12.69808974 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 124 | 2.29e-30 | NR | VDP91574.1 | 27848 | g99354 | i0 | 54.8 | 7.30508474576271 | 104 | 46 | 87.3 | 1 | 332 | 24 | 583 | 686 | VDP91574.1 unnamed protein product [Echinostoma caproni] | diamond | 2586 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 33110360 | 33110360 | PRJEB14175_P_NODE_223222_length_211_cov_3.400000_g220954_i0 | PRJEB14175 | 223222 | 211 | 3.4 | 7.174 | Taeniidae | 6208 | Platyhelminthes | Platyhelminthes | 61.6 | 5.4e-9 | NR | VDM32539.1 | 6205 | g220954 | i0 | 50.8 | 6.35545023696682 | 61 | 29 | 86.7 | 1 | 4 | 186 | 140 | 199 | VDM32539.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 1341 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis |
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);;