contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA641707" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4438922 | 4438922 | PRJNA641707_P_NODE_118224_length_245_cov_11.000000_g115561_i0 | PRJNA641707 | 118224 | 245 | 11 | 26.95 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 82.4 | 2.82e-11 | NTclustered | gi|1944939444|ref|XM_038189959.1| | 46514 | g115561 | i0 | 81.818 | 0.404081632653061 | 99 | 16 | 40 | 2 | 1 | 98 | 796 | 699 | PREDICTED: Patiria miniata cilia- and flagella-associated protein 157-like (LOC119720318), mRNA | blastn | 99 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 4439904 | 4439904 | PRJNA641707_P_NODE_163704_length_206_cov_4.554140_g161041_i0 | PRJNA641707 | 163704 | 206 | 4.55414 | 9.3815284 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 135 | 1.74e-27 | NTclustered | gi|1834285991|ref|XM_033768267.1| | 7604 | g161041 | i0 | 84.672 | 56.4854368932039 | 137 | 19 | 66 | 2 | 66 | 201 | 1954 | 1819 | PREDICTED: Asterias rubens CUGBP Elav-like family member 3-A (LOC117287762), transcript variant X1, mRNA | blastn | 11636 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 6991307 | 6991307 | PRJNA641707_P_NODE_190246_length_199_cov_2.933333_g187583_i0 | PRJNA641707 | 190246 | 199 | 2.933333 | 5.83733267 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 121 | 4.669999999999999e-23 | NTclustered | gi|1826680293|ref|XM_033272049.1| | 1529436 | g187583 | i0 | 91.86 | 4.62311557788945 | 86 | 7 | 43 | 0 | 98 | 183 | 1124 | 1039 | PREDICTED: Anneissia japonica transcription factor Sp8-like (LOC117125530), transcript variant X6, mRNA | blastn | 920 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 6994035 | 6994035 | PRJNA641707_P_NODE_305126_length_163_cov_1.596491_g302463_i0 | PRJNA641707 | 305126 | 163 | 1.596491 | 2.60228033 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 108 | 2.86e-19 | NTclustered | gi|1944883718|ref|XM_038202922.1| | 46514 | g302463 | i0 | 84.404 | 4.89570552147239 | 109 | 17 | 67 | 0 | 55 | 163 | 113 | 221 | PREDICTED: Patiria miniata dynein light chain LC6, flagellar outer arm (LOC119730150), mRNA | blastn | 798 | 108 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 8808822 | 8808822 | PRJNA641707_P_NODE_102027_length_246_cov_3.954315_g99364_i0 | PRJNA641707 | 102027 | 246 | 3.954315 | 9.7276149 | root | 1 | Root_unresolved | Root_unresolved | 56.5 | 0.002 | NTclustered | gi|1944905423|ref|XM_038209528.1| | 46514 | g99364 | i0 | 100 | 6.06910569105691 | 30 | 0 | 12 | 0 | 7 | 36 | 8187 | 8216 | PREDICTED: Patiria miniata neurogenic locus Notch protein-like (LOC119735676), transcript variant X42, mRNA | blastn | 1493 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 9544815 | 9544815 | PRJNA641707_P_NODE_34788_length_367_cov_6.415094_g32161_i0 | PRJNA641707 | 34788 | 367 | 6.415094 | 23.54339498 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 124 | 7.28e-24 | NTclustered | gi|1834277309|ref|XM_033779211.1| | 7604 | g32161 | i0 | 80.347 | 2.50136239782016 | 173 | 26 | 47 | 6 | 148 | 318 | 737 | 571 | PREDICTED: Asterias rubens eukaryotic translation initiation factor 2 subunit 3 (LOC117296342), mRNA | blastn | 918 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 9546037 | 9546037 | PRJNA641707_P_NODE_87728_length_246_cov_6.147208_g85065_i0 | PRJNA641707 | 87728 | 246 | 6.147208 | 15.12213168 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 93.5 | 1.31e-14 | NTclustered | gi|1752395007|ref|XM_011670321.2| | 7668 | g85065 | i0 | 88.312 | 3.6869918699187 | 77 | 9 | 31 | 0 | 146 | 222 | 1072 | 1148 | PREDICTED: Strongylocentrotus purpuratus serine/threonine-protein phosphatase 2A 56 kDa regulatory subunit delta isoform (LOC577346), transcript variant X2, mRNA | blastn | 907 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 10821282 | 10821282 | PRJNA641707_P_NODE_69569_length_251_cov_9.688119_g66906_i0 | PRJNA641707 | 69569 | 251 | 9.688119 | 24.31717869 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 89.8 | 1.73e-13 | NTclustered | gi|1752370133|ref|XM_030989160.1| | 7668 | g66906 | i0 | 88 | 0.298804780876494 | 75 | 9 | 30 | 0 | 6 | 80 | 554 | 480 | PREDICTED: Strongylocentrotus purpuratus serine/threonine-protein kinase tricorner (LOC582923), mRNA | blastn | 75 | 89.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 14639700 | 14639700 | PRJNA641707_P_NODE_100772_length_246_cov_4.116751_g98109_i0 | PRJNA641707 | 100772 | 246 | 4.116751 | 10.12720746 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 121 | 6.01e-23 | NTclustered | gi|2037953422|ref|XR_005971516.1| | 7654 | g98109 | i0 | 85.841 | 0.91869918699187 | 113 | 16 | 46 | 0 | 19 | 131 | 269 | 157 | PREDICTED: Lytechinus variegatus uncharacterized LOC121425672 (LOC121425672), transcript variant X3, misc_RNA | blastn | 226 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 14641962 | 14641962 | PRJNA641707_P_NODE_201752_length_197_cov_5.445946_g199089_i0 | PRJNA641707 | 201752 | 197 | 5.445946 | 10.72851362 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|2919532668|ref|XM_071655481.1| | 105358 | g199089 | i0 | 100 | 0.142131979695431 | 28 | 0 | 14 | 0 | 148 | 175 | 5719 | 5692 | PREDICTED: Diadema antillarum nucleoprotein TPR-like (LOC139745067), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 14645286 | 14645286 | PRJNA641707_P_NODE_38392_length_351_cov_5.973510_g35752_i0 | PRJNA641707 | 38392 | 351 | 5.97351 | 20.9670201 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 60.2 | 1.98e-4 | NTclustered | gi|1229154216|ref|XM_022234077.1| | 133434 | g35752 | i0 | 100 | 0.333333333333333 | 32 | 0 | 9 | 0 | 46 | 77 | 1633 | 1602 | PREDICTED: Acanthaster planci ribosomal protein S6 kinase alpha-4-like (LOC110978794), mRNA | blastn | 117 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 15186475 | 15186475 | PRJNA641707_P_NODE_56492_length_284_cov_9.514894_g53831_i0 | PRJNA641707 | 56492 | 284 | 9.514894 | 27.02229896 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 52.8 | 0.026 | NTclustered | gi|70887808|gb|AC165428.1| | 7668 | g53831 | i0 | 100 | 0.295774647887324 | 28 | 0 | 10 | 0 | 123 | 150 | 478370 | 478343 | Strongylocentrotus purpuratus BAC clone contig containing Eve, the hox cluster, cholinesterase, and COLP5alpha genes, complete sequence | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 15916141 | 15916141 | PRJNA641707_P_NODE_211113_length_195_cov_7.164384_g208450_i0 | PRJNA641707 | 211113 | 195 | 7.164384 | 13.9705488 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.017 | NTclustered | gi|1752384519|ref|XM_030995292.1| | 7668 | g208450 | i0 | 100 | 0.287179487179487 | 28 | 0 | 14 | 0 | 167 | 194 | 1643 | 1670 | PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC100893267 (LOC100893267), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 17194138 | 17194138 | PRJNA641707_P_NODE_339254_length_150_cov_6.544554_g336591_i0 | PRJNA641707 | 339254 | 150 | 6.544554 | 9.816831 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 65.8 | 1.57e-6 | NTclustered | gi|2919556077|ref|XM_071623634.1| | 105358 | g336591 | i0 | 95.122 | 0.546666666666667 | 41 | 2 | 27 | 0 | 3 | 43 | 1507 | 1547 | PREDICTED: Diadema antillarum long-chain specific acyl-CoA dehydrogenase, mitochondrial-like (LOC139711780), mRNA | blastn | 82 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 17735705 | 17735705 | PRJNA641707_P_NODE_339094_length_150_cov_7.346535_g336431_i0 | PRJNA641707 | 339094 | 150 | 7.346535 | 11.0198025 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 135 | 1.18e-27 | NTclustered | gi|217202|dbj|D01021.1|ANDDBHC | 1043166 | g336431 | i0 | 83.108 | 9.1 | 148 | 25 | 99 | 0 | 3 | 150 | 5814 | 5961 | Heliocidaris crassispina mRNA for dynein beta-heavy chain, complete cds | blastn | 1365 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Echinometridae | Heliocidaris | Heliocidaris crassispina | |
| 21013447 | 21013447 | PRJNA641707_P_NODE_110277_length_246_cov_2.842640_g107614_i0 | PRJNA641707 | 110277 | 246 | 2.84264 | 6.9928944 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 63.9 | 1.03e-5 | NTclustered | gi|2919372062|ref|XM_071620433.1| | 105358 | g107614 | i0 | 79.167 | 3.34552845528455 | 96 | 16 | 38 | 4 | 146 | 239 | 2007 | 1914 | PREDICTED: Diadema antillarum heat shock protein 83-like (LOC139708481), mRNA | blastn | 823 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 21016251 | 21016251 | PRJNA641707_P_NODE_237017_length_187_cov_9.434783_g234354_i0 | PRJNA641707 | 237017 | 187 | 9.434783 | 17.64304421 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 100 | 5.64e-17 | NTclustered | gi|1826634372|ref|XM_033249952.1| | 1529436 | g234354 | i0 | 88.889 | 0.433155080213904 | 81 | 9 | 43 | 0 | 60 | 140 | 539 | 459 | PREDICTED: Anneissia japonica methylcrotonoyl-CoA carboxylase beta chain, mitochondrial-like (LOC117108080), mRNA | blastn | 81 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 21019166 | 21019166 | PRJNA641707_P_NODE_56677_length_284_cov_3.540426_g54016_i0 | PRJNA641707 | 56677 | 284 | 3.540426 | 10.05480984 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 132 | 3.27e-26 | NTclustered | gi|2707414189|ref|XR_010296632.1| | 7653 | g54016 | i0 | 81.366 | 8.5 | 161 | 30 | 57 | 0 | 17 | 177 | 2625 | 2465 | PREDICTED: Lytechinus pictus coatomer subunit beta-like (LOC129282735), transcript variant X1, misc_RNA | blastn | 2414 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 21558033 | 21558033 | PRJNA641707_P_NODE_125597_length_245_cov_3.010204_g122934_i0 | PRJNA641707 | 125597 | 245 | 3.010204 | 7.3749998 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.022 | NTclustered | gi|2707407323|ref|XM_054912764.2| | 7653 | g122934 | i0 | 100 | 0.938775510204082 | 28 | 0 | 11 | 0 | 13 | 40 | 2159 | 2186 | PREDICTED: Lytechinus pictus protein rolling stone-like (LOC129276383), mRNA | blastn | 230 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 22293235 | 22293235 | PRJNA641707_P_NODE_334498_length_152_cov_13.320388_g331835_i0 | PRJNA641707 | 334498 | 152 | 13.320388 | 20.24698976 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 60.2 | 7.43e-5 | NTclustered | gi|1826623817|ref|XM_033245006.1| | 1529436 | g331835 | i0 | 94.737 | 1 | 38 | 2 | 25 | 0 | 101 | 138 | 956 | 919 | PREDICTED: Anneissia japonica aminopeptidase N-like (LOC117104265), transcript variant X4, mRNA | blastn | 152 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 24839024 | 24839024 | PRJNA641707_P_NODE_183900_length_199_cov_12.066667_g181237_i0 | PRJNA641707 | 183900 | 199 | 12.066667 | 24.01266733 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 102 | 1.69e-17 | NTclustered | gi|1752364945|ref|XM_011670502.2| | 7668 | g181237 | i0 | 85.567 | 4.68341708542714 | 97 | 14 | 49 | 0 | 97 | 193 | 367 | 271 | PREDICTED: Strongylocentrotus purpuratus tubulin beta-4B chain (LOC593362), mRNA | blastn | 932 | 102 | 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);;