contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA796753" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3331805 | 3331805 | PRJNA796753_P_NODE_3623_length_699_cov_10.910543_g3334_i0 | PRJNA796753 | 3623 | 699 | 10.910543 | 76.26469557 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 331 | 8.01e-86 | NTclustered | gi|2919435354|ref|XM_071637819.1| | 105358 | g3334 | i0 | 79.825 | 50.4306151645207 | 456 | 90 | 65 | 2 | 14 | 468 | 32 | 486 | PREDICTED: Diadema antillarum ubiquitin-ribosomal protein eS31 fusion protein (LOC139726824), mRNA | blastn | 35251 | 331 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 4608992 | 4608992 | PRJNA796753_P_NODE_19724_length_331_cov_1.461240_g19412_i0 | PRJNA796753 | 19724 | 331 | 1.46124 | 4.8367044 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 202 | 2.92e-47 | NTclustered | gi|1944939444|ref|XM_038189959.1| | 46514 | g19412 | i0 | 78.37 | 0.963746223564955 | 319 | 63 | 95 | 6 | 1 | 316 | 601 | 916 | PREDICTED: Patiria miniata cilia- and flagella-associated protein 157-like (LOC119720318), mRNA | blastn | 319 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 5884164 | 5884164 | PRJNA796753_P_NODE_25185_length_299_cov_1.362832_g24873_i0 | PRJNA796753 | 25185 | 299 | 1.362832 | 4.07486768 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 58.4 | 5.98e-4 | NTclustered | gi|1944936574|ref|XM_038188521.1| | 46514 | g24873 | i0 | 89.362 | 0.62876254180602 | 47 | 3 | 15 | 2 | 44 | 89 | 1159 | 1204 | PREDICTED: Patiria miniata band 4.1-like protein 5 (LOC119719174), transcript variant X1, mRNA | blastn | 188 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 7159046 | 7159046 | PRJNA796753_P_NODE_24726_length_302_cov_1.008734_g24414_i0 | PRJNA796753 | 24726 | 302 | 1.008734 | 3.04637668 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 243 | 1.55e-59 | NTclustered | gi|1826629109|ref|XM_033247205.1| | 1529436 | g24414 | i0 | 81.333 | 19.6754966887417 | 300 | 54 | 99 | 2 | 2 | 300 | 802 | 1100 | PREDICTED: Anneissia japonica 26S proteasome regulatory subunit 6B (LOC117105901), mRNA | blastn | 5942 | 243 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 8433800 | 8433800 | PRJNA796753_P_NODE_30447_length_278_cov_1.878049_g30135_i0 | PRJNA796753 | 30447 | 278 | 1.878049 | 5.22097622 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 189 | 1.87e-43 | NTclustered | gi|1944938040|ref|XM_038189225.1| | 46514 | g30135 | i0 | 87.654 | 39.3525179856115 | 162 | 20 | 58 | 0 | 2 | 163 | 1075 | 914 | PREDICTED: Patiria miniata guanine nucleotide-binding protein alpha-2 subunit-like (LOC119719727), mRNA | blastn | 10940 | 189 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 9709095 | 9709095 | PRJNA796753_P_NODE_7728_length_491_cov_1.825359_g7417_i0 | PRJNA796753 | 7728 | 491 | 1.825359 | 8.96251269 | Asterias rubens | 7604 | Echinodermata | other_Eukaryota | 215 | 5.77e-51 | NTclustered | gi|1834292503|ref|XM_033789944.1| | 7604 | g7417 | i0 | 78.274 | 20.050916496945 | 336 | 71 | 68 | 2 | 80 | 414 | 127 | 461 | PREDICTED: Asterias rubens 60S ribosomal protein L27a-like (LOC117305153), mRNA | blastn | 9845 | 215 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 10984669 | 10984669 | PRJNA796753_P_NODE_3269_length_733_cov_16.412121_g2986_i0 | PRJNA796753 | 3269 | 733 | 16.412121 | 120.30084693 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 401 | 6.329999999999999e-107 | NTclustered | gi|1229182411|ref|XM_022249129.1| | 133434 | g2986 | i0 | 82.43 | 82.3888130968622 | 461 | 79 | 63 | 2 | 220 | 679 | 526 | 67 | PREDICTED: Acanthaster planci ubiquitin-40S ribosomal protein S27a (LOC110986865), mRNA | blastn | 60391 | 401 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 13534473 | 13534473 | PRJNA796753_P_NODE_48551_length_245_cov_0.895349_g48239_i0 | PRJNA796753 | 48551 | 245 | 0.895349 | 2.19360505 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 60.2 | 1.32e-4 | NTclustered | gi|1944902792|ref|XM_038208151.1| | 46514 | g48239 | i0 | 97.222 | 0.502040816326531 | 36 | 0 | 15 | 1 | 89 | 124 | 1067 | 1101 | PREDICTED: Patiria miniata putative uncharacterized protein DDB_G0271606 (LOC119734615), mRNA | blastn | 123 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 16083122 | 16083122 | PRJNA796753_P_NODE_1313_length_1072_cov_4.856857_g1127_i0 | PRJNA796753 | 1313 | 1072 | 4.856857 | 52.06550704 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 183 | 3.699999999999999e-41 | NTclustered | gi|2919509818|ref|XM_071651395.1| | 105358 | g1127 | i0 | 91.111 | 12.6315298507463 | 135 | 12 | 13 | 0 | 938 | 1072 | 416 | 282 | PREDICTED: Diadema antillarum histone H3, embryonic (LOC139740824), mRNA | blastn | 13541 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 21183313 | 21183313 | PRJNA796753_P_NODE_54957_length_235_cov_2.432099_g54645_i0 | PRJNA796753 | 54957 | 235 | 2.432099 | 5.71543265 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 84.2 | 7.47e-12 | NTclustered | gi|1944859319|ref|XM_038195795.1| | 46514 | g54645 | i0 | 77.059 | 3.37021276595745 | 170 | 24 | 77 | 10 | 12 | 178 | 1401 | 1244 | PREDICTED: Patiria miniata aspartyl/asparaginyl beta-hydroxylase-like (LOC119724648), mRNA | blastn | 792 | 84.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 22457981 | 22457981 | PRJNA796753_P_NODE_5398_length_581_cov_3.765748_g5091_i0 | PRJNA796753 | 5398 | 581 | 3.765748 | 21.87899588 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 183 | 1.95e-41 | NTclustered | gi|1752399365|ref|XM_011667624.2| | 7668 | g5091 | i0 | 83.59 | 38.7538726333907 | 195 | 32 | 34 | 0 | 130 | 324 | 583 | 389 | PREDICTED: Strongylocentrotus purpuratus ATP synthase F(0) complex subunit C2, mitochondrial (LOC583818), mRNA | blastn | 22516 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 22894368 | 22894368 | PRJNA796753_P_NODE_49918_length_244_cov_0.900585_g49606_i0 | PRJNA796753 | 49918 | 244 | 0.900585 | 2.1974274 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 54.7 | 0.006 | NTclustered | gi|1944913393|ref|XM_038213593.1| | 46514 | g49606 | i0 | 100 | 2.9672131147541 | 29 | 0 | 12 | 0 | 49 | 77 | 1135 | 1163 | PREDICTED: Patiria miniata septin-7-like (LOC119738680), transcript variant X2, mRNA | blastn | 724 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 25007261 | 25007261 | PRJNA796753_P_NODE_5600_length_571_cov_1.353414_g5292_i0 | PRJNA796753 | 5600 | 571 | 1.353414 | 7.72799394 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 224 | 1.13e-53 | NTclustered | gi|1944923555|ref|XM_038218481.1| | 46514 | g5292 | i0 | 80.836 | 29.3905429071804 | 287 | 53 | 50 | 2 | 1 | 286 | 1973 | 2258 | PREDICTED: Patiria miniata major vault protein-like (LOC119742522), mRNA | blastn | 16782 | 224 | 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);;