contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA994052" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 11179813 | 11179813 | PRJNA994052_P_NODE_44829_length_249_cov_1264.755682_g43580_i0 | PRJNA994052 | 44829 | 249 | 1264.755682 | 3149.24164818 | Dugesia sp. Shandong | 3122083 | Platyhelminthes | Platyhelminthes | 156 | 7.09e-43 | NR | WWO62212.1 | 3122083 | g43580 | i0 | 92.5 | 0.963855421686747 | 80 | 6 | 96.4 | 0 | 5 | 244 | 158 | 237 | WWO62212.1 apoe protein [Dugesia sp. Shandong] | diamond | 240 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Dugesia | Dugesia sp. Shandong | |
| 27317021 | 27317021 | PRJNA994052_P_NODE_68943_length_213_cov_766.300000_g67687_i0 | PRJNA994052 | 68943 | 213 | 766.3 | 1632.219 | root | 1 | Root_unresolved | Root_unresolved | 73.9 | 2.61e-13 | NR | ACA62790.1 | 6182 | g67687 | i0 | 66.7 | 16.0422535211268 | 57 | 19 | 80.3 | 0 | 40 | 210 | 7 | 63 | ACA62790.1 paramyosin [Schistosoma japonicum] | diamond | 3417 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27380245 | 27380245 | PRJNA994052_P_NODE_13823_length_314_cov_2449.518672_g12602_i0 | PRJNA994052 | 13823 | 314 | 2449.518672 | 7691.48863008 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 72.4 | 3.42e-12 | NR | CAH8603739.1 | 39320 | g12602 | i0 | 56.5 | 1.35668789808917 | 46 | 20 | 43.9 | 0 | 152 | 15 | 1417 | 1462 | CAH8603739.1 unnamed protein product [Heterobilharzia americana] | diamond | 426 | 72.8 | 0.994505494505495 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 27411876 | 27411876 | PRJNA994052_P_NODE_30863_length_279_cov_87.713592_g29619_i0 | PRJNA994052 | 30863 | 279 | 87.713592 | 244.72092168 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 47 | 0.00177 | NR | AKN21572.1 | 79327 | g29619 | i0 | 67.7 | 1.60215053763441 | 31 | 10 | 33.3 | 0 | 116 | 24 | 82 | 112 | AKN21572.1 slc25a-4 [Schmidtea mediterranea] | diamond | 447 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 27727724 | 27727724 | PRJNA994052_P_NODE_16204_length_312_cov_17.878661_g14983_i0 | PRJNA994052 | 16204 | 312 | 17.878661 | 55.78142232 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 50.4 | 1.71e-4 | NR | XP_009171573.1 | 6198 | g14983 | i0 | 45.8 | 1.39423076923077 | 48 | 24 | 44.2 | 1 | 303 | 166 | 271 | 318 | XP_009171573.1 hypothetical protein T265_07713 [Opisthorchis viverrini] | diamond | 435 | 50.8 | 0.992125984251969 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Opisthorchis | Opisthorchis viverrini | |
| 27853626 | 27853626 | PRJNA994052_P_NODE_29284_length_283_cov_2864.119048_g28042_i0 | PRJNA994052 | 29284 | 283 | 2864.119048 | 8105.45690584 | Platyhelminthes | 6157 | Platyhelminthes | Platyhelminthes | 123 | 3.26e-30 | NR | VDL89046.1 | 70667 | g28042 | i0 | 66.7 | 5.61837455830389 | 87 | 29 | 92.2 | 0 | 272 | 12 | 515 | 601 | VDL89046.1 unnamed protein product [Schistocephalus solidus] | diamond | 1590 | 124 | 0.991935483870968 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 28542645 | 28542645 | PRJNA994052_P_NODE_61507_length_223_cov_3280.806667_g60251_i0 | PRJNA994052 | 61507 | 223 | 3280.806667 | 7316.19886741 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 62 | 4.25e-10 | NR | ADW66116.1 | 79327 | g60251 | i0 | 54.9 | 0.68609865470852 | 51 | 23 | 68.6 | 0 | 69 | 221 | 65 | 115 | ADW66116.1 lectin-like protein, partial [Schmidtea mediterranea] | diamond | 153 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 29521181 | 29521181 | PRJNA994052_P_NODE_24330_length_296_cov_81.058296_g23095_i0 | PRJNA994052 | 24330 | 296 | 81.058296 | 239.93255616 | Schmidtea mediterranea | 79327 | Platyhelminthes | Platyhelminthes | 61.6 | 1.56e-8 | NR | AKN21572.1 | 79327 | g23095 | i0 | 68.2 | 1.31756756756757 | 44 | 13 | 43.6 | 1 | 134 | 6 | 87 | 130 | AKN21572.1 slc25a-4 [Schmidtea mediterranea] | diamond | 390 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Tricladida | Dugesiidae | Schmidtea | Schmidtea mediterranea | |
| 29811129 | 29811129 | PRJNA994052_P_NODE_78851_length_202_cov_13.255814_g77594_i0 | PRJNA994052 | 78851 | 202 | 13.255814 | 26.77674428 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 45.4 | 0.00241 | NR | KAF8569843.1 | 34504 | g77594 | i0 | 41.7 | 5.95544554455446 | 48 | 28 | 71.3 | 0 | 29 | 172 | 64 | 111 | KAF8569843.1 hypothetical protein P879_02231 [Paragonimus westermani] | diamond | 1203 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 29836873 | 29836873 | PRJNA994052_P_NODE_35271_length_268_cov_1898.348718_g34026_i0 | PRJNA994052 | 35271 | 268 | 1898.348718 | 5087.57456424 | Fasciolopsis buskii | 27845 | Platyhelminthes | Platyhelminthes | 76.3 | 7.98e-14 | NR | KAA0195747.1 | 27845 | g34026 | i0 | 41.5 | 2.6865671641791 | 82 | 48 | 91.8 | 0 | 262 | 17 | 21 | 102 | KAA0195747.1 hypothetical protein FBUS_08306 [Fasciolopsis buskii] | diamond | 720 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 30380308 | 30380308 | PRJNA994052_P_NODE_30052_length_281_cov_1129.048077_g28810_i0 | PRJNA994052 | 30052 | 281 | 1129.048077 | 3172.62509637 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 107 | 9.36e-25 | NR | XP_024355518.1 | 6210 | g28810 | i0 | 63.5 | 3.9288256227758 | 74 | 27 | 79 | 0 | 226 | 5 | 53 | 126 | XP_024355518.1 Myophilin [Echinococcus granulosus] | diamond | 1104 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31321960 | 31321960 | PRJNA994052_P_NODE_15455_length_312_cov_75.933054_g14234_i0 | PRJNA994052 | 15455 | 312 | 75.933054 | 236.91112848 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 63.5 | 3.86e-9 | NR | VDO07559.1 | 102285 | g14234 | i0 | 69.6 | 1.34615384615385 | 46 | 14 | 44.2 | 0 | 143 | 6 | 62 | 107 | VDO07559.1 unnamed protein product [Rodentolepis nana] | diamond | 420 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 31575260 | 31575260 | PRJNA994052_P_NODE_54496_length_234_cov_19.180124_g53241_i0 | PRJNA994052 | 54496 | 234 | 19.180124 | 44.88149016 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 57 | 3.2e-7 | NR | PAA77876.1 | 282301 | g53241 | i0 | 38.4 | 0.935897435897436 | 73 | 45 | 93.6 | 0 | 222 | 4 | 264 | 336 | PAA77876.1 hypothetical protein BOX15_Mlig022080g2 [Macrostomum lignano] | diamond | 219 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31638225 | 31638225 | PRJNA994052_P_NODE_55436_length_232_cov_966.987421_g54181_i0 | PRJNA994052 | 55436 | 232 | 966.987421 | 2243.41081672 | Mesocestoides corti | 53468 | Platyhelminthes | Platyhelminthes | 72.8 | 8.59e-13 | NR | VDD80775.1 | 53468 | g54181 | i0 | 45.9 | 0.956896551724138 | 74 | 37 | 91.8 | 1 | 19 | 231 | 912 | 985 | VDD80775.1 unnamed protein product [Mesocestoides corti] | diamond | 222 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Mesocestoididae | Mesocestoides | Mesocestoides corti | |
| 31644043 | 31644043 | PRJNA994052_P_NODE_42596_length_253_cov_3816.811111_g41349_i0 | PRJNA994052 | 42596 | 253 | 3816.811111 | 9656.53211083 | Schistosomatidae | 31245 | Platyhelminthes | Platyhelminthes | 117 | 1.62e-28 | NR | CAH8557889.1 | 39320 | g41349 | i0 | 68.3 | 5.83399209486166 | 82 | 26 | 97.2 | 0 | 7 | 252 | 375 | 456 | CAH8557889.1 unnamed protein product [Heterobilharzia americana] | diamond | 1476 | 117 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 32397778 | 32397778 | PRJNA994052_P_NODE_15439_length_312_cov_89.175732_g14218_i0 | PRJNA994052 | 15439 | 312 | 89.175732 | 278.22828384 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 72 | 4.08e-12 | NR | VDL63400.1 | 6216 | g14218 | i0 | 72.9 | 1.39423076923077 | 48 | 13 | 46.2 | 0 | 149 | 6 | 60 | 107 | VDL63400.1 unnamed protein product [Hymenolepis diminuta] | diamond | 435 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 32556144 | 32556144 | PRJNA994052_P_NODE_20119_length_308_cov_77.191489_g18893_i0 | PRJNA994052 | 20119 | 308 | 77.191489 | 237.74978612 | Rodentolepis nana | 102285 | Platyhelminthes | Platyhelminthes | 66.2 | 4.2e-10 | NR | VDO07559.1 | 102285 | g18893 | i0 | 71.7 | 1.36363636363636 | 46 | 13 | 44.8 | 0 | 143 | 6 | 62 | 107 | VDO07559.1 unnamed protein product [Rodentolepis nana] | diamond | 420 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Rodentolepis | Rodentolepis nana | |
| 32618825 | 32618825 | PRJNA994052_P_NODE_14520_length_313_cov_177.804167_g13299_i0 | PRJNA994052 | 14520 | 313 | 177.804167 | 556.52704271 | Schistosoma turkestanicum | 1163369 | Platyhelminthes | Platyhelminthes | 89.7 | 2.04e-18 | NR | CAH8516822.1 | 1163369 | g13299 | i0 | 52.5 | 1.92651757188498 | 99 | 32 | 80.5 | 2 | 257 | 6 | 10 | 108 | CAH8516822.1 unnamed protein product [Schistosoma turkestanicum] | diamond | 603 | 89.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma turkestanicum |
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);;