RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB14803 · 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
1295738 1295738 PRJEB14803_P_NODE_44122_length_156_cov_1.652893_g43656_i0 PRJEB14803 44122 156 1.652893 2.57851308 Sycon ciliatum 27933 Porifera other_Eukaryota 89.8 9.79e-14   NTclustered gi|457867032|emb|HF570310.1| 27933 g43656 i0 81.481 2.11538461538462 108 20 69 0 49 156 330 223 Sycon ciliatum mRNA for 60S ribosomal protein L22 (rpl22 gene) blastn 330 89.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
17563647 17563647 PRJEB14803_P_NODE_17814_length_279_cov_3.209016_g17348_i0 PRJEB14803 17814 279 3.209016 8.95315464 Metazoa 33208 Porifera other_Eukaryota 54.7 0.007   NTclustered gi|2732927492|ref|XM_065330786.1| 27933 g17348 i0 100 2.94982078853047 29 0 10 0 203 231 5497 5469 PREDICTED: Sycon ciliatum E3 ubiquitin-protein ligase TTC3-like (LOC135817572), mRNA blastn 823 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
21698139 21698139 PRJEB14803_P_NODE_25758_length_218_cov_1.874317_g25292_i0 PRJEB14803 25758 218 1.874317 4.08601106 Sycon ciliatum 27933 Porifera other_Eukaryota 58.4 4.14e-4   NTclustered gi|2732937828|ref|XM_065336059.1| 27933 g25292 i0 97.059 0.467889908256881 34 1 16 0 10 43 508 541 PREDICTED: Sycon ciliatum FMR1-interacting protein NUFIP2-like (LOC135823215), transcript variant X1, mRNA blastn 102 58.4 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
24247347 24247347 PRJEB14803_P_NODE_41460_length_162_cov_1.259843_g40994_i0 PRJEB14803 41460 162 1.259843 2.04094566 Halisarca dujardinii 2583056 Porifera other_Eukaryota 119 1.31e-22   NTclustered gi|2006291025|gb|MT423786.1| 2583056 g40994 i0 80 1.92592592592593 160 32 99 0 3 162 1208 1049 Halisarca dujardinii NFS1 cysteine desulfurase mRNA, complete cds blastn 312 119 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Chondrillida Halisarcidae Halisarca Halisarca dujardinii

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