contig_metadata
18 rows where bioproject = "PRJEB43370", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2265177 | 2265177 | PRJEB43370_P_NODE_3842_length_226_cov_0.881356_g3799_i0 | PRJEB43370 | 3842 | 226 | 0.881356 | 1.99186456 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 90.9 | 3.37e-19 | NR | VDM33295.1 | 6205 | g3799 | i0 | 61.5 | 7.20796460176991 | 78 | 22 | 92.9 | 2 | 210 | 1 | 496 | 573 | VDM33295.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 1629 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 7712596 | 7712596 | PRJEB43370_P_NODE_4547_length_210_cov_1.478261_g4504_i0 | PRJEB43370 | 4547 | 210 | 1.478261 | 3.1043481 | Trichobilharzia regenti | 157069 | Platyhelminthes | Platyhelminthes | 97.4 | 9.75e-24 | NR | CAH8859821.1 | 157069 | g4504 | i0 | 73.4 | 9.54285714285714 | 64 | 15 | 91.4 | 1 | 2 | 193 | 80 | 141 | CAH8859821.1 unnamed protein product [Trichobilharzia regenti] | diamond | 2004 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 9918110 | 9918110 | PRJEB43370_P_NODE_10188_length_163_cov_0.912281_g10145_i0 | PRJEB43370 | 10188 | 163 | 0.912281 | 1.48701803 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 302 | 1.22e-77 | NTclustered | gi|60687563|gb|AY914894.1| | 6182 | g10145 | i0 | 100 | 100 | 163 | 0 | 100 | 0 | 1 | 163 | 262 | 424 | Schistosoma japonicum unknown mRNA | blastn | 16300 | 302 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 20461083 | 20461083 | PRJEB43370_P_NODE_977_length_439_cov_3.135897_g934_i0 | PRJEB43370 | 977 | 439 | 3.135897 | 13.76658783 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 732 | 0 | NTclustered | gi|68479954|gb|DQ076149.1| | 6182 | g934 | i0 | 96.811 | 1 | 439 | 13 | 100 | 1 | 1 | 439 | 449 | 12 | Schistosoma japonicum clone 1XA1 unknown mRNA | blastn | 439 | 732 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 26938386 | 26938386 | PRJEB43370_P_NODE_5922_length_188_cov_1.136691_g5879_i0 | PRJEB43370 | 5922 | 188 | 1.136691 | 2.13697908 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 47.8 | 3.04e-4 | NR | AAX27390.2 | 6182 | g5879 | i0 | 37.5 | 11.5851063829787 | 56 | 35 | 89.4 | 0 | 2 | 169 | 303 | 358 | AAX27390.2 SJCHGC06130 protein, partial [Schistosoma japonicum] | diamond | 2178 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27469345 | 27469345 | PRJEB43370_P_NODE_8283_length_167_cov_1.322034_g8240_i0 | PRJEB43370 | 8283 | 167 | 1.322034 | 2.20779678 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 76.3 | 2.03e-14 | NR | CAH8535814.1 | 6188 | g8240 | i0 | 66.7 | 10.7065868263473 | 54 | 18 | 97 | 0 | 164 | 3 | 818 | 871 | CAH8535814.1 unnamed protein product [Schistosoma rodhaini] | diamond | 1788 | 77 | 0.990909090909091 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma rodhaini | |
| 27595661 | 27595661 | PRJEB43370_P_NODE_7084_length_172_cov_1.691057_g7041_i0 | PRJEB43370 | 7084 | 172 | 1.691057 | 2.90861804 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 77.8 | 3.32e-15 | NR | KAA3675398.1 | 34504 | g7041 | i0 | 57.1 | 16.6046511627907 | 56 | 24 | 97.7 | 0 | 170 | 3 | 160 | 215 | KAA3675398.1 guanine nucleotide-binding protein G(i) subunit alpha, partial [Paragonimus westermani] | diamond | 2856 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani | |
| 28289981 | 28289981 | PRJEB43370_P_NODE_2266_length_287_cov_1.310924_g2223_i0 | PRJEB43370 | 2266 | 287 | 1.310924 | 3.76235188 | Cyclophyllidea | 6201 | Platyhelminthes | Platyhelminthes | 141 | 4.409999999999999e-37 | NR | VDM16417.1 | 6205 | g2223 | i0 | 68.1 | 5.89547038327526 | 94 | 30 | 98.3 | 0 | 3 | 284 | 16 | 109 | VDM16417.1 unnamed protein product [Hydatigera taeniaeformis] | diamond | 1692 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Hydatigera | Hydatigera taeniaeformis | |
| 28738873 | 28738873 | PRJEB43370_P_NODE_1947_length_312_cov_1.581749_g1904_i0 | PRJEB43370 | 1947 | 312 | 1.581749 | 4.93505688 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 152 | 4.03e-45 | NR | AAY97887.1 | 6182 | g1904 | i0 | 78.7 | 0.903846153846154 | 94 | 20 | 90.4 | 0 | 307 | 26 | 35 | 128 | AAY97887.1 unknown [Schistosoma japonicum] | diamond | 282 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28889948 | 28889948 | PRJEB43370_P_NODE_8948_length_166_cov_0.888889_g8905_i0 | PRJEB43370 | 8948 | 166 | 0.888889 | 1.47555574 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 73.2 | 2.35e-13 | NR | TNN17426.1 | 6182 | g8905 | i0 | 80.5 | 8.92771084337349 | 41 | 8 | 74.1 | 0 | 42 | 164 | 546 | 586 | TNN17426.1 Glutamine-dependent NAD(+) synthetase [Schistosoma japonicum] | diamond | 1482 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29338835 | 29338835 | PRJEB43370_P_NODE_10569_length_162_cov_1.840708_g10526_i0 | PRJEB43370 | 10569 | 162 | 1.840708 | 2.98194696 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 96.3 | 6.909999999999998e-24 | NR | TNN14750.1 | 6182 | g10526 | i0 | 81.1 | 1.94444444444444 | 53 | 10 | 98.1 | 0 | 161 | 3 | 6 | 58 | TNN14750.1 60S ribosomal protein [Schistosoma japonicum] | diamond | 315 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29995358 | 29995358 | PRJEB43370_P_NODE_4271_length_216_cov_0.934132_g4228_i0 | PRJEB43370 | 4271 | 216 | 0.934132 | 2.01772512 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 119 | 2.0599999999999997e-31 | NR | VUZ40767.1 | 6216 | g4228 | i0 | 78.9 | 11.8333333333333 | 71 | 14 | 98.6 | 1 | 3 | 215 | 162 | 231 | VUZ40767.1 unnamed protein product [Hymenolepis diminuta] | diamond | 2556 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 30570319 | 30570319 | PRJEB43370_P_NODE_10533_length_162_cov_3.221239_g10490_i0 | PRJEB43370 | 10533 | 162 | 3.221239 | 5.21840718 | Cichlidogyrus casuarinus | 1844966 | Platyhelminthes | Platyhelminthes | 55.1 | 5.37e-7 | NR | KAL3314241.1 | 1844966 | g10490 | i0 | 48.1 | 0.962962962962963 | 52 | 27 | 96.3 | 0 | 161 | 6 | 189 | 240 | KAL3314241.1 60S ribosomal protein L4 [Cichlidogyrus casuarinus] | diamond | 156 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Monogenea | Dactylogyridea | Ancyrocephalidae | Cichlidogyrus | Cichlidogyrus casuarinus | |
| 31012903 | 31012903 | PRJEB43370_P_NODE_2535_length_272_cov_1.246637_g2492_i0 | PRJEB43370 | 2535 | 272 | 1.246637 | 3.39085264 | Macrostomum lignano | 282301 | Platyhelminthes | Platyhelminthes | 55.8 | 1.25e-6 | NR | PAA93605.1 | 282301 | g2492 | i0 | 32.2 | 1.98529411764706 | 90 | 60 | 99.3 | 1 | 3 | 272 | 334 | 422 | PAA93605.1 hypothetical protein BOX15_Mlig031413g1 [Macrostomum lignano] | diamond | 540 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 31575514 | 31575514 | PRJEB43370_P_NODE_4536_length_210_cov_2.397516_g4493_i0 | PRJEB43370 | 4536 | 210 | 2.397516 | 5.0347836 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 40 | 0.0477 | NR | THD27271.1 | 6192 | g4493 | i0 | 60.6 | 1.95714285714286 | 33 | 13 | 47.1 | 0 | 116 | 18 | 48 | 80 | THD27271.1 putative beta thymosin [Fasciola hepatica] | diamond | 411 | 40.4 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 31803322 | 31803322 | PRJEB43370_P_NODE_6697_length_177_cov_1.625000_g6654_i0 | PRJEB43370 | 6697 | 177 | 1.625 | 2.87625 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 49.3 | 6.48e-5 | NR | VDL93466.1 | 70667 | g6654 | i0 | 44.4 | 1.83050847457627 | 54 | 30 | 91.5 | 0 | 164 | 3 | 177 | 230 | VDL93466.1 unnamed protein product [Schistocephalus solidus] | diamond | 324 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 32049863 | 32049863 | PRJEB43370_P_NODE_9458_length_165_cov_0.896552_g9415_i0 | PRJEB43370 | 9458 | 165 | 0.896552 | 1.4793108 | Opisthokonta | 33154 | Platyhelminthes | Platyhelminthes | 45.1 | 0.00198 | NR | CAH8864424.1 | 157069 | g9415 | i0 | 50 | 12.3272727272727 | 46 | 23 | 83.6 | 0 | 1 | 138 | 242 | 287 | CAH8864424.1 unnamed protein product, partial [Trichobilharzia regenti] | diamond | 2034 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Trichobilharzia | Trichobilharzia regenti | |
| 32902410 | 32902410 | PRJEB43370_P_NODE_1260_length_388_cov_2.498525_g1217_i0 | PRJEB43370 | 1260 | 388 | 2.498525 | 9.694277 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 110 | 4.45e-28 | NR | VUZ41626.1 | 6216 | g1217 | i0 | 56 | 1.50773195876289 | 100 | 44 | 77.3 | 0 | 306 | 7 | 10 | 109 | VUZ41626.1 unnamed protein product [Hymenolepis diminuta] | diamond | 585 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta |
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);;