contig_metadata
7 rows where bioproject = "PRJNA635874", tax_clade = "Opisthokonta" and tax_phylum = "Porifera"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9535281 | 9535281 | PRJNA635874_P_NODE_14708_length_396_cov_2.808050_g14561_i0 | PRJNA635874 | 14708 | 396 | 2.80805 | 11.119878 | Corticium candelabrum | 121492 | Porifera | other_Eukaryota | 152 | 7.64e-45 | NR | XP_062513731.1 | 121492 | g14561 | i0 | 67 | 0.871212121212121 | 115 | 38 | 87.1 | 0 | 357 | 13 | 2 | 116 | XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] | diamond | 345 | 152 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Plakinidae | Corticium | Corticium candelabrum | |
| 26827946 | 26827946 | PRJNA635874_P_NODE_48861_length_250_cov_0.870056_g48714_i0 | PRJNA635874 | 48861 | 250 | 0.870056 | 2.17514 | Oscarella lobularis | 121494 | Porifera | other_Eukaryota | 44.3 | 0.0123 | NR | XP_065840073.1 | 121494 | g48714 | i0 | 48.1 | 0.624 | 52 | 23 | 60 | 3 | 250 | 101 | 2874 | 2923 | XP_065840073.1 uncharacterized protein [Oscarella lobularis] | diamond | 156 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 27902033 | 27902033 | PRJNA635874_P_NODE_63805_length_244_cov_0.900585_g63658_i0 | PRJNA635874 | 63805 | 244 | 0.900585 | 2.1974274 | Halichondria panicea | 6063 | Porifera | other_Eukaryota | 105 | 2.94e-25 | NR | XP_064392077.1 | 6063 | g63658 | i0 | 61.7 | 0.995901639344262 | 81 | 30 | 99.6 | 1 | 244 | 2 | 202 | 281 | XP_064392077.1 serine dehydratase-like [Halichondria panicea] | diamond | 243 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Suberitida | Halichondriidae | Halichondria | Halichondria panicea | |
| 30946727 | 30946727 | PRJNA635874_P_NODE_60334_length_246_cov_0.890173_g60187_i0 | PRJNA635874 | 60334 | 246 | 0.890173 | 2.18982558 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 6.85e-4 | NR | XP_065841788.1 | 121494 | g60187 | i0 | 58.6 | 1.10975609756098 | 29 | 12 | 35.4 | 0 | 182 | 96 | 25 | 53 | XP_065841788.1 radial spoke head 1 homolog isoform X2 [Oscarella lobularis] | diamond | 273 | 45.8 | 0.991266375545852 | Eukaryota | Opisthokonta | Metazoa | Porifera | Homoscleromorpha | Homosclerophorida | Oscarellidae | Oscarella | Oscarella lobularis | |
| 31629645 | 31629645 | PRJNA635874_P_NODE_29896_length_303_cov_1.160870_g29749_i0 | PRJNA635874 | 29896 | 303 | 1.16087 | 3.5174361 | Dysidea avara | 196820 | Porifera | other_Eukaryota | 154 | 7.24e-41 | NR | XP_065903858.1 | 196820 | g29749 | i0 | 70.1 | 2.95049504950495 | 97 | 29 | 96 | 0 | 303 | 13 | 360 | 456 | XP_065903858.1 uncharacterized protein [Dysidea avara] | diamond | 894 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Dictyoceratida | Dysideidae | Dysidea | Dysidea avara | |
| 32262614 | 32262614 | PRJNA635874_P_NODE_2278_length_826_cov_4.495352_g2158_i0 | PRJNA635874 | 2278 | 826 | 4.495352 | 37.13160752 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 145 | 2.1299999999999998e-39 | NR | CAI8030757.1 | 519541 | g2158 | i0 | 51.2 | 0.602905569007264 | 166 | 66 | 57.7 | 6 | 280 | 756 | 18 | 175 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 498 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti | |
| 32736288 | 32736288 | PRJNA635874_P_NODE_3040_length_745_cov_1.669643_g2906_i0 | PRJNA635874 | 3040 | 745 | 1.669643 | 12.43884035 | Geodia barretti | 519541 | Porifera | other_Eukaryota | 139 | 2.3899999999999997e-37 | NR | CAI8030757.1 | 519541 | g2906 | i0 | 48.8 | 1.30469798657718 | 166 | 70 | 64 | 6 | 142 | 618 | 18 | 175 | CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] | diamond | 972 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Porifera | Demospongiae | Tetractinellida | Geodiidae | Geodia | Geodia barretti |
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);;