contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA1113956" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1023981 | 1023981 | PRJNA1113956_P_NODE_9721_length_449_cov_9.382979_g9382_i0 | PRJNA1113956 | 9721 | 449 | 9.382979 | 42.12957571 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 180 | 1.91e-40 | NTclustered | gi|2663986577|emb|OY756918.1| | 59785 | g9382 | i0 | 90.977 | 27.4721603563474 | 133 | 12 | 30 | 0 | 60 | 192 | 6424 | 6556 | 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 | |
| 2772637 | 2772637 | PRJNA1113956_P_NODE_2583_length_1156_cov_16.030471_g2383_i0 | PRJNA1113956 | 2583 | 1156 | 16.030471 | 185.31224476 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 2119 | 0 | NTclustered | gi|681870005|gb|KM001688.1| | 1542451 | g2383 | i0 | 99.74 | 37.9489619377163 | 1156 | 3 | 100 | 0 | 1 | 1156 | 640 | 1795 | Myxidium streisingeri clone ZF10 18S small subunit ribosomal RNA gene, partial sequence | blastn | 43869 | 2119 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 5324954 | 5324954 | PRJNA1113956_P_NODE_5665_length_701_cov_18.015924_g5355_i0 | PRJNA1113956 | 5665 | 701 | 18.015924 | 126.29162724 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 809 | 0 | NTclustered | gi|681870004|gb|KM001687.1| | 1542451 | g5355 | i0 | 99.774 | 28.774607703281 | 442 | 0 | 63 | 1 | 260 | 701 | 1 | 441 | Myxidium streisingeri clone ZF12 18S small subunit ribosomal RNA gene, partial sequence | blastn | 20171 | 809 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 7401731 | 7401731 | PRJNA1113956_P_NODE_3386_length_986_cov_7.170865_g3137_i0 | PRJNA1113956 | 3386 | 986 | 7.170865 | 70.7047289 | Myxobolus | 35588 | Cnidaria | other_Eukaryota | 375 | 5.22e-99 | NTclustered | gi|2806899062|dbj|LC764547.1| | 402991 | g3137 | i0 | 97.285 | 24.7545638945233 | 221 | 6 | 27 | 0 | 1 | 221 | 3318 | 3098 | Myxobolus nagaraensis mx18004 gene for 28S rRNA, partial sequence, clone: mx18004lsu3 | blastn | 24408 | 375 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Myxobolus | Myxobolus nagaraensis | |
| 7874883 | 7874883 | PRJNA1113956_P_NODE_4527_length_818_cov_1.269799_g4239_i0 | PRJNA1113956 | 4527 | 818 | 1.269799 | 10.38695582 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 71.3 | 2.27e-7 | NTclustered | gi|2782863769|ref|XM_067059506.1| | 252671 | g4239 | i0 | 90.566 | 0.273838630806846 | 53 | 5 | 6 | 0 | 19 | 71 | 807 | 755 | PREDICTED: Clytia hemisphaerica ack-related non-receptor tyrosine kinase-like (LOC136802747), transcript variant X2, mRNA | blastn | 224 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 9149601 | 9149601 | PRJNA1113956_P_NODE_12268_length_372_cov_1.792642_g11928_i0 | PRJNA1113956 | 12268 | 372 | 1.792642 | 6.66862824 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 477 | 4.929999999999999e-130 | NTclustered | gi|2744802769|ref|XR_010647098.1| | 6087 | g11928 | i0 | 89.812 | 11.8682795698925 | 373 | 37 | 100 | 1 | 1 | 372 | 413 | 41 | PREDICTED: Hydra vulgaris uncharacterized LOC136094432 (LOC136094432), ncRNA | blastn | 4415 | 477 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 13777070 | 13777070 | PRJNA1113956_P_NODE_14051_length_334_cov_1.038314_g13711_i0 | PRJNA1113956 | 14051 | 334 | 1.038314 | 3.46796876 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.031 | NTclustered | gi|2729068924|ref|XM_065196482.1| | 499914 | g13711 | i0 | 100 | 0.167664670658683 | 28 | 0 | 8 | 0 | 33 | 60 | 4725 | 4752 | PREDICTED: Rhopilema esculentum bone morphogenetic protein 1-like (LOC135681857), mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 16326335 | 16326335 | PRJNA1113956_P_NODE_16733_length_289_cov_5.662037_g16393_i0 | PRJNA1113956 | 16733 | 289 | 5.662037 | 16.36328693 | Myxobolidae | 35587 | Cnidaria | other_Eukaryota | 198 | 3.25e-46 | NTclustered | gi|241911747|gb|FJ417053.1| | 35592 | g16393 | i0 | 80.069 | 59.9411764705882 | 291 | 39 | 100 | 13 | 1 | 289 | 1026 | 753 | Henneguya zschokkei isolate M0630 28S large subunit ribosomal RNA gene, partial sequence | blastn | 17323 | 200 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Henneguya | Henneguya zschokkei | |
| 16799152 | 16799152 | PRJNA1113956_P_NODE_5874_length_681_cov_35.156250_g5557_i0 | PRJNA1113956 | 5874 | 681 | 35.15625 | 239.4140625 | Myxidium streisingeri | 1542451 | Cnidaria | other_Eukaryota | 1258 | 0 | NTclustered | gi|681870001|gb|KM001684.1| | 1542451 | g5557 | i0 | 100 | 60.6725403817915 | 681 | 0 | 100 | 0 | 1 | 681 | 1864 | 2544 | Myxidium streisingeri clone ZF2 18S small subunit ribosomal RNA gene, partial sequence | blastn | 41318 | 1258 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxidiidae | Myxidium | Myxidium streisingeri | |
| 21898909 | 21898909 | PRJNA1113956_P_NODE_3698_length_934_cov_2.838560_g3435_i0 | PRJNA1113956 | 3698 | 934 | 2.83856 | 26.5121504 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 1072 | 0 | NTclustered | gi|2744802769|ref|XR_010647098.1| | 6087 | g3435 | i0 | 88.613 | 10.1820128479657 | 887 | 93 | 94 | 4 | 53 | 934 | 4 | 887 | PREDICTED: Hydra vulgaris uncharacterized LOC136094432 (LOC136094432), ncRNA | blastn | 9510 | 1072 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris |
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);;