contig_metadata
6 rows where bioproject = "PRJNA1068830" and tax_phylum = "Bryozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9110351 | 9110351 | PRJNA1068830_P_NODE_43988_length_333_cov_1.715385_g43285_i0 | PRJNA1068830 | 43988 | 333 | 1.715385 | 5.71223205 | Plumatella sp. ZHY-2005 | 365321 | Bryozoa | other_Eukaryota | 329 | 1.29e-85 | NTclustered | gi|90992874|gb|DQ333339.1| | 365321 | g43285 | i0 | 85.67 | 37.7477477477477 | 321 | 37 | 96 | 9 | 11 | 330 | 1 | 313 | Plumatella sp. ZHY-2005 28S ribosomal RNA gene, partial sequence | blastn | 12570 | 329 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Phylactolaemata | Plumatellidae | Plumatella | Plumatella sp. ZHY-2005 | ||
| 9110723 | 9110723 | PRJNA1068830_P_NODE_58148_length_285_cov_2.061321_g57445_i0 | PRJNA1068830 | 58148 | 285 | 2.061321 | 5.87476485 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 90.9 | 6.38e-19 | NR | XP_067949379.1 | 2589382 | g57445 | i0 | 43.5 | 4.76842105263158 | 92 | 45 | 96.8 | 1 | 277 | 2 | 311 | 395 | XP_067949379.1 serine/threonine-protein kinase PAK 1-like [Watersipora subatra] | diamond | 1359 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 27880174 | 27880174 | PRJNA1068830_P_NODE_83605_length_245_cov_0.906977_g82902_i0 | PRJNA1068830 | 83605 | 245 | 0.906977 | 2.22209365 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 42.7 | 0.0388 | NR | KAF6025003.1 | 10212 | g82902 | i0 | 48.6 | 0.930612244897959 | 37 | 19 | 45.3 | 0 | 117 | 227 | 893 | 929 | KAF6025003.1 SNX14 [Bugula neritina] | diamond | 228 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 28141446 | 28141446 | PRJNA1068830_P_NODE_69465_length_259_cov_1.032258_g68762_i0 | PRJNA1068830 | 69465 | 259 | 1.032258 | 2.67354822 | Watersipora subatra | 2589382 | Bryozoa | other_Eukaryota | 58.2 | 1.59e-7 | NR | XP_067940328.1 | 2589382 | g68762 | i0 | 40.3 | 1.43629343629344 | 62 | 37 | 71.8 | 0 | 257 | 72 | 128 | 189 | XP_067940328.1 uncharacterized protein [Watersipora subatra] | diamond | 372 | 58.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra | |
| 29877895 | 29877895 | PRJNA1068830_P_NODE_35551_length_377_cov_1.536184_g34848_i0 | PRJNA1068830 | 35551 | 377 | 1.536184 | 5.79141368 | Bugula neritina | 10212 | Bryozoa | other_Eukaryota | 178 | 1.27e-51 | NR | KAF6026996.1 | 10212 | g34848 | i0 | 62.9 | 0.986737400530504 | 124 | 42 | 98.7 | 1 | 6 | 377 | 108 | 227 | KAF6026996.1 NAGA [Bugula neritina] | diamond | 372 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina | |
| 31512792 | 31512792 | PRJNA1068830_P_NODE_51456_length_305_cov_1.284483_g50753_i0 | PRJNA1068830 | 51456 | 305 | 1.284483 | 3.91767315 | Metazoa | 33208 | Bryozoa | other_Eukaryota | 124 | 1.3e-30 | NR | XP_067928311.1 | 2589382 | g50753 | i0 | 58.8 | 3.02950819672131 | 102 | 40 | 98.4 | 1 | 301 | 2 | 448 | 549 | XP_067928311.1 plastin-1-like [Watersipora subatra] | diamond | 924 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Watersiporidae | Watersipora | Watersipora subatra |
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);;