RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA685607" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 4 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA685607 · 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
9594896 9594896 PRJNA685607_P_NODE_35588_length_312_cov_1.372385_g35229_i0 PRJNA685607 35588 312 1.372385 4.2818412 Aphrocallistes beatrix 398365 Porifera other_Eukaryota 104 7.94e-18   NTclustered gi|222419933|emb|FM946126.1| 398365 g35229 i0 75.641 35.8044871794872 234 44 73 11 1 228 150 376 Aphrocallistes beatrix partial 28S rRNA gene blastn 11171 104 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Sceptrulophora Aphrocallistidae Aphrocallistes Aphrocallistes beatrix
10870371 10870371 PRJNA685607_P_NODE_63029_length_254_cov_1.276243_g62670_i0 PRJNA685607 63029 254 1.276243 3.24165722 Sycon ciliatum 27933 Porifera other_Eukaryota 195 3.62e-45   NTclustered gi|457867044|emb|HF570316.1| 27933 g62670 i0 83.568 83.1811023622047 213 29 83 6 32 241 504 295 Sycon ciliatum mRNA for Ubiquitin and ubiquitin-like proteins (ubc gene) blastn 21128 195 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
12145589 12145589 PRJNA685607_P_NODE_23890_length_354_cov_1.113879_g23531_i0 PRJNA685607 23890 354 1.113879 3.94313166 Amphimedon queenslandica 400682 Porifera other_Eukaryota 311 5e-80   NTclustered gi|1133459419|ref|XM_003385902.3| 400682 g23531 i0 84.112 172.282485875706 321 51 91 0 25 345 310 630 PREDICTED: Amphimedon queenslandica polyubiquitin-B (LOC100636532), mRNA blastn 60988 311 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
14695336 14695336 PRJNA685607_P_NODE_6472_length_605_cov_1.116541_g6124_i0 PRJNA685607 6472 605 1.116541 6.75507305 Hyrtios reticulatus 1162751 Porifera other_Eukaryota 132 7.480000000000001e-26   NTclustered gi|512765404|gb|KC869642.1| 1162751 g6124 i0 91.089 15.9057851239669 101 4 31 5 506 604 2047 2144 Hyrtios reticulatus voucher NCI426 28S ribosomal RNA gene, partial sequence blastn 9623 132 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Thorectidae Hyrtios Hyrtios reticulatus

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