contig_metadata
11 rows where bioproject = "PRJNA345071" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2345744 | 2345744 | PRJNA345071_P_NODE_542_length_672_cov_2.549249_g502_i0 | PRJNA345071 | 542 | 672 | 2.549249 | 17.13095328 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 311 | 3.21e-103 | NR | XP_001626294.2 | 45351 | g502 | i0 | 70.4 | 49.3482142857143 | 213 | 63 | 95.1 | 0 | 34 | 672 | 2 | 214 | XP_001626294.2 60S acidic ribosomal protein P0 [Nematostella vectensis] | diamond | 33162 | 311 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Edwardsiidae | Nematostella | Nematostella vectensis | |
| 5496924 | 5496924 | PRJNA345071_P_NODE_2425_length_372_cov_2.013378_g2385_i0 | PRJNA345071 | 2425 | 372 | 2.013378 | 7.48976616 | Scleractinia | 6125 | Cnidaria | other_Eukaryota | 153 | 6.18e-41 | NR | KAK2565409.1 | 6130 | g2385 | i0 | 58.5 | 7.93548387096774 | 123 | 51 | 99.2 | 0 | 371 | 3 | 52 | 174 | KAK2565409.1 Arginine kinase [Acropora cervicornis] | diamond | 2952 | 154 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora cervicornis | |
| 19519126 | 19519126 | PRJNA345071_P_NODE_3756_length_320_cov_1.263158_g3716_i0 | PRJNA345071 | 3756 | 320 | 1.263158 | 4.0421056 | Hydractinia symbiolongicarpus | 13093 | Cnidaria | other_Eukaryota | 141 | 3.8399999999999995e-37 | NR | XP_057315409.1 | 13093 | g3716 | i0 | 66.4 | 4.9875 | 107 | 31 | 97.5 | 2 | 315 | 4 | 71 | 175 | XP_057315409.1 UTP--glucose-1-phosphate uridylyltransferase-like isoform X1 [Hydractinia symbiolongicarpus] | diamond | 1596 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 26711847 | 26711847 | PRJNA345071_P_NODE_11221_length_229_cov_2.955128_g11181_i0 | PRJNA345071 | 11221 | 229 | 2.955128 | 6.76724312 | Opisthokonta | 33154 | Cnidaria | other_Eukaryota | 86.7 | 1.06e-17 | NR | CAH3172482.1 | 104759 | g11181 | i0 | 55.4 | 8.35807860262009 | 74 | 33 | 96.9 | 0 | 224 | 3 | 543 | 616 | CAH3172482.1 unnamed protein product [Porites lobata] | diamond | 1914 | 86.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Poritidae | Porites | Porites lobata | |
| 27692445 | 27692445 | PRJNA345071_P_NODE_11224_length_229_cov_2.698718_g11184_i0 | PRJNA345071 | 11224 | 229 | 2.698718 | 6.18006422 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 90.9 | 3.13e-19 | NR | XP_027043473.1 | 46731 | g11184 | i0 | 53.3 | 4.75545851528384 | 75 | 35 | 98.3 | 0 | 227 | 3 | 220 | 294 | XP_027043473.1 protein disulfide-isomerase 2-like [Pocillopora damicornis] | diamond | 1089 | 91.7 | 0.991275899672846 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Pocillopora | Pocillopora damicornis | |
| 28418614 | 28418614 | PRJNA345071_P_NODE_8206_length_251_cov_0.876404_g8166_i0 | PRJNA345071 | 8206 | 251 | 0.876404 | 2.19977404 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 141 | 1.81e-40 | NR | KAJ7382773.1 | 174260 | g8166 | i0 | 73.2 | 8.8207171314741 | 82 | 22 | 98 | 0 | 247 | 2 | 53 | 134 | KAJ7382773.1 Peroxiredoxin-5, mitochondrial [Desmophyllum pertusum] | diamond | 2214 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Caryophylliidae | Desmophyllum | Desmophyllum pertusum | |
| 29316839 | 29316839 | PRJNA345071_P_NODE_2049_length_397_cov_1.296296_g2009_i0 | PRJNA345071 | 2049 | 397 | 1.296296 | 5.14629512 | Thelohanellus kitauei | 669202 | Cnidaria | other_Eukaryota | 55.8 | 4.79e-6 | NR | KII70892.1 | 669202 | g2009 | i0 | 36.6 | 1.92695214105793 | 82 | 46 | 57.4 | 2 | 330 | 103 | 130 | 211 | KII70892.1 ELAV-like protein 2 [Thelohanellus kitauei] | diamond | 765 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Myxozoa | Bivalvulida | Myxobolidae | Thelohanellus | Thelohanellus kitauei | |
| 29600721 | 29600721 | PRJNA345071_P_NODE_3410_length_331_cov_1.209302_g3370_i0 | PRJNA345071 | 3410 | 331 | 1.209302 | 4.00278962 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 78.2 | 3.81e-14 | NR | XP_022786285.1 | 50429 | g3370 | i0 | 41.3 | 4.7583081570997 | 104 | 53 | 93.4 | 3 | 17 | 325 | 378 | 474 | XP_022786285.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit 2-like [Stylophora pistillata] | diamond | 1575 | 78.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 29712545 | 29712545 | PRJNA345071_P_NODE_7430_length_254_cov_3.348066_g7390_i0 | PRJNA345071 | 7430 | 254 | 3.348066 | 8.50408764 | root | 1 | Root_unresolved | Root_unresolved | 44.3 | 0.0122 | NR | PFX21664.1 | 50429 | g7390 | i0 | 42.2 | 0.968503937007874 | 45 | 26 | 53.1 | 0 | 180 | 46 | 230 | 274 | PFX21664.1 hypothetical protein AWC38_SpisGene13848 [Stylophora pistillata] | diamond | 246 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31781365 | 31781365 | PRJNA345071_P_NODE_1197_length_493_cov_1.445238_g1157_i0 | PRJNA345071 | 1197 | 493 | 1.445238 | 7.12502334 | Rhopilema esculentum | 499914 | Cnidaria | other_Eukaryota | 101 | 2.19e-21 | NR | XP_065054357.1 | 499914 | g1157 | i0 | 38 | 1.94117647058824 | 163 | 85 | 99.2 | 4 | 1 | 489 | 443 | 589 | XP_065054357.1 prosaposin-like [Rhopilema esculentum] | diamond | 957 | 101 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Scyphozoa | Rhizostomeae | Rhizostomatidae | Rhopilema | Rhopilema esculentum | |
| 32904395 | 32904395 | PRJNA345071_P_NODE_10360_length_243_cov_1.676471_g10320_i0 | PRJNA345071 | 10360 | 243 | 1.676471 | 4.0738245300000004 | Metazoa | 33208 | Cnidaria | other_Eukaryota | 142 | 2.99e-37 | NR | CAH3121840.1 | 104759 | g10320 | i0 | 79.5 | 6.76543209876543 | 78 | 16 | 96.3 | 0 | 242 | 9 | 135 | 212 | CAH3121840.1 unnamed protein product [Porites lobata] | diamond | 1644 | 142 | 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);;