contig_metadata
7 rows where bioproject = "PRJNA1073712", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26814334 | 26814334 | PRJNA1073712_P_NODE_5561_length_320_cov_1.578947_g5478_i0 | PRJNA1073712 | 5561 | 320 | 1.578947 | 5.0526304 | Acropora muricata | 159855 | Cnidaria | other_Eukaryota | 53.9 | 2.41e-6 | NR | XP_067016321.1 | 159855 | g5478 | i0 | 31.6 | 0.91875 | 98 | 62 | 90 | 3 | 294 | 7 | 4 | 98 | XP_067016321.1 actophorin-like [Acropora muricata] | diamond | 294 | 53.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Acroporidae | Acropora | Acropora muricata | |
| 31047167 | 31047167 | PRJNA1073712_P_NODE_15435_length_243_cov_1.764706_g15352_i0 | PRJNA1073712 | 15435 | 243 | 1.764706 | 4.28823558 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 127 | 6.15e-32 | NR | PFX23400.1 | 50429 | g15352 | i0 | 84 | 1 | 81 | 13 | 100 | 0 | 243 | 1 | 444 | 524 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 243 | 127 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 31331279 | 31331279 | PRJNA1073712_P_NODE_11176_length_251_cov_0.865169_g11093_i0 | PRJNA1073712 | 11176 | 251 | 0.865169 | 2.17157419 | Stylophora pistillata | 50429 | Cnidaria | other_Eukaryota | 93.6 | 5.23e-20 | NR | PFX23400.1 | 50429 | g11093 | i0 | 78.1 | 1.68525896414343 | 73 | 16 | 87.3 | 0 | 250 | 32 | 371 | 443 | PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] | diamond | 423 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Scleractinia | Pocilloporidae | Stylophora | Stylophora pistillata | |
| 32650885 | 32650885 | PRJNA1073712_P_NODE_8000_length_282_cov_1.473684_g7917_i0 | PRJNA1073712 | 8000 | 282 | 1.473684 | 4.15578888 | Anthozoa | 6101 | Cnidaria | other_Eukaryota | 121 | 2.16e-30 | NR | XP_031566895.1 | 6105 | g7917 | i0 | 60.9 | 6.88297872340426 | 92 | 35 | 97.9 | 1 | 2 | 277 | 144 | 234 | XP_031566895.1 dnaJ homolog subfamily A member 2-like [Actinia tenebrosa] | diamond | 1941 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Actiniaria | Actiniidae | Actinia | Actinia tenebrosa | |
| 32777012 | 32777012 | PRJNA1073712_P_NODE_16000_length_242_cov_1.715976_g15917_i0 | PRJNA1073712 | 16000 | 242 | 1.715976 | 4.15266192 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 102 | 1.92e-23 | NR | XP_057311217.1 | 13093 | g15917 | i0 | 62 | 1.95867768595041 | 79 | 25 | 97.9 | 1 | 241 | 5 | 287 | 360 | XP_057311217.1 60S ribosomal protein L3-like [Hydractinia symbiolongicarpus] | diamond | 474 | 103 | 0.990291262135922 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Hydrozoa | Anthoathecata | Hydractiniidae | Hydractinia | Hydractinia symbiolongicarpus | |
| 32785444 | 32785444 | PRJNA1073712_P_NODE_14160_length_246_cov_0.890173_g14077_i0 | PRJNA1073712 | 14160 | 246 | 0.890173 | 2.18982558 | Xenia sp. Carnegie-2 | 86540 | Cnidaria | other_Eukaryota | 72 | 1.86e-12 | NR | XP_046860393.1 | 2897299 | g14077 | i0 | 40.7 | 7.90243902439024 | 81 | 46 | 98.8 | 2 | 245 | 3 | 456 | 534 | XP_046860393.1 dnaJ homolog subfamily C member 10-like [Xenia sp. Carnegie-2017] | diamond | 1944 | 72.4 | 0.994475138121547 | Eukaryota | Opisthokonta | Metazoa | Cnidaria | Anthozoa | Malacalcyonacea | Xeniidae | Xenia | Xenia sp. Carnegie-2017 | |
| 32839927 | 32839927 | PRJNA1073712_P_NODE_16920_length_241_cov_0.916667_g16837_i0 | PRJNA1073712 | 16920 | 241 | 0.916667 | 2.20916747 | Cnidaria | 6073 | Cnidaria | other_Eukaryota | 92 | 4.36e-20 | NR | XP_047125519.1 | 6087 | g16837 | i0 | 56.3 | 14.0165975103734 | 80 | 34 | 98.3 | 1 | 3 | 239 | 53 | 132 | XP_047125519.1 eukaryotic translation initiation factor 3 subunit H [Hydra vulgaris] | diamond | 3378 | 92 | 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);;