RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1148190 · 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
4123615 4123615 PRJNA1148190_P_NODE_507584_length_265_cov_1.463542_g496411_i0 PRJNA1148190 507584 265 1.463542 3.8783863 Igernella notabilis 479643 Porifera other_Eukaryota 54.7 0.007   NTclustered gi|164421203|ref|NC_010216.1| 479643 g496411 i0 96.774 0.116981132075472 31 1 12 0 44 74 12888 12918 Igernella notabilis mitochondrion, complete genome blastn 31 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dendroceratida Dictyodendrillidae Igernella Igernella notabilis
6670720 6670720 PRJNA1148190_P_NODE_247166_length_345_cov_1.132353_g235996_i0 PRJNA1148190 247166 345 1.132353 3.90661785 Halichondria panicea 6063 Porifera other_Eukaryota 63.9 1.51e-5   NTclustered gi|2719022888|ref|XM_064545113.1| 6063 g235996 i0 97.297 1.88115942028986 37 1 11 0 232 268 593 557 PREDICTED: Halichondria panicea uncharacterized LOC135347230 (LOC135347230), mRNA blastn 649 63.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
10497907 10497907 PRJNA1148190_P_NODE_3369_length_7353_cov_6.079670_g1659_i0 PRJNA1148190 3369 7353 6.07967 447.0381351 Callyspongia plicifera 178539 Porifera other_Eukaryota 87.9 2.11e-11   NTclustered gi|164420950|ref|NC_010206.1| 178539 g1659 i0 92.063 0.0682714538283694 63 3 1 2 2352 2413 16325 16264 Callyspongia plicifera mitochondrion, complete genome blastn 502 87.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Callyspongiidae Callyspongia Callyspongia plicifera
18142619 18142619 PRJNA1148190_P_NODE_130755_length_461_cov_0.881443_g119592_i0 PRJNA1148190 130755 461 0.881443 4.06345223 Amphimedon queenslandica 400682 Porifera other_Eukaryota 56.5 0.003   NTclustered gi|1133491526|ref|XR_002189775.1| 400682 g119592 i0 100 0.134490238611714 30 0 7 0 167 196 297 268 PREDICTED: Amphimedon queenslandica uncharacterized LOC109591349 (LOC109591349), ncRNA blastn 62 56.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
19426451 19426451 PRJNA1148190_P_NODE_796416_length_236_cov_2.257669_g785243_i0 PRJNA1148190 796416 236 2.257669 5.32809884 Amphimedon queenslandica 400682 Porifera other_Eukaryota 52.8 0.021   NTclustered gi|1133478224|ref|XM_020002638.1| 400682 g785243 i0 100 0.11864406779661 28 0 12 0 89 116 1535 1508 PREDICTED: Amphimedon queenslandica hemicentin-1-like (LOC109586452), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
23243512 23243512 PRJNA1148190_P_NODE_146079_length_435_cov_1.488950_g134913_i0 PRJNA1148190 146079 435 1.48895 6.4769325 Dysidea avara 196820 Porifera other_Eukaryota 65.8 5.4e-6   NTclustered gi|2749550510|ref|XM_066042629.1| 196820 g134913 i0 91.489 0.108045977011494 47 4 11 0 353 399 4055 4101 PREDICTED: Dysidea avara dynein axonemal heavy chain 3-like (LOC136250423), mRNA blastn 47 65.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
23248480 23248480 PRJNA1148190_P_NODE_471619_length_272_cov_1.432161_g460446_i0 PRJNA1148190 471619 272 1.432161 3.89547792 Sycon ciliatum 27933 Porifera other_Eukaryota 54.7 0.007   NTclustered gi|2732917138|ref|XM_065325377.1| 27933 g460446 i0 100 0.106617647058824 29 0 11 0 243 271 2039 2011 PREDICTED: Sycon ciliatum uncharacterized LOC135812054 (LOC135812054), mRNA blastn 29 54.7 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);;