RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "blastn", bioproject = "PRJNA690592" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 18 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA690592 · 18 ✖

analysis 1

  • blastn · 18 ✖
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
1946825 1946825 PRJNA690592_S_NODE_114342_length_310_cov_1.835443_g113328_i0 PRJNA690592 114342 310 1.835443 5.6898733 Diadema antillarum 105358 Echinodermata other_Eukaryota 148 3.5899999999999998e-31   NTclustered gi|2919420762|ref|XM_071635214.1| 105358 g113328 i0 81.283 25.8290322580645 187 31 60 4 27 211 1187 1371 PREDICTED: Diadema antillarum alpha-enolase-like (LOC139724015), mRNA blastn 8007 148 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
4499625 4499625 PRJNA690592_S_NODE_24224_length_610_cov_2.378026_g23234_i0 PRJNA690592 24224 610 2.378026 14.5059586 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 76.8 3.59e-9   NTclustered gi|1752382759|ref|XM_030994536.1| 7668 g23234 i0 82.759 0.511475409836066 87 13 14 2 353 438 981 896 PREDICTED: Strongylocentrotus purpuratus peptidyl-prolyl cis-trans isomerase sig-7 (LOC100892657), transcript variant X2, mRNA blastn 312 76.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
4499799 4499799 PRJNA690592_S_NODE_45384_length_458_cov_2.638961_g44370_i0 PRJNA690592 45384 458 2.638961 12.08644138 Diadema antillarum 105358 Echinodermata other_Eukaryota 178 7.03e-40   NTclustered gi|2919389732|ref|XM_071629686.1| 105358 g44370 i0 74.347 10.1397379912664 421 106 92 2 37 456 625 1044 PREDICTED: Diadema antillarum uncharacterized protein (LOC139718207), mRNA blastn 4644 178 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
5007240 5007240 PRJNA690592_S_NODE_113584_length_311_cov_1.613445_g112570_i0 PRJNA690592 113584 311 1.613445 5.01781395 Opisthokonta 33154 Echinodermata other_Eukaryota 231 3.4799999999999996e-56   NTclustered gi|2707365836|ref|XM_054916537.2| 7653 g112570 i0 82.331 76.9710610932476 266 47 86 0 6 271 529 264 PREDICTED: Lytechinus pictus small ribosomal subunit protein uS10-like (LOC129280523), mRNA blastn 23938 233 0.991416309012876 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
5775450 5775450 PRJNA690592_S_NODE_64545_length_393_cov_15.268750_g63531_i0 PRJNA690592 64545 393 15.26875 60.0061875 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 54.7 0.01   NTclustered gi|2037991158|ref|XM_041608433.1| 7654 g63531 i0 96.875 0.895674300254453 32 1 8 0 248 279 86 55 PREDICTED: Lytechinus variegatus histone H1.1, embryonic-like (LOC121415250), mRNA blastn 352 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
8324560 8324560 PRJNA690592_S_NODE_204687_length_245_cov_0.860465_g203673_i0 PRJNA690592 204687 245 0.860465 2.10813925 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 63.9 1.02e-5   NTclustered gi|2037925573|ref|XM_041621827.1| 7654 g203673 i0 95 1.28571428571429 40 2 16 0 68 107 1139 1178 PREDICTED: Lytechinus variegatus helicase with zinc finger domain 2-like (LOC121425670), transcript variant X1, mRNA blastn 315 63.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
9599591 9599591 PRJNA690592_S_NODE_157228_length_271_cov_1.555556_g156214_i0 PRJNA690592 157228 271 1.555556 4.21555676 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 171 6.58e-38   NTclustered gi|2037991336|ref|XM_041608522.1| 7654 g156214 i0 82.741 15.590405904059 197 28 72 4 1 194 713 906 PREDICTED: Lytechinus variegatus ribosome biogenesis protein NSA2 homolog (LOC121415344), mRNA blastn 4225 171 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
9600300 9600300 PRJNA690592_S_NODE_57388_length_414_cov_1.774194_g56374_i0 PRJNA690592 57388 414 1.774194 7.34516316 Capillaster sp. DH-Y2 3038058 Echinodermata other_Eukaryota 193 2.25e-44   NTclustered gi|2473919549|gb|OP546034.1| 3038058 g56374 i0 80.212 66.5990338164251 283 34 66 18 91 363 4314 4044 Capillaster sp. DH-Y2 mitochondrion, complete genome blastn 27572 193 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Capillaster Capillaster sp. DH-Y2
10875175 10875175 PRJNA690592_S_NODE_162189_length_267_cov_1.943299_g161175_i0 PRJNA690592 162189 267 1.943299 5.18860833 Patiria miniata 46514 Echinodermata other_Eukaryota 58.4 5.25e-4   NTclustered gi|1944934410|ref|XM_038222831.1| 46514 g161175 i0 100 0.340823970037453 31 0 12 0 30 60 1193 1163 PREDICTED: Patiria miniata serine-aspartate repeat-containing protein F-like (LOC119746059), transcript variant X2, mRNA blastn 91 58.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
13425535 13425535 PRJNA690592_S_NODE_37711_length_497_cov_18.341981_g36700_i0 PRJNA690592 37711 497 18.341981 91.15964557 Peniagone sp. AKM-2016 1902931 Echinodermata other_Eukaryota 52.8 0.049   NTclustered gi|1160550721|gb|KX856877.1| 1902931 g36700 i0 100 0.0563380281690141 28 0 6 0 470 497 857 830 Peniagone sp. AKM-2016 voucher SIO:BIC:E5608 28S ribosomal RNA gene, partial sequence blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Holothuroidea Elasipodida Elpidiidae Peniagone Peniagone sp. AKM-2016
14699669 14699669 PRJNA690592_S_NODE_107012_length_319_cov_1.178862_g105998_i0 PRJNA690592 107012 319 1.178862 3.76056978 Patiria miniata 46514 Echinodermata other_Eukaryota 65.8 3.84e-6   NTclustered gi|1944874129|ref|XM_038200792.1| 46514 g105998 i0 97.368 10.4200626959248 38 1 12 0 45 82 1024 1061 PREDICTED: Patiria miniata probable protein phosphatase 2C 60 (LOC119728520), mRNA blastn 3324 65.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
14700680 14700680 PRJNA690592_S_NODE_4192_length_1282_cov_3.722911_g3751_i0 PRJNA690592 4192 1282 3.722911 47.72771902 Lytechinus pictus 7653 Echinodermata other_Eukaryota 346 5.37e-90   NTclustered gi|2707400846|ref|XM_054917831.2| 7653 g3751 i0 83.158 12.6989079563183 380 62 30 1 822 1201 794 417 PREDICTED: Lytechinus pictus histone H2A.V (LOC129281901), mRNA blastn 16280 346 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
15974541 15974541 PRJNA690592_S_NODE_51353_length_434_cov_2.069252_g50339_i0 PRJNA690592 51353 434 2.069252 8.98055368 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 122 3.1499999999999995e-23   NTclustered gi|2037969038|ref|XM_041596501.1| 7654 g50339 i0 81.818 26.6428571428571 154 20 35 8 3 152 264 413 PREDICTED: Lytechinus variegatus late histone H2A.2.2-like (LOC121405574), mRNA blastn 11563 122 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
15974772 15974772 PRJNA690592_S_NODE_84293_length_351_cov_1.694245_g83279_i0 PRJNA690592 84293 351 1.694245 5.94679995 Acanthaster planci 133434 Echinodermata other_Eukaryota 224 6.639999999999999e-54   NTclustered gi|1229130570|ref|XM_022241757.1| 133434 g83279 i0 79.808 21.8945868945869 312 59 88 3 1 310 1001 692 PREDICTED: Acanthaster planci developmentally-regulated GTP-binding protein 1 (LOC110982944), transcript variant X1, mRNA blastn 7685 224 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
17248646 17248646 PRJNA690592_S_NODE_116694_length_308_cov_1.140426_g115680_i0 PRJNA690592 116694 308 1.140426 3.51251208 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 261 4.39e-65   NTclustered gi|1752364846|ref|XM_030986855.1| 7668 g115680 i0 83.571 69.9902597402597 280 44 91 2 1 279 359 81 PREDICTED: Strongylocentrotus purpuratus tubulin beta chain-like (LOC115924522), mRNA blastn 21557 261 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
17249029 17249029 PRJNA690592_S_NODE_165694_length_265_cov_1.182292_g164680_i0 PRJNA690592 165694 265 1.182292 3.1330738 Diadema antillarum 105358 Echinodermata other_Eukaryota 54.7 0.007   NTclustered gi|2919415389|ref|XM_071634272.1| 105358 g164680 i0 94.444 0.483018867924528 36 0 14 2 156 191 4288 4321 PREDICTED: Diadema antillarum tyrosine-protein phosphatase non-receptor type 23-like (LOC139722996), mRNA blastn 128 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
22348832 22348832 PRJNA690592_S_NODE_212998_length_242_cov_0.911243_g211984_i0 PRJNA690592 212998 242 0.911243 2.20520806 Acanthaster planci 133434 Echinodermata other_Eukaryota 154 5.81e-33   NTclustered gi|1229178978|ref|XM_022247298.1| 133434 g211984 i0 79.907 16.3264462809917 214 40 88 3 4 215 699 487 PREDICTED: Acanthaster planci ribosome biogenesis protein NSA2 homolog (LOC110985870), mRNA blastn 3951 154 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
22349423 22349423 PRJNA690592_S_NODE_91038_length_340_cov_1.655431_g90024_i0 PRJNA690592 91038 340 1.655431 5.6284654 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 60.2 1.92e-4   NTclustered gi|2037931603|ref|XM_041597475.1| 7654 g90024 i0 100 0.0941176470588235 32 0 9 0 9 40 958 927 PREDICTED: Lytechinus variegatus uncharacterized LOC121406465 (LOC121406465), mRNA blastn 32 60.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;