contig_metadata
7 rows where bioproject = "PRJNA229468", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 13121080 | 13121080 | PRJNA229468_S_NODE_451_length_234_cov_1.308108_g438_i0 | PRJNA229468 | 451 | 234 | 1.308108 | 3.06097272 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 165 | 2.58e-36 | NTclustered | gi|2729103509|ref|XM_065214830.1| | 499914 | g438 | i0 | 81.159 | 3.25641025641026 | 207 | 37 | 88 | 2 | 10 | 215 | 143 | 348 | PREDICTED: Rhopilema esculentum large ribosomal subunit protein uL15-like (LOC135695664), mRNA | blastn | 762 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 15084139 | 15084139 | PRJNA229468_S_NODE_232_length_322_cov_1.446886_g219_i0 | PRJNA229468 | 232 | 322 | 1.446886 | 4.65897292 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 185 | 1.52e-56 | NR | XP_065063129.1 | 499914 | g219 | i0 | 74.8 | 7.97515527950311 | 107 | 27 | 99.7 | 0 | 2 | 322 | 120 | 226 | XP_065063129.1 large ribosomal subunit protein uL30-like [Rhopilema esculentum] | diamond | 2568 | 185 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 28765398 | 28765398 | PRJNA229468_S_NODE_687_length_197_cov_1.763514_g674_i0 | PRJNA229468 | 687 | 197 | 1.763514 | 3.47412258 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 86.3 | 5.76e-20 | NR | XP_031552790.1 | 6105 | g674 | i0 | 66.7 | 2.60406091370558 | 57 | 19 | 86.8 | 0 | 175 | 5 | 3 | 59 | XP_031552790.1 60S ribosomal protein L35a-like [Actinia tenebrosa] | diamond | 513 | 86.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 29473673 | 29473673 | PRJNA229468_S_NODE_670_length_200_cov_1.013245_g657_i0 | PRJNA229468 | 670 | 200 | 1.013245 | 2.02649 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 47 | 6.7e-4 | NR | XP_047141988.1 | 6087 | g657 | i0 | 34.4 | 1.875 | 64 | 40 | 96 | 1 | 196 | 5 | 324 | 385 | XP_047141988.1 uncharacterized protein sll0103 isoform X1 [Hydra vulgaris] | diamond | 375 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 29694643 | 29694643 | PRJNA229468_S_NODE_610_length_207_cov_0.968354_g597_i0 | PRJNA229468 | 610 | 207 | 0.968354 | 2.00449278 | Actinostola sp. cb2 | 3060491 | Cnidaria | other_Eukaryota | 56.2 | 4.05e-7 | NR | KAK3743620.1 | 3060491 | g597 | i0 | 46.3 | 0.971014492753623 | 67 | 35 | 97.1 | 1 | 205 | 5 | 709 | 774 | KAK3743620.1 hypothetical protein QZH41_017696, partial [Actinostola sp. cb2023] | diamond | 201 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actinostolidae | Actinostola | Actinostola sp. cb2023 | |
| 31008053 | 31008053 | PRJNA229468_S_NODE_414_length_244_cov_1.420513_g401_i0 | PRJNA229468 | 414 | 244 | 1.420513 | 3.46605172 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 123 | 1.05e-33 | NR | XP_031572794.1 | 6105 | g401 | i0 | 78.2 | 18.3073770491803 | 78 | 17 | 95.9 | 0 | 9 | 242 | 22 | 99 | XP_031572794.1 40S ribosomal protein S16-like [Actinia tenebrosa] | diamond | 4467 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 31861645 | 31861645 | PRJNA229468_S_NODE_717_length_194_cov_1.758621_g704_i0 | PRJNA229468 | 717 | 194 | 1.758621 | 3.41172474 | root | 1 | Root_unresolved | Root_unresolved | 74.7 | 4.12e-15 | NR | KII62976.1 | 669202 | g704 | i0 | 54.1 | 2.65979381443299 | 61 | 28 | 94.3 | 0 | 183 | 1 | 12 | 72 | KII62976.1 60S ribosomal protein L23 [Thelohanellus kitauei] | diamond | 516 | 74.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei |
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);;