RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1148190 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
1566389 1566389 PRJNA1148190_P_NODE_180962_length_393_cov_1.609375_g169793_i0 PRJNA1148190 180962 393 1.609375 6.32484375 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 62.1 6.25e-5   NTclustered gi|2038004331|ref|XM_041615407.1| 7654 g169793 i0 93.023 0.193384223918575 43 2 11 1 18 60 1973 1932 PREDICTED: Lytechinus variegatus guanylate cyclase soluble subunit beta-2-like (LOC121420763), mRNA blastn 76 62.1 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
2847076 2847076 PRJNA1148190_P_NODE_472483_length_272_cov_1.276382_g461310_i0 PRJNA1148190 472483 272 1.276382 3.47175904 Anneissia japonica 1529436 Echinodermata other_Eukaryota 54.7 0.007   NTclustered gi|1826612771|ref|XM_033240095.1| 1529436 g461310 i0 94.444 0.132352941176471 36 1 13 1 235 270 2199 2233 PREDICTED: Anneissia japonica phytanoyl-CoA dioxygenase domain-containing protein 1-like (LOC117100418), mRNA blastn 36 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
5401595 5401595 PRJNA1148190_P_NODE_649165_length_248_cov_0.880000_g637992_i0 PRJNA1148190 649165 248 0.88 2.1824 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 52.8 0.022   NTclustered gi|2037925951|ref|XM_041623394.1| 7654 g637992 i0 100 0.564516129032258 28 0 11 0 125 152 8001 7974 PREDICTED: Lytechinus variegatus diacylglycerol kinase theta-like (LOC121427055), transcript variant X4, mRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
6670073 6670073 PRJNA1148190_P_NODE_206706_length_371_cov_1.761745_g195536_i0 PRJNA1148190 206706 371 1.761745 6.53607395 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.035   NTclustered gi|1752382611|ref|XM_030994477.1| 7668 g195536 i0 100 0.377358490566038 28 0 8 0 31 58 3112 3139 PREDICTED: Strongylocentrotus purpuratus ensconsin (LOC586167), transcript variant X3, mRNA blastn 140 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
9225883 9225883 PRJNA1148190_P_NODE_599808_length_250_cov_1.502825_g588635_i0 PRJNA1148190 599808 250 1.502825 3.7570625 Lytechinus pictus 7653 Echinodermata other_Eukaryota 52.8 0.023   NTclustered gi|2707407773|ref|XM_054912244.2| 7653 g588635 i0 96.875 0.128 32 0 13 1 66 97 3933 3903 PREDICTED: Lytechinus pictus melatonin receptor type 1B-B-like (LOC129275754), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
10498484 10498484 PRJNA1148190_P_NODE_377529_length_291_cov_1.211009_g366356_i0 PRJNA1148190 377529 291 1.211009 3.52403619 Anneissia japonica 1529436 Echinodermata other_Eukaryota 54.7 0.007   NTclustered gi|1826654567|ref|XM_033259352.1| 1529436 g366356 i0 100 0.199312714776632 29 0 10 0 48 76 1854 1826 PREDICTED: Anneissia japonica uncharacterized LOC117115516 (LOC117115516), transcript variant X2, mRNA blastn 58 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
13044640 13044640 PRJNA1148190_P_NODE_135691_length_452_cov_1.216359_g124527_i0 PRJNA1148190 135691 452 1.216359 5.49794268 Patiria miniata 46514 Echinodermata other_Eukaryota 76.8 2.6e-9   NTclustered gi|1944862406|ref|XM_038196917.1| 46514 g124527 i0 74.866 0.827433628318584 187 37 40 10 150 331 723 542 PREDICTED: Patiria miniata myb-related protein A-like (LOC119725505), transcript variant X1, mRNA blastn 374 76.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
14328709 14328709 PRJNA1148190_P_NODE_747512_length_243_cov_0.905882_g736339_i0 PRJNA1148190 747512 243 0.905882 2.20129326 Patiria miniata 46514 Echinodermata other_Eukaryota 106 1.66e-18   NTclustered gi|1944924273|ref|XM_038218757.1| 46514 g736339 i0 87.778 6.32921810699589 90 11 37 0 5 94 299 210 PREDICTED: Patiria miniata ras-related protein ORAB-1 (LOC119742629), mRNA blastn 1538 106 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
15063978 15063978 PRJNA1148190_P_NODE_756292_length_242_cov_1.366864_g745119_i0 PRJNA1148190 756292 242 1.366864 3.30781088 Lytechinus 7652 Echinodermata other_Eukaryota 54.7 0.006   NTclustered gi|2707360271|ref|XM_054894792.2| 7653 g745119 i0 100 0.359504132231405 29 0 12 0 16 44 1096 1068 PREDICTED: Lytechinus pictus high mobility group protein 20A-like (LOC129256633), mRNA blastn 87 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
16871781 16871781 PRJNA1148190_P_NODE_370414_length_293_cov_1.400000_g359241_i0 PRJNA1148190 370414 293 1.4 4.102 Anneissia japonica 1529436 Echinodermata other_Eukaryota 54.7 0.008   NTclustered gi|1826627737|ref|XR_004444886.1| 1529436 g359241 i0 100 0.0989761092150171 29 0 10 0 165 193 1311 1283 PREDICTED: Anneissia japonica uncharacterized LOC117105355 (LOC117105355), ncRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
19416530 19416530 PRJNA1148190_P_NODE_107176_length_514_cov_1.346939_g96018_i0 PRJNA1148190 107176 514 1.346939 6.92326646 Diadema antillarum 105358 Echinodermata other_Eukaryota 54.7 0.014   NTclustered gi|2919514998|ref|XM_071652323.1| 105358 g96018 i0 100 0.056420233463035 29 0 6 0 14 42 4250 4278 PREDICTED: Diadema antillarum ATP-binding cassette sub-family C member 4-like (LOC139741739), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
21972965 21972965 PRJNA1148190_P_NODE_475118_length_271_cov_1.888889_g463945_i0 PRJNA1148190 475118 271 1.888889 5.11888919 Anneissia japonica 1529436 Echinodermata other_Eukaryota 52.8 0.025   NTclustered gi|1826644966|ref|XM_033254746.1| 1529436 g463945 i0 100 0.103321033210332 28 0 10 0 83 110 386 413 PREDICTED: Anneissia japonica uncharacterized LOC117111749 (LOC117111749), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
21973687 21973687 PRJNA1148190_P_NODE_527998_length_261_cov_1.510638_g516825_i0 PRJNA1148190 527998 261 1.510638 3.94276518 Asterias rubens 7604 Echinodermata other_Eukaryota 52.8 0.024   NTclustered gi|1834283071|ref|XM_033787036.1| 7604 g516825 i0 100 0.10727969348659 28 0 11 0 34 61 2902 2875 PREDICTED: Asterias rubens NACHT domain- and WD repeat-containing protein 1-like (LOC117303005), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
24525288 24525288 PRJNA1148190_P_NODE_719580_length_244_cov_0.900585_g708407_i0 PRJNA1148190 719580 244 0.900585 2.1974274 Anneissia japonica 1529436 Echinodermata other_Eukaryota 58.4 4.73e-4   NTclustered gi|1826616428|ref|XM_033241106.1| 1529436 g708407 i0 92.683 0.504098360655738 41 1 16 2 197 236 1190 1229 PREDICTED: Anneissia japonica ribonuclease T2-like (LOC117101198), transcript variant X3, mRNA blastn 123 58.4 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica

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