contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA1011833" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2705543 | 2705543 | PRJNA1011833_S_NODE_1483_length_709_cov_10.786787_g1182_i0 | PRJNA1011833 | 1483 | 709 | 10.786787 | 76.47831983 | Myxobolus arcticus | 81492 | Cnidaria | other_Eukaryota | 331 | 8.13e-86 | NTclustered | gi|380343413|gb|JN003830.1| | 81492 | g1182 | i0 | 85.241 | 39.4287729196051 | 332 | 37 | 47 | 10 | 380 | 709 | 1060 | 1381 | 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 | 27955 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus arcticus | |
| 2705684 | 2705684 | PRJNA1011833_S_NODE_38543_length_187_cov_8.965278_g38123_i0 | PRJNA1011833 | 38543 | 187 | 8.965278 | 16.76506986 | Thelohanellus sp. CM-2018 | 2498614 | Cnidaria | other_Eukaryota | 159 | 9.169999999999999e-35 | NTclustered | gi|1540859865|gb|MK332023.1| | 2498614 | g38123 | i0 | 91.379 | 42.8235294117647 | 116 | 10 | 62 | 0 | 72 | 187 | 3493 | 3608 | Thelohanellus sp. CM-2018 large subunit ribosomal RNA gene, partial sequence | blastn | 8008 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus sp. CM-2018 | |
| 2705837 | 2705837 | PRJNA1011833_S_NODE_6963_length_420_cov_13.265252_g6547_i0 | PRJNA1011833 | 6963 | 420 | 13.265252 | 55.7140584 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 776 | 0 | NTclustered | gi|681870001|gb|KM001684.1| | 1542451 | g6547 | i0 | 100 | 24.5404761904762 | 420 | 0 | 100 | 0 | 1 | 420 | 1941 | 2360 | Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence | blastn | 10307 | 776 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 7807858 | 7807858 | PRJNA1011833_S_NODE_14727_length_314_cov_3.977860_g14307_i0 | PRJNA1011833 | 14727 | 314 | 3.97786 | 12.4904804 | Anemonia sulcata | 6108 | Cnidaria | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2917940696|emb|OZ237557.1| | 6108 | g14307 | i0 | 100 | 5.21656050955414 | 30 | 0 | 10 | 0 | 249 | 278 | 787304 | 787275 | Anemonia sulcata genome assembly, chromosome: 3 | blastn | 1638 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anemonia | Anemonia sulcata | |
| 7807934 | 7807934 | PRJNA1011833_S_NODE_28327_length_222_cov_2.240223_g27907_i0 | PRJNA1011833 | 28327 | 222 | 2.240223 | 4.97329506 | Myxobolus squamalis | 59785 | Cnidaria | other_Eukaryota | 185 | 1.86e-42 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g27907 | i0 | 82.96 | 61.6621621621622 | 223 | 20 | 100 | 15 | 1 | 222 | 3975 | 4180 | Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 13689 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 7808005 | 7808005 | PRJNA1011833_S_NODE_407_length_1367_cov_18.698640_g302_i0 | PRJNA1011833 | 407 | 1367 | 18.69864 | 255.6104088 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 91.6 | 2.97e-13 | NTclustered | gi|2692952344|ref|NC_086769.1| | 669202 | g302 | i0 | 76.316 | 0.16020482809071 | 190 | 34 | 13 | 8 | 700 | 882 | 547 | 732 | Thelohanellus kitauei isolate A1 complete mitochondrial genome | blastn | 219 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 11204891 | 11204891 | PRJNA1011833_S_NODE_6129_length_438_cov_11.635443_g5716_i0 | PRJNA1011833 | 6129 | 438 | 11.635443 | 50.96324034 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 99 | 5.36e-16 | NTclustered | gi|259130322|gb|GQ424317.1| | 168780 | g5716 | i0 | 93.846 | 14.1780821917808 | 65 | 4 | 15 | 0 | 1 | 65 | 2075 | 2139 | Polyorchis haplus isolate 06CA001 28S ribosomal RNA gene, partial sequence | blastn | 6210 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Polyorchidae | Polyorchis | Polyorchis haplus | |
| 11634009 | 11634009 | PRJNA1011833_S_NODE_33750_length_201_cov_16.765823_g33330_i0 | PRJNA1011833 | 33750 | 201 | 16.765823 | 33.69930423 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 372 | 1.18e-98 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g33330 | i0 | 100 | 100.34328358209 | 201 | 0 | 100 | 0 | 1 | 201 | 2339 | 2539 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20169 | 372 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 12909012 | 12909012 | PRJNA1011833_S_NODE_24571_length_240_cov_2.862944_g24151_i0 | PRJNA1011833 | 24571 | 240 | 2.862944 | 6.8710656 | Myxobolus wulii | 649408 | Cnidaria | other_Eukaryota | 134 | 7.49e-27 | NTclustered | gi|2692952329|ref|NC_086768.1| | 649408 | g24151 | i0 | 88.889 | 0.45 | 108 | 12 | 45 | 0 | 2 | 109 | 12020 | 12127 | Myxobolus wulii isolate C1 complete mitochondrial genome | blastn | 108 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus wulii | |
| 12909148 | 12909148 | PRJNA1011833_S_NODE_4671_length_476_cov_35.307159_g4264_i0 | PRJNA1011833 | 4671 | 476 | 35.307159 | 168.06207684 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 52.8 | 0.046 | NTclustered | gi|2202666560|ref|XR_006951441.1| | 2897299 | g4264 | i0 | 100 | 0.0588235294117647 | 28 | 0 | 6 | 0 | 449 | 476 | 28 | 1 | PREDICTED: Xenia sp. Carnegie-2017 uncharacterized LOC124454405 (LOC124454405), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 14184094 | 14184094 | PRJNA1011833_S_NODE_43852_length_175_cov_2.128788_g43432_i0 | PRJNA1011833 | 43852 | 175 | 2.128788 | 3.725379 | Chloromyxum careni | 941395 | Cnidaria | other_Eukaryota | 235 | 1.36e-57 | NTclustered | gi|315666422|gb|HM641795.1| | 941395 | g43432 | i0 | 91.279 | 98.2685714285714 | 172 | 15 | 98 | 0 | 4 | 175 | 1707 | 1536 | Chloromyxum careni large subunit ribosomal RNA gene, partial sequence | blastn | 17197 | 235 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Chloromyxidae | Chloromyxum | Chloromyxum careni | |
| 14184183 | 14184183 | PRJNA1011833_S_NODE_7372_length_412_cov_7.905149_g6956_i0 | PRJNA1011833 | 7372 | 412 | 7.905149 | 32.56921388 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 761 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g6956 | i0 | 100 | 44.0194174757282 | 412 | 0 | 100 | 0 | 1 | 412 | 25 | 436 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 18136 | 761 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 16732329 | 16732329 | PRJNA1011833_S_NODE_33454_length_202_cov_5.333333_g33034_i0 | PRJNA1011833 | 33454 | 202 | 5.333333 | 10.77333266 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 230 | 7.569999999999998e-56 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g33034 | i0 | 99.213 | 61.519801980198 | 127 | 1 | 63 | 0 | 76 | 202 | 1964 | 1838 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 12427 | 230 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 17579447 | 17579447 | PRJNA1011833_S_NODE_1054_length_809_cov_18.809399_g809_i0 | PRJNA1011833 | 1054 | 809 | 18.809399 | 152.16803791 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 226 | 4.53e-54 | NTclustered | gi|241911747|gb|FJ417053.1| | 35592 | g809 | i0 | 80.769 | 30.7713226205192 | 312 | 40 | 51 | 14 | 498 | 806 | 720 | 1014 | Henneguya zschokkei isolate M0630 28S large subunit ribosomal RNA gene, partial sequence | blastn | 24894 | 226 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya zschokkei | |
| 18007204 | 18007204 | PRJNA1011833_S_NODE_40175_length_183_cov_6.250000_g39755_i0 | PRJNA1011833 | 40175 | 183 | 6.25 | 11.4375 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 270 | 3.949999999999999e-68 | NTclustered | gi|681870002|gb|KM001685.1| | 1542451 | g39755 | i0 | 98.077 | 85.6448087431694 | 156 | 1 | 85 | 2 | 1 | 156 | 1654 | 1807 | Myxidium streisingeri clone ZF5 18S small subunit ribosomal RNA gene, partial sequence | blastn | 15673 | 270 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 21832356 | 21832356 | PRJNA1011833_S_NODE_658_length_1023_cov_15.128571_g488_i0 | PRJNA1011833 | 658 | 1023 | 15.128571 | 154.76528133 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1879 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g488 | i0 | 99.804 | 33.238514173998 | 1023 | 2 | 100 | 0 | 1 | 1023 | 1664 | 642 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 34003 | 1879 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 23107600 | 23107600 | PRJNA1011833_S_NODE_1079_length_802_cov_13.537549_g827_i0 | PRJNA1011833 | 1079 | 802 | 13.537549 | 108.57114298 | Myxobolus cloutmani | 2766936 | Cnidaria | other_Eukaryota | 278 | 1.22e-69 | NTclustered | gi|1896054819|gb|MT919695.1| | 2766936 | g827 | i0 | 76.135 | 25.2817955112219 | 683 | 76 | 83 | 47 | 36 | 703 | 1010 | 400 | Myxobolus cloutmani isolate CTM large subunit ribosomal RNA gene, partial sequence | blastn | 20276 | 278 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus cloutmani | |
| 23107614 | 23107614 | PRJNA1011833_S_NODE_1379_length_730_cov_3.803493_g1089_i0 | PRJNA1011833 | 1379 | 730 | 3.803493 | 27.7654989 | Myxobolus wulii | 649408 | Cnidaria | other_Eukaryota | 137 | 1.96e-27 | NTclustered | gi|2692952329|ref|NC_086768.1| | 649408 | g1089 | i0 | 75.658 | 0.416438356164384 | 304 | 59 | 40 | 13 | 428 | 719 | 6171 | 6471 | Myxobolus wulii isolate C1 complete mitochondrial genome | blastn | 304 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus wulii | |
| 23953957 | 23953957 | PRJNA1011833_S_NODE_639_length_1037_cov_8.481891_g472_i0 | PRJNA1011833 | 639 | 1037 | 8.481891 | 87.95720967 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 394 | 1.52e-104 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g472 | i0 | 97.403 | 27.168756027001 | 231 | 6 | 28 | 0 | 807 | 1037 | 3098 | 3328 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 28174 | 394 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis |
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);;