contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA951388" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 934760 | 934760 | PRJNA951388_S_NODE_121_length_1355_cov_11.818253_g78_i0 | PRJNA951388 | 121 | 1355 | 11.818253 | 160.13732815 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 86.1 | 1.37e-11 | NTclustered | gi|2692952344|ref|NC_086769.1| | 669202 | g78 | i0 | 75.789 | 0.140221402214022 | 190 | 35 | 14 | 8 | 562 | 744 | 732 | 547 | Thelohanellus kitauei isolate A1 complete mitochondrial genome | blastn | 190 | 86.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 3485432 | 3485432 | PRJNA951388_S_NODE_783_length_709_cov_21.583333_g670_i0 | PRJNA951388 | 783 | 709 | 21.583333 | 153.02583097 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1299 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g670 | i0 | 99.718 | 52.1706629055007 | 709 | 2 | 100 | 0 | 1 | 709 | 1831 | 2539 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 36989 | 1299 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 3485437 | 3485437 | PRJNA951388_S_NODE_9523_length_269_cov_5.250000_g9396_i0 | PRJNA951388 | 9523 | 269 | 5.25 | 14.1225 | Henneguya salminicola | 69463 | Cnidaria | other_Eukaryota | 62.1 | 4.09e-5 | NTclustered | gi|2663986575|emb|OY756916.1| | 69463 | g9396 | i0 | 97.222 | 11.2639405204461 | 36 | 1 | 13 | 0 | 1 | 36 | 6611 | 6646 | Henneguya salminicola isolate Hz1 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 3030 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya salminicola | |
| 7312758 | 7312758 | PRJNA951388_S_NODE_5526_length_359_cov_14.258741_g5399_i0 | PRJNA951388 | 5526 | 359 | 14.258741 | 51.18888019 | Myxobolus arcticus | 81492 | Cnidaria | other_Eukaryota | 333 | 1.0800000000000001e-86 | NTclustered | gi|380343413|gb|JN003830.1| | 81492 | g5399 | i0 | 85.119 | 77.4735376044568 | 336 | 38 | 93 | 10 | 26 | 359 | 1060 | 1385 | 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 | 27813 | 333 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus arcticus | |
| 8587741 | 8587741 | PRJNA951388_S_NODE_9427_length_271_cov_4.555556_g9300_i0 | PRJNA951388 | 9427 | 271 | 4.555556 | 12.34555676 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 501 | 2.05e-137 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g9300 | i0 | 100 | 48.2693726937269 | 271 | 0 | 100 | 0 | 1 | 271 | 432 | 162 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 13081 | 501 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 9862753 | 9862753 | PRJNA951388_S_NODE_288_length_996_cov_43.152763_g205_i0 | PRJNA951388 | 288 | 996 | 43.152763 | 429.80151948 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1823 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g205 | i0 | 99.699 | 34.1164658634538 | 996 | 3 | 100 | 0 | 1 | 996 | 640 | 1635 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 33980 | 1823 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 10191488 | 10191488 | PRJNA951388_S_NODE_868_length_686_cov_28.473083_g754_i0 | PRJNA951388 | 868 | 686 | 28.473083 | 195.32534938 | Henneguya | 35590 | Cnidaria | other_Eukaryota | 134 | 2.38e-26 | NTclustered | gi|241911747|gb|FJ417053.1| | 35592 | g754 | i0 | 90.291 | 11.7959183673469 | 103 | 9 | 15 | 1 | 584 | 686 | 435 | 334 | Henneguya zschokkei isolate M0630 28S large subunit ribosomal RNA gene, partial sequence | blastn | 8092 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya zschokkei | |
| 14016618 | 14016618 | PRJNA951388_S_NODE_2211_length_496_cov_29.186761_g2085_i0 | PRJNA951388 | 2211 | 496 | 29.186761 | 144.76633456 | Henneguya | 35590 | Cnidaria | other_Eukaryota | 178 | 7.66e-40 | NTclustered | gi|241911746|gb|FJ417052.1| | 650981 | g2085 | i0 | 94.068 | 27.1532258064516 | 118 | 5 | 36 | 2 | 1 | 117 | 2128 | 2244 | Henneguya sp. M0375 28S large subunit ribosomal RNA gene, partial sequence | blastn | 13468 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya sp. M0375 | |
| 16565287 | 16565287 | PRJNA951388_S_NODE_3673_length_419_cov_17.323699_g3546_i0 | PRJNA951388 | 3673 | 419 | 17.323699 | 72.58629881 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 191 | 8.190000000000001e-44 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g3546 | i0 | 99.057 | 24.7613365155131 | 106 | 1 | 25 | 0 | 311 | 416 | 1997 | 2102 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 10375 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 17512888 | 17512888 | PRJNA951388_S_NODE_494_length_824_cov_26.660453_g392_i0 | PRJNA951388 | 494 | 824 | 26.660453 | 219.68213272 | Myxobolus cloutmani | 2766936 | Cnidaria | other_Eukaryota | 348 | 9.439999999999999e-91 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g392 | i0 | 77.174 | 25.6067961165049 | 736 | 81 | 88 | 47 | 3 | 723 | 1063 | 400 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 21100 | 348 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 18786489 | 18786489 | PRJNA951388_S_NODE_3775_length_415_cov_9.342105_g3648_i0 | PRJNA951388 | 3775 | 415 | 9.342105 | 38.76973575 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g3648 | i0 | 100 | 3.94698795180723 | 30 | 0 | 7 | 0 | 307 | 336 | 787304 | 787275 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 1638 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata |
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);;