contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA725806" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3263078 | 3263078 | PRJNA725806_P_NODE_148383_length_169_cov_5.871212_g148081_i0 | PRJNA725806 | 148383 | 169 | 5.871212 | 9.92234828 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|1826648140|ref|XM_033256022.1| | 1529436 | g148081 | i0 | 100 | 0.165680473372781 | 28 | 0 | 17 | 0 | 16 | 43 | 1740 | 1767 | PREDICTED: Anneissia japonica uncharacterized LOC117112836 (LOC117112836), transcript variant X2, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 3263080 | 3263080 | PRJNA725806_P_NODE_149263_length_169_cov_2.484848_g148961_i0 | PRJNA725806 | 149263 | 169 | 2.484848 | 4.19939312 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|1752346579|ref|XM_794947.5| | 7668 | g148961 | i0 | 100 | 0.177514792899408 | 30 | 0 | 18 | 0 | 85 | 114 | 2536 | 2507 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC579484 (LOC579484), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 4540372 | 4540372 | PRJNA725806_P_NODE_70284_length_223_cov_2.322581_g69983_i0 | PRJNA725806 | 70284 | 223 | 2.322581 | 5.17935563 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|1944935915|ref|XM_038188197.1| | 46514 | g69983 | i0 | 100 | 0.376681614349776 | 28 | 0 | 13 | 0 | 179 | 206 | 2330 | 2303 | PREDICTED: Patiria miniata cytochrome P450 2J6-like (LOC119718780), transcript variant X2, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 5815283 | 5815283 | PRJNA725806_P_NODE_102205_length_195_cov_24.689873_g101903_i0 | PRJNA725806 | 102205 | 195 | 24.689873 | 48.14525235 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1752359112|ref|XR_004063961.1| | 7668 | g101903 | i0 | 100 | 0.148717948717949 | 29 | 0 | 15 | 0 | 42 | 70 | 1303 | 1331 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC115923551 (LOC115923551), ncRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 7090725 | 7090725 | PRJNA725806_P_NODE_72586_length_220_cov_7.486339_g72285_i0 | PRJNA725806 | 72586 | 220 | 7.486339 | 16.4699458 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 52.8 | 0.019 | NTclustered | gi|1834263619|ref|XM_033777490.1| | 7604 | g72285 | i0 | 92.105 | 0.518181818181818 | 38 | 2 | 17 | 1 | 160 | 196 | 5759 | 5796 | PREDICTED: Asterias rubens alpha-adducin-like (LOC117294937), transcript variant X1, mRNA | blastn | 114 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 8365166 | 8365166 | PRJNA725806_P_NODE_27327_length_294_cov_1.968872_g27030_i0 | PRJNA725806 | 27327 | 294 | 1.968872 | 5.78848368 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|1229195568|ref|XR_002600076.1| | 133434 | g27030 | i0 | 100 | 0.0952380952380952 | 28 | 0 | 10 | 0 | 121 | 148 | 439 | 412 | PREDICTED: Acanthaster planci uncharacterized LOC110990985 (LOC110990985), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 8365247 | 8365247 | PRJNA725806_P_NODE_67187_length_226_cov_5.042328_g66887_i0 | PRJNA725806 | 67187 | 226 | 5.042328 | 11.39566128 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|2919570248|ref|XR_011709731.1| | 105358 | g66887 | i0 | 100 | 0.123893805309735 | 28 | 0 | 12 | 0 | 102 | 129 | 1620 | 1647 | PREDICTED: Diadema antillarum uncharacterized lncRNA (LOC139714669), ncRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 10915779 | 10915779 | PRJNA725806_P_NODE_113569_length_188_cov_3.271523_g113267_i0 | PRJNA725806 | 113569 | 188 | 3.271523 | 6.15046324 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 52.8 | 0.016 | NTclustered | gi|2037974790|ref|XM_041599758.1| | 7654 | g113267 | i0 | 100 | 0.148936170212766 | 28 | 0 | 15 | 0 | 103 | 130 | 4653 | 4680 | PREDICTED: Lytechinus variegatus gamma-aminobutyric acid receptor-associated protein-like 2 (LOC121408331), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 17289699 | 17289699 | PRJNA725806_P_NODE_100174_length_197_cov_3.425000_g99872_i0 | PRJNA725806 | 100174 | 197 | 3.425 | 6.74725 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2919358228|ref|XM_071630345.1| | 105358 | g99872 | i0 | 100 | 0.142131979695431 | 28 | 0 | 14 | 0 | 62 | 89 | 2768 | 2741 | PREDICTED: Diadema antillarum 4-hydroxyphenylpyruvate dioxygenase-like (LOC139718894), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 18563437 | 18563437 | PRJNA725806_P_NODE_101495_length_196_cov_4.006289_g101193_i0 | PRJNA725806 | 101495 | 196 | 4.006289 | 7.85232644 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|2707392299|ref|XM_064101031.1| | 7653 | g101193 | i0 | 100 | 0.443877551020408 | 29 | 0 | 15 | 0 | 55 | 83 | 4875 | 4847 | PREDICTED: Lytechinus pictus CCR4-NOT transcription complex subunit 11-like (LOC129263721), transcript variant X2, mRNA | blastn | 87 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 19838795 | 19838795 | PRJNA725806_P_NODE_21176_length_313_cov_4.713768_g20880_i0 | PRJNA725806 | 21176 | 313 | 4.713768 | 14.75409384 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2707410542|ref|XM_054892566.2| | 7653 | g20880 | i0 | 100 | 0.0958466453674121 | 30 | 0 | 10 | 0 | 238 | 267 | 9646 | 9617 | PREDICTED: Lytechinus pictus uncharacterized LOC129254113 (LOC129254113), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 22389335 | 22389335 | PRJNA725806_P_NODE_37358_length_270_cov_9.519313_g37061_i0 | PRJNA725806 | 37358 | 270 | 9.519313 | 25.7021451 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 113 | 1.12e-20 | NTclustered | gi|1826669370|ref|XM_033266414.1| | 1529436 | g37061 | i0 | 82.707 | 1.72222222222222 | 133 | 18 | 49 | 5 | 101 | 231 | 890 | 761 | PREDICTED: Anneissia japonica isovaleryl-CoA dehydrogenase, mitochondrial-like (LOC117121280), mRNA | blastn | 465 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 22389356 | 22389356 | PRJNA725806_P_NODE_4838_length_445_cov_4.811275_g4562_i0 | PRJNA725806 | 4838 | 445 | 4.811275 | 21.41017375 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.043 | NTclustered | gi|1752368495|ref|XR_004064556.1| | 7668 | g4562 | i0 | 96.774 | 0.139325842696629 | 31 | 1 | 7 | 0 | 179 | 209 | 969 | 999 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC115925137 (LOC115925137), ncRNA | blastn | 62 | 52.8 | 1 | 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);;