contig_metadata
15 rows where bioproject = "PRJEB75017" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6513426 | 6513426 | PRJEB75017_P_NODE_12826_length_261_cov_1.638298_g12697_i0 | PRJEB75017 | 12826 | 261 | 1.638298 | 4.27595778 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 107 | 2.7600000000000004e-27 | NR | CAH8445308.1 | 39320 | g12697 | i0 | 70.4 | 8.7816091954023 | 71 | 21 | 81.6 | 0 | 1 | 213 | 84 | 154 | CAH8445308.1 unnamed protein product [Heterobilharzia americana] | diamond | 2292 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 11198887 | 11198887 | PRJEB75017_P_NODE_8149_length_315_cov_0.966942_g8020_i0 | PRJEB75017 | 8149 | 315 | 0.966942 | 3.0458673 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 239 | 2.11e-58 | NTclustered | gi|1084312253|ref|XM_018795509.1| | 6183 | g8020 | i0 | 82.007 | 26.2253968253968 | 289 | 44 | 90 | 7 | 31 | 315 | 1686 | 1402 | Schistosoma mansoni myosin heavy chain, putative partial mRNA | blastn | 8261 | 239 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 12888957 | 12888957 | PRJEB75017_P_NODE_531_length_1121_cov_3.121183_g459_i0 | PRJEB75017 | 531 | 1121 | 3.121183 | 34.98846143 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 625 | 5.359999999999999e-174 | NTclustered | gi|1369885|gb|L78441.1|SCM14332R | 6183 | g459 | i0 | 85.289 | 9.05263157894737 | 605 | 89 | 80 | 0 | 356 | 960 | 605 | 1 | Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds | blastn | 10148 | 625 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 17986922 | 17986922 | PRJEB75017_P_NODE_15395_length_249_cov_0.886364_g15266_i0 | PRJEB75017 | 15395 | 249 | 0.886364 | 2.20704636 | Dugesia japonica | 6161 | Platyhelminthes | Platyhelminthes | 224 | 4.5099999999999996e-54 | NTclustered | gi|326417553|gb|HM204940.1| | 6161 | g15266 | i0 | 86.634 | 24.9718875502008 | 202 | 27 | 81 | 0 | 36 | 237 | 11 | 212 | Dugesia japonica Rho2 GTPase mRNA, complete cds | blastn | 6218 | 224 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia japonica | |
| 26868910 | 26868910 | PRJEB75017_P_NODE_10221_length_287_cov_1.088785_g10092_i0 | PRJEB75017 | 10221 | 287 | 1.088785 | 3.12481295 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.6 | 7.86e-7 | NR | KAF5405861.1 | 100268 | g10092 | i0 | 56.5 | 1.5052264808362401 | 46 | 19 | 48.1 | 1 | 286 | 149 | 349 | 393 | KAF5405861.1 3-hydroxyisobutyryl-CoA hydrolase mitochondrial [Paragonimus heterotremus] | diamond | 432 | 56.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus heterotremus | |
| 27002304 | 27002304 | PRJEB75017_P_NODE_15222_length_250_cov_0.881356_g15093_i0 | PRJEB75017 | 15222 | 250 | 0.881356 | 2.20339 | Schistosoma mekongi | 38744 | Platyhelminthes | Platyhelminthes | 43.1 | 0.00562 | NR | KAK4474356.1 | 38744 | g15093 | i0 | 66.7 | 0.324 | 27 | 9 | 32.4 | 0 | 248 | 168 | 65 | 91 | KAK4474356.1 hypothetical protein MN116_001519 [Schistosoma mekongi] | diamond | 81 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mekongi | |
| 27816865 | 27816865 | PRJEB75017_P_NODE_1064_length_827_cov_1.230769_g957_i0 | PRJEB75017 | 1064 | 827 | 1.230769 | 10.17845963 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 259 | 2.87e-76 | NR | PAA76323.1 | 282301 | g957 | i0 | 53 | 5.8403869407497 | 270 | 108 | 96.9 | 4 | 826 | 26 | 336 | 589 | PAA76323.1 hypothetical protein BOX15_Mlig015150g8 [Macrostomum lignano] | diamond | 4830 | 259 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28448322 | 28448322 | PRJEB75017_P_NODE_11266_length_277_cov_0.799020_g11137_i0 | PRJEB75017 | 11266 | 277 | 0.79902 | 2.2132854 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 92.4 | 2e-19 | NR | VDL20006.1 | 6216 | g11137 | i0 | 46.7 | 6.82310469314079 | 90 | 48 | 97.5 | 0 | 1 | 270 | 128 | 217 | VDL20006.1 unnamed protein product [Hymenolepis diminuta] | diamond | 1890 | 92.8 | 0.995689655172414 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 29150396 | 29150396 | PRJEB75017_P_NODE_9849_length_290_cov_2.156682_g9720_i0 | PRJEB75017 | 9849 | 290 | 2.156682 | 6.2543778 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 98.6 | 1.62e-21 | NR | VDL17052.1 | 6216 | g9720 | i0 | 51 | 2.77241379310345 | 100 | 44 | 98.3 | 1 | 5 | 289 | 1533 | 1632 | VDL17052.1 unnamed protein product [Hymenolepis diminuta] | diamond | 804 | 98.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 29963820 | 29963820 | PRJEB75017_P_NODE_12771_length_262_cov_1.238095_g12642_i0 | PRJEB75017 | 12771 | 262 | 1.238095 | 3.2438089 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 51.2 | 5.07e-5 | NR | XP_009173188.1 | 6198 | g12642 | i0 | 69 | 0.755725190839695 | 29 | 9 | 33.2 | 0 | 240 | 154 | 1040 | 1068 | XP_009173188.1 hypothetical protein T265_08977 [Opisthorchis viverrini] | diamond | 198 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 30034302 | 30034302 | PRJEB75017_P_NODE_8051_length_317_cov_0.959016_g7922_i0 | PRJEB75017 | 8051 | 317 | 0.959016 | 3.04008072 | Fasciola gigantica | 46835 | Platyhelminthes | Platyhelminthes | 42.7 | 0.0308 | NR | TPP67752.1 | 46835 | g7922 | i0 | 39.2 | 0.482649842271293 | 51 | 31 | 48.3 | 0 | 157 | 5 | 12 | 62 | TPP67752.1 Myotrophin [Fasciola gigantica] | diamond | 153 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 30785220 | 30785220 | PRJEB75017_P_NODE_17534_length_244_cov_0.912281_g17405_i0 | PRJEB75017 | 17534 | 244 | 0.912281 | 2.22596564 | Cestoda | 6199 | Platyhelminthes | Platyhelminthes | 46.6 | 0.00156 | NR | VDD79367.1 | 53468 | g17405 | i0 | 77.3 | 2.12704918032787 | 22 | 5 | 27 | 0 | 3 | 68 | 405 | 426 | VDD79367.1 unnamed protein product [Mesocestoides corti] | diamond | 519 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 31480960 | 31480960 | PRJEB75017_P_NODE_18356_length_242_cov_0.923077_g18227_i0 | PRJEB75017 | 18356 | 242 | 0.923077 | 2.23384634 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 63.9 | 1.18e-9 | NR | CDS27417.1 | 85433 | g18227 | i0 | 51.5 | 7.99586776859504 | 68 | 27 | 84.3 | 2 | 206 | 3 | 40 | 101 | CDS27417.1 NADH dehydrogenase (ubiquinone) 1 alpha [Hymenolepis microstoma] | diamond | 1935 | 64.3 | 0.993779160186625 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 31551364 | 31551364 | PRJEB75017_P_NODE_16816_length_246_cov_0.901734_g16687_i0 | PRJEB75017 | 16816 | 246 | 0.901734 | 2.21826564 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 54.3 | 3.27e-6 | NR | PAA71225.1 | 282301 | g16687 | i0 | 38.6 | 1.70731707317073 | 70 | 43 | 85.4 | 0 | 245 | 36 | 573 | 642 | PAA71225.1 hypothetical protein BOX15_Mlig034412g1, partial [Macrostomum lignano] | diamond | 420 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32468838 | 32468838 | PRJEB75017_P_NODE_18219_length_242_cov_1.810651_g18090_i0 | PRJEB75017 | 18219 | 242 | 1.810651 | 4.38177542 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 52.8 | 1.08e-5 | NR | CAH8660513.1 | 39320 | g18090 | i0 | 37.8 | 2.82644628099174 | 74 | 40 | 91.7 | 1 | 230 | 9 | 138 | 205 | CAH8660513.1 unnamed protein product [Heterobilharzia americana] | diamond | 684 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana |
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);;