RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJNA565584" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA565584 · 7 ✖

analysis 1

  • blastn · 7 ✖
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
557061 557061 PRJNA565584_P_NODE_51381_length_415_cov_1.514620_g50230_i0 PRJNA565584 51381 415 1.51462 6.285673 Amphimedon queenslandica 400682 Porifera other_Eukaryota 54.7 0.011   NTclustered gi|1133448538|ref|XM_003382671.2| 400682 g50230 i0 94.286 0.0843373493975904 35 2 8 0 6 40 468 434 PREDICTED: Amphimedon queenslandica cathepsin L1-like (LOC100638285), mRNA blastn 35 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
4383877 4383877 PRJNA565584_P_NODE_218944_length_234_cov_2.925466_g217792_i0 PRJNA565584 218944 234 2.925466 6.84559044 Dysidea avara 196820 Porifera other_Eukaryota 230 9.019999999999998e-56   NTclustered gi|2749550226|ref|XM_066042492.1| 196820 g217792 i0 86.449 77.5470085470085 214 23 90 6 24 234 88 298 PREDICTED: Dysidea avara actin, cytoplasmic (LOC136250303), mRNA blastn 18146 230 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
17132743 17132743 PRJNA565584_P_NODE_142674_length_267_cov_1.479381_g141522_i0 PRJNA565584 142674 267 1.479381 3.94994727 Sycon ciliatum 27933 Porifera other_Eukaryota 159 1.4e-34   NTclustered gi|2732920119|ref|XM_065326880.1| 27933 g141522 i0 80.788 2.09737827715356 203 39 76 0 13 215 640 438 PREDICTED: Sycon ciliatum actin-related protein 2-B (LOC135813856), mRNA blastn 560 159 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
17134109 17134109 PRJNA565584_P_NODE_222594_length_226_cov_2.013072_g221442_i0 PRJNA565584 222594 226 2.013072 4.54954272 Halichondria panicea 6063 Porifera other_Eukaryota 204 5.25e-48   NTclustered gi|2719021344|ref|XM_064544374.1| 6063 g221442 i0 85 5.6061946902654904 200 30 88 0 11 210 368 169 PREDICTED: Halichondria panicea ras-related protein Rap-1b (LOC135346680), mRNA blastn 1267 204 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
22234156 22234156 PRJNA565584_P_NODE_50098_length_420_cov_2.219020_g48947_i0 PRJNA565584 50098 420 2.21902 9.319884 Sycon ciliatum 27933 Porifera other_Eukaryota 254 1.03e-62   NTclustered gi|2732923551|ref|XM_065328702.1| 27933 g48947 i0 81.47 78.0190476190476 313 54 74 2 60 370 429 119 PREDICTED: Sycon ciliatum ubiquitin-ribosomal protein eL40 fusion protein (LOC135815409), mRNA blastn 32768 254 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
23510251 23510251 PRJNA565584_P_NODE_91239_length_311_cov_1.281513_g90087_i0 PRJNA565584 91239 311 1.281513 3.98550543 Suberites domuncula 55567 Porifera other_Eukaryota 255 2.06e-63   NTclustered gi|89258390|gb|DQ414546.1| 55567 g90087 i0 81.553 17.6623794212219 309 57 99 0 1 309 315 7 Suberites domuncula Rap1 gene, complete cds blastn 5493 255 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
23510346 23510346 PRJNA565584_P_NODE_95579_length_306_cov_1.635193_g94427_i0 PRJNA565584 95579 306 1.635193 5.00369058 Dysidea avara 196820 Porifera other_Eukaryota 65.8 3.67e-6   NTclustered gi|2749554548|ref|XM_066044436.1| 196820 g94427 i0 100 2.56535947712418 35 0 11 0 272 306 1408 1374 PREDICTED: Dysidea avara tubulin beta-2B chain (LOC136252080), mRNA blastn 785 65.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara

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