contig_metadata
16 rows where bioproject = "PRJNA421571" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 424435 | 424435 | PRJNA421571_P_NODE_95801_length_248_cov_1.760000_g93252_i0 | PRJNA421571 | 95801 | 248 | 1.76 | 4.3648 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 436 | 5.3e-118 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g93252 | i0 | 98.387 | 1 | 248 | 4 | 100 | 0 | 1 | 248 | 398 | 151 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 248 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 18274458 | 18274458 | PRJNA421571_P_NODE_36015_length_508_cov_2.291954_g33472_i0 | PRJNA421571 | 36015 | 508 | 2.291954 | 11.64312632 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 56.5 | 0.004 | NTclustered | gi|690539951|emb|LN092357.1| | 99802 | g33472 | i0 | 100 | 0.0590551181102362 | 30 | 0 | 6 | 0 | 446 | 475 | 3623 | 3594 | Spirometra erinaceieuropaei genome assembly S_erinaceieuropaei ,scaffold SPER_scaffold0087927 | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 20211690 | 20211690 | PRJNA421571_P_NODE_20716_length_777_cov_4.048295_g18407_i0 | PRJNA421571 | 20716 | 777 | 4.048295 | 31.45525215 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 244 | 3.7e-78 | NR | KAA0196388.1 | 27845 | g18407 | i0 | 68.9 | 14.5135135135135 | 167 | 52 | 64.5 | 0 | 727 | 227 | 10 | 176 | KAA0196388.1 Ribosomal protein L11 [Fasciolopsis buskii] | diamond | 11277 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciolopsis | Fasciolopsis buskii | |
| 26822637 | 26822637 | PRJNA421571_P_NODE_40221_length_464_cov_2.421995_g37673_i0 | PRJNA421571 | 40221 | 464 | 2.421995 | 11.2380568 | Schistosoma mekongi | 38744 | Platyhelminthes | Platyhelminthes | 160 | 6.66e-47 | NR | KAK4469792.1 | 38744 | g37673 | i0 | 62.4 | 8.4051724137931 | 117 | 44 | 75.6 | 0 | 114 | 464 | 1 | 117 | KAK4469792.1 hypothetical protein MN116_007308 [Schistosoma mekongi] | diamond | 3900 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mekongi | |
| 27028941 | 27028941 | PRJNA421571_P_NODE_101902_length_244_cov_0.900585_g99353_i0 | PRJNA421571 | 101902 | 244 | 0.900585 | 2.1974274 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 47.4 | 8.7e-4 | NR | TPP61754.1 | 46835 | g99353 | i0 | 43.5 | 2.77868852459016 | 69 | 35 | 82.4 | 4 | 243 | 43 | 223 | 289 | TPP61754.1 hypothetical protein FGIG_11340, partial [Fasciola gigantica] | diamond | 678 | 47.8 | 0.99163179916318 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola gigantica | |
| 27486481 | 27486481 | PRJNA421571_P_NODE_83263_length_269_cov_1.571429_g80714_i0 | PRJNA421571 | 83263 | 269 | 1.571429 | 4.22714401 | Fasciola hepatica | 6192 | Platyhelminthes | Platyhelminthes | 66.2 | 2.1e-10 | NR | AAF76330.1 | 6192 | g80714 | i0 | 39.6 | 4.05947955390335 | 91 | 53 | 99.3 | 1 | 267 | 1 | 154 | 244 | AAF76330.1 cathepsin L [Fasciola hepatica] | diamond | 1092 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 27945109 | 27945109 | PRJNA421571_P_NODE_60645_length_337_cov_1.166667_g58096_i0 | PRJNA421571 | 60645 | 337 | 1.166667 | 3.93166779 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 161 | 3.13e-43 | NR | VDL63085.1 | 6216 | g58096 | i0 | 71.8 | 12.5964391691395 | 110 | 31 | 97.9 | 0 | 8 | 337 | 658 | 767 | VDL63085.1 unnamed protein product [Hymenolepis diminuta] | diamond | 4245 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 28244065 | 28244065 | PRJNA421571_P_NODE_84086_length_267_cov_2.087629_g81537_i0 | PRJNA421571 | 84086 | 267 | 2.087629 | 5.57396943 | Paragonimus skrjabini miyazakii | 59628 | Platyhelminthes | Platyhelminthes | 72.4 | 1.27e-12 | NR | KAF7262668.1 | 59628 | g81537 | i0 | 76.9 | 0.876404494382023 | 39 | 9 | 43.8 | 0 | 265 | 149 | 295 | 333 | KAF7262668.1 hypothetical protein EG68_00058 [Paragonimus skrjabini miyazakii] | diamond | 234 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 28560114 | 28560114 | PRJNA421571_P_NODE_80347_length_276_cov_1.463054_g77798_i0 | PRJNA421571 | 80347 | 276 | 1.463054 | 4.03802904 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 104 | 2.0399999999999994e-24 | NR | PAA46757.1 | 282301 | g77798 | i0 | 56.5 | 2.97826086956522 | 92 | 39 | 98.9 | 1 | 3 | 275 | 102 | 193 | PAA46757.1 hypothetical protein BOX15_Mlig000518g3, partial [Macrostomum lignano] | diamond | 822 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28765867 | 28765867 | PRJNA421571_P_NODE_102567_length_244_cov_0.900585_g100018_i0 | PRJNA421571 | 102567 | 244 | 0.900585 | 2.1974274 | Trematoda | 6178 | Platyhelminthes | Platyhelminthes | 89 | 1.04e-18 | NR | GAA50816.1 | 79923 | g100018 | i0 | 48.1 | 3.88524590163934 | 79 | 41 | 97.1 | 0 | 2 | 238 | 269 | 347 | GAA50816.1 26S proteasome regulatory subunit N9 [Clonorchis sinensis] | diamond | 948 | 89.4 | 0.995525727069351 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Opisthorchiida | Opisthorchiidae | Clonorchis | Clonorchis sinensis | |
| 29065256 | 29065256 | PRJNA421571_P_NODE_46048_length_416_cov_4.620991_g43500_i0 | PRJNA421571 | 46048 | 416 | 4.620991 | 19.22332256 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 184 | 2.62e-57 | NR | AAY97887.1 | 6182 | g43500 | i0 | 72.7 | 0.923076923076923 | 128 | 35 | 92.3 | 0 | 409 | 26 | 1 | 128 | AAY97887.1 unknown [Schistosoma japonicum] | diamond | 384 | 184 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31197635 | 31197635 | PRJNA421571_P_NODE_103335_length_243_cov_0.905882_g100786_i0 | PRJNA421571 | 103335 | 243 | 0.905882 | 2.20129326 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 77.4 | 2.78e-15 | NR | THD24244.1 | 6192 | g100786 | i0 | 48.8 | 7.8641975308642 | 80 | 37 | 98.8 | 1 | 3 | 242 | 63 | 138 | THD24244.1 RAN binding protein 1 [Fasciola hepatica] | diamond | 1911 | 77.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31577690 | 31577690 | PRJNA421571_P_NODE_96196_length_248_cov_0.880000_g93647_i0 | PRJNA421571 | 96196 | 248 | 0.88 | 2.1824 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 60.1 | 2.59e-8 | NR | XP_018648353.1 | 6183 | g93647 | i0 | 37 | 5.87903225806452 | 81 | 50 | 98 | 1 | 244 | 2 | 109 | 188 | XP_018648353.1 putative clathrin heavy chain [Schistosoma mansoni] | diamond | 1458 | 60.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 32130628 | 32130628 | PRJNA421571_P_NODE_106158_length_241_cov_0.916667_g103609_i0 | PRJNA421571 | 106158 | 241 | 0.916667 | 2.20916747 | Heterobilharzia americana | 39320 | Platyhelminthes | Platyhelminthes | 43.9 | 0.0144 | NR | CAH8582478.1 | 39320 | g103609 | i0 | 45 | 0.49792531120332 | 40 | 22 | 49.8 | 0 | 10 | 129 | 236 | 275 | CAH8582478.1 unnamed protein product [Heterobilharzia americana] | diamond | 120 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 32273786 | 32273786 | PRJNA421571_P_NODE_100338_length_245_cov_1.168605_g97789_i0 | PRJNA421571 | 100338 | 245 | 1.168605 | 2.86308225 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 77.8 | 8.49e-15 | NR | THD21334.1 | 6192 | g97789 | i0 | 61.7 | 5.65714285714286 | 60 | 20 | 71 | 2 | 6 | 179 | 240 | 298 | THD21334.1 Secreted cathepsin L 2 [Fasciola hepatica] | diamond | 1386 | 78.2 | 0.994884910485933 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 32415324 | 32415324 | PRJNA421571_P_NODE_103959_length_243_cov_0.905882_g101410_i0 | PRJNA421571 | 103959 | 243 | 0.905882 | 2.20129326 | Paragonimus westermani | 34504 | Platyhelminthes | Platyhelminthes | 47 | 9.13e-4 | NR | KAA3677463.1 | 34504 | g101410 | i0 | 36.5 | 1.92592592592593 | 74 | 31 | 71.6 | 3 | 49 | 222 | 31 | 104 | KAA3677463.1 uncharacterized protein DEA37_0004637 [Paragonimus westermani] | diamond | 468 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani |
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);;