RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA270367" and tax_phylum = "Echinodermata"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Echinodermata · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA270367 · 4 ✖

analysis 1

  • blastn · 4 ✖
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
1644656 1644656 PRJNA270367_P_NODE_10122_length_418_cov_2.271003_g9920_i0 PRJNA270367 10122 418 2.271003 9.49279254 Acanthaster planci 133434 Echinodermata other_Eukaryota 132 5.02e-26   NTclustered gi|1229163567|ref|XM_022239112.1| 133434 g9920 i0 77.477 2.90430622009569 222 48 53 2 6 226 218 438 PREDICTED: Acanthaster planci 60S ribosomal protein L24-like (LOC110981500), mRNA blastn 1214 132 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
14399034 14399034 PRJNA270367_P_NODE_27472_length_216_cov_1.245509_g27267_i0 PRJNA270367 27472 216 1.245509 2.69029944 Acanthaster planci 133434 Echinodermata other_Eukaryota 196 8.319999999999999e-46   NTclustered gi|1229177987|ref|XM_022246756.1| 133434 g27267 i0 83.981 94.9953703703704 206 31 95 2 8 212 630 426 PREDICTED: Acanthaster planci 40S ribosomal protein SA-like (LOC110985616), transcript variant X2, mRNA blastn 20519 196 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci
16947445 16947445 PRJNA270367_P_NODE_33474_length_189_cov_2.228571_g33269_i0 PRJNA270367 33474 189 2.228571 4.21199919 Patiria miniata 46514 Echinodermata other_Eukaryota 78.7 2.68e-10   NTclustered gi|1944906316|ref|XM_038209998.1| 46514 g33269 i0 79.817 17.5767195767196 109 20 57 2 1 108 269 162 PREDICTED: Patiria miniata 40S ribosomal protein S25-like (LOC119736015), mRNA blastn 3322 78.7 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Asterinidae Patiria Patiria miniata
18221547 18221547 PRJNA270367_P_NODE_13755_length_350_cov_2.000000_g13550_i0 PRJNA270367 13755 350 2 7 Acanthaster planci 133434 Echinodermata other_Eukaryota 267 1.08e-66   NTclustered gi|1229143321|ref|XM_022228209.1| 133434 g13550 i0 81.905 94.1971428571429 315 57 91 0 34 348 522 208 PREDICTED: Acanthaster planci calmodulin-like protein 12 (LOC110975611), mRNA blastn 32969 267 1 Eukaryota Opisthokonta Metazoa Echinodermata Asteroidea Valvatida Acanthasteridae Acanthaster Acanthaster planci

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