contig_metadata
7 rows where bioproject = "PRJNA796639" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2056473 | 2056473 | PRJNA796639_P_NODE_7762_length_241_cov_0.916667_g7637_i0 | PRJNA796639 | 7762 | 241 | 0.916667 | 2.20916747 | Unicauda fimbrethilae | 1720082 | Cnidaria | other_Eukaryota | 63.9 | 1e-5 | NTclustered | gi|2089706636|gb|OK030695.1| | 1720082 | g7637 | i0 | 97.297 | 8.32365145228216 | 37 | 1 | 15 | 0 | 205 | 241 | 1938 | 1974 | Unicauda fimbrethilae large subunit ribosomal RNA gene, partial sequence | blastn | 2006 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Unicauda | Unicauda fimbrethilae | |
| 19907279 | 19907279 | PRJNA796639_P_NODE_1556_length_452_cov_0.810026_g1431_i0 | PRJNA796639 | 1556 | 452 | 0.810026 | 3.66131752 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 231 | 4.94e-75 | NR | KAF1742241.1 | 59785 | g1431 | i0 | 84.4 | 1.91814159292035 | 147 | 22 | 96.9 | 1 | 6 | 443 | 12 | 158 | KAF1742241.1 hypothetical protein MXB_1441 [Myxobolus squamalis] | diamond | 867 | 231 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 23733331 | 23733331 | PRJNA796639_P_NODE_6479_length_247_cov_0.885057_g6354_i0 | PRJNA796639 | 6479 | 247 | 0.885057 | 2.18609079 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 151 | 3.39e-41 | NR | KAF1745217.1 | 59785 | g6354 | i0 | 91.5 | 0.995951417004049 | 82 | 7 | 99.6 | 0 | 2 | 247 | 56 | 137 | KAF1745217.1 hypothetical protein MXB_1005 [Myxobolus squamalis] | diamond | 246 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 30211643 | 30211643 | PRJNA796639_P_NODE_7832_length_241_cov_0.916667_g7707_i0 | PRJNA796639 | 7832 | 241 | 0.916667 | 2.20916747 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 72.4 | 6.27e-14 | NR | KII61489.1 | 669202 | g7707 | i0 | 41.6 | 0.95850622406639 | 77 | 45 | 95.9 | 0 | 3 | 233 | 44 | 120 | KII61489.1 hypothetical protein RF11_12905 [Thelohanellus kitauei] | diamond | 231 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 30275286 | 30275286 | PRJNA796639_P_NODE_2252_length_372_cov_1.314381_g2127_i0 | PRJNA796639 | 2252 | 372 | 1.314381 | 4.88949732 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 156 | 9.61e-43 | NR | KAF1743098.1 | 59785 | g2127 | i0 | 56.1 | 0.991935483870968 | 123 | 54 | 99.2 | 0 | 370 | 2 | 239 | 361 | KAF1743098.1 hypothetical protein MXB_1290 [Myxobolus squamalis] | diamond | 369 | 156 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 32140299 | 32140299 | PRJNA796639_P_NODE_5218_length_258_cov_1.621622_g5093_i0 | PRJNA796639 | 5218 | 258 | 1.621622 | 4.18378476 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 44.7 | 0.00994 | NR | KAF0992774.1 | 69463 | g5093 | i0 | 63.4 | 0.476744186046512 | 41 | 15 | 47.7 | 0 | 258 | 136 | 1248 | 1288 | KAF0992774.1 hypothetical protein HZS_2692, partial [Henneguya salminicola] | diamond | 123 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 32866446 | 32866446 | PRJNA796639_P_NODE_6700_length_246_cov_0.890173_g6575_i0 | PRJNA796639 | 6700 | 246 | 0.890173 | 2.18982558 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 57.8 | 1.87e-7 | NR | KAF0989348.1 | 69463 | g6575 | i0 | 45.2 | 0.75609756097561 | 62 | 32 | 73.2 | 1 | 246 | 67 | 240 | 301 | KAF0989348.1 hypothetical protein HZS_1345 [Henneguya salminicola] | diamond | 186 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola |
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);;