contig_metadata
14 rows where bioproject = "PRJNA492406", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6829969 | 6829969 | PRJNA492406_P_NODE_19326_length_286_cov_9.605634_g19027_i0 | PRJNA492406 | 19326 | 286 | 9.605634 | 27.47211324 | Monotoplana cf. diorchis | 104924 | Platyhelminthes | Platyhelminthes | 73.1 | 2.03e-8 | NTclustered | gi|10944981|emb|AJ270174.1| | 104924 | g19027 | i0 | 100 | 17.8251748251748 | 39 | 0 | 14 | 0 | 92 | 130 | 1633 | 1595 | Monotoplana cf. diorchis partial 28S rRNA gene | blastn | 5098 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Proseriata | Monotoplanidae | Monotoplana | Monotoplana cf. diorchis | |
| 8105730 | 8105730 | PRJNA492406_P_NODE_27907_length_249_cov_0.869318_g27608_i0 | PRJNA492406 | 27907 | 249 | 0.869318 | 2.16460182 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 117 | 1.55e-28 | NR | KAF8561086.1 | 34504 | g27608 | i0 | 65.9 | 7.8433734939759 | 82 | 26 | 98.8 | 1 | 248 | 3 | 508 | 587 | KAF8561086.1 hypothetical protein P879_07032 [Paragonimus westermani] | diamond | 1953 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 10656571 | 10656571 | PRJNA492406_P_NODE_8989_length_408_cov_1.214925_g8690_i0 | PRJNA492406 | 8989 | 408 | 1.214925 | 4.956894 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 359 | 2.06e-94 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g8690 | i0 | 97.608 | 0.781862745098039 | 209 | 5 | 78 | 0 | 200 | 408 | 136 | 344 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 319 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 11931114 | 11931114 | PRJNA492406_P_NODE_23410_length_266_cov_2.181347_g23111_i0 | PRJNA492406 | 23410 | 266 | 2.181347 | 5.80238302 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 89 | 2.67e-18 | NR | KAL3309946.1 | 1844966 | g23111 | i0 | 55.8 | 12.2481203007519 | 86 | 35 | 94.7 | 3 | 265 | 14 | 486 | 570 | KAL3309946.1 Sarcoplasmic/endoplasmic reticulum calcium ATPase 2, partial [Cichlidogyrus casuarinus] | diamond | 3258 | 89.7 | 0.992196209587514 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 13852888 | 13852888 | PRJNA492406_P_NODE_29211_length_246_cov_0.924855_g28912_i0 | PRJNA492406 | 29211 | 246 | 0.924855 | 2.2751433 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 131 | 7.13e-34 | NR | TNN11288.1 | 6182 | g28912 | i0 | 76.5 | 24.8658536585366 | 81 | 19 | 98.8 | 0 | 246 | 4 | 368 | 448 | TNN11288.1 Elongation factor 1-alpha 2 isoform 2 [Schistosoma japonicum] | diamond | 6117 | 131 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 14480844 | 14480844 | PRJNA492406_P_NODE_11712_length_363_cov_2.551724_g11413_i0 | PRJNA492406 | 11712 | 363 | 2.551724 | 9.26275812 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 194 | 1.01e-57 | NR | VDL57942.1 | 6216 | g11413 | i0 | 76 | 207.99173553719 | 121 | 29 | 100 | 0 | 363 | 1 | 106 | 226 | VDL57942.1 unnamed protein product [Hymenolepis diminuta] | diamond | 75501 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 26727804 | 26727804 | PRJNA492406_P_NODE_22501_length_271_cov_1.500000_g22202_i0 | PRJNA492406 | 22501 | 271 | 1.5 | 4.065 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 48.5 | 4.72e-4 | NR | PAA93605.1 | 282301 | g22202 | i0 | 32.9 | 1.88191881918819 | 85 | 56 | 94.1 | 1 | 11 | 265 | 343 | 426 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 510 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27234460 | 27234460 | PRJNA492406_P_NODE_5603_length_507_cov_2.373272_g5305_i0 | PRJNA492406 | 5603 | 507 | 2.373272 | 12.03248904 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 45.8 | 0.0362 | NR | PAA74793.1 | 282301 | g5305 | i0 | 38.1 | 0.372781065088757 | 63 | 37 | 36.1 | 1 | 178 | 360 | 177 | 239 | PAA74793.1 hypothetical protein BOX15_Mlig014438g2, partial [Macrostomum lignano] | diamond | 189 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27487201 | 27487201 | PRJNA492406_P_NODE_1123_length_1142_cov_3.674462_g922_i0 | PRJNA492406 | 1123 | 1142 | 3.674462 | 41.96235604 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 99.8 | 6.54e-19 | NR | PAA86220.1 | 282301 | g922 | i0 | 31.7 | 0.422942206654991 | 161 | 109 | 42 | 1 | 492 | 13 | 76 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 483 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 27724582 | 27724582 | PRJNA492406_P_NODE_15924_length_314_cov_1.883817_g15625_i0 | PRJNA492406 | 15924 | 314 | 1.883817 | 5.91518538 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 164 | 4.86e-49 | NR | CAX83045.1 | 6182 | g15625 | i0 | 73.8 | 20.5987261146497 | 103 | 27 | 98.4 | 0 | 4 | 312 | 37 | 139 | CAX83045.1 60S ribosomal protein L8, partial [Schistosoma japonicum] | diamond | 6468 | 165 | 0.993939393939394 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29066050 | 29066050 | PRJNA492406_P_NODE_1248_length_1083_cov_2.737624_g1040_i0 | PRJNA492406 | 1248 | 1083 | 2.737624 | 29.64846792 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 53.5 | 9.27e-4 | NR | PAA93605.1 | 282301 | g1040 | i0 | 29.7 | 0.875346260387812 | 158 | 102 | 42.9 | 5 | 617 | 1081 | 255 | 406 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 948 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31624983 | 31624983 | PRJNA492406_P_NODE_14216_length_332_cov_2.030888_g13917_i0 | PRJNA492406 | 14216 | 332 | 2.030888 | 6.74254816 | Hydatigera taeniaeformis | 6205 | Platyhelminthes | Platyhelminthes | 82.4 | 1.32e-16 | NR | VDM16220.1 | 6205 | g13917 | i0 | 45.8 | 0.75 | 83 | 45 | 75 | 0 | 329 | 81 | 107 | 189 | VDM16220.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 249 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 31877927 | 31877927 | PRJNA492406_P_NODE_1757_length_919_cov_3.101655_g1510_i0 | PRJNA492406 | 1757 | 919 | 3.101655 | 28.50420945 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 99.4 | 2.5e-19 | NR | PAA86220.1 | 282301 | g1510 | i0 | 32.3 | 0.52557127312296 | 161 | 108 | 52.2 | 1 | 563 | 84 | 76 | 236 | PAA86220.1 hypothetical protein BOX15_Mlig009159g3 [Macrostomum lignano] | diamond | 483 | 99.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 32147262 | 32147262 | PRJNA492406_P_NODE_32898_length_226_cov_2.013072_g32599_i0 | PRJNA492406 | 32898 | 226 | 2.013072 | 4.54954272 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 105 | 1.17e-25 | NR | TNN11815.1 | 6182 | g32599 | i0 | 61.8 | 89.787610619469 | 76 | 27 | 98.2 | 1 | 225 | 4 | 118 | 193 | TNN11815.1 Guanine nucleotide-binding protein subunit beta [Schistosoma japonicum] | diamond | 20292 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum |
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);;