RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA914897 · 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
7273256 7273256 PRJNA914897_P_NODE_4906_length_904_cov_2.969916_g4570_i0 PRJNA914897 4906 904 2.969916 26.84804064 Anneissia japonica 1529436 Echinodermata other_Eukaryota 100 3.21e-16   NTclustered gi|1826657558|ref|XM_033260641.1| 1529436 g4570 i0 82.456 0.126106194690265 114 20 13 0 433 546 1160 1273 PREDICTED: Anneissia japonica serine/threonine-protein kinase RIO1-like (LOC117116575), mRNA blastn 114 100 1 Eukaryota Opisthokonta Metazoa Echinodermata Crinoidea Comatulida Comatulidae Anneissia Anneissia japonica
16197868 16197868 PRJNA914897_P_NODE_38673_length_248_cov_0.880000_g38249_i0 PRJNA914897 38673 248 0.88 2.1824 Acanthaster planci 133434 Echinodermata other_Eukaryota 52.8 0.022   NTclustered gi|1229127568|ref|XM_022225570.1| 133434 g38249 i0 96.774 0.125 31 1 13 0 170 200 1053 1023 PREDICTED: Acanthaster planci tRNA methyltransferase 10 homolog A-like (LOC110974158), mRNA blastn 31 52.8 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
21653124 21653124 PRJNA914897_P_NODE_16237_length_435_cov_0.842541_g15815_i0 PRJNA914897 16237 435 0.842541 3.66505335 Metazoa 33208 Echinodermata other_Eukaryota 331 4.82e-86   NTclustered gi|1752383405|ref|XM_030994818.1| 7668 g15815 i0 86.084 72.832183908046 309 41 71 2 126 433 1332 1025 PREDICTED: Strongylocentrotus purpuratus tubulin alpha-1 chain-like (LOC115918924), mRNA blastn 31682 333 0.993993993993994 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);;