RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA669701", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Porifera · 6 ✖

tax_kingdom 1

  • Metazoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA669701 · 6 ✖
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
7014914 7014914 PRJNA669701_P_NODE_83926_length_277_cov_1.509804_g83531_i0 PRJNA669701 83926 277 1.509804 4.18215708 Opisthokonta 33154 Porifera other_Eukaryota 93.2 8.69e-22   NR AAX48891.1 55567 g83531 i0 61.5 12.7148014440433 78 28 82.3 1 50 277 15 92 AAX48891.1 S15 [Suberites domuncula] diamond 3522 93.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
15938186 15938186 PRJNA669701_P_NODE_138533_length_242_cov_0.911243_g138138_i0 PRJNA669701 138533 242 0.911243 2.20520806 Sycon ciliatum 27933 Porifera other_Eukaryota 139 1.63e-28   NTclustered gi|457866990|emb|HF570289.1| 27933 g138138 i0 79.592 14.5743801652893 196 38 81 2 11 205 259 453 Sycon ciliatum mRNA for 40S ribosomal protein S14 (rps14 gene) blastn 3527 139 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
26998589 26998589 PRJNA669701_P_NODE_83202_length_278_cov_1.497561_g82807_i0 PRJNA669701 83202 278 1.497561 4.16321958 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 79.3 7.25e-15   NR XP_065176209.1 27933 g82807 i0 44.2 4.34892086330935 77 43 83.1 0 14 244 107 183 XP_065176209.1 uncharacterized protein LOC135806009 [Sycon ciliatum] diamond 1209 80.1 0.990012484394507 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27524017 27524017 PRJNA669701_P_NODE_78723_length_283_cov_2.533333_g78328_i0 PRJNA669701 78723 283 2.533333 7.16933239 Sycon ciliatum 27933 Porifera other_Eukaryota 49.3 2.74e-4   NR XP_065197216.1 27933 g78328 i0 34.2 2.79858657243816 73 47 76.3 1 63 278 130 202 XP_065197216.1 snurportin-1-like isoform X1 [Sycon ciliatum] diamond 792 49.3 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28818230 28818230 PRJNA669701_P_NODE_85808_length_275_cov_1.514851_g85413_i0 PRJNA669701 85808 275 1.514851 4.16584025 Halisarca dujardinii 2583056 Porifera other_Eukaryota 60.1 4.54e-8   NR WAW84834.1 2583056 g85413 i0 53.4 1.28727272727273 58 24 63.3 1 213 40 4555 4609 WAW84834.1 axonemal dynein heavy chain A [Halisarca dujardinii] diamond 354 60.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Chondrillida Halisarcidae Halisarca Halisarca dujardinii
30081449 30081449 PRJNA669701_P_NODE_106772_length_251_cov_4.629213_g106377_i0 PRJNA669701 106772 251 4.629213 11.61932463 Sycon ciliatum 27933 Porifera other_Eukaryota 88.6 2.43e-18   NR XP_065180299.1 27933 g106377 i0 67.8 1.41035856573705 59 19 70.5 0 75 251 31 89 XP_065180299.1 DDB1- and CUL4-associated factor 13-like [Sycon ciliatum] diamond 354 88.6 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);;