contig_metadata
13 rows where analysis = "diamond", bioproject = "PRJNA641991" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4445445 | 4445445 | PRJNA641991_S_NODE_12644_length_166_cov_0.871795_g12525_i0 | PRJNA641991 | 12644 | 166 | 0.871795 | 1.4471797 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 103 | 9.11e-27 | NR | KAF1741798.1 | 59785 | g12525 | i0 | 100 | 7.95180722891566 | 55 | 0 | 99.4 | 0 | 165 | 1 | 9 | 63 | KAF1741798.1 hypothetical protein MXB_1522, partial [Myxobolus squamalis] | diamond | 1320 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 19744616 | 19744616 | PRJNA641991_S_NODE_13056_length_165_cov_0.879310_g12937_i0 | PRJNA641991 | 13056 | 165 | 0.87931 | 1.4508615 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 110 | 4.24e-29 | NR | KAF1744769.1 | 59785 | g12937 | i0 | 90.9 | 2 | 55 | 5 | 100 | 0 | 165 | 1 | 36 | 90 | KAF1744769.1 hypothetical protein MXB_1814 [Myxobolus squamalis] | diamond | 330 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 26828236 | 26828236 | PRJNA641991_S_NODE_12981_length_165_cov_0.879310_g12862_i0 | PRJNA641991 | 12981 | 165 | 0.87931 | 1.4508615 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 104 | 1.88e-24 | NR | KAF0991154.1 | 69463 | g12862 | i0 | 85.2 | 1.96363636363636 | 54 | 8 | 98.2 | 0 | 2 | 163 | 493 | 546 | KAF0991154.1 hypothetical protein HZS_788 [Henneguya salminicola] | diamond | 324 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 27554990 | 27554990 | PRJNA641991_S_NODE_12604_length_166_cov_0.871795_g12485_i0 | PRJNA641991 | 12604 | 166 | 0.871795 | 1.4471797 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 77.8 | 5.56e-15 | NR | KII61094.1 | 669202 | g12485 | i0 | 66.7 | 0.975903614457831 | 54 | 18 | 97.6 | 0 | 3 | 164 | 533 | 586 | KII61094.1 Arginine--tRNA ligase, cytoplasmic [Thelohanellus kitauei] | diamond | 162 | 77.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 27997363 | 27997363 | PRJNA641991_S_NODE_13725_length_163_cov_0.894737_g13606_i0 | PRJNA641991 | 13725 | 163 | 0.894737 | 1.45842131 | Paramuricea clavata | 317549 | Cnidaria | other_Eukaryota | 41.6 | 0.0332 | NR | CAB3981937.1 | 317549 | g13606 | i0 | 43.6 | 1.01226993865031 | 55 | 21 | 82.8 | 1 | 4 | 138 | 246 | 300 | CAB3981937.1 UDP-glucose:glyco glucosyltransferase 1 isoform X1 [Paramuricea clavata] | diamond | 165 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Plexauridae | Paramuricea | Paramuricea clavata | |
| 28344499 | 28344499 | PRJNA641991_S_NODE_12466_length_166_cov_0.871795_g12347_i0 | PRJNA641991 | 12466 | 166 | 0.871795 | 1.4471797 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 66.6 | 4.97e-11 | NR | KAF0989879.1 | 69463 | g12347 | i0 | 54.5 | 0.993975903614458 | 55 | 25 | 99.4 | 0 | 165 | 1 | 249 | 303 | KAF0989879.1 hypothetical protein HZS_2728 [Henneguya salminicola] | diamond | 165 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 28597261 | 28597261 | PRJNA641991_S_NODE_12087_length_167_cov_0.864407_g11968_i0 | PRJNA641991 | 12087 | 167 | 0.864407 | 1.44355969 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 57 | 1.21e-7 | NR | KAF1742154.1 | 59785 | g11968 | i0 | 49.1 | 0.988023952095808 | 55 | 28 | 98.8 | 0 | 165 | 1 | 136 | 190 | KAF1742154.1 hypothetical protein MXB_104 [Myxobolus squamalis] | diamond | 165 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 29177889 | 29177889 | PRJNA641991_S_NODE_13729_length_163_cov_0.894737_g13610_i0 | PRJNA641991 | 13729 | 163 | 0.894737 | 1.45842131 | Montipora | 46703 | Cnidaria | other_Eukaryota | 48.9 | 8.43e-5 | NR | XP_068737565.1 | 246305 | g13610 | i0 | 46.8 | 2.55828220858896 | 47 | 23 | 82.8 | 2 | 17 | 151 | 20 | 66 | XP_068737565.1 lipase ZK262.3-like [Montipora capricornis] | diamond | 417 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 29954905 | 29954905 | PRJNA641991_S_NODE_12531_length_166_cov_0.871795_g12412_i0 | PRJNA641991 | 12531 | 166 | 0.871795 | 1.4471797 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 51.6 | 7.42e-6 | NR | XP_046862721.1 | 2897299 | g12412 | i0 | 57.1 | 1.71686746987952 | 49 | 21 | 88.6 | 0 | 165 | 19 | 58 | 106 | XP_046862721.1 LIM and SH3 domain protein 1-like [Xenia sp. Carnegie-2017] | diamond | 285 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 30366003 | 30366003 | PRJNA641991_S_NODE_13292_length_164_cov_0.886957_g13173_i0 | PRJNA641991 | 13292 | 164 | 0.886957 | 1.45460948 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 75.9 | 1.58e-14 | NR | KAF0992293.1 | 69463 | g13173 | i0 | 62.3 | 0.969512195121951 | 53 | 20 | 97 | 0 | 160 | 2 | 266 | 318 | KAF0992293.1 hypothetical protein HZS_2041 [Henneguya salminicola] | diamond | 159 | 75.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 30630507 | 30630507 | PRJNA641991_P_NODE_1413_length_265_cov_1.282407_g1372_i0 | PRJNA641991 | 1413 | 265 | 1.282407 | 3.39837855 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 149 | 2.3099999999999998e-39 | NR | CAH3170974.1 | 104759 | g1372 | i0 | 78.2 | 7.87924528301887 | 87 | 19 | 98.5 | 0 | 263 | 3 | 186 | 272 | CAH3170974.1 unnamed protein product [Porites lobata] | diamond | 2088 | 150 | 0.993333333333333 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 31958435 | 31958435 | PRJNA641991_P_NODE_4197_length_161_cov_0.910714_g4156_i0 | PRJNA641991 | 4197 | 161 | 0.910714 | 1.46624954 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 50.4 | 2.31e-5 | NR | XP_066931305.1 | 252671 | g4156 | i0 | 47.2 | 1.97515527950311 | 53 | 27 | 98.8 | 1 | 2 | 160 | 332 | 383 | XP_066931305.1 protein disulfide-isomerase A3-like [Clytia hemisphaerica] | diamond | 318 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 32357816 | 32357816 | PRJNA641991_S_NODE_8659_length_191_cov_1.077465_g8540_i0 | PRJNA641991 | 8659 | 191 | 1.077465 | 2.05795815 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 106 | 2.71e-27 | NR | KII70082.1 | 669202 | g8540 | i0 | 71.4 | 0.989528795811518 | 63 | 18 | 99 | 0 | 3 | 191 | 77 | 139 | KII70082.1 60S ribosomal protein L18a [Thelohanellus kitauei] | diamond | 189 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei |
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);;