contig_metadata
6 rows where bioproject = "PRJNA1012699", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10361243 | 10361243 | PRJNA1012699_P_NODE_1749_length_292_cov_4.178082_g1717_i0 | PRJNA1012699 | 1749 | 292 | 4.178082 | 12.19999944 | Myxobolus arcticus | 81492 | Cnidaria | other_Eukaryota | 274 | 5.309999999999998e-69 | NTclustered | gi|380343413|gb|JN003830.1| | 81492 | g1717 | i0 | 84.247 | 62.9383561643836 | 292 | 34 | 99 | 10 | 2 | 291 | 1077 | 1358 | Myxobolus arcticus from Japan 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 18378 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus arcticus | |
| 10361294 | 10361294 | PRJNA1012699_P_NODE_929_length_376_cov_3.122112_g897_i0 | PRJNA1012699 | 929 | 376 | 3.122112 | 11.73914112 | Myxobolus cloutmani | 2766936 | Cnidaria | other_Eukaryota | 307 | 6.920000000000001e-79 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g897 | i0 | 88.76 | 68.5398936170213 | 258 | 20 | 69 | 6 | 118 | 375 | 1087 | 839 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 25771 | 307 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 14186623 | 14186623 | PRJNA1012699_P_NODE_1812_length_289_cov_4.226852_g1780_i0 | PRJNA1012699 | 1812 | 289 | 4.226852 | 12.21560228 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 134 | 9.29e-27 | NTclustered | gi|2663986575|emb|OY756916.1| | 69463 | g1780 | i0 | 95.238 | 24.6262975778547 | 84 | 4 | 29 | 0 | 204 | 287 | 6646 | 6563 | Henneguya salminicola isolate Hz1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 7117 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 14186663 | 14186663 | PRJNA1012699_P_NODE_532_length_473_cov_2.297500_g500_i0 | PRJNA1012699 | 532 | 473 | 2.2975 | 10.867175 | Bivalvulida gen. n. sp. a JO-2023 | 3073449 | Cnidaria | other_Eukaryota | 213 | 1.99e-50 | NTclustered | gi|2572825558|gb|OR509833.1| | 3073449 | g500 | i0 | 86.5 | 35.5665961945032 | 200 | 19 | 42 | 6 | 198 | 396 | 615 | 423 | Bivalvulida gen. n. sp. a JO-2023 isolate BM_02 large subunit ribosomal RNA gene, partial sequence | blastn | 16823 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Bivalvulida gen. n. sp. a JO-2023 | |||
| 16735010 | 16735010 | PRJNA1012699_P_NODE_934_length_375_cov_1.867550_g902_i0 | PRJNA1012699 | 934 | 375 | 1.86755 | 7.0033125 | Ortholinea sp. jeju-2020 | 2806109 | Cnidaria | other_Eukaryota | 215 | 4.3e-51 | NTclustered | gi|1972887737|gb|MW540892.2| | 2806109 | g902 | i0 | 98.361 | 31.3306666666667 | 122 | 2 | 33 | 0 | 2 | 123 | 3183 | 3062 | Ortholinea sp. jeju-2020 large subunit ribosomal RNA gene, partial sequence | blastn | 11749 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ortholineidae | Ortholinea | Ortholinea sp. jeju-2020 | |
| 28361234 | 28361234 | PRJNA1012699_P_NODE_1466_length_312_cov_1.623431_g1434_i0 | PRJNA1012699 | 1466 | 312 | 1.623431 | 5.06510472 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 106 | 5.94e-25 | NR | XP_065063803.1 | 499914 | g1434 | i0 | 48.1 | 5.90384615384615 | 104 | 52 | 98.1 | 1 | 310 | 5 | 253 | 356 | XP_065063803.1 large ribosomal subunit protein uL4-like [Rhopilema esculentum] | diamond | 1842 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum |
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);;