contig_metadata
20 rows where bioproject = "PRJNA756891", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10936077 | 10936077 | PRJNA756891_P_NODE_2089_length_575_cov_2.005976_g2021_i0 | PRJNA756891 | 2089 | 575 | 2.005976 | 11.534362 | Cestoda | 6199 | Platyhelminthes | Platyhelminthes | 283 | 7.210000000000001e-91 | NR | VUZ46957.1 | 6216 | g2021 | i0 | 73 | 28.8260869565217 | 189 | 50 | 98.1 | 1 | 574 | 11 | 145 | 333 | VUZ46957.1 unnamed protein product [Hymenolepis diminuta] | diamond | 16575 | 284 | 0.996478873239437 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 26809654 | 26809654 | PRJNA756891_P_NODE_9221_length_286_cov_2.276995_g9152_i0 | PRJNA756891 | 9221 | 286 | 2.276995 | 6.5122057 | Cestoda | 6199 | Platyhelminthes | Platyhelminthes | 110 | 6.9e-26 | NR | VDD82022.1 | 53468 | g9152 | i0 | 57.3 | 5.55944055944056 | 89 | 38 | 93.4 | 0 | 286 | 20 | 302 | 390 | VDD82022.1 unnamed protein product [Mesocestoides corti] | diamond | 1590 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 26841484 | 26841484 | PRJNA756891_P_NODE_14221_length_246_cov_0.890173_g14152_i0 | PRJNA756891 | 14221 | 246 | 0.890173 | 2.18982558 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 73.6 | 4.37e-13 | NR | VZI42884.1 | 99802 | g14152 | i0 | 66 | 1.21951219512195 | 50 | 17 | 61 | 0 | 2 | 151 | 329 | 378 | VZI42884.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 300 | 74.3 | 0.990578734858681 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 26936140 | 26936140 | PRJNA756891_P_NODE_7622_length_313_cov_1.604167_g7553_i0 | PRJNA756891 | 7622 | 313 | 1.604167 | 5.02104271 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 175 | 6.03e-49 | NR | KAF7261606.1 | 59628 | g7553 | i0 | 73.5 | 29.3290734824281 | 102 | 27 | 97.8 | 0 | 313 | 8 | 147 | 248 | KAF7261606.1 hypothetical protein EG68_01080 [Paragonimus skrjabini miyazakii] | diamond | 9180 | 176 | 0.994318181818182 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 27558252 | 27558252 | PRJNA756891_P_NODE_14544_length_245_cov_1.343023_g14475_i0 | PRJNA756891 | 14544 | 245 | 1.343023 | 3.29040635 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 53.5 | 6.06e-6 | NR | VDD74685.1 | 53468 | g14475 | i0 | 38 | 0.869387755102041 | 71 | 44 | 86.9 | 0 | 21 | 233 | 28 | 98 | VDD74685.1 unnamed protein product [Mesocestoides corti] | diamond | 213 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 27716710 | 27716710 | PRJNA756891_P_NODE_3904_length_425_cov_1.090909_g3835_i0 | PRJNA756891 | 3904 | 425 | 1.090909 | 4.63636325 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 100 | 2.64e-21 | NR | QAU32668.1 | 79327 | g3835 | i0 | 41.4 | 7.66588235294118 | 133 | 75 | 92.5 | 2 | 406 | 14 | 658 | 789 | QAU32668.1 Dach-1 [Schmidtea mediterranea] | diamond | 3258 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 28104900 | 28104900 | PRJNA756891_P_NODE_13425_length_248_cov_0.880000_g13356_i0 | PRJNA756891 | 13425 | 248 | 0.88 | 2.1824 | Fasciola | 6191 | Platyhelminthes | Platyhelminthes | 47 | 0.00129 | NR | THD19883.1 | 6192 | g13356 | i0 | 76.9 | 0.629032258064516 | 26 | 6 | 31.5 | 0 | 2 | 79 | 1077 | 1102 | THD19883.1 Serine/threonine-protein kinase LATS1 [Fasciola hepatica] | diamond | 156 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 28316311 | 28316311 | PRJNA756891_P_NODE_7386_length_318_cov_0.942857_g7317_i0 | PRJNA756891 | 7386 | 318 | 0.942857 | 2.99828526 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 52 | 5.2e-5 | NR | VZI15130.1 | 99802 | g7317 | i0 | 54.2 | 0.962264150943396 | 48 | 20 | 43.4 | 2 | 168 | 305 | 355 | 402 | VZI15130.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 306 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28357483 | 28357483 | PRJNA756891_P_NODE_8206_length_303_cov_1.339130_g8137_i0 | PRJNA756891 | 8206 | 303 | 1.33913 | 4.0575639 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 62.8 | 1.7e-9 | NR | KAK4467922.1 | 38744 | g8137 | i0 | 42.5 | 1.68316831683168 | 73 | 39 | 69.3 | 1 | 2 | 211 | 90 | 162 | KAK4467922.1 hypothetical protein MN116_008530 [Schistosoma mekongi] | diamond | 510 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mekongi | |
| 28411068 | 28411068 | PRJNA756891_P_NODE_10986_length_264_cov_1.612565_g10917_i0 | PRJNA756891 | 10986 | 264 | 1.612565 | 4.2571716 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 48.1 | 5.35e-4 | NR | PAA65719.1 | 282301 | g10917 | i0 | 51.2 | 0.465909090909091 | 41 | 20 | 46.6 | 0 | 18 | 140 | 247 | 287 | PAA65719.1 hypothetical protein BOX15_Mlig030451g1 [Macrostomum lignano] | diamond | 123 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28484009 | 28484009 | PRJNA756891_P_NODE_15566_length_243_cov_0.905882_g15497_i0 | PRJNA756891 | 15566 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 45.8 | 0.00306 | NR | VZI45584.1 | 99802 | g15497 | i0 | 38.8 | 5.65432098765432 | 67 | 32 | 75.3 | 2 | 183 | 1 | 344 | 407 | VZI45584.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 1374 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 29673622 | 29673622 | PRJNA756891_P_NODE_1690_length_632_cov_1.890877_g1623_i0 | PRJNA756891 | 1690 | 632 | 1.890877 | 11.95034264 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 160 | 8.88e-46 | NR | THD22317.1 | 6192 | g1623 | i0 | 46.2 | 1.68987341772152 | 173 | 90 | 82.1 | 1 | 598 | 80 | 8 | 177 | THD22317.1 Small GTP-binding protein Rab1 [Fasciola hepatica] | diamond | 1068 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 30094192 | 30094192 | PRJNA756891_P_NODE_8032_length_306_cov_1.708155_g7963_i0 | PRJNA756891 | 8032 | 306 | 1.708155 | 5.2269543 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 94 | 6.33e-20 | NR | VUZ50339.1 | 6216 | g7963 | i0 | 60 | 4.14705882352941 | 70 | 28 | 68.6 | 0 | 14 | 223 | 398 | 467 | VUZ50339.1 unnamed protein product [Hymenolepis diminuta] | diamond | 1269 | 94.7 | 0.992608236536431 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 30369337 | 30369337 | PRJNA756891_P_NODE_12352_length_251_cov_0.865169_g12283_i0 | PRJNA756891 | 12352 | 251 | 0.865169 | 2.17157419 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 120 | 9.42e-31 | NR | KAL3310133.1 | 1844966 | g12283 | i0 | 71.1 | 0.99203187250996006 | 83 | 23 | 99.2 | 1 | 2 | 250 | 145 | 226 | KAL3310133.1 GDP-L-fucose synthase [Cichlidogyrus casuarinus] | diamond | 249 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 30684726 | 30684726 | PRJNA756891_P_NODE_6413_length_337_cov_4.196970_g6344_i0 | PRJNA756891 | 6413 | 337 | 4.19697 | 14.1437889 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 73.2 | 1.08e-13 | NR | CUU99044.1 | 85433 | g6344 | i0 | 37.9 | 2.68842729970326 | 103 | 61 | 91.7 | 2 | 9 | 317 | 3 | 102 | CUU99044.1 hypothetical transcript [Hymenolepis microstoma] | diamond | 906 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 31042580 | 31042580 | PRJNA756891_P_NODE_11195_length_261_cov_3.686170_g11126_i0 | PRJNA756891 | 11195 | 261 | 3.68617 | 9.6209037 | Diphyllobothriidae | 28843 | Platyhelminthes | Platyhelminthes | 139 | 2.09e-37 | NR | VDN14717.1 | 60516 | g11126 | i0 | 69.4 | 5.88505747126437 | 85 | 26 | 97.7 | 0 | 5 | 259 | 235 | 319 | VDN14717.1 unnamed protein product [Dibothriocephalus latus] | diamond | 1536 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Dibothriocephalus | Dibothriocephalus latus | |
| 31263466 | 31263466 | PRJNA756891_P_NODE_3995_length_420_cov_2.893372_g3926_i0 | PRJNA756891 | 3995 | 420 | 2.893372 | 12.1521624 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 146 | 7.109999999999999e-38 | NR | CAH8829811.1 | 157070 | g3926 | i0 | 61.9 | 4.03571428571429 | 113 | 41 | 80.7 | 1 | 1 | 339 | 520 | 630 | CAH8829811.1 unnamed protein product [Trichobilharzia szidati] | diamond | 1695 | 146 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 31326652 | 31326652 | PRJNA756891_P_NODE_1495_length_667_cov_2.723906_g1431_i0 | PRJNA756891 | 1495 | 667 | 2.723906 | 18.16845302 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 135 | 2.78e-34 | NR | KAH8871687.1 | 6182 | g1431 | i0 | 41.7 | 3.61619190404798 | 206 | 104 | 85.5 | 5 | 666 | 97 | 72 | 277 | KAH8871687.1 MAP kinase-activated protein kinase 2 [Schistosoma japonicum] | diamond | 2412 | 136 | 0.992647058823529 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31822783 | 31822783 | PRJNA756891_P_NODE_15877_length_242_cov_1.366864_g15808_i0 | PRJNA756891 | 15877 | 242 | 1.366864 | 3.30781088 | Paragonimus kellicotti | 100269 | Platyhelminthes | Platyhelminthes | 47.8 | 6.19e-4 | NR | KAF6770646.1 | 100269 | g15808 | i0 | 30.5 | 2.03305785123967 | 82 | 53 | 97.9 | 2 | 2 | 238 | 179 | 259 | KAF6770646.1 hypothetical protein AHF37_09396 [Paragonimus kellicotti] | diamond | 492 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus kellicotti | |
| 32654667 | 32654667 | PRJNA756891_P_NODE_1100_length_766_cov_4.389610_g1038_i0 | PRJNA756891 | 1100 | 766 | 4.38961 | 33.6244126 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 48.1 | 0.0102 | NR | PAA72397.1 | 282301 | g1038 | i0 | 28.3 | 1.9934725848564 | 120 | 53 | 45.4 | 4 | 79 | 426 | 51 | 141 | PAA72397.1 hypothetical protein BOX15_Mlig017771g3 [Macrostomum lignano] | diamond | 1527 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano |
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);;