contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA1249535" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2906912 | 2906912 | PRJNA1249535_S_NODE_183643_length_315_cov_3.454545_g180260_i0 | PRJNA1249535 | 183643 | 315 | 3.454545 | 10.88181675 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|1826666960|ref|XM_033265190.1| | 1529436 | g180260 | i0 | 100 | 0.0888888888888889 | 28 | 0 | 9 | 0 | 100 | 127 | 888 | 915 | PREDICTED: Anneissia japonica lys-63-specific deubiquitinase BRCC36-like (LOC117120165), transcript variant X2, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 4186302 | 4186302 | PRJNA1249535_S_NODE_93284_length_382_cov_9.310680_g89902_i0 | PRJNA1249535 | 93284 | 382 | 9.31068 | 35.5667976 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|1944880545|ref|XM_038202311.1| | 46514 | g89902 | i0 | 94.444 | 0.651832460732984 | 36 | 2 | 9 | 0 | 157 | 192 | 121 | 156 | PREDICTED: Patiria miniata DNA annealing helicase and endonuclease ZRANB3-like (LOC119729648), transcript variant X2, mRNA | blastn | 249 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 5458876 | 5458876 | PRJNA1249535_S_NODE_133445_length_346_cov_4.234432_g130062_i0 | PRJNA1249535 | 133445 | 346 | 4.234432 | 14.65113472 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|1826647612|ref|XM_033255739.1| | 1529436 | g130062 | i0 | 100 | 0.0809248554913295 | 28 | 0 | 8 | 0 | 266 | 293 | 2497 | 2524 | PREDICTED: Anneissia japonica tripartite motif-containing protein 2-like (LOC117112628), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 5459812 | 5459812 | PRJNA1249535_S_NODE_200905_length_306_cov_1.339056_g197522_i0 | PRJNA1249535 | 200905 | 306 | 1.339056 | 4.09751136 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.008 | NTclustered | gi|2707354388|ref|XM_064096696.1| | 7653 | g197522 | i0 | 88.636 | 0.143790849673203 | 44 | 5 | 14 | 0 | 54 | 97 | 2231 | 2188 | PREDICTED: Lytechinus pictus uncharacterized LOC129257557 (LOC129257557), mRNA | blastn | 44 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 6733193 | 6733193 | PRJNA1249535_S_NODE_129466_length_349_cov_3.503623_g126083_i0 | PRJNA1249535 | 129466 | 349 | 3.503623 | 12.22764427 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 52.8 | 0.033 | NTclustered | gi|1752337726|ref|XM_785646.5| | 7668 | g126083 | i0 | 100 | 0.0802292263610315 | 28 | 0 | 8 | 0 | 309 | 336 | 2302 | 2275 | PREDICTED: Strongylocentrotus purpuratus transmembrane protein 161B (LOC585840), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 8009702 | 8009702 | PRJNA1249535_S_NODE_191227_length_311_cov_2.542017_g187844_i0 | PRJNA1249535 | 191227 | 311 | 2.542017 | 7.90567287 | Brisinga sp. SS-2022 | 2939278 | Echinodermata | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|2232175715|gb|MZ702705.1| | 2939278 | g187844 | i0 | 100 | 0.090032154340836 | 28 | 0 | 9 | 0 | 145 | 172 | 14221 | 14194 | Brisinga sp. SS-2022 mitochondrion, complete genome | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Brisingida | Brisingidae | Brisinga | Brisinga sp. SS-2022 | |
| 9284707 | 9284707 | PRJNA1249535_S_NODE_205868_length_303_cov_3.043478_g202485_i0 | PRJNA1249535 | 205868 | 303 | 3.043478 | 9.22173834 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 58.4 | 6.07e-4 | NTclustered | gi|1944883614|ref|XM_038202899.1| | 46514 | g202485 | i0 | 100 | 2.5973597359736 | 31 | 0 | 10 | 0 | 253 | 283 | 510 | 540 | PREDICTED: Patiria miniata oocyte zinc finger protein XlCOF6-like (LOC119730126), mRNA | blastn | 787 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 10560541 | 10560541 | PRJNA1249535_S_NODE_207249_length_302_cov_4.200873_g203866_i0 | PRJNA1249535 | 207249 | 302 | 4.200873 | 12.68663646 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2707354388|ref|XM_064096696.1| | 7653 | g203866 | i0 | 90.476 | 0.139072847682119 | 42 | 4 | 14 | 0 | 200 | 241 | 2190 | 2231 | PREDICTED: Lytechinus pictus uncharacterized LOC129257557 (LOC129257557), mRNA | blastn | 42 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 10561364 | 10561364 | PRJNA1249535_S_NODE_269149_length_269_cov_6.530612_g265766_i0 | PRJNA1249535 | 269149 | 269 | 6.530612 | 17.56734628 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 52.8 | 0.025 | NTclustered | gi|1834257867|ref|XM_033775803.1| | 7604 | g265766 | i0 | 100 | 0.104089219330855 | 28 | 0 | 10 | 0 | 31 | 58 | 4540 | 4567 | PREDICTED: Asterias rubens short transient receptor potential channel 4-like (LOC117293459), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 11836173 | 11836173 | PRJNA1249535_S_NODE_290230_length_258_cov_2.259459_g286847_i0 | PRJNA1249535 | 290230 | 258 | 2.259459 | 5.82940422 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2707354388|ref|XM_064096696.1| | 7653 | g286847 | i0 | 90.476 | 0.162790697674419 | 42 | 4 | 16 | 0 | 49 | 90 | 2190 | 2231 | PREDICTED: Lytechinus pictus uncharacterized LOC129257557 (LOC129257557), mRNA | blastn | 42 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 14384133 | 14384133 | PRJNA1249535_S_NODE_105672_length_369_cov_3.368243_g102289_i0 | PRJNA1249535 | 105672 | 369 | 3.368243 | 12.42881667 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 52.8 | 0.035 | NTclustered | gi|1826641312|ref|XM_033252848.1| | 1529436 | g102289 | i0 | 100 | 0.303523035230352 | 28 | 0 | 8 | 0 | 269 | 296 | 4665 | 4692 | PREDICTED: Anneissia japonica chromodomain-helicase-DNA-binding protein 5-like (LOC117110224), transcript variant X3, mRNA | blastn | 112 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 15659091 | 15659091 | PRJNA1249535_S_NODE_185913_length_314_cov_2.560166_g182530_i0 | PRJNA1249535 | 185913 | 314 | 2.560166 | 8.03892124 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 65.8 | 3.77e-6 | NTclustered | gi|2919361364|ref|XR_011710540.1| | 105358 | g182530 | i0 | 93.182 | 0.60828025477707 | 44 | 3 | 14 | 0 | 271 | 314 | 190 | 147 | PREDICTED: Diadema antillarum U2 spliceosomal RNA (LOC139725251), ncRNA | blastn | 191 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 16933929 | 16933929 | PRJNA1249535_S_NODE_226574_length_292_cov_3.493151_g223191_i0 | PRJNA1249535 | 226574 | 292 | 3.493151 | 10.20000092 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 52.8 | 0.027 | NTclustered | gi|1834292684|ref|XM_033790040.1| | 7604 | g223191 | i0 | 100 | 0.0958904109589041 | 28 | 0 | 10 | 0 | 150 | 177 | 1596 | 1623 | PREDICTED: Asterias rubens DNA damage-regulated autophagy modulator protein 1-like (LOC117305217), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 17630154 | 17630154 | PRJNA1249535_S_NODE_147654_length_337_cov_1.359848_g144271_i0 | PRJNA1249535 | 147654 | 337 | 1.359848 | 4.58268776 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 52.8 | 0.032 | NTclustered | gi|2707359366|ref|XR_010293135.1| | 7653 | g144271 | i0 | 100 | 0.166172106824926 | 28 | 0 | 8 | 0 | 26 | 53 | 5631 | 5658 | PREDICTED: Lytechinus pictus uncharacterized LOC129256177 (LOC129256177), ncRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 19482121 | 19482121 | PRJNA1249535_S_NODE_176096_length_319_cov_4.585366_g172713_i0 | PRJNA1249535 | 176096 | 319 | 4.585366 | 14.62731754 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|2707354388|ref|XM_064096696.1| | 7653 | g172713 | i0 | 90.476 | 0.13166144200627 | 42 | 4 | 13 | 0 | 138 | 179 | 2190 | 2231 | PREDICTED: Lytechinus pictus uncharacterized LOC129257557 (LOC129257557), mRNA | blastn | 42 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 19485187 | 19485187 | PRJNA1249535_S_NODE_91296_length_385_cov_3.589744_g87914_i0 | PRJNA1249535 | 91296 | 385 | 3.589744 | 13.8205144 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.037 | NTclustered | gi|2707400012|ref|XM_064112790.1| | 7653 | g87914 | i0 | 100 | 0.0727272727272727 | 28 | 0 | 7 | 0 | 79 | 106 | 1953 | 1926 | PREDICTED: Lytechinus pictus uncharacterized LOC129282141 (LOC129282141), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 22032965 | 22032965 | PRJNA1249535_S_NODE_186778_length_313_cov_5.316667_g183395_i0 | PRJNA1249535 | 186778 | 313 | 5.316667 | 16.64116771 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 52.8 | 0.029 | NTclustered | gi|1834282974|ref|XM_033786542.1| | 7604 | g183395 | i0 | 100 | 0.447284345047923 | 28 | 0 | 9 | 0 | 236 | 263 | 5560 | 5587 | PREDICTED: Asterias rubens uncharacterized LOC117302549 (LOC117302549), transcript variant X3, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 24584971 | 24584971 | PRJNA1249535_S_NODE_62460_length_439_cov_1.642077_g59086_i0 | PRJNA1249535 | 62460 | 439 | 1.642077 | 7.20871803 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.042 | NTclustered | gi|2707364290|ref|XM_064108056.1| | 7653 | g59086 | i0 | 92.105 | 0.0865603644646925 | 38 | 2 | 9 | 1 | 255 | 292 | 4191 | 4155 | PREDICTED: Lytechinus pictus C-terminal-binding protein 1-like (LOC129273295), mRNA | blastn | 38 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus |
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);;