contig_metadata
19 rows where bioproject = "PRJNA1068830", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5286565 | 5286565 | PRJNA1068830_P_NODE_81825_length_246_cov_1.751445_g81122_i0 | PRJNA1068830 | 81825 | 246 | 1.751445 | 4.3085547 | Stenostomum leucops | 52061 | Platyhelminthes | Platyhelminthes | 435 | 1.8900000000000003e-117 | NTclustered | gi|209968685|gb|FJ384848.1| | 52061 | g81122 | i0 | 99.174 | 63.8617886178862 | 242 | 1 | 98 | 1 | 1 | 241 | 253 | 12 | Stenostomum leucops isolate K04_75 28S ribosomal RNA gene, partial sequence | blastn | 15710 | 435 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Stenostomidae | Stenostomum | Stenostomum leucops | |||
| 9109855 | 9109855 | PRJNA1068830_P_NODE_22388_length_499_cov_3.889671_g21687_i0 | PRJNA1068830 | 22388 | 499 | 3.889671 | 19.40945829 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 266 | 4.78e-85 | NR | VDL18401.1 | 6216 | g21687 | i0 | 75.2 | 38.5310621242485 | 165 | 41 | 99.2 | 0 | 498 | 4 | 200 | 364 | VDL18401.1 unnamed protein product [Hymenolepis diminuta] | diamond | 19227 | 267 | 0.99625468164794 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 16759257 | 16759257 | PRJNA1068830_P_NODE_24934_length_468_cov_1.751899_g24233_i0 | PRJNA1068830 | 24934 | 468 | 1.751899 | 8.19888732 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 286 | 9.359999999999998e-94 | NR | CDS15399.1 | 6210 | g24233 | i0 | 80.1 | 288.99358974359 | 156 | 31 | 100 | 0 | 1 | 468 | 98 | 253 | CDS15399.1 serine:threonine protein phosphatase PP1 gamma [Echinococcus granulosus] | diamond | 135249 | 286 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 21416241 | 21416241 | PRJNA1068830_P_NODE_53817_length_297_cov_2.075893_g53114_i0 | PRJNA1068830 | 53817 | 297 | 2.075893 | 6.16540221 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 115 | 3.47e-21 | NTclustered | gi|15808977|gb|AF418550.1| | 6183 | g53114 | i0 | 100 | 0.626262626262626 | 62 | 0 | 21 | 0 | 30 | 91 | 1859 | 1798 | Schistosoma mansoni albumin precursor, mRNA, complete cds | blastn | 186 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 27596142 | 27596142 | PRJNA1068830_P_NODE_35624_length_376_cov_4.867987_g34921_i0 | PRJNA1068830 | 35624 | 376 | 4.867987 | 18.30363112 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 119 | 1.92e-29 | NR | THD23375.1 | 6192 | g34921 | i0 | 46.4 | 8.07446808510638 | 125 | 65 | 98.9 | 2 | 1 | 372 | 207 | 330 | THD23375.1 Cathepsin L cysteine proteinase [Fasciola hepatica] | diamond | 3036 | 120 | 0.991666666666667 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 27983290 | 27983290 | PRJNA1068830_P_NODE_64085_length_271_cov_1.505051_g63382_i0 | PRJNA1068830 | 64085 | 271 | 1.505051 | 4.07868821 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 70.9 | 6.1e-12 | NR | VZI37571.1 | 99802 | g63382 | i0 | 62.2 | 0.498154981549816 | 45 | 17 | 49.8 | 0 | 271 | 137 | 260 | 304 | VZI37571.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 135 | 70.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 28077945 | 28077945 | PRJNA1068830_P_NODE_67165_length_264_cov_1.277487_g66462_i0 | PRJNA1068830 | 67165 | 264 | 1.277487 | 3.37256568 | Schistosoma intercalatum | 6187 | Platyhelminthes | Platyhelminthes | 107 | 1.82e-27 | NR | CAH8515303.1 | 6187 | g66462 | i0 | 62.7 | 0.852272727272727 | 75 | 28 | 85.2 | 0 | 226 | 2 | 1 | 75 | CAH8515303.1 unnamed protein product [Schistosoma intercalatum] | diamond | 225 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma intercalatum | |
| 28543465 | 28543465 | PRJNA1068830_P_NODE_86067_length_243_cov_3.370588_g85364_i0 | PRJNA1068830 | 86067 | 243 | 3.370588 | 8.19052884 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 110 | 2.87e-26 | NR | PAA93316.1 | 282301 | g85364 | i0 | 68.4 | 2.88888888888889 | 76 | 24 | 93.8 | 0 | 234 | 7 | 243 | 318 | PAA93316.1 hypothetical protein BOX15_Mlig013126g2 [Macrostomum lignano] | diamond | 702 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 28732739 | 28732739 | PRJNA1068830_P_NODE_83427_length_245_cov_1.360465_g82724_i0 | PRJNA1068830 | 83427 | 245 | 1.360465 | 3.33313925 | Schistosoma | 6181 | Platyhelminthes | Platyhelminthes | 81.6 | 2.13e-16 | NR | CAH8671007.1 | 6185 | g82724 | i0 | 46.8 | 3.86938775510204 | 79 | 40 | 96.7 | 2 | 243 | 7 | 100 | 176 | CAH8671007.1 unnamed protein product [Schistosoma haematobium] | diamond | 948 | 82 | 0.995121951219512 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 28953916 | 28953916 | PRJNA1068830_P_NODE_2068_length_1661_cov_6.251889_g1849_i0 | PRJNA1068830 | 2068 | 1661 | 6.251889 | 103.84387629 | Hymenolepididae | 6214 | Platyhelminthes | Platyhelminthes | 122 | 2.82e-28 | NR | CDS26983.2 | 85433 | g1849 | i0 | 45.3 | 0.550872968091511 | 150 | 73 | 26 | 2 | 18 | 449 | 2 | 148 | CDS26983.2 RNA and export factor binding protein 2 [Hymenolepis microstoma] | diamond | 915 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 29120220 | 29120220 | PRJNA1068830_P_NODE_83049_length_245_cov_2.773256_g82346_i0 | PRJNA1068830 | 83049 | 245 | 2.773256 | 6.7944772 | Hymenolepis microstoma | 85433 | Platyhelminthes | Platyhelminthes | 97.1 | 2.9e-21 | NR | CDS26487.1 | 85433 | g82346 | i0 | 56.8 | 5.5469387755102 | 81 | 33 | 96.7 | 2 | 238 | 2 | 505 | 585 | CDS26487.1 thioredoxin glutathione reductase [Hymenolepis microstoma] | diamond | 1359 | 97.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis microstoma | |
| 29206489 | 29206489 | PRJNA1068830_P_NODE_71349_length_254_cov_4.182320_g70646_i0 | PRJNA1068830 | 71349 | 254 | 4.18232 | 10.6230928 | Fasciolidae | 27843 | Platyhelminthes | Platyhelminthes | 59.3 | 2.4e-8 | NR | THD22600.1 | 6192 | g70646 | i0 | 42.3 | 1.67716535433071 | 71 | 38 | 80.3 | 1 | 207 | 4 | 7 | 77 | THD22600.1 Mitochondrial ATP synthase subunit OSCP subunit [Fasciola hepatica] | diamond | 426 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Fasciolidae | Fasciola | Fasciola hepatica | |
| 30067260 | 30067260 | PRJNA1068830_P_NODE_47272_length_319_cov_2.630081_g46569_i0 | PRJNA1068830 | 47272 | 319 | 2.630081 | 8.38995839 | Schistosoma turkestanicum | 1163369 | Platyhelminthes | Platyhelminthes | 97.4 | 2e-21 | NR | CAH8465612.1 | 1163369 | g46569 | i0 | 44.1 | 0.959247648902821 | 102 | 54 | 93.1 | 2 | 10 | 306 | 268 | 369 | CAH8465612.1 unnamed protein product [Schistosoma turkestanicum] | diamond | 306 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma turkestanicum | |
| 30288886 | 30288886 | PRJNA1068830_P_NODE_28432_length_431_cov_2.145251_g27729_i0 | PRJNA1068830 | 28432 | 431 | 2.145251 | 9.24603181 | Calicophoron daubneyi | 300641 | Platyhelminthes | Platyhelminthes | 147 | 6.2e-40 | NR | CAL5129275.1 | 300641 | g27729 | i0 | 53.3 | 13.5034802784223 | 137 | 63 | 94.7 | 1 | 416 | 9 | 5 | 141 | CAL5129275.1 unnamed protein product [Calicophoron daubneyi] | diamond | 5820 | 147 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Paramphistomidae | Calicophoron | Calicophoron daubneyi | |
| 31227787 | 31227787 | PRJNA1068830_P_NODE_55015_length_294_cov_0.950226_g54312_i0 | PRJNA1068830 | 55015 | 294 | 0.950226 | 2.79366444 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 121 | 8.85e-30 | NR | VUZ56249.1 | 6216 | g54312 | i0 | 63.5 | 27.2551020408163 | 96 | 35 | 98 | 0 | 5 | 292 | 208 | 303 | VUZ56249.1 unnamed protein product [Hymenolepis diminuta] | diamond | 8013 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 31259615 | 31259615 | PRJNA1068830_P_NODE_15275_length_626_cov_2.086799_g14597_i0 | PRJNA1068830 | 15275 | 626 | 2.086799 | 13.06336174 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 153 | 7.57e-41 | NR | CAH8476265.1 | 39320 | g14597 | i0 | 38.2 | 8.38178913738019 | 199 | 120 | 94.9 | 2 | 625 | 32 | 158 | 354 | CAH8476265.1 unnamed protein product [Heterobilharzia americana] | diamond | 5247 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Heterobilharzia | Heterobilharzia americana | |
| 31773975 | 31773975 | PRJNA1068830_P_NODE_24997_length_467_cov_2.162437_g24295_i0 | PRJNA1068830 | 24997 | 467 | 2.162437 | 10.09858079 | Schistocephalus solidus | 70667 | Platyhelminthes | Platyhelminthes | 153 | 2.5499999999999994e-42 | NR | VDL97057.1 | 70667 | g24295 | i0 | 46.5 | 2.01713062098501 | 157 | 82 | 99.6 | 1 | 466 | 2 | 181 | 337 | VDL97057.1 unnamed protein product [Schistocephalus solidus] | diamond | 942 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Schistocephalus | Schistocephalus solidus | |
| 32090494 | 32090494 | PRJNA1068830_P_NODE_85678_length_244_cov_0.912281_g84975_i0 | PRJNA1068830 | 85678 | 244 | 0.912281 | 2.22596564 | Spirometra erinaceieuropaei | 99802 | Platyhelminthes | Platyhelminthes | 63.9 | 1.29e-9 | NR | VZI19819.1 | 99802 | g84975 | i0 | 40.3 | 1.73360655737705 | 72 | 42 | 88.5 | 1 | 220 | 5 | 461 | 531 | VZI19819.1 unnamed protein product [Spirometra erinaceieuropaei] | diamond | 423 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Diphyllobothriidea | Diphyllobothriidae | Spirometra | Spirometra erinaceieuropaei | |
| 32871557 | 32871557 | PRJNA1068830_P_NODE_36400_length_372_cov_1.200669_g35697_i0 | PRJNA1068830 | 36400 | 372 | 1.200669 | 4.46648868 | Metazoa | 33208 | Platyhelminthes | Platyhelminthes | 97.1 | 8.31e-22 | NR | TNN12665.1 | 6182 | g35697 | i0 | 44.2 | 3.57258064516129 | 104 | 58 | 83.9 | 0 | 314 | 3 | 69 | 172 | TNN12665.1 thiamine pyrophosphokinase 1 [Schistosoma japonicum] | diamond | 1329 | 97.1 | 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);;