contig_metadata
11 rows where bioproject = "PRJNA599026" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5675161 | 5675161 | PRJNA599026_S_NODE_13745_length_270_cov_0.923077_g13289_i0 | PRJNA599026 | 13745 | 270 | 0.923077 | 2.4923079 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|1944836794|ref|XM_038191229.1| | 46514 | g13289 | i0 | 100 | 0.111111111111111 | 30 | 0 | 11 | 0 | 64 | 93 | 2199 | 2170 | PREDICTED: Patiria miniata cGMP-inhibited 3',5'-cyclic phosphodiesterase A-like (LOC119721247), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 12050808 | 12050808 | PRJNA599026_S_NODE_34490_length_192_cov_1.006993_g34034_i0 | PRJNA599026 | 34490 | 192 | 1.006993 | 1.93342656 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 97.4 | 4.189999999999999e-24 | NR | PIK62521.1 | 307972 | g34034 | i0 | 70.3 | 3.953125 | 64 | 19 | 100 | 0 | 1 | 192 | 56 | 119 | PIK62521.1 putative isovaleryl-CoA dehydrogenase, mitochondrial isoform X1 [Apostichopus japonicus] | diamond | 759 | 97.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 18423661 | 18423661 | PRJNA599026_S_NODE_38635_length_184_cov_1.355556_g38179_i0 | PRJNA599026 | 38635 | 184 | 1.355556 | 2.49422304 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 148 | 1.9499999999999999e-31 | NTclustered | gi|1826640317|ref|XM_033252309.1| | 1529436 | g38179 | i0 | 81.667 | 23.3478260869565 | 180 | 31 | 97 | 2 | 6 | 184 | 705 | 527 | PREDICTED: Anneissia japonica polyubiquitin-B-like (LOC117109862), mRNA | blastn | 4296 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 27743557 | 27743557 | PRJNA599026_S_NODE_54324_length_166_cov_0.871795_g53868_i0 | PRJNA599026 | 54324 | 166 | 0.871795 | 1.4471797 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 72.8 | 1.06e-13 | NR | XP_022085782.1 | 133434 | g53868 | i0 | 58.9 | 5.00602409638554 | 56 | 22 | 99.4 | 1 | 166 | 2 | 74 | 129 | XP_022085782.1 glutathione S-transferase theta-1-like isoform X1 [Acanthaster planci] | diamond | 831 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28451387 | 28451387 | PRJNA599026_S_NODE_40046_length_182_cov_0.819549_g39590_i0 | PRJNA599026 | 40046 | 182 | 0.819549 | 1.49157918 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 43.9 | 0.00643 | NR | XP_022081808.1 | 133434 | g39590 | i0 | 67.5 | 4.38461538461539 | 40 | 13 | 65.9 | 0 | 181 | 62 | 364 | 403 | XP_022081808.1 tubulin alpha-1C chain-like [Acanthaster planci] | diamond | 798 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 28798342 | 28798342 | PRJNA599026_S_NODE_32247_length_196_cov_2.680272_g31791_i0 | PRJNA599026 | 32247 | 196 | 2.680272 | 5.25333312 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 64.3 | 2.35e-10 | NR | XP_030852552.1 | 7668 | g31791 | i0 | 44.4 | 5.75510204081633 | 63 | 34 | 94.9 | 1 | 194 | 9 | 16 | 78 | XP_030852552.1 uncharacterized protein LOC581871 [Strongylocentrotus purpuratus] | diamond | 1128 | 64.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29164311 | 29164311 | PRJNA599026_S_NODE_31309_length_198_cov_3.161074_g30853_i0 | PRJNA599026 | 31309 | 198 | 3.161074 | 6.25892652 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 42.7 | 0.00885 | NR | XP_783271.3 | 7668 | g30853 | i0 | 39.2 | 0.772727272727273 | 51 | 31 | 77.3 | 0 | 2 | 154 | 44 | 94 | XP_783271.3 ubiquitin-like protein FUBI [Strongylocentrotus purpuratus] | diamond | 153 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 29668897 | 29668897 | PRJNA599026_S_NODE_33730_length_193_cov_1.701389_g33274_i0 | PRJNA599026 | 33730 | 193 | 1.701389 | 3.28368077 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 46.2 | 0.00111 | NR | XP_071511694.1 | 105358 | g33274 | i0 | 53.1 | 0.761658031088083 | 49 | 21 | 76.2 | 2 | 3 | 149 | 441 | 487 | XP_071511694.1 dnaJ homolog subfamily C member 7-like [Diadema antillarum] | diamond | 147 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 29953548 | 29953548 | PRJNA599026_S_NODE_57231_length_165_cov_0.879310_g56775_i0 | PRJNA599026 | 57231 | 165 | 0.87931 | 1.4508615 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 74.3 | 9.65e-14 | NR | KAJ8019468.1 | 206669 | g56775 | i0 | 69.2 | 0.945454545454545 | 52 | 16 | 94.5 | 0 | 4 | 159 | 645 | 696 | KAJ8019468.1 Alanine--tRNA ligase, cytoplasmic [Holothuria leucospilota] | diamond | 156 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 31483917 | 31483917 | PRJNA599026_S_NODE_35156_length_190_cov_2.234043_g34700_i0 | PRJNA599026 | 35156 | 190 | 2.234043 | 4.2446817 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 45.4 | 0.00198 | NR | XP_038045623.1 | 46514 | g34700 | i0 | 50 | 1.26315789473684 | 40 | 20 | 63.2 | 0 | 51 | 170 | 329 | 368 | XP_038045623.1 vacuolar protein sorting-associated protein 4-like [Patiria miniata] | diamond | 240 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 32197977 | 32197977 | PRJNA599026_S_NODE_39118_length_183_cov_1.522388_g38662_i0 | PRJNA599026 | 39118 | 183 | 1.522388 | 2.78597004 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 72 | 1.44e-13 | NR | PIK62562.1 | 307972 | g38662 | i0 | 53.3 | 2.75409836065574 | 60 | 28 | 98.4 | 0 | 182 | 3 | 137 | 196 | PIK62562.1 putative ERI1 exoribonuclease 3 [Apostichopus japonicus] | diamond | 504 | 72 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus |
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);;