contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA577226" and tax_phylum = "Cnidaria"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4389007 | 4389007 | PRJNA577226_S_NODE_26444_length_244_cov_0.942029_g25505_i0 | PRJNA577226 | 26444 | 244 | 0.942029 | 2.29855076 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 66.6 | 1.42e-10 | NR | XP_065053058.1 | 499914 | g25505 | i0 | 61.7 | 1.2172131147541 | 47 | 18 | 57.8 | 0 | 243 | 103 | 422 | 468 | XP_065053058.1 aspartyl aminopeptidase-like [Rhopilema esculentum] | diamond | 297 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 13315609 | 13315609 | PRJNA577226_S_NODE_28691_length_233_cov_3.933673_g27752_i0 | PRJNA577226 | 28691 | 233 | 3.933673 | 9.16545809 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 84.7 | 6.59e-19 | NR | KAF1743137.1 | 59785 | g27752 | i0 | 81.8 | 1.41630901287554 | 55 | 7 | 70.8 | 2 | 3 | 167 | 83 | 134 | KAF1743137.1 hypothetical protein MXB_2311 [Myxobolus squamalis] | diamond | 330 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 26763116 | 26763116 | PRJNA577226_S_NODE_64861_length_157_cov_0.975000_g63922_i0 | PRJNA577226 | 64861 | 157 | 0.975 | 1.53075 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 52.8 | 3.37e-6 | NR | KAF1742538.1 | 59785 | g63922 | i0 | 68.8 | 0.611464968152866 | 32 | 10 | 61.1 | 0 | 1 | 96 | 428 | 459 | KAF1742538.1 hypothetical protein MXB_4431, partial [Myxobolus squamalis] | diamond | 96 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 26858468 | 26858468 | PRJNA577226_S_NODE_21721_length_271_cov_1.995726_g20782_i0 | PRJNA577226 | 21721 | 271 | 1.9957260000000001 | 5.40841746 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 90.5 | 6.86e-19 | NR | KAF0990815.1 | 69463 | g20782 | i0 | 64.9 | 0.6309963099631 | 57 | 20 | 63.1 | 0 | 269 | 99 | 410 | 466 | KAF0990815.1 hypothetical protein HZS_1306 [Henneguya salminicola] | diamond | 171 | 90.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 27079597 | 27079597 | PRJNA577226_S_NODE_26342_length_244_cov_1.753623_g25403_i0 | PRJNA577226 | 26342 | 244 | 1.753623 | 4.27884012 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 53.5 | 1.25e-6 | NR | KII72167.1 | 669202 | g25403 | i0 | 36.8 | 0.700819672131147 | 57 | 36 | 70.1 | 0 | 3 | 173 | 74 | 130 | KII72167.1 hypothetical protein RF11_10260 [Thelohanellus kitauei] | diamond | 171 | 53.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 27111083 | 27111083 | PRJNA577226_S_NODE_69302_length_152_cov_1.895652_g68363_i0 | PRJNA577226 | 69302 | 152 | 1.895652 | 2.88139104 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 41.6 | 0.0279 | NR | KII61094.1 | 669202 | g68363 | i0 | 48.6 | 0.690789473684211 | 35 | 18 | 69.1 | 0 | 138 | 34 | 626 | 660 | KII61094.1 Arginine--tRNA ligase, cytoplasmic [Thelohanellus kitauei] | diamond | 105 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 27332680 | 27332680 | PRJNA577226_S_NODE_71083_length_151_cov_1.026316_g70144_i0 | PRJNA577226 | 71083 | 151 | 1.026316 | 1.54973716 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 47 | 6.76e-5 | NR | KII70672.1 | 669202 | g70144 | i0 | 59.5 | 0.735099337748344 | 37 | 15 | 73.5 | 0 | 146 | 36 | 69 | 105 | KII70672.1 hypothetical protein RF11_10602 [Thelohanellus kitauei] | diamond | 111 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 28121905 | 28121905 | PRJNA577226_S_NODE_35885_length_208_cov_1.362573_g34946_i0 | PRJNA577226 | 35885 | 208 | 1.362573 | 2.83415184 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 88.6 | 4.78e-19 | NR | KAF0991672.1 | 69463 | g34946 | i0 | 67.9 | 1.64423076923077 | 56 | 18 | 80.8 | 0 | 5 | 172 | 224 | 279 | KAF0991672.1 hypothetical protein HZS_6462 [Henneguya salminicola] | diamond | 342 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 28784767 | 28784767 | PRJNA577226_S_NODE_29347_length_231_cov_1.396907_g28408_i0 | PRJNA577226 | 29347 | 231 | 1.396907 | 3.22685517 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 56.2 | 5.44e-7 | NR | KAF1742636.1 | 59785 | g28408 | i0 | 39.1 | 0.831168831168831 | 64 | 39 | 83.1 | 0 | 229 | 38 | 461 | 524 | KAF1742636.1 hypothetical protein MXB_5460, partial [Myxobolus squamalis] | diamond | 192 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 29668635 | 29668635 | PRJNA577226_S_NODE_35490_length_209_cov_1.813953_g34551_i0 | PRJNA577226 | 35490 | 209 | 1.813953 | 3.79116177 | Sphaeromyxa zaharoni | 275449 | Cnidaria | other_Eukaryota | 48.5 | 9.92e-5 | NR | CDU32390.1 | 275449 | g34551 | i0 | 75 | 0.401913875598086 | 28 | 7 | 40.2 | 0 | 102 | 185 | 138 | 165 | CDU32390.1 putative minicollagen [Sphaeromyxa zaharoni] | diamond | 84 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaeromyxidae | Sphaeromyxa | Sphaeromyxa zaharoni | |
| 29745435 | 29745435 | PRJNA577226_S_NODE_29750_length_229_cov_1.828125_g28811_i0 | PRJNA577226 | 29750 | 229 | 1.828125 | 4.18640625 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 53.9 | 3.4e-6 | NR | YP_011052045.1 | 649408 | g28811 | i0 | 50.8 | 1.57205240174672 | 59 | 29 | 77.3 | 0 | 191 | 15 | 206 | 264 | YP_011052045.1 NADH dehydrogenase subunit 5 [Myxobolus wulii] | diamond | 360 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus wulii | |
| 30819871 | 30819871 | PRJNA577226_S_NODE_25014_length_251_cov_1.817757_g24075_i0 | PRJNA577226 | 25014 | 251 | 1.817757 | 4.56257007 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 137 | 1.6299999999999998e-35 | NR | XP_066936722.1 | 252671 | g24075 | i0 | 72.3 | 3.9681274900398402 | 83 | 23 | 99.2 | 0 | 3 | 251 | 444 | 526 | XP_066936722.1 lysine--tRNA ligase-like [Clytia hemisphaerica] | diamond | 996 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 30869444 | 30869444 | PRJNA577226_S_NODE_50034_length_176_cov_2.748201_g49095_i0 | PRJNA577226 | 50034 | 176 | 2.748201 | 4.83683376 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 56.2 | 1.48e-7 | NR | KII61746.1 | 669202 | g49095 | i0 | 71 | 0.528409090909091 | 31 | 9 | 52.8 | 0 | 2 | 94 | 190 | 220 | KII61746.1 Peroxiredoxin-1 [Thelohanellus kitauei] | diamond | 93 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 31578592 | 31578592 | PRJNA577226_S_NODE_32056_length_220_cov_2.612022_g31117_i0 | PRJNA577226 | 32056 | 220 | 2.612022 | 5.7464484 | root | 1 | Root_unresolved | Root_unresolved | 44.7 | 0.00587 | NR | PFX21664.1 | 50429 | g31117 | i0 | 42.2 | 1.11818181818182 | 45 | 26 | 61.4 | 0 | 53 | 187 | 230 | 274 | PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] | diamond | 246 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32892075 | 32892075 | PRJNA577226_S_NODE_28300_length_235_cov_1.969697_g27361_i0 | PRJNA577226 | 28300 | 235 | 1.969697 | 4.62878795 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 61.2 | 7.95e-9 | NR | KAF1741521.1 | 59785 | g27361 | i0 | 46.6 | 1.12340425531915 | 88 | 32 | 99.6 | 3 | 1 | 234 | 210 | 292 | KAF1741521.1 hypothetical protein MXB_54 [Myxobolus squamalis] | diamond | 264 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis |
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);;