contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1240804" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1623218 | 1623218 | PRJNA1240804_P_NODE_58262_length_207_cov_1.607595_g57896_i0 | PRJNA1240804 | 58262 | 207 | 1.607595 | 3.32772165 | Ceratomyxa leatherjacketi | 1579382 | Cnidaria | other_Eukaryota | 73.1 | 1.39e-8 | NTclustered | gi|730837044|gb|KM392428.1| | 1579382 | g57896 | i0 | 85.714 | 0.536231884057971 | 70 | 9 | 34 | 1 | 138 | 207 | 380 | 448 | Ceratomyxa leatherjacketi isolate LJ-GB-B 28S ribosomal RNA gene, partial sequence | blastn | 111 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Ceratomyxidae | Ceratomyxa | Ceratomyxa leatherjacketi | |
| 4175209 | 4175209 | PRJNA1240804_P_NODE_3424_length_622_cov_2.677138_g3086_i0 | PRJNA1240804 | 3424 | 622 | 2.677138 | 16.65179836 | Montipora capricornis | 246305 | Cnidaria | other_Eukaryota | 58.4 | 0.001 | NTclustered | gi|2812114944|ref|XM_068870257.1| | 246305 | g3086 | i0 | 97.059 | 0.0546623794212219 | 34 | 1 | 5 | 0 | 558 | 591 | 178 | 145 | PREDICTED: Montipora capricornis nucleolar transcription factor 1-A-like (LOC138023236), mRNA | blastn | 34 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Montipora | Montipora capricornis | |
| 11253332 | 11253332 | PRJNA1240804_P_NODE_145409_length_163_cov_0.912281_g145043_i0 | PRJNA1240804 | 145409 | 163 | 0.912281 | 1.48701803 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 82.4 | 1.73e-11 | NTclustered | gi|636577294|gb|KJ483128.1| | 856778 | g145043 | i0 | 87.5 | 2.19018404907975 | 72 | 8 | 44 | 1 | 10 | 80 | 1901 | 1830 | Antholoba achates isolate acha 28S large subunit ribosomal RNA gene, partial sequence | blastn | 357 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Antholoba | Antholoba achates | |
| 15651201 | 15651201 | PRJNA1240804_P_NODE_40313_length_237_cov_1.281915_g39947_i0 | PRJNA1240804 | 40313 | 237 | 1.281915 | 3.03813855 | Parvicapsula sp. SPS-2018 | 2806882 | Cnidaria | other_Eukaryota | 121 | 5.75e-23 | NTclustered | gi|1444845538|gb|MH729074.1| | 2806882 | g39947 | i0 | 85.593 | 5.24472573839662 | 118 | 14 | 50 | 3 | 20 | 137 | 1978 | 1864 | Parvicapsula sp. SPS-2018 isolate JejuCJGd-2018 large subunit ribosomal RNA gene, partial sequence | blastn | 1243 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Parvicapsulidae | Parvicapsula | Parvicapsula sp. SPS-2018 | |
| 18200261 | 18200261 | PRJNA1240804_P_NODE_56955_length_209_cov_1.218750_g56589_i0 | PRJNA1240804 | 56955 | 209 | 1.21875 | 2.5471875 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 76.8 | 1.09e-9 | NTclustered | gi|2518956999|ref|XR_008980547.1| | 13093 | g56589 | i0 | 95.833 | 18.7416267942584 | 48 | 0 | 22 | 2 | 15 | 61 | 2119 | 2165 | PREDICTED: Hydractinia symbiolongicarpus large subunit ribosomal RNA (LOC130619804), rRNA | blastn | 3917 | 76.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 18901834 | 18901834 | PRJNA1240804_P_NODE_69395_length_194_cov_1.551724_g69029_i0 | PRJNA1240804 | 69395 | 194 | 1.551724 | 3.01034456 | Buddenbrockia | 185686 | Cnidaria | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|570962622|gb|KF731730.1| | 1442316 | g69029 | i0 | 82.353 | 18.2113402061856 | 68 | 9 | 35 | 2 | 38 | 104 | 319 | 254 | Buddenbrockia sp. 2 PBS-2014 isolate Bsp2CaC 28S ribosomal RNA gene, partial sequence | blastn | 3533 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Malacovalvulida | Saccosporidae | Buddenbrockia | Buddenbrockia sp. 2 PBS-2014 | |
| 20750628 | 20750628 | PRJNA1240804_P_NODE_84917_length_183_cov_1.447761_g84551_i0 | PRJNA1240804 | 84917 | 183 | 1.447761 | 2.64940263 | Clytia hemisphaerica | 252671 | Cnidaria | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2782839894|ref|XM_067055043.1| | 252671 | g84551 | i0 | 100 | 0.306010928961749 | 28 | 0 | 15 | 0 | 64 | 91 | 7988 | 7961 | PREDICTED: Clytia hemisphaerica uncharacterized protein (LOC136798434), transcript variant X2, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Leptothecata | Clytiidae | Clytia | Clytia hemisphaerica | |
| 25276435 | 25276435 | PRJNA1240804_P_NODE_60500_length_204_cov_1.606452_g60134_i0 | PRJNA1240804 | 60500 | 204 | 1.606452 | 3.27716208 | Cubozoa | 6137 | Cnidaria | other_Eukaryota | 121 | 4.809999999999999e-23 | NTclustered | gi|270297346|gb|GQ849057.1| | 645347 | g60134 | i0 | 82.609 | 21.9656862745098 | 138 | 22 | 67 | 2 | 69 | 204 | 1936 | 2073 | Chiropsalmus quadrumanus isolate BB011 28S large subunit ribosomal RNA gene, partial sequence | blastn | 4481 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Cubozoa | Chirodropida | Chiropsalmidae | Chiropsalmus | Chiropsalmus quadrumanus |
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);;