RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "blastn", bioproject = "PRJNA1122875" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1122875 · 13 ✖

analysis 1

  • blastn · 13 ✖
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
2828174 2828174 PRJNA1122875_P_NODE_20903_length_364_cov_1.240550_g20679_i0 PRJNA1122875 20903 364 1.24055 4.515602 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 490 6.18e-134   NTclustered gi|1752378812|ref|XM_030992750.1| 7668 g20679 i0 90.934 86.5796703296703 364 33 100 0 1 364 551 188 PREDICTED: Strongylocentrotus purpuratus 60S ribosomal protein L12 (LOC576067), mRNA blastn 31515 490 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
4104932 4104932 PRJNA1122875_P_NODE_49024_length_245_cov_1.790698_g48800_i0 PRJNA1122875 49024 245 1.790698 4.3872101 Heliocidaris crassispina 1043166 Echinodermata other_Eukaryota 448 2.41e-121   NTclustered gi|2188572302|gb|MN275902.1| 1043166 g48800 i0 99.592 83.930612244898 245 1 100 0 1 245 8118 7874 Heliocidaris crassispina isolate zs1 mitochondrion, complete genome blastn 20563 448 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinometridae Heliocidaris Heliocidaris crassispina
5380944 5380944 PRJNA1122875_P_NODE_46305_length_248_cov_0.880000_g46081_i0 PRJNA1122875 46305 248 0.88 2.1824 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 353 5.49e-93   NTclustered gi|1752400306|ref|XM_030972964.1| 7668 g46081 i0 92.339 95.5362903225806 248 19 100 0 1 248 481 234 PREDICTED: Strongylocentrotus purpuratus 60S ribosomal protein L23 (LOC115919367), mRNA blastn 23693 353 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
6655420 6655420 PRJNA1122875_P_NODE_26126_length_324_cov_1.023904_g25902_i0 PRJNA1122875 26126 324 1.023904 3.31744896 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 387 7.35e-103   NTclustered gi|1752391227|ref|XM_030998163.1| 7668 g25902 i0 88.308 1.00308641975309 325 35 99 3 1 323 1055 732 PREDICTED: Strongylocentrotus purpuratus 60S ribosomal protein L5 (LOC752626), mRNA blastn 325 387 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
9205675 9205675 PRJNA1122875_P_NODE_35728_length_277_cov_1.700980_g35504_i0 PRJNA1122875 35728 277 1.70098 4.7117146 Heliocidaris crassispina 1043166 Echinodermata other_Eukaryota 512 9.73e-141   NTclustered gi|2188572302|gb|MN275902.1| 1043166 g35504 i0 100 89.2238267148014 277 0 100 0 1 277 7143 6867 Heliocidaris crassispina isolate zs1 mitochondrion, complete genome blastn 24715 512 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinometridae Heliocidaris Heliocidaris crassispina
9205791 9205791 PRJNA1122875_P_NODE_46048_length_248_cov_1.417143_g45824_i0 PRJNA1122875 46048 248 1.417143 3.51451464 Lytechinus pictus 7653 Echinodermata other_Eukaryota 52.8 0.022   NTclustered gi|2707444784|ref|XM_054907488.2| 7653 g45824 i0 96.875 0.129032258064516 32 0 13 1 127 157 2615 2646 PREDICTED: Lytechinus pictus G patch domain and ankyrin repeat-containing protein 1-like (LOC129270077), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus pictus
11756173 11756173 PRJNA1122875_P_NODE_31310_length_292_cov_0.958904_g31086_i0 PRJNA1122875 31310 292 0.958904 2.79999968 Heliocidaris crassispina 1043166 Echinodermata other_Eukaryota 501 2.24e-137   NTclustered gi|2188572302|gb|MN275902.1| 1043166 g31086 i0 97.603 62.708904109589 292 7 100 0 1 292 8427 8136 Heliocidaris crassispina isolate zs1 mitochondrion, complete genome blastn 18311 501 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinometridae Heliocidaris Heliocidaris crassispina
13031191 13031191 PRJNA1122875_P_NODE_20071_length_372_cov_1.030100_g19847_i0 PRJNA1122875 20071 372 1.0301 3.831972 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 414 3.92e-111   NTclustered gi|1752354982|ref|XM_790334.5| 7668 g19847 i0 88.406 27.0349462365591 345 38 92 2 30 372 579 235 PREDICTED: Strongylocentrotus purpuratus 40S ribosomal protein S12 (LOC590740), mRNA blastn 10057 414 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
13031550 13031550 PRJNA1122875_P_NODE_51771_length_243_cov_0.905882_g51547_i0 PRJNA1122875 51771 243 0.905882 2.20129326 Heliocidaris crassispina 1043166 Echinodermata other_Eukaryota 438 1.4399999999999996e-118   NTclustered gi|2188572302|gb|MN275902.1| 1043166 g51547 i0 99.177 5.32510288065844 243 2 100 0 1 243 2772 2530 Heliocidaris crassispina isolate zs1 mitochondrion, complete genome blastn 1294 438 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinometridae Heliocidaris Heliocidaris crassispina
13031632 13031632 PRJNA1122875_P_NODE_7791_length_583_cov_1.078431_g7573_i0 PRJNA1122875 7791 583 1.078431 6.28725273 Heliocidaris crassispina 1043166 Echinodermata other_Eukaryota 1072 0   NTclustered gi|2188572302|gb|MN275902.1| 1043166 g7573 i0 99.828 96.3550600343053 583 1 100 0 1 583 6481 5899 Heliocidaris crassispina isolate zs1 mitochondrion, complete genome blastn 56175 1072 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinometridae Heliocidaris Heliocidaris crassispina
15580453 15580453 PRJNA1122875_P_NODE_27753_length_313_cov_1.154167_g27529_i0 PRJNA1122875 27753 313 1.154167 3.61254271 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 431 3.22e-116   NTclustered gi|1752353792|ref|XM_779989.5| 7668 g27529 i0 91.64 3.93610223642173 311 26 99 0 1 311 116 426 PREDICTED: Strongylocentrotus purpuratus 60S ribosomal protein L35a (LOC579897), mRNA blastn 1232 431 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
20679056 20679056 PRJNA1122875_P_NODE_29477_length_302_cov_0.956332_g29253_i0 PRJNA1122875 29477 302 0.956332 2.88812264 Heliocidaris crassispina 1043166 Echinodermata other_Eukaryota 553 6.32e-153   NTclustered gi|2188572302|gb|MN275902.1| 1043166 g29253 i0 99.669 99.9735099337748 302 1 100 0 1 302 14851 15152 Heliocidaris crassispina isolate zs1 mitochondrion, complete genome blastn 30192 553 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinometridae Heliocidaris Heliocidaris crassispina
21954613 21954613 PRJNA1122875_P_NODE_47578_length_247_cov_0.885057_g47354_i0 PRJNA1122875 47578 247 0.885057 2.18609079 Heliocidaris crassispina 1043166 Echinodermata other_Eukaryota 451 1.88e-122   NTclustered gi|55166884|dbj|AB178514.1| 1043166 g47354 i0 99.595 3 247 1 100 0 1 247 775 529 Heliocidaris crassispina mitochondrial ND2 gene for NADH dehydrogenase subunit 2, complete cds blastn 741 451 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Echinometridae Heliocidaris Heliocidaris crassispina

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