contig_metadata
14 rows where analysis = "blastn", bioproject = "PRJNA770361" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 746416 | 746416 | PRJNA770361_P_NODE_3801_length_483_cov_2.158537_g3706_i0 | PRJNA770361 | 3801 | 483 | 2.158537 | 10.42573371 | Bivalvulida gen. n. sp. a JO-2023 | 3073449 | Cnidaria | other_Eukaryota | 82.4 | 6e-11 | NTclustered | gi|2572825558|gb|OR509833.1| | 3073449 | g3706 | i0 | 88.406 | 1.87784679089027 | 69 | 6 | 14 | 2 | 415 | 483 | 615 | 549 | Bivalvulida gen. n. sp. a JO-2023 isolate BM_02 large subunit ribosomal RNA gene, partial sequence | blastn | 907 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Bivalvulida gen. n. sp. a JO-2023 | |||
| 7125037 | 7125037 | PRJNA770361_P_NODE_14246_length_252_cov_0.871508_g14151_i0 | PRJNA770361 | 14246 | 252 | 0.871508 | 2.19620016 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 366 | 7.19e-97 | NTclustered | gi|2744884988|ref|XM_065808629.1| | 6087 | g14151 | i0 | 92.857 | 9.14285714285714 | 252 | 18 | 100 | 0 | 1 | 252 | 677 | 426 | PREDICTED: Hydra vulgaris uncharacterized LOC136086334 (LOC136086334), mRNA | blastn | 2304 | 366 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 10134981 | 10134981 | PRJNA770361_P_NODE_3408_length_510_cov_2.457666_g3313_i0 | PRJNA770361 | 3408 | 510 | 2.457666 | 12.5340966 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 106 | 3.78e-18 | NTclustered | gi|1430506822|gb|MH630267.1| | 35589 | g3313 | i0 | 88.764 | 4.76862745098039 | 89 | 7 | 17 | 3 | 423 | 510 | 389 | 303 | Myxobolus sp. voucher CTM101 large subunit ribosomal RNA gene, partial sequence | blastn | 2432 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus sp. | |
| 10134992 | 10134992 | PRJNA770361_P_NODE_7388_length_345_cov_3.242647_g7293_i0 | PRJNA770361 | 7388 | 345 | 3.242647 | 11.18713215 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 115 | 4.1100000000000006e-21 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g7293 | i0 | 88.119 | 19.4985507246377 | 101 | 7 | 29 | 5 | 1 | 99 | 2208 | 2111 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 6727 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 10950547 | 10950547 | PRJNA770361_P_NODE_6769_length_360_cov_1.630662_g6674_i0 | PRJNA770361 | 6769 | 360 | 1.630662 | 5.8703832 | Ortholinea sp. jeju-2020 | 2806109 | Cnidaria | other_Eukaryota | 202 | 3.2e-47 | NTclustered | gi|1972887737|gb|MW540892.2| | 2806109 | g6674 | i0 | 98.261 | 30.8138888888889 | 115 | 2 | 32 | 0 | 2 | 116 | 3176 | 3062 | Ortholinea sp. jeju-2020 large subunit ribosomal RNA gene, partial sequence | blastn | 11093 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ortholineidae | Ortholinea | Ortholinea sp. jeju-2020 | |
| 12226100 | 12226100 | PRJNA770361_P_NODE_1970_length_675_cov_7.290698_g1878_i0 | PRJNA770361 | 1970 | 675 | 7.290698 | 49.2122115 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1247 | 0 | NTclustered | gi|681870001|gb|KM001684.1| | 1542451 | g1878 | i0 | 100 | 60.362962962963 | 675 | 0 | 100 | 0 | 1 | 675 | 1872 | 2546 | Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence | blastn | 40745 | 1247 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 12226130 | 12226130 | PRJNA770361_P_NODE_3850_length_480_cov_1.852580_g3755_i0 | PRJNA770361 | 3850 | 480 | 1.85258 | 8.892384 | Myxobolus nagaraensis | 402991 | Cnidaria | other_Eukaryota | 207 | 9.43e-49 | NTclustered | gi|2806899035|dbj|LC764520.1| | 402991 | g3755 | i0 | 90.062 | 31.5729166666667 | 161 | 15 | 34 | 1 | 22 | 182 | 634 | 475 | Myxobolus nagaraensis mx18003 genes for ITS1, 5.8S rRNA, ITS2, partial and complete sequence, clone: mx18003its2 | blastn | 15155 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 18598157 | 18598157 | PRJNA770361_P_NODE_2095_length_656_cov_3.962264_g2002_i0 | PRJNA770361 | 2095 | 656 | 3.962264 | 25.99245184 | Myxobolus arcticus | 81492 | Cnidaria | other_Eukaryota | 363 | 2.66e-95 | NTclustered | gi|380343413|gb|JN003830.1| | 81492 | g2002 | i0 | 85.014 | 48.1829268292683 | 367 | 43 | 56 | 10 | 292 | 656 | 1060 | 1416 | 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 | 31608 | 363 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus arcticus | |
| 18598197 | 18598197 | PRJNA770361_P_NODE_5695_length_394_cov_1.697819_g5600_i0 | PRJNA770361 | 5695 | 394 | 1.697819 | 6.68940686 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g5600 | i0 | 100 | 4.15736040609137 | 30 | 0 | 8 | 0 | 236 | 265 | 787304 | 787275 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 1638 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 19873017 | 19873017 | PRJNA770361_P_NODE_11396_length_279_cov_1.514563_g11301_i0 | PRJNA770361 | 11396 | 279 | 1.514563 | 4.22563077 | Myxobolus sp. 'branchicola' | 1446104 | Cnidaria | other_Eukaryota | 198 | 3.12e-46 | NTclustered | gi|573041015|gb|JN616264.1| | 1446104 | g11301 | i0 | 88.024 | 58.3978494623656 | 167 | 20 | 60 | 0 | 1 | 167 | 3750 | 3584 | Myxobolus sp. 'branchicola' voucher CQ-20090225 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 | 16293 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus sp. 'branchicola' | |
| 19873129 | 19873129 | PRJNA770361_P_NODE_1696_length_720_cov_2.737249_g1605_i0 | PRJNA770361 | 1696 | 720 | 2.737249 | 19.7081928 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 795 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g1605 | i0 | 99.77 | 26.9361111111111 | 434 | 0 | 60 | 1 | 287 | 720 | 1 | 433 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19394 | 795 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 19873247 | 19873247 | PRJNA770361_P_NODE_596_length_1164_cov_3.595784_g547_i0 | PRJNA770361 | 596 | 1164 | 3.595784 | 41.85492576 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 2137 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g547 | i0 | 99.828 | 39.9518900343643 | 1163 | 2 | 99 | 0 | 2 | 1164 | 1793 | 631 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 46504 | 2137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 21148884 | 21148884 | PRJNA770361_P_NODE_13777_length_253_cov_0.866667_g13682_i0 | PRJNA770361 | 13777 | 253 | 0.866667 | 2.19266751 | Staurotheca dichotoma | 1848360 | Cnidaria | other_Eukaryota | 174 | 4.7e-39 | NTclustered | gi|1027506860|gb|KT824458.1| | 1848360 | g13682 | i0 | 82.99 | 20.596837944664 | 194 | 31 | 76 | 2 | 1 | 193 | 194 | 2 | Staurotheca dichotoma calmodulin (CaM) gene, partial cds | blastn | 5211 | 174 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Sertulariidae | Staurotheca | Staurotheca dichotoma | |
| 21608547 | 21608547 | PRJNA770361_P_NODE_3477_length_505_cov_2.312500_g3382_i0 | PRJNA770361 | 3477 | 505 | 2.3125 | 11.678125 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 207 | 9.96e-49 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g3382 | i0 | 94.776 | 25.7485148514851 | 134 | 6 | 27 | 1 | 2 | 135 | 4972 | 5104 | Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 13003 | 209 | 0.990430622009569 | 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);;