contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA950981" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26715192 | 26715192 | PRJNA950981_P_NODE_7881_length_355_cov_1.645390_g7705_i0 | PRJNA950981 | 7881 | 355 | 1.64539 | 5.8411345 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 124 | 2.43e-33 | NR | XP_030852344.1 | 7668 | g7705 | i0 | 56.1 | 5.45070422535211 | 107 | 43 | 87.9 | 2 | 351 | 40 | 45 | 150 | XP_030852344.1 thioredoxin domain-containing protein 12-like [Strongylocentrotus purpuratus] | diamond | 1935 | 125 | 0.992 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27752329 | 27752329 | PRJNA950981_P_NODE_13744_length_278_cov_1.404878_g13568_i0 | PRJNA950981 | 13744 | 278 | 1.404878 | 3.90556084 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 119 | 5.79e-32 | NR | XP_033096589.1 | 1529436 | g13568 | i0 | 80.6 | 11.158273381295 | 72 | 13 | 76.6 | 1 | 63 | 275 | 35 | 106 | XP_033096589.1 methylmalonyl-CoA epimerase, mitochondrial-like [Anneissia japonica] | diamond | 3102 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27822063 | 27822063 | PRJNA950981_P_NODE_13864_length_277_cov_1.147059_g13688_i0 | PRJNA950981 | 13864 | 277 | 1.147059 | 3.17735343 | root | 1 | Root_unresolved | Root_unresolved | 108 | 5.62e-26 | NR | XP_033646815.1 | 7604 | g13688 | i0 | 50.5 | 4.9927797833935 | 93 | 44 | 98.6 | 2 | 274 | 2 | 121 | 213 | XP_033646815.1 2-oxoglutarate and iron-dependent oxygenase domain-containing protein 2-like [Asterias rubens] | diamond | 1383 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30158282 | 30158282 | PRJNA950981_P_NODE_17532_length_251_cov_0.876404_g17356_i0 | PRJNA950981 | 17532 | 251 | 0.876404 | 2.19977404 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 63.5 | 1.91e-9 | NR | XP_038053802.1 | 46514 | g17356 | i0 | 50.9 | 2.85657370517928 | 55 | 27 | 65.7 | 0 | 249 | 85 | 197 | 251 | XP_038053802.1 switch-associated protein 70-like [Patiria miniata] | diamond | 717 | 63.9 | 0.993740219092332 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 30436589 | 30436589 | PRJNA950981_P_NODE_6193_length_394_cov_0.971963_g6017_i0 | PRJNA950981 | 6193 | 394 | 0.971963 | 3.82953422 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 52 | 7.66e-5 | NR | XP_022085782.1 | 133434 | g6017 | i0 | 45.5 | 2.87817258883249 | 55 | 27 | 39.6 | 1 | 13 | 168 | 93 | 147 | XP_022085782.1 glutathione S-transferase theta-1-like isoform X1 [Acanthaster planci] | diamond | 1134 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30752326 | 30752326 | PRJNA950981_P_NODE_20574_length_244_cov_0.912281_g20398_i0 | PRJNA950981 | 20574 | 244 | 0.912281 | 2.22596564 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 56.2 | 6.65e-7 | NR | XP_071499141.1 | 105358 | g20398 | i0 | 44.4 | 0.885245901639344 | 72 | 31 | 88.5 | 2 | 233 | 18 | 2046 | 2108 | XP_071499141.1 uncharacterized protein [Diadema antillarum] | diamond | 216 | 56.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32593131 | 32593131 | PRJNA950981_P_NODE_14679_length_269_cov_1.346939_g14503_i0 | PRJNA950981 | 14679 | 269 | 1.346939 | 3.62326591 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 88.6 | 3.63e-18 | NR | XP_033641496.1 | 7604 | g14503 | i0 | 46.7 | 3 | 90 | 46 | 99.3 | 2 | 1 | 267 | 356 | 444 | XP_033641496.1 cystathionine beta-synthase-like [Asterias rubens] | diamond | 807 | 89 | 0.995505617977528 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens |
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);;