contig_metadata
6 rows where bioproject = "PRJNA1088503", tax_clade = "Opisthokonta" and tax_phylum = "Brachiopoda"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19320226 | 19320226 | PRJNA1088503_P_NODE_1236_length_814_cov_451.830573_g1094_i0 | PRJNA1088503 | 1236 | 814 | 451.830573 | 3677.90086422 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 392 | 2.31e-135 | NR | XP_013380988.2 | 7574 | g1094 | i0 | 76.4 | 1.81326781326781 | 246 | 58 | 90.7 | 0 | 47 | 784 | 1 | 246 | XP_013380988.2 60S ribosomal protein L7 [Lingula anatina] | diamond | 1476 | 392 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 28994179 | 28994179 | PRJNA1088503_P_NODE_11748_length_151_cov_1.622951_g11376_i0 | PRJNA1088503 | 11748 | 151 | 1.622951 | 2.45065601 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 85.5 | 2.62e-19 | NR | XP_013390948.1 | 7574 | g11376 | i0 | 72.3 | 0.933774834437086 | 47 | 13 | 93.4 | 0 | 9 | 149 | 77 | 123 | XP_013390948.1 prostaglandin E synthase 3 [Lingula anatina] | diamond | 141 | 85.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 29522003 | 29522003 | PRJNA1088503_P_NODE_9630_length_201_cov_1.511628_g9258_i0 | PRJNA1088503 | 9630 | 201 | 1.511628 | 3.03837228 | Metazoa | 33208 | Brachiopoda | other_Eukaryota | 98.2 | 3.3899999999999996e-24 | NR | XP_013411007.1 | 7574 | g9258 | i0 | 68.9 | 4.65671641791045 | 61 | 19 | 91 | 0 | 3 | 185 | 92 | 152 | XP_013411007.1 histone deacetylase complex subunit SAP18 [Lingula anatina] | diamond | 936 | 98.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 30825765 | 30825765 | PRJNA1088503_P_NODE_5434_length_346_cov_2.668770_g5062_i0 | PRJNA1088503 | 5434 | 346 | 2.66877 | 9.2339442 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 124 | 2.49e-32 | NR | XP_013399917.1 | 7574 | g5062 | i0 | 55.3 | 0.988439306358382 | 114 | 47 | 98.8 | 1 | 342 | 1 | 4 | 113 | XP_013399917.1 60S ribosomal protein L6 [Lingula anatina] | diamond | 342 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31236465 | 31236465 | PRJNA1088503_P_NODE_10515_length_178_cov_1.624161_g10143_i0 | PRJNA1088503 | 10515 | 178 | 1.624161 | 2.89100658 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 59.7 | 6.21e-9 | NR | XP_013405017.1 | 7574 | g10143 | i0 | 76.5 | 1.23033707865169 | 34 | 8 | 57.3 | 0 | 2 | 103 | 162 | 195 | XP_013405017.1 proteasome subunit beta type-2 [Lingula anatina] | diamond | 219 | 59.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina | |
| 31331408 | 31331408 | PRJNA1088503_P_NODE_7556_length_261_cov_1.547414_g7184_i0 | PRJNA1088503 | 7556 | 261 | 1.547414 | 4.03875054 | Lingula anatina | 7574 | Brachiopoda | other_Eukaryota | 145 | 1.9199999999999998e-42 | NR | XP_013383640.1 | 7574 | g7184 | i0 | 77.9 | 2.96551724137931 | 86 | 19 | 98.9 | 0 | 3 | 260 | 61 | 146 | XP_013383640.1 adrenodoxin-like [Lingula anatina] | diamond | 774 | 145 | 1 | Eukaryota | Opisthokonta | Metazoa | Brachiopoda | Lingulata | Lingulida | Lingulidae | Lingula | Lingula anatina |
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);;