contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA577226" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3112421 | 3112421 | PRJNA577226_S_NODE_27743_length_237_cov_12.630000_g26804_i0 | PRJNA577226 | 27743 | 237 | 12.63 | 29.9331 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 213 | 9.22e-51 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g26804 | i0 | 84.034 | 69.0084388185654 | 238 | 20 | 100 | 15 | 1 | 237 | 4189 | 3969 | Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 16355 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 4388585 | 4388585 | PRJNA577226_S_NODE_11224_length_389_cov_2.957386_g10287_i0 | PRJNA577226 | 11224 | 389 | 2.957386 | 11.50423154 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 691 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g10287 | i0 | 99.735 | 35.6298200514139 | 378 | 0 | 97 | 1 | 12 | 389 | 1 | 377 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 13860 | 691 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 13315937 | 13315937 | PRJNA577226_S_NODE_40831_length_194_cov_14.471338_g39892_i0 | PRJNA577226 | 40831 | 194 | 14.471338 | 28.07439572 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 359 | 8.809999999999999e-95 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g39892 | i0 | 100 | 100.10824742268 | 194 | 0 | 100 | 0 | 1 | 194 | 2340 | 2533 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 19421 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 14591305 | 14591305 | PRJNA577226_S_NODE_62172_length_159_cov_12.418033_g61233_i0 | PRJNA577226 | 62172 | 159 | 12.418033 | 19.74467247 | Anthohebella parasitica | 308667 | Cnidaria | other_Eukaryota | 132 | 1.64e-26 | NTclustered | gi|166407129|gb|EU272545.1| | 308667 | g61233 | i0 | 82.781 | 95.5974842767296 | 151 | 23 | 95 | 2 | 9 | 159 | 953 | 806 | Anthohebella parasitica voucher MHNG INVE29762 28S large subunit ribosomal RNA gene, partial sequence | blastn | 15200 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Hebellidae | Anthohebella | Anthohebella parasitica | |
| 18414041 | 18414041 | PRJNA577226_S_NODE_47135_length_181_cov_12.520833_g46196_i0 | PRJNA577226 | 47135 | 181 | 12.520833 | 22.66270773 | Thelohanellus sp. CM-2018 | 2498614 | Cnidaria | other_Eukaryota | 158 | 3.1699999999999993e-34 | NTclustered | gi|1540859865|gb|MK332023.1| | 2498614 | g46196 | i0 | 91.304 | 43.4198895027624 | 115 | 10 | 64 | 0 | 66 | 180 | 3493 | 3607 | Thelohanellus sp. CM-2018 large subunit ribosomal RNA gene, partial sequence | blastn | 7859 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus sp. CM-2018 | |
| 19689090 | 19689090 | PRJNA577226_S_NODE_69036_length_152_cov_15.086957_g68097_i0 | PRJNA577226 | 69036 | 152 | 15.086957 | 22.93217464 | Chloromyxum careni | 941395 | Cnidaria | other_Eukaryota | 204 | 3.2399999999999996e-48 | NTclustered | gi|315666422|gb|HM641795.1| | 941395 | g68097 | i0 | 90.789 | 99.9342105263158 | 152 | 14 | 100 | 0 | 1 | 152 | 1700 | 1549 | Chloromyxum careni large subunit ribosomal RNA gene, partial sequence | blastn | 15190 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Chloromyxidae | Chloromyxum | Chloromyxum careni | |
| 20963356 | 20963356 | PRJNA577226_S_NODE_14157_length_343_cov_6.758170_g13218_i0 | PRJNA577226 | 14157 | 343 | 6.75817 | 23.1805231 | Chloromyxum cristatum | 650990 | Cnidaria | other_Eukaryota | 113 | 1.47e-20 | NTclustered | gi|241911748|gb|FJ417054.1| | 650990 | g13218 | i0 | 100 | 16.6880466472303 | 61 | 0 | 18 | 0 | 1 | 61 | 2941 | 3001 | Chloromyxum cristatum isolate M0178 28S large subunit ribosomal RNA gene, partial sequence | blastn | 5724 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Chloromyxidae | Chloromyxum | Chloromyxum cristatum | |
| 20963575 | 20963575 | PRJNA577226_S_NODE_2217_length_1227_cov_10.854622_g1475_i0 | PRJNA577226 | 2217 | 1227 | 10.854622 | 133.18621194 | Myxobolus cloutmani | 2766936 | Cnidaria | other_Eukaryota | 398 | 1.3999999999999994e-105 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g1475 | i0 | 78.026 | 37.321108394458 | 760 | 80 | 61 | 46 | 101 | 845 | 400 | 1087 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 45793 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 22238145 | 22238145 | PRJNA577226_S_NODE_10418_length_406_cov_11.907859_g9481_i0 | PRJNA577226 | 10418 | 406 | 11.907859 | 48.34590754 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 749 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g9481 | i0 | 100 | 21.8768472906404 | 405 | 0 | 99 | 0 | 2 | 406 | 2349 | 1945 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 8882 | 749 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 22238207 | 22238207 | PRJNA577226_S_NODE_12358_length_369_cov_4.771084_g11419_i0 | PRJNA577226 | 12358 | 369 | 4.771084 | 17.60529996 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 682 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g11419 | i0 | 100 | 54.3875338753388 | 369 | 0 | 100 | 0 | 1 | 369 | 1292 | 1660 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20069 | 682 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 24089375 | 24089375 | PRJNA577226_S_NODE_4419_length_685_cov_7.939815_g3541_i0 | PRJNA577226 | 4419 | 685 | 7.939815 | 54.38773275 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 398 | 7.619999999999997e-106 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g3541 | i0 | 97.425 | 34.0394160583942 | 233 | 6 | 34 | 0 | 1 | 233 | 3330 | 3098 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 23317 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 24787478 | 24787478 | PRJNA577226_S_NODE_19080_length_291_cov_12.566929_g18141_i0 | PRJNA577226 | 19080 | 291 | 12.566929 | 36.56976339 | Myxobolus arcticus | 81492 | Cnidaria | other_Eukaryota | 281 | 3.16e-71 | NTclustered | gi|380343413|gb|JN003830.1| | 81492 | g18141 | i0 | 84.642 | 44.6907216494845 | 293 | 33 | 100 | 10 | 1 | 291 | 1378 | 1096 | 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 | 13005 | 281 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus arcticus | |
| 25363678 | 25363678 | PRJNA577226_S_NODE_3460_length_822_cov_12.028025_g2631_i0 | PRJNA577226 | 3460 | 822 | 12.028025 | 98.8703655 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 248 | 9.82e-61 | NTclustered | gi|241911747|gb|FJ417053.1| | 35592 | g2631 | i0 | 81.212 | 32.1520681265207 | 330 | 42 | 52 | 14 | 496 | 822 | 720 | 1032 | Henneguya zschokkei isolate M0630 28S large subunit ribosomal RNA gene, partial sequence | blastn | 26429 | 248 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya zschokkei |
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);;