RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA611476" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA611476 · 6 ✖

analysis 1

  • blastn · 6 ✖
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
1865026 1865026 PRJNA611476_P_NODE_14602_length_514_cov_1.857143_g13812_i0 PRJNA611476 14602 514 1.857143 9.54571502 Acanthaster planci 133434 Echinodermata other_Eukaryota 353 1.23e-92   NTclustered gi|1229151045|ref|XM_022232375.1| 133434 g13812 i0 82.284 83.0466926070039 429 57 83 12 56 482 950 539 PREDICTED: Acanthaster planci uncharacterized LOC110977866 (LOC110977866), mRNA blastn 42686 353 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
6968298 6968298 PRJNA611476_P_NODE_76906_length_253_cov_1.316667_g76115_i0 PRJNA611476 76906 253 1.316667 3.33116751 Patiria miniata 46514 Echinodermata other_Eukaryota 134 7.970000000000001e-27   NTclustered gi|1944901884|ref|XM_038207740.1| 46514 g76115 i0 83.007 19.5217391304348 153 21 60 4 25 176 880 732 PREDICTED: Patiria miniata serine/threonine-protein phosphatase 6 catalytic subunit (LOC119734310), mRNA blastn 4939 134 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
10793555 10793555 PRJNA611476_P_NODE_31509_length_369_cov_1.040541_g30718_i0 PRJNA611476 31509 369 1.040541 3.83959629 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 60.2 2.1e-4   NTclustered gi|1752345424|ref|XM_030978805.1| 7668 g30718 i0 91.111 0.121951219512195 45 3 12 1 239 282 3498 3542 PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC585630 (LOC585630), mRNA blastn 45 60.2 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
10793615 10793615 PRJNA611476_P_NODE_36469_length_349_cov_0.992754_g35678_i0 PRJNA611476 36469 349 0.992754 3.46471146 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 52.8 0.033   NTclustered gi|1752391288|ref|XR_004066438.1| 7668 g35678 i0 100 0.0802292263610315 28 0 8 0 46 73 8405 8432 PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC115929351 (LOC115929351), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
17167813 17167813 PRJNA611476_P_NODE_77614_length_252_cov_1.016760_g76823_i0 PRJNA611476 77614 252 1.01676 2.5622352 Lytechinus variegatus 7654 Echinodermata other_Eukaryota 52.8 0.023   NTclustered gi|2037986643|ref|XM_041606037.1| 7654 g76823 i0 100 0.666666666666667 28 0 11 0 4 31 1674 1701 PREDICTED: Lytechinus variegatus SH3 domain-containing kinase-binding protein 1-like (LOC121413275), transcript variant X3, mRNA blastn 168 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Temnopleuroida Toxopneustidae Lytechinus Lytechinus variegatus
22266777 22266777 PRJNA611476_P_NODE_52998_length_300_cov_1.356828_g52207_i0 PRJNA611476 52998 300 1.356828 4.070484 Strongylocentrotus droebachiensis 7671 Echinodermata other_Eukaryota 102 2.73e-17   NTclustered gi|397782121|gb|JQ317299.1| 7671 g52207 i0 88.372 3.49333333333333 86 8 29 2 203 288 248 165 Strongylocentrotus droebachiensis heat shock cognate protein 70 mRNA, partial cds blastn 1048 102 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus droebachiensis

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