RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA453567 · 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
1716703 1716703 PRJNA453567_P_NODE_23982_length_179_cov_1.647887_g23745_i0 PRJNA453567 23982 179 1.647887 2.94971773 Sycon ciliatum 27933 Porifera other_Eukaryota 145 2.43e-30   NTclustered gi|2732900686|ref|XM_065338289.1| 27933 g23745 i0 84.828 1.58100558659218 145 20 80 2 14 157 2192 2049 PREDICTED: Sycon ciliatum major vault protein-like (LOC135825668), mRNA blastn 283 145 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
10645682 10645682 PRJNA453567_P_NODE_21309_length_191_cov_1.142857_g21072_i0 PRJNA453567 21309 191 1.142857 2.18285687 Sycon ciliatum 27933 Porifera other_Eukaryota 60.2 9.82e-5   NTclustered gi|2732902150|ref|XM_065339018.1| 27933 g21072 i0 92.683 0.214659685863874 41 3 21 0 34 74 1649 1689 PREDICTED: Sycon ciliatum ADP-ribosylarginine hydrolase Tri1-like (LOC135826401), mRNA blastn 41 60.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
23394097 23394097 PRJNA453567_P_NODE_339_length_1743_cov_4.063306_g308_i0 PRJNA453567 339 1743 4.063306 70.82342358 Sycon ciliatum 27933 Porifera other_Eukaryota 56.5 0.014   NTclustered gi|2732937507|ref|XM_065335895.1| 27933 g308 i0 100 0.100401606425703 30 0 2 0 1165 1194 1338 1309 PREDICTED: Sycon ciliatum polyamine-modulated factor 1-binding protein 1-like (LOC135823065), mRNA blastn 175 56.5 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum

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