contig_metadata
15 rows where bioproject = "PRJNA431371", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4916119 | 4916119 | PRJNA431371_P_NODE_25244_length_251_cov_0.865169_g25171_i0 | PRJNA431371 | 25244 | 251 | 0.865169 | 2.17157419 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 112 | 6.91e-30 | NR | XP_024354652.1 | 6210 | g25171 | i0 | 70.3 | 27.8844621513944 | 74 | 22 | 88.4 | 0 | 223 | 2 | 12 | 85 | XP_024354652.1 60S ribosomal protein L31 [Echinococcus granulosus] | diamond | 6999 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 20829871 | 20829871 | PRJNA431371_P_NODE_23897_length_257_cov_1.255435_g23824_i0 | PRJNA431371 | 23897 | 257 | 1.255435 | 3.22646795 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 56.5 | 0.002 | NTclustered | gi|84617288|emb|AJ865376.1| | 6161 | g23824 | i0 | 87.755 | 5.88715953307393 | 49 | 4 | 19 | 2 | 209 | 257 | 47 | 1 | Dugesia japonica iwi gene for Piwi homologue | blastn | 1513 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 22764883 | 22764883 | PRJNA431371_P_NODE_19718_length_288_cov_1.116279_g19645_i0 | PRJNA431371 | 19718 | 288 | 1.116279 | 3.21488352 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 54.7 | 0.007 | NTclustered | gi|690545570|emb|LN098773.1| | 99802 | g19645 | i0 | 83.871 | 0.315972222222222 | 62 | 4 | 22 | 4 | 176 | 237 | 752 | 807 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0093663 | blastn | 91 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 26743685 | 26743685 | PRJNA431371_P_NODE_1341_length_853_cov_3.343590_g1278_i0 | PRJNA431371 | 1341 | 853 | 3.34359 | 28.5208227 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 126 | 3.4499999999999996e-30 | NR | TPP59227.1 | 46835 | g1278 | i0 | 38.2 | 5.65533411488863 | 228 | 124 | 79.5 | 7 | 97 | 774 | 96 | 308 | TPP59227.1 Retinol dehydrogenase 11 [Fasciola gigantica] | diamond | 4824 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 26886119 | 26886119 | PRJNA431371_P_NODE_15621_length_324_cov_1.215139_g15548_i0 | PRJNA431371 | 15621 | 324 | 1.215139 | 3.93705036 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 99 | 9.79e-22 | NR | CAL5138104.1 | 300641 | g15548 | i0 | 51.9 | 1 | 108 | 49 | 97.2 | 2 | 320 | 6 | 220 | 327 | CAL5138104.1 unnamed protein product [Calicophoron daubneyi] | diamond | 324 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 28071302 | 28071302 | PRJNA431371_P_NODE_12325_length_360_cov_1.341463_g12252_i0 | PRJNA431371 | 12325 | 360 | 1.341463 | 4.8292668 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 78.2 | 2.09e-14 | NR | VDN09839.1 | 60516 | g12252 | i0 | 38.7 | 6.96666666666667 | 119 | 53 | 99.2 | 3 | 360 | 4 | 142 | 240 | VDN09839.1 unnamed protein product [Dibothriocephalus latus] | diamond | 2508 | 78.6 | 0.994910941475827 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 29334340 | 29334340 | PRJNA431371_P_NODE_16549_length_315_cov_1.727273_g16476_i0 | PRJNA431371 | 16549 | 315 | 1.727273 | 5.44090995 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 57 | 8.49e-7 | NR | KAF8562128.1 | 34504 | g16476 | i0 | 50 | 9.2 | 62 | 30 | 59 | 1 | 251 | 66 | 764 | 824 | KAF8562128.1 hypothetical protein P879_04250 [Paragonimus westermani] | diamond | 2898 | 57.4 | 0.993031358885017 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 29349509 | 29349509 | PRJNA431371_P_NODE_21449_length_275_cov_2.118812_g21376_i0 | PRJNA431371 | 21449 | 275 | 2.118812 | 5.826733 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 52.8 | 1.57e-5 | NR | PAA93605.1 | 282301 | g21376 | i0 | 32.9 | 1.84363636363636 | 85 | 56 | 92.7 | 1 | 13 | 267 | 328 | 411 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 507 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29507226 | 29507226 | PRJNA431371_P_NODE_18650_length_296_cov_1.461883_g18577_i0 | PRJNA431371 | 18650 | 296 | 1.461883 | 4.32717368 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 44.7 | 0.0123 | NR | KAL3316124.1 | 1844966 | g18577 | i0 | 38.5 | 1.54054054054054 | 78 | 47 | 79.1 | 1 | 249 | 16 | 139 | 215 | KAL3316124.1 Transportin-1 [Cichlidogyrus casuarinus] | diamond | 456 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 29555166 | 29555166 | PRJNA431371_P_NODE_12990_length_351_cov_1.428058_g12917_i0 | PRJNA431371 | 12990 | 351 | 1.428058 | 5.01248358 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 47 | 0.004 | NR | USE40454.1 | 6161 | g12917 | i0 | 43.2 | 3.58119658119658 | 44 | 25 | 37.6 | 0 | 343 | 212 | 490 | 533 | USE40454.1 tyrosine phosphatase non-receptor type 11 protein [Dugesia japonica] | diamond | 1257 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 29886381 | 29886381 | PRJNA431371_P_NODE_1771_length_775_cov_4.730769_g1700_i0 | PRJNA431371 | 1771 | 775 | 4.730769 | 36.66345975 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 60.1 | 2.56e-6 | NR | PAA93605.1 | 282301 | g1700 | i0 | 30.1 | 1.26193548387097 | 163 | 105 | 61.9 | 5 | 480 | 1 | 270 | 426 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 978 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 29917937 | 29917937 | PRJNA431371_P_NODE_10091_length_393_cov_1.340625_g10018_i0 | PRJNA431371 | 10091 | 393 | 1.340625 | 5.26865625 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 122 | 1.06e-29 | NR | CAH8603584.1 | 57078 | g10018 | i0 | 41.5 | 7.61832061068702 | 123 | 72 | 93.9 | 0 | 11 | 379 | 106 | 228 | CAH8603584.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 2994 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 31229488 | 31229488 | PRJNA431371_P_NODE_23295_length_261_cov_1.638298_g23222_i0 | PRJNA431371 | 23295 | 261 | 1.638298 | 4.27595778 | Echinococcus | 6209 | Platyhelminthes | Platyhelminthes | 66.6 | 1.91e-10 | NR | XP_024350811.1 | 6210 | g23222 | i0 | 49.2 | 3.14942528735632 | 65 | 33 | 74.7 | 0 | 261 | 67 | 234 | 298 | XP_024350811.1 Centrosomal protein [Echinococcus granulosus] | diamond | 822 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31719278 | 31719278 | PRJNA431371_P_NODE_1237_length_874_cov_1.579276_g1174_i0 | PRJNA431371 | 1237 | 874 | 1.579276 | 13.80287224 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 89.7 | 4.09e-16 | NR | PAA86220.1 | 282301 | g1174 | i0 | 33.3 | 0.483981693363844 | 141 | 93 | 48.1 | 1 | 434 | 15 | 76 | 216 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 423 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31909071 | 31909071 | PRJNA431371_P_NODE_26277_length_250_cov_0.870056_g26204_i0 | PRJNA431371 | 26277 | 250 | 0.870056 | 2.17514 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 65.9 | 2.77e-10 | NR | CAH8630283.1 | 57078 | g26204 | i0 | 50.8 | 4.872 | 65 | 31 | 78 | 1 | 244 | 50 | 302 | 365 | CAH8630283.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 1218 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum |
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);;