contig_metadata
21 rows where analysis = "diamond", bioproject = "PRJNA1115053" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26783349 | 26783349 | PRJNA1115053_S_NODE_262461_length_172_cov_1.116279_g260644_i0 | PRJNA1115053 | 262461 | 172 | 1.116279 | 1.91999988 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 92 | 6.1300000000000005e-22 | NR | AAX25839.2 | 6182 | g260644 | i0 | 84.9 | 0.924418604651163 | 53 | 8 | 92.4 | 0 | 172 | 14 | 60 | 112 | AAX25839.2 SJCHGC09516 protein, partial [Schistosoma japonicum] | diamond | 159 | 92 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27605275 | 27605275 | PRJNA1115053_S_NODE_25604_length_423_cov_3.215789_g23795_i0 | PRJNA1115053 | 25604 | 423 | 3.215789 | 13.60278747 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 101 | 6.15e-24 | NR | AAX25032.2 | 6182 | g23795 | i0 | 66.2 | 0.546099290780142 | 77 | 26 | 54.6 | 0 | 248 | 18 | 104 | 180 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 231 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 27857622 | 27857622 | PRJNA1115053_S_NODE_129605_length_233_cov_2.273684_g127788_i0 | PRJNA1115053 | 129605 | 233 | 2.273684 | 5.29768372 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 90.5 | 2.5600000000000003e-21 | NR | AAX24812.2 | 6182 | g127788 | i0 | 74.1 | 0.695278969957081 | 54 | 14 | 69.5 | 0 | 3 | 164 | 4 | 57 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 162 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28236325 | 28236325 | PRJNA1115053_S_NODE_192046_length_197_cov_2.181818_g190229_i0 | PRJNA1115053 | 192046 | 197 | 2.181818 | 4.29818146 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 53.1 | 7.14e-7 | NR | AAX24812.2 | 6182 | g190229 | i0 | 65 | 1.96446700507614 | 40 | 9 | 53.3 | 1 | 191 | 87 | 17 | 56 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 387 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28362741 | 28362741 | PRJNA1115053_S_NODE_217546_length_187_cov_1.000000_g215729_i0 | PRJNA1115053 | 217546 | 187 | 1 | 1.87 | Schistosoma mansoni | 6183 | Platyhelminthes | Platyhelminthes | 45.1 | 0.0013 | NR | XP_018644101.1 | 6183 | g215729 | i0 | 44 | 18.7058823529412 | 50 | 28 | 80.2 | 0 | 11 | 160 | 101 | 150 | XP_018644101.1 hypothetical protein Smp_191100 [Schistosoma mansoni] | diamond | 3498 | 45.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma mansoni | |
| 28552493 | 28552493 | PRJNA1115053_S_NODE_38067_length_370_cov_2.840979_g36250_i0 | PRJNA1115053 | 38067 | 370 | 2.840979 | 10.5116223 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 69.7 | 7.79e-12 | NR | AAX25032.2 | 6182 | g36250 | i0 | 59.6 | 0.381081081081081 | 47 | 19 | 38.1 | 0 | 109 | 249 | 90 | 136 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 141 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28615567 | 28615567 | PRJNA1115053_S_NODE_308867_length_159_cov_1.241379_g307050_i0 | PRJNA1115053 | 308867 | 159 | 1.241379 | 1.97379261 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 57 | 6.2e-9 | NR | AAX30341.2 | 6182 | g307050 | i0 | 76.9 | 0.735849056603774 | 39 | 8 | 73.6 | 1 | 125 | 9 | 51 | 88 | AAX30341.2 SJCHGC03035 protein [Schistosoma japonicum] | diamond | 117 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 28741776 | 28741776 | PRJNA1115053_S_NODE_232927_length_181_cov_1.739130_g231110_i0 | PRJNA1115053 | 232927 | 181 | 1.73913 | 3.1478253 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 40.8 | 0.0102 | NR | AAX30326.1 | 6182 | g231110 | i0 | 55.2 | 1.06077348066298 | 29 | 13 | 48.1 | 0 | 179 | 93 | 29 | 57 | AAX30326.1 SJCHGC03015 protein [Schistosoma japonicum] | diamond | 192 | 40.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 29910206 | 29910206 | PRJNA1115053_S_NODE_260831_length_172_cov_1.728682_g259014_i0 | PRJNA1115053 | 260831 | 172 | 1.728682 | 2.97333304 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 88.2 | 5.5e-20 | NR | AAX25963.2 | 6182 | g259014 | i0 | 97.6 | 0.715116279069767 | 41 | 1 | 71.5 | 0 | 1 | 123 | 100 | 140 | AAX25963.2 SJCHGC04741 protein, partial [Schistosoma japonicum] | diamond | 123 | 88.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30162553 | 30162553 | PRJNA1115053_S_NODE_184032_length_201_cov_1.518987_g182215_i0 | PRJNA1115053 | 184032 | 201 | 1.518987 | 3.05316387 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 83.6 | 8.81e-19 | NR | AAX24812.2 | 6182 | g182215 | i0 | 71.2 | 2.29850746268657 | 52 | 15 | 77.6 | 0 | 199 | 44 | 6 | 57 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 462 | 83.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30384392 | 30384392 | PRJNA1115053_S_NODE_4373_length_809_cov_18.231070_g3295_i0 | PRJNA1115053 | 4373 | 809 | 18.23107 | 147.4893563 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 49.7 | 2.53e-4 | NR | ABA40899.1 | 6182 | g3295 | i0 | 59 | 0.144622991347342 | 39 | 14 | 13.7 | 1 | 355 | 245 | 4 | 42 | ABA40899.1 SJCHGC09658 protein, partial [Schistosoma japonicum] | diamond | 117 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30447331 | 30447331 | PRJNA1115053_S_NODE_323513_length_155_cov_2.142857_g321696_i0 | PRJNA1115053 | 323513 | 155 | 2.142857 | 3.32142835 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 72 | 1.66e-14 | NR | AAX24812.2 | 6182 | g321696 | i0 | 64 | 2.92258064516129 | 50 | 15 | 96.8 | 1 | 3 | 152 | 6 | 52 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 453 | 72.4 | 0.994475138121547 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30478874 | 30478874 | PRJNA1115053_S_NODE_178993_length_203_cov_2.818750_g177176_i0 | PRJNA1115053 | 178993 | 203 | 2.81875 | 5.7220625 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 105 | 1.6700000000000002e-26 | NR | AAX25032.2 | 6182 | g177176 | i0 | 91.1 | 0.827586206896552 | 56 | 3 | 79.8 | 1 | 163 | 2 | 131 | 186 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 168 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 30636560 | 30636560 | PRJNA1115053_S_NODE_179533_length_203_cov_1.800000_g177716_i0 | PRJNA1115053 | 179533 | 203 | 1.8 | 3.654 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 57 | 2.44e-8 | NR | AAX24812.2 | 6182 | g177716 | i0 | 70.6 | 1.64039408866995 | 34 | 10 | 50.2 | 0 | 101 | 202 | 1 | 34 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 333 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31205010 | 31205010 | PRJNA1115053_S_NODE_352755_length_151_cov_0.888889_g350938_i0 | PRJNA1115053 | 352755 | 151 | 0.888889 | 1.34222239 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 70.5 | 6.13e-14 | NR | ABA40296.1 | 6182 | g350938 | i0 | 94.3 | 0.695364238410596 | 35 | 2 | 69.5 | 0 | 45 | 149 | 1 | 35 | ABA40296.1 SJCHGC09003 protein, partial [Schistosoma japonicum] | diamond | 105 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31806419 | 31806419 | PRJNA1115053_S_NODE_264697_length_171_cov_1.500000_g262880_i0 | PRJNA1115053 | 264697 | 171 | 1.5 | 2.565 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 51.2 | 1.75e-6 | NR | AAX26836.2 | 6182 | g262880 | i0 | 76.7 | 1.57894736842105 | 30 | 7 | 52.6 | 0 | 62 | 151 | 70 | 99 | AAX26836.2 SJCHGC03019 protein, partial [Schistosoma japonicum] | diamond | 270 | 51.6 | 0.992248062015504 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 31996286 | 31996286 | PRJNA1115053_S_NODE_274578_length_168_cov_1.536000_g272761_i0 | PRJNA1115053 | 274578 | 168 | 1.536 | 2.58048 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 49.3 | 1.5e-5 | NR | AAX24812.2 | 6182 | g272761 | i0 | 74.1 | 1.91071428571429 | 27 | 7 | 48.2 | 0 | 2 | 82 | 32 | 58 | AAX24812.2 SJCHGC04011 protein, partial [Schistosoma japonicum] | diamond | 321 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32597376 | 32597376 | PRJNA1115053_S_NODE_99620_length_259_cov_3.648148_g97803_i0 | PRJNA1115053 | 99620 | 259 | 3.648148 | 9.44870332 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 98.2 | 1.1500000000000002e-21 | NR | AAX28387.3 | 6182 | g97803 | i0 | 74 | 3.38223938223938 | 73 | 19 | 84.6 | 0 | 257 | 39 | 108 | 180 | AAX28387.3 SJCHGC01615 protein, partial [Schistosoma japonicum] | diamond | 876 | 98.6 | 0.995943204868154 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32723251 | 32723251 | PRJNA1115053_S_NODE_18060_length_476_cov_3.695150_g16270_i0 | PRJNA1115053 | 18060 | 476 | 3.69515 | 17.588914 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 82.8 | 1.88e-17 | NR | AAX30341.2 | 6182 | g16270 | i0 | 55.3 | 2.57773109243697 | 85 | 38 | 53.6 | 0 | 118 | 372 | 4 | 88 | AAX30341.2 SJCHGC03035 protein [Schistosoma japonicum] | diamond | 1227 | 83.2 | 0.995192307692308 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32817633 | 32817633 | PRJNA1115053_S_NODE_142200_length_224_cov_2.983425_g140383_i0 | PRJNA1115053 | 142200 | 224 | 2.983425 | 6.682872 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 49.7 | 9.46e-6 | NR | AAX30454.1 | 6182 | g140383 | i0 | 92.3 | 0.348214285714286 | 26 | 2 | 34.8 | 0 | 223 | 146 | 55 | 80 | AAX30454.1 SJCHGC03747 protein [Schistosoma japonicum] | diamond | 78 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Strigeidida | Schistosomatidae | Schistosoma | Schistosoma japonicum | |
| 32880568 | 32880568 | PRJNA1115053_S_NODE_107120_length_252_cov_2.133971_g105303_i0 | PRJNA1115053 | 107120 | 252 | 2.133971 | 5.37760692 | Schistosoma japonicum | 6182 | Platyhelminthes | Platyhelminthes | 151 | 2.17e-44 | NR | AAX25032.2 | 6182 | g105303 | i0 | 87.7 | 0.964285714285714 | 81 | 10 | 96.4 | 0 | 2 | 244 | 89 | 169 | AAX25032.2 SJCHGC04714 protein, partial [Schistosoma japonicum] | diamond | 243 | 151 | 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);;