contig_metadata
10 rows where bioproject = "PRJNA1215813", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4158848 | 4158848 | PRJNA1215813_P_NODE_924_length_742_cov_14.294469_g854_i0 | PRJNA1215813 | 924 | 742 | 14.294469 | 106.06495998 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 288 | 1.03e-94 | NR | XP_038051326.1 | 46514 | g854 | i0 | 59 | 19.1603773584906 | 234 | 96 | 94.6 | 0 | 707 | 6 | 13 | 246 | XP_038051326.1 60S ribosomal protein L7-like [Patiria miniata] | diamond | 14217 | 288 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27767878 | 27767878 | PRJNA1215813_P_NODE_3004_length_437_cov_1.148352_g2924_i0 | PRJNA1215813 | 3004 | 437 | 1.148352 | 5.01829824 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 47.8 | 0.00251 | NR | XP_033127893.1 | 1529436 | g2924 | i0 | 23.9 | 0.803203661327231 | 117 | 88 | 80.3 | 1 | 436 | 86 | 1 | 116 | XP_033127893.1 mammalian ependymin-related protein 1-like isoform X4 [Anneissia japonica] | diamond | 351 | 47.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27862270 | 27862270 | PRJNA1215813_P_NODE_12125_length_243_cov_0.917647_g12045_i0 | PRJNA1215813 | 12125 | 243 | 0.917647 | 2.22988221 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 79.3 | 2.44e-15 | NR | KAJ8047614.1 | 206669 | g12045 | i0 | 51.3 | 2.82716049382716 | 78 | 35 | 95.1 | 2 | 233 | 3 | 149 | 224 | KAJ8047614.1 hypothetical protein HOLleu_06656 [Holothuria leucospilota] | diamond | 687 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 28418164 | 28418164 | PRJNA1215813_P_NODE_8446_length_269_cov_1.193878_g8366_i0 | PRJNA1215813 | 8446 | 269 | 1.193878 | 3.21153182 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 117 | 3.76e-28 | NR | PIK35821.1 | 307972 | g8366 | i0 | 67.1 | 3.75836431226766 | 85 | 27 | 93.7 | 1 | 16 | 267 | 576 | 660 | PIK35821.1 putative P protein [Apostichopus japonicus] | diamond | 1011 | 118 | 0.991525423728814 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29946427 | 29946427 | PRJNA1215813_P_NODE_7991_length_278_cov_1.073171_g7911_i0 | PRJNA1215813 | 7991 | 278 | 1.073171 | 2.98341538 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 65.9 | 3.96e-10 | NR | KAJ8035565.1 | 206669 | g7911 | i0 | 41.6 | 1.86690647482014 | 89 | 38 | 87.4 | 3 | 278 | 36 | 316 | 398 | KAJ8035565.1 Monoacylglycerol lipase ABHD2-A [Holothuria leucospilota] | diamond | 519 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30376298 | 30376298 | PRJNA1215813_P_NODE_6632_length_304_cov_1.350649_g6552_i0 | PRJNA1215813 | 6632 | 304 | 1.350649 | 4.10597296 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 87 | 1.7e-17 | NR | XP_063957870.1 | 7653 | g6552 | i0 | 48 | 10.5789473684211 | 98 | 50 | 96.7 | 1 | 304 | 11 | 207 | 303 | XP_063957870.1 NEDD8 ultimate buster 1-like [Lytechinus pictus] | diamond | 3216 | 87 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 30799256 | 30799256 | PRJNA1215813_P_NODE_8654_length_265_cov_1.130208_g8574_i0 | PRJNA1215813 | 8654 | 265 | 1.130208 | 2.9950512 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 82 | 1.36e-16 | NR | XP_038065949.1 | 46514 | g8574 | i0 | 72.5 | 0.577358490566038 | 51 | 14 | 57.7 | 0 | 101 | 253 | 94 | 144 | XP_038065949.1 AAC-rich mRNA clone AAC4 protein-like [Patiria miniata] | diamond | 153 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32399558 | 32399558 | PRJNA1215813_P_NODE_12079_length_243_cov_1.376471_g11999_i0 | PRJNA1215813 | 12079 | 243 | 1.376471 | 3.34482453 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 110 | 2.23e-26 | NR | XP_030836272.1 | 7668 | g11999 | i0 | 64.4 | 3.67901234567901 | 73 | 26 | 90.1 | 0 | 23 | 241 | 362 | 434 | XP_030836272.1 lysosomal Pro-X carboxypeptidase [Strongylocentrotus purpuratus] | diamond | 894 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32620598 | 32620598 | PRJNA1215813_P_NODE_10500_length_249_cov_0.886364_g10420_i0 | PRJNA1215813 | 10500 | 249 | 0.886364 | 2.20704636 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 88.2 | 3.85e-18 | NR | XP_041473105.1 | 7654 | g10420 | i0 | 50.6 | 11 | 83 | 40 | 98.8 | 1 | 247 | 2 | 448 | 530 | XP_041473105.1 eukaryotic translation initiation factor 3 subunit L-like [Lytechinus variegatus] | diamond | 2739 | 89 | 0.991011235955056 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 32759366 | 32759366 | PRJNA1215813_P_NODE_10840_length_248_cov_0.891429_g10760_i0 | PRJNA1215813 | 10840 | 248 | 0.891429 | 2.21074392 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 44.3 | 0.011 | NR | XP_033632383.1 | 7604 | g10760 | i0 | 36.8 | 0.82258064516129 | 68 | 39 | 77.4 | 2 | 28 | 219 | 17 | 84 | XP_033632383.1 vacuolar protein sorting-associated protein 37A-like [Asterias rubens] | diamond | 204 | 44.3 | 1 | 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);;