contig_metadata
15 rows where bioproject = "PRJNA690234", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19797347 | 19797347 | PRJNA690234_P_NODE_4856_length_593_cov_1.732692_g4496_i0 | PRJNA690234 | 4856 | 593 | 1.732692 | 10.27486356 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 158 | 8.289999999999998e-42 | NR | XP_041474319.1 | 7654 | g4496 | i0 | 44.3 | 2.77740303541315 | 185 | 101 | 93.6 | 1 | 590 | 36 | 82 | 264 | XP_041474319.1 3-phosphoinositide-dependent protein kinase 1-like [Lytechinus variegatus] | diamond | 1647 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 23622943 | 23622943 | PRJNA690234_P_NODE_2099_length_913_cov_2.916667_g1817_i0 | PRJNA690234 | 2099 | 913 | 2.916667 | 26.62916971 | Echinodermata | 7586 | Echinodermata | other_Eukaryota | 396 | 1.17e-127 | NR | XP_071496866.1 | 105358 | g1817 | i0 | 66.2 | 6.59802847754655 | 287 | 97 | 94.3 | 0 | 52 | 912 | 11 | 297 | XP_071496866.1 AP-1 complex subunit beta-1-like [Diadema antillarum] | diamond | 6024 | 400 | 0.99 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27062201 | 27062201 | PRJNA690234_P_NODE_24042_length_258_cov_2.108108_g23675_i0 | PRJNA690234 | 24042 | 258 | 2.108108 | 5.43891864 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 55.8 | 1.08e-6 | NR | XP_041452552.1 | 7654 | g23675 | i0 | 56.4 | 2.27906976744186 | 55 | 21 | 60.5 | 1 | 81 | 236 | 286 | 340 | XP_041452552.1 uncharacterized protein LOC121405700 [Lytechinus variegatus] | diamond | 588 | 56.2 | 0.99288256227758 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 27145183 | 27145183 | PRJNA690234_P_NODE_21842_length_271_cov_2.494949_g21475_i0 | PRJNA690234 | 21842 | 271 | 2.494949 | 6.76131179 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 75.5 | 1.75e-15 | NR | KAJ8017667.1 | 206669 | g21475 | i0 | 38.6 | 1.71586715867159 | 88 | 54 | 97.4 | 0 | 8 | 271 | 2 | 89 | KAJ8017667.1 RNA polymerase II-associated factor 1-like [Holothuria leucospilota] | diamond | 465 | 75.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27631084 | 27631084 | PRJNA690234_P_NODE_9024_length_426_cov_2.254958_g8658_i0 | PRJNA690234 | 9024 | 426 | 2.254958 | 9.60612108 | Opisthokonta | 33154 | Echinodermata | other_Eukaryota | 207 | 7.3e-62 | NR | XP_033633564.1 | 7604 | g8658 | i0 | 67.6 | 9.84507042253521 | 139 | 45 | 97.9 | 0 | 8 | 424 | 279 | 417 | XP_033633564.1 2,3-bisphosphoglycerate-independent phosphoglycerate mutase-like [Asterias rubens] | diamond | 4194 | 207 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27714607 | 27714607 | PRJNA690234_P_NODE_16684_length_311_cov_1.563025_g16317_i0 | PRJNA690234 | 16684 | 311 | 1.563025 | 4.86100775 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 102 | 1.81e-23 | NR | XP_022083544.1 | 133434 | g16317 | i0 | 50 | 1.73633440514469 | 90 | 45 | 86.8 | 0 | 275 | 6 | 39 | 128 | XP_022083544.1 branched-chain-amino-acid aminotransferase, cytosolic-like isoform X2 [Acanthaster planci] | diamond | 540 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28124691 | 28124691 | PRJNA690234_P_NODE_1945_length_946_cov_4.817869_g1673_i0 | PRJNA690234 | 1945 | 946 | 4.817869 | 45.57704074 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 114 | 4.31e-24 | NR | XP_033624940.1 | 7604 | g1673 | i0 | 26.2 | 1.02748414376321 | 324 | 204 | 98.3 | 11 | 943 | 14 | 793 | 1095 | XP_033624940.1 cubilin-like [Asterias rubens] | diamond | 972 | 114 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 28977316 | 28977316 | PRJNA690234_P_NODE_19468_length_287_cov_1.831776_g19101_i0 | PRJNA690234 | 19468 | 287 | 1.831776 | 5.25719712 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 68.9 | 3.95e-11 | NR | XP_033631060.1 | 7604 | g19101 | i0 | 36.2 | 0.982578397212544 | 94 | 59 | 97.2 | 1 | 1 | 279 | 123 | 216 | XP_033631060.1 transducin beta-like protein 3 [Asterias rubens] | diamond | 282 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 30682501 | 30682501 | PRJNA690234_P_NODE_14253_length_336_cov_1.646388_g13886_i0 | PRJNA690234 | 14253 | 336 | 1.646388 | 5.53186368 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 154 | 1.27e-41 | NR | XP_033108165.1 | 1529436 | g13886 | i0 | 59.5 | 6.9375 | 111 | 44 | 99.1 | 1 | 335 | 3 | 396 | 505 | XP_033108165.1 cGMP-dependent protein kinase 1-like isoform X2 [Anneissia japonica] | diamond | 2331 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30757387 | 30757387 | PRJNA690234_P_NODE_6574_length_504_cov_1.928074_g6209_i0 | PRJNA690234 | 6574 | 504 | 1.928074 | 9.71749296 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 162 | 3.7299999999999985e-43 | NR | XP_033115728.1 | 1529436 | g6209 | i0 | 45.5 | 6.97023809523809 | 167 | 91 | 99.4 | 0 | 3 | 503 | 19 | 185 | XP_033115728.1 AP-1 complex subunit gamma-1-like isoform X1 [Anneissia japonica] | diamond | 3513 | 162 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 30935567 | 30935567 | PRJNA690234_P_NODE_10354_length_396_cov_1.733746_g9988_i0 | PRJNA690234 | 10354 | 396 | 1.733746 | 6.86563416 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 49.3 | 9.14e-4 | NR | XP_030829109.1 | 7668 | g9988 | i0 | 35.8 | 0.613636363636364 | 81 | 36 | 49.2 | 3 | 186 | 380 | 318 | 398 | XP_030829109.1 proline-serine-threonine phosphatase-interacting protein 1 isoform X2 [Strongylocentrotus purpuratus] | diamond | 243 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31231115 | 31231115 | PRJNA690234_P_NODE_32715_length_228_cov_2.012903_g32348_i0 | PRJNA690234 | 32715 | 228 | 2.012903 | 4.5894188400000004 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 108 | 7.71e-26 | NR | KAJ8046425.1 | 206669 | g32348 | i0 | 68 | 11.8421052631579 | 75 | 24 | 98.7 | 0 | 227 | 3 | 198 | 272 | KAJ8046425.1 Isocitrate dehydrogenase [NAD] subunit gamma, mitochondrial [Holothuria leucospilota] | diamond | 2700 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32117125 | 32117125 | PRJNA690234_P_NODE_15158_length_326_cov_1.561265_g14791_i0 | PRJNA690234 | 15158 | 326 | 1.561265 | 5.0897239 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 107 | 2.0399999999999994e-24 | NR | KAJ8046901.1 | 206669 | g14791 | i0 | 45.8 | 108.312883435583 | 107 | 58 | 98.5 | 0 | 324 | 4 | 668 | 774 | KAJ8046901.1 hypothetical protein HOLleu_05736 [Holothuria leucospilota] | diamond | 35310 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 32611614 | 32611614 | PRJNA690234_P_NODE_19920_length_284_cov_1.744076_g19553_i0 | PRJNA690234 | 19920 | 284 | 1.744076 | 4.95317584 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52 | 3.3e-5 | NR | XP_030836923.1 | 7668 | g19553 | i0 | 42.3 | 1.32042253521127 | 52 | 30 | 54.9 | 0 | 163 | 8 | 84 | 135 | XP_030836923.1 TBC1 domain family member 17 [Strongylocentrotus purpuratus] | diamond | 375 | 52 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32737715 | 32737715 | PRJNA690234_P_NODE_11520_length_374_cov_2.073090_g11154_i0 | PRJNA690234 | 11520 | 374 | 2.07309 | 7.7533566 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 97.4 | 1.31e-22 | NR | XP_071476142.1 | 105358 | g11154 | i0 | 44.9 | 2.74331550802139 | 89 | 49 | 71.4 | 0 | 68 | 334 | 81 | 169 | XP_071476142.1 E3 ubiquitin-protein ligase RNF126-like isoform X2 [Diadema antillarum] | diamond | 1026 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum |
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);;