contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA682078" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3211849 | 3211849 | PRJNA682078_P_NODE_240043_length_248_cov_2.102857_g238266_i0 | PRJNA682078 | 240043 | 248 | 2.102857 | 5.21508536 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 140 | 1.99e-40 | NR | CDS40614.1 | 6211 | g238266 | i0 | 82.9 | 0.991935483870968 | 82 | 14 | 99.2 | 0 | 248 | 3 | 28 | 109 | CDS40614.1 expressed protein [Echinococcus multilocularis] | diamond | 246 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 10861599 | 10861599 | PRJNA682078_P_NODE_103089_length_347_cov_1.492701_g101313_i0 | PRJNA682078 | 103089 | 347 | 1.492701 | 5.17967247 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 115 | 2.17e-29 | NR | KAH9284062.1 | 6210 | g101313 | i0 | 100 | 0.510086455331412 | 59 | 0 | 51 | 0 | 1 | 177 | 64 | 122 | KAH9284062.1 hypothetical protein ECG_02711 [Echinococcus granulosus] | diamond | 177 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 10862970 | 10862970 | PRJNA682078_P_NODE_157149_length_289_cov_1.148148_g155372_i0 | PRJNA682078 | 157149 | 289 | 1.148148 | 3.31814772 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 144 | 1.74e-40 | NR | CDS16966.1 | 6210 | g155372 | i0 | 84.4 | 2.26297577854671 | 109 | 3 | 98.6 | 1 | 288 | 4 | 3 | 111 | CDS16966.1 expressed conserved protein [Echinococcus granulosus] | diamond | 654 | 144 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 10863616 | 10863616 | PRJNA682078_P_NODE_183569_length_273_cov_0.830000_g181792_i0 | PRJNA682078 | 183569 | 273 | 0.83 | 2.2659 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 140 | 5.16e-41 | NR | KAH9277513.1 | 6210 | g181792 | i0 | 100 | 0.703296703296703 | 64 | 0 | 70.3 | 0 | 81 | 272 | 1 | 64 | KAH9277513.1 hypothetical protein ECG_09945 [Echinococcus granulosus] | diamond | 192 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 24885045 | 24885045 | PRJNA682078_P_NODE_152740_length_292_cov_1.406393_g150963_i0 | PRJNA682078 | 152740 | 292 | 1.406393 | 4.10666756 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 158 | 3.1199999999999995e-48 | NR | CDS38307.1 | 6211 | g150963 | i0 | 96.4 | 0.852739726027397 | 83 | 3 | 85.3 | 0 | 3 | 251 | 5 | 87 | CDS38307.1 expressed conserved protein [Echinococcus multilocularis] | diamond | 249 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 26765643 | 26765643 | PRJNA682078_P_NODE_90341_length_367_cov_2.408163_g88566_i0 | PRJNA682078 | 90341 | 367 | 2.408163 | 8.83795821 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 124 | 1.84e-34 | NR | CUT99393.1 | 6211 | g88566 | i0 | 85.9 | 0.752043596730245 | 92 | 12 | 75.2 | 1 | 367 | 92 | 2 | 92 | CUT99393.1 expressed protein [Echinococcus multilocularis] | diamond | 276 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 28061136 | 28061136 | PRJNA682078_P_NODE_280445_length_242_cov_1.609467_g278668_i0 | PRJNA682078 | 280445 | 242 | 1.609467 | 3.89491014 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 153 | 1.6e-44 | NR | CDS16004.1 | 6210 | g278668 | i0 | 100 | 0.855371900826446 | 69 | 0 | 85.5 | 0 | 207 | 1 | 6 | 74 | CDS16004.1 nucleic acid binding [Echinococcus granulosus] | diamond | 207 | 153 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28218806 | 28218806 | PRJNA682078_P_NODE_185346_length_271_cov_2.984848_g183569_i0 | PRJNA682078 | 185346 | 271 | 2.984848 | 8.08893808 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 59.7 | 1.48e-9 | NR | VUZ52238.1 | 6216 | g183569 | i0 | 81.7 | 0.785977859778598 | 71 | 13 | 78.6 | 0 | 254 | 42 | 1 | 71 | VUZ52238.1 unnamed protein product [Hymenolepis diminuta] | diamond | 213 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 28250509 | 28250509 | PRJNA682078_P_NODE_253686_length_246_cov_1.728324_g251909_i0 | PRJNA682078 | 253686 | 246 | 1.728324 | 4.25167704 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 166 | 2.55e-50 | NR | CDS15655.1 | 6210 | g251909 | i0 | 100 | 2 | 82 | 0 | 100 | 0 | 246 | 1 | 64 | 145 | CDS15655.1 Kinase binding protein CGI 121, partial [Echinococcus granulosus] | diamond | 492 | 166 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 28692855 | 28692855 | PRJNA682078_P_NODE_170147_length_280_cov_5.613527_g168370_i0 | PRJNA682078 | 170147 | 280 | 5.613527 | 15.7178756 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 90.1 | 1.14e-21 | NR | VUZ39874.1 | 6216 | g168370 | i0 | 66.7 | 0.578571428571429 | 54 | 18 | 57.9 | 0 | 279 | 118 | 1 | 54 | VUZ39874.1 unnamed protein product [Hymenolepis diminuta] | diamond | 162 | 90.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 28818660 | 28818660 | PRJNA682078_P_NODE_280408_length_242_cov_1.633136_g278631_i0 | PRJNA682078 | 280408 | 242 | 1.633136 | 3.95218912 | Hymenolepis diminuta | 6216 | Platyhelminthes | Platyhelminthes | 82.8 | 5.7e-19 | NR | VUZ40226.1 | 6216 | g278631 | i0 | 75.5 | 0.65702479338843 | 53 | 13 | 65.7 | 0 | 9 | 167 | 5 | 57 | VUZ40226.1 unnamed protein product [Hymenolepis diminuta] | diamond | 159 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Hymenolepididae | Hymenolepis | Hymenolepis diminuta | |
| 29355848 | 29355848 | PRJNA682078_P_NODE_226969_length_250_cov_2.129944_g225192_i0 | PRJNA682078 | 226969 | 250 | 2.129944 | 5.32486 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 116 | 3.29e-32 | NR | CDS43732.1 | 6211 | g225192 | i0 | 94.6 | 0.672 | 56 | 3 | 67.2 | 0 | 23 | 190 | 1 | 56 | CDS43732.1 mitochondrial F1F0 ATP synthase subunit epsilon [Echinococcus multilocularis] | diamond | 168 | 116 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 29387397 | 29387397 | PRJNA682078_P_NODE_100069_length_351_cov_3.877698_g98293_i0 | PRJNA682078 | 100069 | 351 | 3.877698 | 13.61071998 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 140 | 4e-41 | NR | CDS18674.1 | 6210 | g98293 | i0 | 100 | 0.64957264957265 | 76 | 0 | 65 | 0 | 350 | 123 | 4 | 79 | CDS18674.1 expressed protein [Echinococcus granulosus] | diamond | 228 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 29924221 | 29924221 | PRJNA682078_P_NODE_206071_length_259_cov_2.016129_g204294_i0 | PRJNA682078 | 206071 | 259 | 2.016129 | 5.22177411 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 164 | 2.13e-50 | NR | KAH9281770.1 | 6210 | g204294 | i0 | 100 | 0.984555984555985 | 85 | 0 | 98.5 | 0 | 257 | 3 | 12 | 96 | KAH9281770.1 C-Myc-binding -like protein [Echinococcus granulosus] | diamond | 255 | 164 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 30062019 | 30062019 | PRJNA682078_P_NODE_246571_length_247_cov_2.109195_g244794_i0 | PRJNA682078 | 246571 | 247 | 2.109195 | 5.20971165 | root | 1 | Root_unresolved | Root_unresolved | 51.2 | 4.1e-5 | NR | CAH8478024.1 | 6185 | g244794 | i0 | 67.6 | 2.56275303643725 | 34 | 11 | 41.3 | 0 | 4 | 105 | 572 | 605 | CAH8478024.1 unnamed protein product [Schistosoma haematobium] | diamond | 633 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma haematobium | |
| 30378514 | 30378514 | PRJNA682078_P_NODE_177392_length_276_cov_1.517241_g175615_i0 | PRJNA682078 | 177392 | 276 | 1.517241 | 4.18758516 | Echinococcus | 6209 | Platyhelminthes | Platyhelminthes | 56.2 | 3.75e-8 | NR | KAH9284526.1 | 6210 | g175615 | i0 | 100 | 0.58695652173913 | 27 | 0 | 29.3 | 0 | 274 | 194 | 33 | 59 | KAH9284526.1 hypothetical protein ECG_02173 [Echinococcus granulosus] | diamond | 162 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 30966879 | 30966879 | PRJNA682078_P_NODE_153874_length_291_cov_1.412844_g152097_i0 | PRJNA682078 | 153874 | 291 | 1.412844 | 4.11137604 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 133 | 1.6499999999999999e-38 | NR | CDS37181.1 | 6211 | g152097 | i0 | 100 | 0.680412371134021 | 66 | 0 | 68 | 0 | 290 | 93 | 19 | 84 | CDS37181.1 expressed protein [Echinococcus multilocularis] | diamond | 198 | 133 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 31030225 | 31030225 | PRJNA682078_P_NODE_64515_length_428_cov_3.340845_g62740_i0 | PRJNA682078 | 64515 | 428 | 3.340845 | 14.2988166 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 157 | 6e-46 | NR | CDS24155.1 | 6210 | g62740 | i0 | 91.2 | 0.63785046728972 | 91 | 2 | 59.6 | 1 | 257 | 3 | 13 | 103 | CDS24155.1 expressed protein [Echinococcus granulosus] | diamond | 273 | 157 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31314381 | 31314381 | PRJNA682078_P_NODE_161515_length_286_cov_1.361502_g159738_i0 | PRJNA682078 | 161515 | 286 | 1.361502 | 3.89389572 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 180 | 6.139999999999999e-57 | NR | KAH9283648.1 | 6210 | g159738 | i0 | 100 | 0.933566433566434 | 89 | 0 | 93.4 | 0 | 9 | 275 | 1 | 89 | KAH9283648.1 hypothetical protein ECG_04216 [Echinococcus granulosus] | diamond | 267 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31346108 | 31346108 | PRJNA682078_P_NODE_120676_length_324_cov_2.649402_g118899_i0 | PRJNA682078 | 120676 | 324 | 2.649402 | 8.58406248 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 194 | 1.03e-61 | NR | KAH9287360.1 | 6210 | g118899 | i0 | 100 | 0.935185185185185 | 101 | 0 | 93.5 | 0 | 304 | 2 | 1 | 101 | KAH9287360.1 40S ribosomal protein S30-B [Echinococcus granulosus] | diamond | 303 | 194 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31377780 | 31377780 | PRJNA682078_P_NODE_112656_length_334_cov_1.762452_g110879_i0 | PRJNA682078 | 112656 | 334 | 1.762452 | 5.88658968 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 188 | 8.48e-60 | NR | KAH9283261.1 | 6210 | g110879 | i0 | 100 | 0.817365269461078 | 91 | 0 | 81.7 | 0 | 277 | 5 | 2 | 92 | KAH9283261.1 hypothetical protein ECG_04538 [Echinococcus granulosus] | diamond | 273 | 188 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31536065 | 31536065 | PRJNA682078_P_NODE_298556_length_224_cov_6.894040_g296779_i0 | PRJNA682078 | 298556 | 224 | 6.89404 | 15.4426496 | Paragonimus skrjabini miyazakii | 59628 | Platyhelminthes | Platyhelminthes | 52 | 5.26e-7 | NR | KAF7234433.1 | 59628 | g296779 | i0 | 55 | 0.535714285714286 | 40 | 16 | 50.9 | 1 | 181 | 68 | 4 | 43 | KAF7234433.1 hypothetical protein EG68_11869 [Paragonimus skrjabini miyazakii] | diamond | 120 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus skrjabini miyazakii | |
| 31662189 | 31662189 | PRJNA682078_P_NODE_297317_length_228_cov_3.748387_g295540_i0 | PRJNA682078 | 297317 | 228 | 3.748387 | 8.54632236 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 140 | 6.78e-41 | NR | CDS23165.1 | 6210 | g295540 | i0 | 98.7 | 1 | 76 | 1 | 100 | 0 | 228 | 1 | 13 | 88 | CDS23165.1 expressed protein [Echinococcus granulosus] | diamond | 228 | 140 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 31852009 | 31852009 | PRJNA682078_P_NODE_266897_length_244_cov_1.730994_g265120_i0 | PRJNA682078 | 266897 | 244 | 1.730994 | 4.22362536 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 60.8 | 3.47e-10 | NR | CDS36480.1 | 6211 | g265120 | i0 | 92.9 | 0.344262295081967 | 28 | 2 | 34.4 | 0 | 48 | 131 | 41 | 68 | CDS36480.1 expressed protein [Echinococcus multilocularis] | diamond | 84 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 32642460 | 32642460 | PRJNA682078_P_NODE_133640_length_310_cov_2.223629_g131863_i0 | PRJNA682078 | 133640 | 310 | 2.223629 | 6.8932499 | Echinococcus granulosus | 6210 | Platyhelminthes | Platyhelminthes | 175 | 7.819999999999999e-55 | NR | CDS18470.1 | 6210 | g131863 | i0 | 100 | 0.764516129032258 | 79 | 0 | 76.5 | 0 | 310 | 74 | 8 | 86 | CDS18470.1 expressed conserved protein [Echinococcus granulosus] | diamond | 237 | 175 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus | |
| 32737359 | 32737359 | PRJNA682078_P_NODE_148120_length_296_cov_1.609865_g146343_i0 | PRJNA682078 | 148120 | 296 | 1.609865 | 4.7652004 | Echinococcus multilocularis | 6211 | Platyhelminthes | Platyhelminthes | 134 | 5.92e-39 | NR | CDI97862.1 | 6211 | g146343 | i0 | 98.4 | 0.638513513513513 | 63 | 1 | 63.9 | 0 | 2 | 190 | 8 | 70 | CDI97862.1 expressed conserved protein [Echinococcus multilocularis] | diamond | 189 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus multilocularis | |
| 32748850 | 32748850 | PRJNA682078_P_NODE_74520_length_401_cov_1.054878_g72745_i0 | PRJNA682078 | 74520 | 401 | 1.054878 | 4.23006078 | Echinococcus | 6209 | Platyhelminthes | Platyhelminthes | 186 | 3.2700000000000004e-58 | NR | KAH9281880.1 | 6210 | g72745 | i0 | 94.4 | 1.45885286783042 | 89 | 5 | 66.6 | 0 | 3 | 269 | 25 | 113 | KAH9281880.1 hypothetical protein ECG_06028 [Echinococcus granulosus] | diamond | 585 | 187 | 0.994652406417112 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Cestoda | Cyclophyllidea | Taeniidae | Echinococcus | Echinococcus granulosus |
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);;