contig_metadata
9 rows where bioproject = "PRJNA407087" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5518707 | 5518707 | PRJNA407087_S_NODE_2065_length_458_cov_5.305361_g1609_i0 | PRJNA407087 | 2065 | 458 | 5.305361 | 24.29855338 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.044 | NTclustered | gi|1826617890|ref|XM_033241892.1| | 1529436 | g1609 | i0 | 100 | 0.305676855895196 | 28 | 0 | 6 | 0 | 28 | 55 | 1637 | 1610 | PREDICTED: Anneissia japonica nucleolin-like (LOC117101811), transcript variant X2, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 24641404 | 24641404 | PRJNA407087_S_NODE_800_length_829_cov_37.120000_g508_i0 | PRJNA407087 | 800 | 829 | 37.12 | 307.7248 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 311 | 8.09e-103 | NR | XP_041453906.1 | 7654 | g508 | i0 | 61.7 | 85.0458383594692 | 253 | 92 | 90.8 | 2 | 1 | 753 | 51 | 300 | XP_041453906.1 ADP/ATP translocase 3-like [Lytechinus variegatus] | diamond | 70503 | 314 | 0.990445859872611 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 26917264 | 26917264 | PRJNA407087_S_NODE_2402_length_414_cov_5.231169_g1941_i0 | PRJNA407087 | 2402 | 414 | 5.231169 | 21.65703966 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 181 | 3.71e-53 | NR | XP_022081367.1 | 133434 | g1941 | i0 | 61.4 | 8.64492753623188 | 132 | 51 | 95.7 | 0 | 412 | 17 | 130 | 261 | XP_022081367.1 mannose-1-phosphate guanyltransferase beta-A-like [Acanthaster planci] | diamond | 3579 | 181 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 26917270 | 26917270 | PRJNA407087_S_NODE_9602_length_154_cov_1.336000_g9139_i0 | PRJNA407087 | 9602 | 154 | 1.336 | 2.05744 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 43.1 | 0.00785 | NR | XP_038075555.1 | 46514 | g9139 | i0 | 54.9 | 0.993506493506494 | 51 | 22 | 99.4 | 1 | 153 | 1 | 187 | 236 | XP_038075555.1 60S ribosomal protein L6-like [Patiria miniata] | diamond | 153 | 43.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 27296710 | 27296710 | PRJNA407087_S_NODE_8403_length_165_cov_4.191176_g7940_i0 | PRJNA407087 | 8403 | 165 | 4.191176 | 6.9154404 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 41.2 | 0.0458 | NR | XP_003723284.2 | 7668 | g7940 | i0 | 36.2 | 0.854545454545454 | 47 | 30 | 85.5 | 0 | 24 | 164 | 363 | 409 | XP_003723284.2 uncharacterized protein LOC100893670 [Strongylocentrotus purpuratus] | diamond | 141 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 28875484 | 28875484 | PRJNA407087_S_NODE_7988_length_171_cov_1.901408_g7525_i0 | PRJNA407087 | 7988 | 171 | 1.901408 | 3.25140768 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 54.7 | 7.54e-7 | NR | XP_041455176.1 | 7654 | g7525 | i0 | 44.9 | 4.6140350877193 | 49 | 26 | 86 | 1 | 163 | 17 | 165 | 212 | XP_041455176.1 cathepsin Z-like [Lytechinus variegatus] | diamond | 789 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 29128327 | 29128327 | PRJNA407087_S_NODE_10089_length_150_cov_1.834711_g9626_i0 | PRJNA407087 | 10089 | 150 | 1.834711 | 2.7520665 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 57 | 8.28e-8 | NR | XP_071492371.1 | 105358 | g9626 | i0 | 52.1 | 2.76 | 48 | 23 | 96 | 0 | 3 | 146 | 83 | 130 | XP_071492371.1 nucleoside diphosphate-linked moiety X motif 6-like [Diadema antillarum] | diamond | 414 | 57 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32558544 | 32558544 | PRJNA407087_S_NODE_5299_length_223_cov_5.628866_g4836_i0 | PRJNA407087 | 5299 | 223 | 5.628866 | 12.55237118 | Echinoidea | 7625 | Echinodermata | other_Eukaryota | 55.1 | 5.65e-7 | NR | XP_030840219.1 | 7668 | g4836 | i0 | 37.7 | 3.29596412556054 | 61 | 35 | 78 | 1 | 18 | 191 | 133 | 193 | XP_030840219.1 calcium-binding protein P isoform X2 [Strongylocentrotus purpuratus] | diamond | 735 | 55.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 32887877 | 32887877 | PRJNA407087_S_NODE_5320_length_223_cov_2.597938_g4857_i0 | PRJNA407087 | 5320 | 223 | 2.597938 | 5.79340174 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 47.4 | 4.87e-4 | NR | XP_038051309.1 | 46514 | g4857 | i0 | 54.8 | 9.14798206278027 | 31 | 14 | 41.7 | 0 | 159 | 67 | 109 | 139 | XP_038051309.1 serine/arginine-rich splicing factor 7-like isoform X1 [Patiria miniata] | diamond | 2040 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;