RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1028258" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 3 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1028258 · 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
164243 164243 PRJNA1028258_P_NODE_182221_length_195_cov_4.293651_g181657_i0 PRJNA1028258 182221 195 4.293651 8.37261945 Oscarella lobularis 121494 Porifera other_Eukaryota 75 3.6e-9   NTclustered gi|2746750386|ref|XM_065987665.1| 121494 g181657 i0 93.878 11.2615384615385 49 3 50 0 146 194 155 107 PREDICTED: Oscarella lobularis histone H2B-like (LOC136197827), mRNA blastn 2196 75 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
1439691 1439691 PRJNA1028258_P_NODE_47342_length_368_cov_1.866221_g46779_i0 PRJNA1028258 47342 368 1.866221 6.86769328 Suberites domuncula 55567 Porifera other_Eukaryota 303 8.74e-78   NTclustered gi|4150907|emb|Y18166.1| 55567 g46779 i0 81.694 98.9864130434783 366 65 99 2 2 366 88 452 Suberites domuncula mRNA for calmodulin blastn 36427 303 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
3990433 3990433 PRJNA1028258_P_NODE_154144_length_230_cov_0.881988_g153581_i0 PRJNA1028258 154144 230 0.881988 2.0285724 Amphimedon queenslandica 400682 Porifera other_Eukaryota 58.4 4.41e-4   NTclustered gi|1133484151|ref|XM_020004729.1| 400682 g153581 i0 97.059 0.147826086956522 34 1 15 0 119 152 276 243 PREDICTED: Amphimedon queenslandica mediator of RNA polymerase II transcription subunit 17-like (LOC105315016), mRNA blastn 34 58.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica

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