contig_metadata
25 rows where analysis = "diamond", bioproject = "PRJNA781427" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8414996 | 8414996 | PRJNA781427_P_NODE_91967_length_243_cov_0.905882_g91083_i0 | PRJNA781427 | 91967 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 149 | 2.52e-43 | NR | Q26537.1 | 6183 | g91083 | i0 | 96.3 | 5 | 81 | 3 | 100 | 0 | 243 | 1 | 24 | 104 | Q26537.1 RecName: Full=14-3-3 protein homolog 2; Short=14-3-3-2 [Schistosoma mansoni] | diamond | 1215 | 149 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 9688498 | 9688498 | PRJNA781427_P_NODE_1848_length_1962_cov_38.534145_g1522_i1 | PRJNA781427 | 1848 | 1962 | 38.534145 | 756.0399249 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 393 | 5.869999999999998e-121 | NR | CDS31835.1 | 85433 | g1522 | i1 | 40.3 | 4.97706422018349 | 491 | 247 | 68.5 | 8 | 1863 | 520 | 338 | 825 | CDS31835.1 Papilin [Hymenolepis microstoma] | diamond | 9765 | 393 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 21162576 | 21162576 | PRJNA781427_P_NODE_1697_length_2028_cov_36.787724_g1522_i0 | PRJNA781427 | 1697 | 2028 | 36.787724 | 746.05504272 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 393 | 1.13e-120 | NR | CDS31835.1 | 85433 | g1522 | i0 | 40.3 | 4.81508875739645 | 491 | 247 | 66.3 | 8 | 100 | 1443 | 338 | 825 | CDS31835.1 Papilin [Hymenolepis microstoma] | diamond | 9765 | 393 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 21163930 | 21163930 | PRJNA781427_P_NODE_6917_length_1054_cov_7.074414_g6338_i0 | PRJNA781427 | 6917 | 1054 | 7.074414 | 74.56432356 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 83.6 | 5.52e-14 | NR | PAA81674.1 | 282301 | g6338 | i0 | 56.2 | 0.42409867172675503 | 73 | 32 | 20.8 | 0 | 934 | 716 | 26 | 98 | PAA81674.1 hypothetical protein BOX15_Mlig021371g5, partial [Macrostomum lignano] | diamond | 447 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 26736620 | 26736620 | PRJNA781427_P_NODE_46101_length_334_cov_0.988506_g45218_i0 | PRJNA781427 | 46101 | 334 | 0.988506 | 3.30161004 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 60.8 | 4.66e-8 | NR | CAH8863097.1 | 157069 | g45218 | i0 | 29.5 | 7.76047904191617 | 132 | 56 | 85.3 | 2 | 10 | 294 | 185 | 316 | CAH8863097.1 unnamed protein product [Trichobilharzia regenti] | diamond | 2592 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 27094484 | 27094484 | PRJNA781427_P_NODE_24642_length_479_cov_1.041872_g23763_i0 | PRJNA781427 | 24642 | 479 | 1.041872 | 4.99056688 | Plagiorchiida | 27871 | Platyhelminthes | Platyhelminthes | 49.7 | 0.00136 | NR | CAH8644972.1 | 57078 | g23763 | i0 | 66.7 | 0.8580375782881 | 33 | 11 | 20.7 | 0 | 441 | 343 | 379 | 411 | CAH8644972.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 411 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 27821200 | 27821200 | PRJNA781427_P_NODE_10964_length_797_cov_2.627072_g10220_i0 | PRJNA781427 | 10964 | 797 | 2.627072 | 20.93776384 | Opisthorchiidae | 6196 | Platyhelminthes | Platyhelminthes | 56.2 | 6.29e-6 | NR | OON18335.1 | 6198 | g10220 | i0 | 35.7 | 0.737766624843162 | 98 | 52 | 36.9 | 1 | 699 | 406 | 17 | 103 | OON18335.1 hypothetical protein X801_05811 [Opisthorchis viverrini] | diamond | 588 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 28285090 | 28285090 | PRJNA781427_P_NODE_73166_length_253_cov_1.283333_g72282_i0 | PRJNA781427 | 73166 | 253 | 1.283333 | 3.24683249 | Clonorchis sinensis | 79923 | Platyhelminthes | Platyhelminthes | 70.5 | 2.65e-12 | NR | GAA27164.2 | 79923 | g72282 | i0 | 46.7 | 2.64426877470356 | 75 | 40 | 88.9 | 0 | 20 | 244 | 126 | 200 | GAA27164.2 hypothetical protein CLF_103367 [Clonorchis sinensis] | diamond | 669 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 28380009 | 28380009 | PRJNA781427_P_NODE_34326_length_393_cov_1.868750_g33445_i0 | PRJNA781427 | 34326 | 393 | 1.86875 | 7.3441875 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 51.2 | 1.85e-5 | NR | PAA74596.1 | 282301 | g33445 | i0 | 30.3 | 1.16793893129771 | 76 | 46 | 55.7 | 2 | 80 | 298 | 9 | 80 | PAA74596.1 hypothetical protein BOX15_Mlig015166g3, partial [Macrostomum lignano] | diamond | 459 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28642099 | 28642099 | PRJNA781427_P_NODE_34207_length_394_cov_1.398754_g33326_i0 | PRJNA781427 | 34207 | 394 | 1.398754 | 5.51109076 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 68.2 | 2.47e-10 | NR | VZI26196.1 | 99802 | g33326 | i0 | 45.2 | 3.04568527918782 | 93 | 34 | 57.9 | 2 | 92 | 319 | 398 | 490 | VZI26196.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 1200 | 68.6 | 0.994169096209913 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28695929 | 28695929 | PRJNA781427_P_NODE_27627_length_446_cov_1.742627_g26746_i0 | PRJNA781427 | 27627 | 446 | 1.742627 | 7.77211642 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 47.4 | 0.00109 | NR | VDN98382.1 | 102285 | g26746 | i0 | 47.6 | 0.282511210762332 | 42 | 22 | 28.3 | 0 | 1 | 126 | 67 | 108 | VDN98382.1 unnamed protein product [Rodentolepis nana] | diamond | 126 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 29052552 | 29052552 | PRJNA781427_P_NODE_76248_length_250_cov_1.096045_g75364_i0 | PRJNA781427 | 76248 | 250 | 1.096045 | 2.7401125 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 78.6 | 1.02e-14 | NR | CAX83703.1 | 6182 | g75364 | i0 | 45.6 | 11.856 | 79 | 39 | 90 | 1 | 7 | 231 | 253 | 331 | CAX83703.1 Gag-Pol polyprotein [Schistosoma japonicum] | diamond | 2964 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29263912 | 29263912 | PRJNA781427_P_NODE_50909_length_316_cov_0.950617_g50026_i0 | PRJNA781427 | 50909 | 316 | 0.950617 | 3.00394972 | Echinostoma caproni | 27848 | Platyhelminthes | Platyhelminthes | 63.9 | 1.49e-9 | NR | VDP92820.1 | 27848 | g50026 | i0 | 37.9 | 0.626582278481013 | 66 | 41 | 62.7 | 0 | 315 | 118 | 109 | 174 | VDP92820.1 unnamed protein product [Echinostoma caproni] | diamond | 198 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Echinostomatidae | Echinostoma | Echinostoma caproni | |
| 29516535 | 29516535 | PRJNA781427_P_NODE_27790_length_445_cov_0.948925_g26909_i0 | PRJNA781427 | 27790 | 445 | 0.948925 | 4.22271625 | Schistosoma bovis | 6184 | Platyhelminthes | Platyhelminthes | 60.8 | 1.67e-7 | NR | RTG88168.1 | 6184 | g26909 | i0 | 44.4 | 0.970786516853933 | 144 | 70 | 91 | 2 | 38 | 442 | 1011 | 1153 | RTG88168.1 uncharacterized protein DC041_0012488 [Schistosoma bovis] | diamond | 432 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma bovis | |
| 30085067 | 30085067 | PRJNA781427_P_NODE_88712_length_245_cov_0.883721_g87828_i0 | PRJNA781427 | 88712 | 245 | 0.883721 | 2.16511645 | Trichobilharzia szidati | 157070 | Platyhelminthes | Platyhelminthes | 66.2 | 2.02e-10 | NR | CAH8850936.1 | 157070 | g87828 | i0 | 46.1 | 5.69387755102041 | 76 | 40 | 93.1 | 1 | 228 | 1 | 848 | 922 | CAH8850936.1 unnamed protein product [Trichobilharzia szidati] | diamond | 1395 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia szidati | |
| 30347786 | 30347786 | PRJNA781427_P_NODE_55572_length_300_cov_1.132159_g54689_i0 | PRJNA781427 | 55572 | 300 | 1.132159 | 3.396477 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 111 | 5.830000000000001e-27 | NR | XP_009171718.1 | 6198 | g54689 | i0 | 66.3 | 11.8 | 80 | 27 | 80 | 0 | 252 | 13 | 240 | 319 | XP_009171718.1 hypothetical protein T265_14397 [Opisthorchis viverrini] | diamond | 3540 | 112 | 0.991071428571429 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 30369994 | 30369994 | PRJNA781427_P_NODE_66292_length_271_cov_1.161616_g65408_i0 | PRJNA781427 | 66292 | 271 | 1.161616 | 3.14797936 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 121 | 5.66e-32 | NR | PAA64903.1 | 282301 | g65408 | i0 | 92.1 | 50.2140221402214 | 63 | 5 | 69.7 | 0 | 270 | 82 | 166 | 228 | PAA64903.1 hypothetical protein BOX15_Mlig005313g1 [Macrostomum lignano] | diamond | 13608 | 122 | 0.991803278688525 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30433060 | 30433060 | PRJNA781427_P_NODE_12793_length_723_cov_1.761538_g12005_i0 | PRJNA781427 | 12793 | 723 | 1.761538 | 12.73591974 | Dicrocoelium dendriticum | 57078 | Platyhelminthes | Platyhelminthes | 56.2 | 4.69e-5 | NR | CAH8462670.1 | 57078 | g12005 | i0 | 36.2 | 0.390041493775934 | 94 | 32 | 39 | 2 | 659 | 378 | 1 | 66 | CAH8462670.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 282 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 30527458 | 30527458 | PRJNA781427_P_NODE_8413_length_936_cov_3.332561_g7765_i0 | PRJNA781427 | 8413 | 936 | 3.332561 | 31.19277096 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 123 | 1.35e-28 | NR | PAA79683.1 | 282301 | g7765 | i0 | 44.7 | 0.487179487179487 | 152 | 83 | 48.4 | 1 | 485 | 33 | 178 | 329 | PAA79683.1 hypothetical protein BOX15_Mlig004819g2, partial [Macrostomum lignano] | diamond | 456 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30916162 | 30916162 | PRJNA781427_P_NODE_48714_length_324_cov_0.928287_g47831_i0 | PRJNA781427 | 48714 | 324 | 0.928287 | 3.00764988 | root | 1 | Root_unresolved | Root_unresolved | 60.5 | 5.36e-8 | NR | XP_051069536.1 | 6185 | g47831 | i0 | 76.5 | 4.88888888888889 | 34 | 8 | 31.5 | 0 | 215 | 316 | 346 | 379 | XP_051069536.1 hypothetical protein MS3_00005476 [Schistosoma haematobium] | diamond | 1584 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 30947797 | 30947797 | PRJNA781427_P_NODE_90294_length_244_cov_0.900585_g89410_i0 | PRJNA781427 | 90294 | 244 | 0.900585 | 2.1974274 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 53.5 | 5.77e-6 | NR | CAH8822413.1 | 157069 | g89410 | i0 | 42.9 | 5.55737704918033 | 56 | 32 | 68.9 | 0 | 170 | 3 | 572 | 627 | CAH8822413.1 unnamed protein product [Trichobilharzia regenti] | diamond | 1356 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 31190666 | 31190666 | PRJNA781427_P_NODE_7315_length_1021_cov_6.145570_g6714_i0 | PRJNA781427 | 7315 | 1021 | 6.14557 | 62.7462697 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 50.8 | 0.00699 | NR | VDD75794.1 | 53468 | g6714 | i0 | 48.9 | 0.132223310479922 | 45 | 22 | 13.2 | 1 | 109 | 243 | 402 | 445 | VDD75794.1 unnamed protein product [Mesocestoides corti] | diamond | 135 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 31633723 | 31633723 | PRJNA781427_P_NODE_42616_length_348_cov_2.421818_g41734_i0 | PRJNA781427 | 42616 | 348 | 2.421818 | 8.42792664 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 72.4 | 2.7e-12 | NR | KAA0184206.1 | 27845 | g41734 | i0 | 58.8 | 0.879310344827586 | 51 | 21 | 44 | 0 | 5 | 157 | 50 | 100 | KAA0184206.1 WD repeat-containing protein 5 [Fasciolopsis buskii] | diamond | 306 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 31728613 | 31728613 | PRJNA781427_P_NODE_93057_length_242_cov_2.733728_g92173_i0 | PRJNA781427 | 93057 | 242 | 2.733728 | 6.61562176 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 50.4 | 7.22e-5 | NR | CAH8492295.1 | 39320 | g92173 | i0 | 38.5 | 2.00826446280992 | 78 | 44 | 95.5 | 3 | 233 | 3 | 960 | 1034 | CAH8492295.1 unnamed protein product [Heterobilharzia americana] | diamond | 486 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 32843979 | 32843979 | PRJNA781427_P_NODE_38580_length_368_cov_2.003390_g37698_i0 | PRJNA781427 | 38580 | 368 | 2.00339 | 7.3724752 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 100 | 5.81e-25 | NR | CDS26770.1 | 85433 | g37698 | i0 | 47.3 | 1.57336956521739 | 91 | 48 | 74.2 | 0 | 44 | 316 | 6 | 96 | CDS26770.1 presenilin enhancer [Hymenolepis microstoma] | diamond | 579 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma |
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);;