contig_metadata
27 rows where analysis = "diamond", bioproject = "PRJNA1241156" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 27041973 | 27041973 | PRJNA1241156_S_NODE_35182_length_315_cov_6.511029_g34722_i0 | PRJNA1241156 | 35182 | 315 | 6.511029 | 20.50974135 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 85.1 | 9.91e-19 | NR | AAX24812.2 | 6182 | g34722 | i0 | 68.4 | 0.542857142857143 | 57 | 18 | 54.3 | 0 | 309 | 139 | 1 | 57 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 171 | 85.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27389817 | 27389817 | PRJNA1241156_S_NODE_73983_length_209_cov_4.921687_g73523_i0 | PRJNA1241156 | 73983 | 209 | 4.921687 | 10.28632583 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 83.6 | 8.96e-19 | NR | AAW25324.1 | 6182 | g73523 | i0 | 76.8 | 2.29665071770335 | 56 | 13 | 80.4 | 0 | 205 | 38 | 23 | 78 | AAW25324.1 SJCHGC04440 protein [Schistosoma japonicum] | diamond | 480 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27453002 | 27453002 | PRJNA1241156_S_NODE_60743_length_252_cov_2.411483_g60283_i0 | PRJNA1241156 | 60743 | 252 | 2.411483 | 6.07693716 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 79.7 | 1.01e-16 | NR | AAX30334.2 | 6182 | g60283 | i0 | 70.5 | 1.3452380952381 | 61 | 15 | 72.6 | 1 | 232 | 50 | 46 | 103 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 339 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27705770 | 27705770 | PRJNA1241156_S_NODE_20324_length_364_cov_4.102804_g19864_i0 | PRJNA1241156 | 20324 | 364 | 4.102804 | 14.93420656 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 65.9 | 5.77e-11 | NR | AAX24812.2 | 6182 | g19864 | i0 | 61.2 | 0.791208791208791 | 49 | 19 | 40.4 | 0 | 7 | 153 | 1 | 49 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 288 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27957974 | 27957974 | PRJNA1241156_S_NODE_28825_length_334_cov_4.546392_g28365_i0 | PRJNA1241156 | 28825 | 334 | 4.546392 | 15.18494928 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 76.3 | 6.39e-15 | NR | AAX30334.2 | 6182 | g28365 | i0 | 74.5 | 0.844311377245509 | 47 | 12 | 42.2 | 0 | 241 | 101 | 54 | 100 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 282 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28494845 | 28494845 | PRJNA1241156_S_NODE_38087_length_307_cov_6.556818_g37627_i0 | PRJNA1241156 | 38087 | 307 | 6.556818 | 20.12943126 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 66.6 | 5.81e-11 | NR | AAX25032.2 | 6182 | g37627 | i0 | 71.4 | 1.79804560260586 | 49 | 13 | 46.9 | 1 | 115 | 258 | 139 | 187 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 552 | 67 | 0.994029850746269 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28841907 | 28841907 | PRJNA1241156_S_NODE_24908_length_347_cov_4.055921_g24448_i0 | PRJNA1241156 | 24908 | 347 | 4.055921 | 14.07404587 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 84 | 4.03e-18 | NR | AAX24812.2 | 6182 | g24448 | i0 | 53.1 | 0.70028818443804 | 81 | 29 | 70 | 1 | 334 | 92 | 4 | 75 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 243 | 84 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29126488 | 29126488 | PRJNA1241156_S_NODE_47809_length_281_cov_5.777311_g47349_i0 | PRJNA1241156 | 47809 | 281 | 5.777311 | 16.23424391 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 53.9 | 9.9e-7 | NR | AAX24812.2 | 6182 | g47349 | i0 | 71.9 | 0.875444839857651 | 32 | 9 | 34.2 | 0 | 240 | 145 | 13 | 44 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 246 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29378822 | 29378822 | PRJNA1241156_S_NODE_51409_length_272_cov_8.074236_g50949_i0 | PRJNA1241156 | 51409 | 272 | 8.074236 | 21.96192192 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 94.7 | 1.71e-22 | NR | AAX30334.2 | 6182 | g50949 | i0 | 50.8 | 1.95220588235294 | 122 | 27 | 98.2 | 2 | 269 | 3 | 1 | 122 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 531 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29568155 | 29568155 | PRJNA1241156_S_NODE_28870_length_334_cov_3.728522_g28410_i0 | PRJNA1241156 | 28870 | 334 | 3.728522 | 12.45326348 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 79.3 | 2.19e-16 | NR | AAX24812.2 | 6182 | g28410 | i0 | 74.5 | 0.835329341317365 | 47 | 12 | 42.2 | 0 | 332 | 192 | 11 | 57 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 279 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29694199 | 29694199 | PRJNA1241156_S_NODE_32250_length_323_cov_20.353571_g31790_i0 | PRJNA1241156 | 32250 | 323 | 20.353571 | 65.74203433 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 82.8 | 4.09e-17 | NR | AAX25032.2 | 6182 | g31790 | i0 | 68.2 | 0.993808049535604 | 66 | 18 | 61.3 | 2 | 112 | 309 | 1 | 63 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 321 | 82.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30041931 | 30041931 | PRJNA1241156_S_NODE_2471_length_651_cov_8.064145_g2136_i0 | PRJNA1241156 | 2471 | 651 | 8.064145 | 52.49758395 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 81.3 | 2.6e-16 | NR | AAX31080.1 | 6182 | g2136 | i0 | 80 | 0.230414746543779 | 50 | 8 | 22.1 | 1 | 557 | 414 | 3 | 52 | AAX31080.1 SJCHGC09793 protein [Schistosoma japonicum] | diamond | 150 | 81.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30073437 | 30073437 | PRJNA1241156_S_NODE_73972_length_209_cov_5.493976_g73512_i0 | PRJNA1241156 | 73972 | 209 | 5.493976 | 11.48240984 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 62 | 2.92e-10 | NR | AAX24812.2 | 6182 | g73512 | i0 | 67.5 | 0.574162679425837 | 40 | 13 | 57.4 | 0 | 203 | 84 | 1 | 40 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 120 | 62 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30136393 | 30136393 | PRJNA1241156_S_NODE_40132_length_302_cov_2.405405_g39672_i0 | PRJNA1241156 | 40132 | 302 | 2.405405 | 7.2643231 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 45.1 | 0.00166 | NR | AAX30341.2 | 6182 | g39672 | i0 | 90.9 | 0.218543046357616 | 22 | 2 | 21.9 | 0 | 39 | 104 | 57 | 78 | AAX30341.2 SJCHGC03035 protein [Schistosoma japonicum] | diamond | 66 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30358401 | 30358401 | PRJNA1241156_S_NODE_20292_length_364_cov_5.143302_g19832_i0 | PRJNA1241156 | 20292 | 364 | 5.143302 | 18.72161928 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 94.4 | 4.14e-22 | NR | AAX24812.2 | 6182 | g19832 | i0 | 71.9 | 0.46978021978022 | 57 | 16 | 47 | 0 | 7 | 177 | 1 | 57 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 171 | 94.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30515892 | 30515892 | PRJNA1241156_S_NODE_18753_length_370_cov_8.981651_g18293_i0 | PRJNA1241156 | 18753 | 370 | 8.981651 | 33.2321087 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 58.5 | 1.42e-8 | NR | AAX31080.1 | 6182 | g18293 | i0 | 85.3 | 0.275675675675676 | 34 | 5 | 27.6 | 0 | 261 | 362 | 1 | 34 | AAX31080.1 SJCHGC09793 protein [Schistosoma japonicum] | diamond | 102 | 58.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30831798 | 30831798 | PRJNA1241156_S_NODE_57034_length_260_cov_1.225806_g56574_i0 | PRJNA1241156 | 57034 | 260 | 1.225806 | 3.1870956 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 68.6 | 6.59e-13 | NR | AAX30341.2 | 6182 | g56574 | i0 | 83.3 | 0.415384615384615 | 36 | 6 | 41.5 | 0 | 137 | 30 | 15 | 50 | AAX30341.2 SJCHGC03035 protein [Schistosoma japonicum] | diamond | 108 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31084655 | 31084655 | PRJNA1241156_S_NODE_72475_length_217_cov_4.011494_g72015_i0 | PRJNA1241156 | 72475 | 217 | 4.011494 | 8.70494198 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 86.7 | 6.61e-20 | NR | AAX24812.2 | 6182 | g72015 | i0 | 82.2 | 0.622119815668203 | 45 | 8 | 62.2 | 0 | 36 | 170 | 13 | 57 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 135 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31210516 | 31210516 | PRJNA1241156_S_NODE_45215_length_288_cov_3.902041_g44755_i0 | PRJNA1241156 | 45215 | 288 | 3.902041 | 11.23787808 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 79.3 | 5.68e-17 | NR | AAX31112.1 | 6182 | g44755 | i0 | 51.9 | 0.802083333333333 | 77 | 10 | 52.1 | 1 | 118 | 267 | 13 | 89 | AAX31112.1 SJCHGC09827 protein [Schistosoma japonicum] | diamond | 231 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31210521 | 31210521 | PRJNA1241156_S_NODE_67035_length_238_cov_7.497436_g66575_i0 | PRJNA1241156 | 67035 | 238 | 7.497436 | 17.84389768 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 154 | 1.12e-45 | NR | AAX25032.2 | 6182 | g66575 | i0 | 94.9 | 0.995798319327731 | 79 | 4 | 99.6 | 0 | 2 | 238 | 107 | 185 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 237 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31242519 | 31242519 | PRJNA1241156_S_NODE_31675_length_325_cov_5.833333_g31215_i0 | PRJNA1241156 | 31675 | 325 | 5.833333 | 18.95833225 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 80.9 | 9.64e-18 | NR | AAX30326.1 | 6182 | g31215 | i0 | 74.1 | 0.498461538461538 | 54 | 13 | 48.9 | 1 | 321 | 163 | 5 | 58 | AAX30326.1 SJCHGC03015 protein [Schistosoma japonicum] | diamond | 162 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31717056 | 31717056 | PRJNA1241156_S_NODE_77917_length_196_cov_233.339869_g77457_i0 | PRJNA1241156 | 77917 | 196 | 233.339869 | 457.34614324 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 68.2 | 1.17e-12 | NR | AAW27122.1 | 6182 | g77457 | i0 | 90.6 | 0.489795918367347 | 32 | 3 | 49 | 0 | 185 | 90 | 18 | 49 | AAW27122.1 SJCHGC01951 protein [Schistosoma japonicum] | diamond | 96 | 68.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32413249 | 32413249 | PRJNA1241156_S_NODE_59779_length_254_cov_2.331754_g59319_i0 | PRJNA1241156 | 59779 | 254 | 2.331754 | 5.92265516 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 61.6 | 2.49e-9 | NR | AAX25032.2 | 6182 | g59319 | i0 | 84.8 | 0.389763779527559 | 33 | 4 | 37.8 | 1 | 12 | 107 | 90 | 122 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 99 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32602813 | 32602813 | PRJNA1241156_S_NODE_45280_length_288_cov_3.004082_g44820_i0 | PRJNA1241156 | 45280 | 288 | 3.004082 | 8.65175616 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 114 | 3.88e-30 | NR | AAX30334.2 | 6182 | g44820 | i0 | 87 | 1.64583333333333 | 69 | 9 | 71.9 | 0 | 287 | 81 | 77 | 145 | AAX30334.2 SJCHGC03026 protein, partial [Schistosoma japonicum] | diamond | 474 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32791509 | 32791509 | PRJNA1241156_S_NODE_10760_length_416_cov_34.664879_g10303_i0 | PRJNA1241156 | 10760 | 416 | 34.664879 | 144.20589664 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 49.7 | 4.25e-5 | NR | ABA40899.1 | 6182 | g10303 | i0 | 59 | 0.28125 | 39 | 14 | 26.7 | 1 | 351 | 241 | 4 | 42 | ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] | diamond | 117 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32854597 | 32854597 | PRJNA1241156_S_NODE_27620_length_338_cov_2.538983_g27160_i0 | PRJNA1241156 | 27620 | 338 | 2.538983 | 8.58176254 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 75.5 | 4.36e-14 | NR | AAX27441.2 | 6182 | g27160 | i0 | 79.1 | 0.754437869822485 | 43 | 9 | 38.2 | 0 | 183 | 311 | 55 | 97 | AAX27441.2 SJCHGC08991 protein, partial [Schistosoma japonicum] | diamond | 255 | 75.9 | 0.994729907773386 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32854600 | 32854600 | PRJNA1241156_S_NODE_6320_length_473_cov_3.965116_g5872_i0 | PRJNA1241156 | 6320 | 473 | 3.965116 | 18.75499868 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 59.7 | 1.25e-7 | NR | AAX25032.2 | 6182 | g5872 | i0 | 57.1 | 0.310782241014799 | 49 | 21 | 31.1 | 0 | 327 | 473 | 111 | 159 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 147 | 59.7 | 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);;