contig_metadata
13 rows where bioproject = "PRJNA562549", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3096614 | 3096614 | PRJNA562549_P_NODE_17483_length_276_cov_2.316279_g17250_i0 | PRJNA562549 | 17483 | 276 | 2.316279 | 6.39293004 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2037969758|ref|XM_041596862.1| | 7654 | g17250 | i0 | 96.97 | 2.90579710144928 | 33 | 1 | 12 | 0 | 174 | 206 | 4422 | 4454 | PREDICTED: Lytechinus variegatus F-actin-monooxygenase MICAL3-like (LOC121405875), transcript variant X10, mRNA | blastn | 802 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 3682207 | 3682207 | PRJNA562549_P_NODE_34563_length_205_cov_2.201389_g34330_i0 | PRJNA562549 | 34563 | 205 | 2.201389 | 4.51284745 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 105 | 6.5e-26 | NR | XP_033118288.1 | 1529436 | g34330 | i0 | 73.1 | 29.2829268292683 | 67 | 18 | 98 | 0 | 2 | 202 | 63 | 129 | XP_033118288.1 60S ribosomal protein L7-like isoform X2 [Anneissia japonica] | diamond | 6003 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 5649588 | 5649588 | PRJNA562549_P_NODE_31425_length_211_cov_0.866667_g31192_i0 | PRJNA562549 | 31425 | 211 | 0.866667 | 1.82866737 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 93.2 | 1.2e-20 | NR | XP_030829120.1 | 7668 | g31192 | i0 | 68.6 | 8.95734597156398 | 70 | 21 | 99.5 | 1 | 210 | 1 | 210 | 278 | XP_030829120.1 cathepsin L1 [Strongylocentrotus purpuratus] | diamond | 1890 | 93.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27187651 | 27187651 | PRJNA562549_P_NODE_17682_length_275_cov_1.644860_g17449_i0 | PRJNA562549 | 17682 | 275 | 1.64486 | 4.523365 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 62.8 | 5.09e-9 | NR | XP_030840935.1 | 7668 | g17449 | i0 | 55.6 | 1.36363636363636 | 45 | 20 | 49.1 | 0 | 2 | 136 | 877 | 921 | XP_030840935.1 fibrillin-2 [Strongylocentrotus purpuratus] | diamond | 375 | 62.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 27584644 | 27584644 | PRJNA562549_P_NODE_37784_length_192_cov_3.786260_g37551_i0 | PRJNA562549 | 37784 | 192 | 3.78626 | 7.2696192 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 55.8 | 4.51e-7 | NR | XP_071492962.1 | 105358 | g37551 | i0 | 46.8 | 1.5 | 47 | 23 | 70.3 | 1 | 188 | 54 | 3233 | 3279 | XP_071492962.1 uncharacterized protein [Diadema antillarum] | diamond | 288 | 55.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 27742854 | 27742854 | PRJNA562549_P_NODE_37344_length_196_cov_2.518519_g37111_i0 | PRJNA562549 | 37344 | 196 | 2.518519 | 4.93629724 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47 | 2.31e-4 | NR | KAJ8038666.1 | 206669 | g37111 | i0 | 48.1 | 3.18367346938776 | 52 | 27 | 79.6 | 0 | 2 | 157 | 74 | 125 | KAJ8038666.1 60S ribosomal protein L28 [Holothuria leucospilota] | diamond | 624 | 47 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28514186 | 28514186 | PRJNA562549_P_NODE_12627_length_323_cov_1.469466_g12394_i0 | PRJNA562549 | 12627 | 323 | 1.469466 | 4.74637518 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 94 | 6.12e-20 | NR | NP_001020382.1 | 7668 | g12394 | i0 | 60.3 | 5.92569659442724 | 78 | 31 | 72.4 | 0 | 311 | 78 | 142 | 219 | NP_001020382.1 eukaryotic translation elongation factor 1 gamma [Strongylocentrotus purpuratus] | diamond | 1914 | 94 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28910515 | 28910515 | PRJNA562549_P_NODE_9628_length_371_cov_2.293548_g9395_i0 | PRJNA562549 | 9628 | 371 | 2.293548 | 8.50906308 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 61.6 | 4.13e-8 | NR | XP_071510638.1 | 105358 | g9395 | i0 | 56.1 | 0.331536388140162 | 41 | 18 | 33.2 | 0 | 369 | 247 | 596 | 636 | XP_071510638.1 uncharacterized protein [Diadema antillarum] | diamond | 123 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29384485 | 29384485 | PRJNA562549_P_NODE_33229_length_208_cov_0.884354_g32996_i0 | PRJNA562549 | 33229 | 208 | 0.884354 | 1.83945632 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 69.7 | 5.91e-12 | NR | XP_041479530.1 | 7654 | g32996 | i0 | 44.1 | 1.96153846153846 | 68 | 38 | 98.1 | 0 | 2 | 205 | 193 | 260 | XP_041479530.1 uncharacterized oxidoreductase YrbE-like [Lytechinus variegatus] | diamond | 408 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30047340 | 30047340 | PRJNA562549_P_NODE_13871_length_309_cov_1.524194_g13638_i0 | PRJNA562549 | 13871 | 309 | 1.524194 | 4.70975946 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 58.9 | 1.81e-7 | NR | XP_071485724.1 | 105358 | g13638 | i0 | 62.2 | 3.60194174757282 | 37 | 14 | 35.9 | 0 | 1 | 111 | 1384 | 1420 | XP_071485724.1 cadherin EGF LAG seven-pass G-type receptor 2-like [Diadema antillarum] | diamond | 1113 | 58.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 30141946 | 30141946 | PRJNA562549_P_NODE_32132_length_210_cov_0.872483_g31899_i0 | PRJNA562549 | 32132 | 210 | 0.872483 | 1.8322143 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 96.3 | 3.52e-21 | NR | XP_022085601.1 | 133434 | g31899 | i0 | 62.9 | 9.97142857142857 | 70 | 26 | 100 | 0 | 210 | 1 | 545 | 614 | XP_022085601.1 ABC transporter B family member 1-like [Acanthaster planci] | diamond | 2094 | 96.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 30427152 | 30427152 | PRJNA562549_P_NODE_34793_length_205_cov_0.902778_g34560_i0 | PRJNA562549 | 34793 | 205 | 0.902778 | 1.8506949 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 70.5 | 3.67e-12 | NR | XP_033628364.1 | 7604 | g34560 | i0 | 48.1 | 1.53658536585366 | 52 | 27 | 76.1 | 0 | 6 | 161 | 845 | 896 | XP_033628364.1 vacuolar protein sorting-associated protein 18 homolog [Asterias rubens] | diamond | 315 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 31325290 | 31325290 | PRJNA562549_P_NODE_10695_length_351_cov_2.344828_g10462_i0 | PRJNA562549 | 10695 | 351 | 2.344828 | 8.23034628 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 61.2 | 4.45e-8 | NR | XP_030840935.1 | 7668 | g10462 | i0 | 55.3 | 5.97435897435897 | 47 | 18 | 37.6 | 1 | 6 | 137 | 1478 | 1524 | XP_030840935.1 fibrillin-2 [Strongylocentrotus purpuratus] | diamond | 2097 | 61.6 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus |
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);;