RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA689790" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA689790 · 3 ✖

analysis 1

  • blastn · 3 ✖
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
7047359 7047359 PRJNA689790_S_NODE_6546_length_233_cov_1.790816_g6431_i0 PRJNA689790 6546 233 1.790816 4.17260128 Strongylocentrotus purpuratus 7668 Echinodermata other_Eukaryota 65.8 2.68e-6   NTclustered gi|1752396283|ref|XM_031000104.1| 7668 g6431 i0 100 14.1502145922747 35 0 15 0 1 35 4457 4491 PREDICTED: Strongylocentrotus purpuratus selenocysteine insertion sequence-binding protein 2-like (LOC584318), mRNA blastn 3297 65.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Camarodonta Strongylocentrotidae Strongylocentrotus Strongylocentrotus purpuratus
18520830 18520830 PRJNA689790_S_NODE_8255_length_205_cov_3.202381_g8140_i0 PRJNA689790 8255 205 3.202381 6.56488105 Patiria miniata 46514 Echinodermata other_Eukaryota 134 6.2100000000000006e-27   NTclustered gi|1944901330|ref|XM_038207541.1| 46514 g8140 i0 80.214 0.91219512195122 187 29 89 7 14 196 691 509 PREDICTED: Patiria miniata 60S ribosomal protein L5-like (LOC119734187), mRNA blastn 187 134 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
19029821 19029821 PRJNA689790_S_NODE_8775_length_199_cov_2.462963_g8660_i0 PRJNA689790 8775 199 2.462963 4.90129637 Opisthokonta 33154 Echinodermata other_Eukaryota 196 7.539999999999999e-46   NTclustered gi|46909244|gb|AY580216.1| 7632 g8660 i0 84.422 101.115577889447 199 31 100 0 1 199 775 577 Eucidaris tribuloides ATP synthase beta subunit mRNA, partial cds blastn 20122 196 1 Eukaryota Opisthokonta Metazoa Echinodermata Echinoidea Cidaroida Cidaridae Eucidaris Eucidaris tribuloides

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