RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA1186363" 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

  • PRJNA1186363 · 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
319883 319883 PRJNA1186363_P_NODE_40981_length_248_cov_0.891429_g40093_i0 PRJNA1186363 40981 248 0.891429 2.21074392 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 63.9 1.04e-5   NTclustered gi|1752384678|ref|XM_003724180.3| 7668 g40093 i0 100 5.37096774193548 34 0 14 0 48 81 2564 2531 PREDICTED: Strongylocentrotus purpuratus uncharacterized LOC100893552 (LOC100893552), mRNA blastn 1332 63.9 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
5422994 5422994 PRJNA1186363_P_NODE_8205_length_734_cov_43.588502_g7370_i0 PRJNA1186363 8205 734 43.588502 319.93960468 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 178 1.16e-39   NTclustered gi|1752399365|ref|XM_011667624.2| 7668 g7370 i0 83.077 30.8378746594005 195 33 27 0 254 448 389 583 PREDICTED: Strongylocentrotus purpuratus ATP synthase F(0) complex subunit C2, mitochondrial (LOC583818), mRNA blastn 22635 178 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
10523575 10523575 PRJNA1186363_P_NODE_7789_length_755_cov_2.068915_g6970_i0 PRJNA1186363 7789 755 2.068915 15.62030825 Patiria miniata 46514 Echinodermata other_Eukaryota 54.7 0.021   NTclustered gi|1944907194|ref|XM_038210461.1| 46514 g6970 i0 100 0.0384105960264901 29 0 4 0 43 71 898 870 PREDICTED: Patiria miniata microfibril-associated glycoprotein 4-like (LOC119736442), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
17619764 17619764 PRJNA1186363_P_NODE_10454_length_639_cov_1.830389_g9575_i0 PRJNA1186363 10454 639 1.830389 11.69618571 Metazoa 33208 Echinodermata other_Eukaryota 76.8 3.77e-9   NTclustered gi|1834288451|ref|XM_033784271.1| 7604 g9575 i0 82.558 1.31298904538341 86 15 13 0 554 639 3795 3710 PREDICTED: Asterias rubens pumilio homolog 2-like (LOC117300609), transcript variant X2, mRNA blastn 839 76.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Forcipulatida Asteriidae Asterias Asterias rubens
24545653 24545653 PRJNA1186363_P_NODE_15480_length_501_cov_1.457944_g14594_i0 PRJNA1186363 15480 501 1.457944 7.30429944 Diadema antillarum 105358 Echinodermata other_Eukaryota 54.7 0.014   NTclustered gi|2919368438|ref|XR_011711507.1| 105358 g14594 i0 100 0.227544910179641 29 0 6 0 231 259 7524 7552 PREDICTED: Diadema antillarum uncharacterized protein (LOC139739272), transcript variant X1, misc_RNA blastn 114 54.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Diadematoida Diadematidae Diadema Diadema antillarum
24545814 24545814 PRJNA1186363_P_NODE_40340_length_249_cov_0.886364_g39452_i0 PRJNA1186363 40340 249 0.886364 2.20704636 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 174 4.61e-39   NTclustered gi|1752406886|ref|XM_030975522.1| 7668 g39452 i0 81.905 7.99196787148594 210 35 84 3 8 215 2132 2340 PREDICTED: Strongylocentrotus purpuratus E3 ubiquitin-protein ligase Su(dx) (LOC752270), mRNA blastn 1990 174 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus

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