contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA782551" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2488066 | 2488066 | PRJNA782551_P_NODE_6962_length_353_cov_2.732143_g6840_i0 | PRJNA782551 | 6962 | 353 | 2.732143 | 9.64446479 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 180 | 1.47e-40 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g6840 | i0 | 90.977 | 34.943342776204 | 133 | 12 | 38 | 0 | 212 | 344 | 6556 | 6424 | Myxobolus squamalis isolate 71B08 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA complete sequences | blastn | 12335 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus squamalis | |
| 3315044 | 3315044 | PRJNA782551_P_NODE_3783_length_487_cov_2.415459_g3661_i0 | PRJNA782551 | 3783 | 487 | 2.415459 | 11.76328533 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 817 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g3661 | i0 | 99.776 | 41.435318275154 | 446 | 0 | 92 | 1 | 42 | 487 | 1 | 445 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20179 | 817 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 4591854 | 4591854 | PRJNA782551_P_NODE_1004_length_945_cov_3.040138_g903_i0 | PRJNA782551 | 1004 | 945 | 3.040138 | 28.7293041 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1735 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g903 | i0 | 99.788 | 31.4603174603175 | 945 | 2 | 100 | 0 | 1 | 945 | 649 | 1593 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 29730 | 1735 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 4592059 | 4592059 | PRJNA782551_P_NODE_2804_length_575_cov_4.312749_g2683_i0 | PRJNA782551 | 2804 | 575 | 4.312749 | 24.79830675 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1062 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g2683 | i0 | 100 | 45.9530434782609 | 575 | 0 | 100 | 0 | 1 | 575 | 1865 | 2439 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 26423 | 1062 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 5040886 | 5040886 | PRJNA782551_P_NODE_4784_length_427_cov_3.177966_g4662_i0 | PRJNA782551 | 4784 | 427 | 3.177966 | 13.56991482 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 318 | 3.68e-82 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g4662 | i0 | 96.842 | 43.9133489461358 | 190 | 6 | 44 | 0 | 238 | 427 | 3098 | 3287 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 18751 | 318 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 5867275 | 5867275 | PRJNA782551_P_NODE_6585_length_363_cov_3.041379_g6463_i0 | PRJNA782551 | 6585 | 363 | 3.041379 | 11.04020577 | Myxobolus arcticus | 81492 | Cnidaria | other_Eukaryota | 359 | 1.81e-94 | NTclustered | gi|380343413|gb|JN003830.1| | 81492 | g6463 | i0 | 84.932 | 84.9917355371901 | 365 | 43 | 100 | 10 | 1 | 363 | 1067 | 1421 | 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 | 30852 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus arcticus | |
| 19890399 | 19890399 | PRJNA782551_P_NODE_11636_length_281_cov_4.091346_g11514_i0 | PRJNA782551 | 11636 | 281 | 4.091346 | 11.49668226 | Chloromyxum cristatum | 650990 | Cnidaria | other_Eukaryota | 139 | 1.9299999999999999e-28 | NTclustered | gi|241911748|gb|FJ417054.1| | 650990 | g11514 | i0 | 100 | 25.9074733096085 | 75 | 0 | 27 | 0 | 1 | 75 | 2927 | 3001 | Chloromyxum cristatum isolate M0178 28S large subunit ribosomal RNA gene, partial sequence | blastn | 7280 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Chloromyxidae | Chloromyxum | Chloromyxum cristatum | |
| 21166412 | 21166412 | PRJNA782551_P_NODE_7797_length_335_cov_1.175573_g7675_i0 | PRJNA782551 | 7797 | 335 | 1.175573 | 3.93816955 | Sphaerospora angulata | 1232752 | Cnidaria | other_Eukaryota | 215 | 3.81e-51 | NTclustered | gi|444437440|gb|JX286637.1| | 1232752 | g7675 | i0 | 79.863 | 2.1044776119403 | 293 | 59 | 87 | 0 | 8 | 300 | 293 | 1 | Sphaerospora angulata isolate 4K2/01032011 elongation factor 2 (EF2) gene, partial cds | blastn | 705 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Sphaerosporidae | Sphaerospora | Sphaerospora angulata | |
| 24990046 | 24990046 | PRJNA782551_P_NODE_12540_length_274_cov_2.870647_g12418_i0 | PRJNA782551 | 12540 | 274 | 2.870647 | 7.86557278 | Myxobolus sp. 'branchicola' | 1446104 | Cnidaria | other_Eukaryota | 228 | 3.899999999999999e-55 | NTclustered | gi|573041015|gb|JN616264.1| | 1446104 | g12418 | i0 | 89.071 | 61.1788321167883 | 183 | 20 | 67 | 0 | 1 | 183 | 3766 | 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 | 16763 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus sp. 'branchicola' | |
| 25439341 | 25439341 | PRJNA782551_P_NODE_3040_length_549_cov_4.703782_g2919_i0 | PRJNA782551 | 3040 | 549 | 4.703782 | 25.82376318 | Bivalvulida | 35583 | Cnidaria | other_Eukaryota | 104 | 1.47e-17 | NTclustered | gi|1430506822|gb|MH630267.1| | 35589 | g2919 | i0 | 88.636 | 13.0692167577413 | 88 | 7 | 16 | 3 | 463 | 549 | 389 | 304 | Myxobolus sp. voucher CTM101 large subunit ribosomal RNA gene, partial sequence | blastn | 7175 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus sp. |
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);;