contig_metadata
10 rows where bioproject = "PRJNA1156092", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 302781 | 302781 | PRJNA1156092_P_NODE_22141_length_251_cov_0.865169_g22011_i0 | PRJNA1156092 | 22141 | 251 | 0.865169 | 2.17157419 | Xenia sp. Carnegie-2017 | 2897299 | Cnidaria | other_Eukaryota | 193 | 1.28e-44 | NTclustered | gi|2202645792|ref|XM_046996420.1| | 2897299 | g22011 | i0 | 82.432 | 7.36653386454183 | 222 | 37 | 88 | 2 | 31 | 251 | 369 | 149 | PREDICTED: Xenia sp. Carnegie-2017 RING-box protein 1-like (LOC124445670), mRNA | blastn | 1849 | 193 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 9230821 | 9230821 | PRJNA1156092_P_NODE_23528_length_250_cov_0.870056_g23398_i0 | PRJNA1156092 | 23528 | 250 | 0.870056 | 2.17514 | Nematostella vectensis | 45351 | Cnidaria | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|2257864996|ref|XM_001628341.3| | 45351 | g23398 | i0 | 100 | 0.112 | 28 | 0 | 11 | 0 | 161 | 188 | 394 | 421 | PREDICTED: Nematostella vectensis progestin and adipoQ receptor family member 3 (LOC5507734), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 13056650 | 13056650 | PRJNA1156092_P_NODE_5531_length_444_cov_1.326146_g5401_i0 | PRJNA1156092 | 5531 | 444 | 1.326146 | 5.88808824 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 244 | 6.600000000000002e-60 | NTclustered | gi|2518998737|ref|XM_057450856.1| | 13093 | g5401 | i0 | 84.127 | 135.540540540541 | 252 | 40 | 57 | 0 | 193 | 444 | 532 | 281 | PREDICTED: Hydractinia symbiolongicarpus polyubiquitin-C-like (LOC130645015), mRNA | blastn | 60180 | 244 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 18154654 | 18154654 | PRJNA1156092_P_NODE_28355_length_245_cov_0.895349_g28225_i0 | PRJNA1156092 | 28355 | 245 | 0.895349 | 2.19360505 | Hydra vulgaris | 6087 | Cnidaria | other_Eukaryota | 220 | 5.73e-53 | NTclustered | gi|2744801597|ref|XM_012699221.3| | 6087 | g28225 | i0 | 82.927 | 8.84489795918367 | 246 | 40 | 100 | 2 | 1 | 245 | 1827 | 2071 | PREDICTED: Hydra vulgaris transitional endoplasmic reticulum ATPase (LOC100205318), mRNA | blastn | 2167 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydridae | Hydra | Hydra vulgaris | |
| 18154763 | 18154763 | PRJNA1156092_P_NODE_4595_length_480_cov_1.132678_g4466_i0 | PRJNA1156092 | 4595 | 480 | 1.132678 | 5.4368544 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 201 | 2.88e-63 | NR | ABC67745.1 | 6110 | g4466 | i0 | 62.2 | 34.31875 | 148 | 56 | 92.5 | 0 | 449 | 6 | 1 | 148 | ABC67745.1 ribosomal protein L12 [Anthopleura elegantissima] | diamond | 16473 | 202 | 0.995049504950495 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Anthopleura | Anthopleura elegantissima | |
| 22714150 | 22714150 | PRJNA1156092_P_NODE_22818_length_250_cov_1.305085_g22688_i0 | PRJNA1156092 | 22818 | 250 | 1.305085 | 3.2627125 | Acropora | 6127 | Cnidaria | other_Eukaryota | 189 | 1.6499999999999999e-43 | NTclustered | gi|2114098761|ref|XM_029328531.2| | 45264 | g22688 | i0 | 83.582 | 19.176 | 201 | 33 | 80 | 0 | 7 | 207 | 278 | 78 | PREDICTED: Acropora millepora tubulin beta-4B chain-like (LOC114952563), mRNA | blastn | 4794 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora millepora | |
| 27028061 | 27028061 | PRJNA1156092_P_NODE_26142_length_247_cov_0.885057_g26012_i0 | PRJNA1156092 | 26142 | 247 | 0.885057 | 2.18609079 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 52 | 1.06e-5 | NR | XP_027036769.1 | 46731 | g26012 | i0 | 38.8 | 5.91497975708502 | 80 | 44 | 96 | 2 | 246 | 10 | 15 | 90 | XP_027036769.1 MICAL-like protein 1 [Pocillopora damicornis] | diamond | 1461 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 31576794 | 31576794 | PRJNA1156092_P_NODE_24556_length_249_cov_0.875000_g24426_i0 | PRJNA1156092 | 24556 | 249 | 0.875 | 2.17875 | Actiniaria | 6103 | Cnidaria | other_Eukaryota | 172 | 8.149999999999998e-48 | NR | XP_048583854.1 | 45351 | g24426 | i0 | 92.7 | 15.8072289156626 | 82 | 6 | 98.8 | 0 | 248 | 3 | 900 | 981 | XP_048583854.1 uncharacterized protein LOC116606010 [Nematostella vectensis] | diamond | 3936 | 173 | 0.994219653179191 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 31766395 | 31766395 | PRJNA1156092_P_NODE_21817_length_251_cov_1.213483_g21687_i0 | PRJNA1156092 | 21817 | 251 | 1.213483 | 3.04584233 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 43.5 | 0.0221 | NR | XP_057290307.1 | 13093 | g21687 | i0 | 38 | 2.23505976095618 | 50 | 31 | 59.8 | 0 | 188 | 39 | 27 | 76 | XP_057290307.1 uncharacterized protein LOC130612998 [Hydractinia symbiolongicarpus] | diamond | 561 | 43.9 | 0.990888382687927 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32348430 | 32348430 | PRJNA1156092_P_NODE_28339_length_245_cov_0.895349_g28209_i0 | PRJNA1156092 | 28339 | 245 | 0.895349 | 2.19360505 | Porites lobata | 104759 | Cnidaria | other_Eukaryota | 48.5 | 3.62e-4 | NR | CAH3035664.1 | 104759 | g28209 | i0 | 36.2 | 0.710204081632653 | 58 | 29 | 71 | 1 | 241 | 68 | 2775 | 2824 | CAH3035664.1 unnamed protein product, partial [Porites lobata] | diamond | 174 | 48.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata |
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);;