RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where bioproject = "PRJNA450343", 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 · 12 ✖

tax_kingdom 1

  • Metazoa · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA450343 · 12 ✖
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
6816768 6816768 PRJNA450343_P_NODE_106_length_1470_cov_6.995778_g92_i0 PRJNA450343 106 1470 6.995778 102.8379366 Opisthokonta 33154 Porifera other_Eukaryota 551 3.41e-191   NR AQM52339.1 121494 g92 i0 58.6 27.0632653061224 457 175 92.9 5 14 1378 1 445 AQM52339.1 elongation factor 1 alpha, partial [Oscarella lobularis] diamond 39783 556 0.991007194244604 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
9366936 9366936 PRJNA450343_P_NODE_10228_length_170_cov_1.264463_g10160_i0 PRJNA450343 10228 170 1.264463 2.1495871 Halichondria panicea 6063 Porifera other_Eukaryota 119 1.3800000000000001e-22   NTclustered gi|2719047883|ref|XM_064532147.1| 6063 g10160 i0 81.081 7.74705882352941 148 28 87 0 1 148 3822 3675 PREDICTED: Halichondria panicea colorectal mutant cancer protein-like (LOC135336384), mRNA blastn 1317 119 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
11917748 11917748 PRJNA450343_P_NODE_10130_length_171_cov_1.245902_g10062_i0 PRJNA450343 10130 171 1.245902 2.13049242 Halichondria sp. AR-2003 232262 Porifera other_Eukaryota 128 2.31e-25   NTclustered gi|32967411|gb|AY226060.1| 232262 g10062 i0 80.117 10.1345029239766 171 34 100 0 1 171 450 280 Halichondria sp. AR-2003 beta-tubulin mRNA, partial cds blastn 1733 128 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria sp. AR-2003
27534722 27534722 PRJNA450343_P_NODE_14103_length_161_cov_0.901786_g14035_i0 PRJNA450343 14103 161 0.901786 1.45187546 Metazoa 33208 Porifera other_Eukaryota 81.3 2.88e-18   NR XP_064382259.1 6063 g14035 i0 84.6 6.42857142857143 39 6 72.7 0 1 117 70 108 XP_064382259.1 peptidyl-prolyl cis-trans isomerase FKBP1A-like [Halichondria panicea] diamond 1035 81.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28655175 28655175 PRJNA450343_P_NODE_8147_length_190_cov_1.085106_g8079_i0 PRJNA450343 8147 190 1.085106 2.0617014 Corticium candelabrum 121492 Porifera other_Eukaryota 53.9 2.12e-6   NR XP_062515092.1 121492 g8079 i0 41.7 0.947368421052632 60 35 94.7 0 186 7 325 384 XP_062515092.1 puromycin-sensitive aminopeptidase-like [Corticium candelabrum] diamond 180 53.9 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29145278 29145278 PRJNA450343_P_NODE_10209_length_170_cov_1.264463_g10141_i0 PRJNA450343 10209 170 1.264463 2.1495871 Metazoa 33208 Porifera other_Eukaryota 97.1 1.9499999999999994e-23   NR KAI6656009.1 111878 g10141 i0 92.2 10.0764705882353 51 4 90 0 158 6 1 51 KAI6656009.1 60S ribosomal protein L19-like [Oopsacas minuta] diamond 1713 97.8 0.992842535787321 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
29444217 29444217 PRJNA450343_P_NODE_10470_length_168_cov_1.285714_g10402_i0 PRJNA450343 10470 168 1.285714 2.15999952 Corticium candelabrum 121492 Porifera other_Eukaryota 74.3 1.01e-13   NR XP_062502461.1 121492 g10402 i0 55.4 1 56 25 100 0 168 1 27 82 XP_062502461.1 alpha-actinin-like [Corticium candelabrum] diamond 168 74.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29492237 29492237 PRJNA450343_P_NODE_3910_length_269_cov_1.159091_g3842_i0 PRJNA450343 3910 269 1.159091 3.11795479 Metazoa 33208 Porifera other_Eukaryota 90.1 6.64e-19   NR XP_064395120.1 6063 g3842 i0 46.5 3.8364312267658 86 46 95.9 0 11 268 100 185 XP_064395120.1 dnaJ homolog subfamily A member 1-like [Halichondria panicea] diamond 1032 90.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
29539079 29539079 PRJNA450343_P_NODE_2790_length_323_cov_2.631387_g2722_i0 PRJNA450343 2790 323 2.631387 8.49938001 Oopsacas minuta 111878 Porifera other_Eukaryota 48.1 0.00128   NR KAI6654232.1 111878 g2722 i0 30.7 2.3126934984520102 114 67 94.7 2 9 314 3893 4006 KAI6654232.1 Ryanodine receptor 3 [Oopsacas minuta] diamond 747 48.1 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
30138871 30138871 PRJNA450343_P_NODE_10532_length_167_cov_2.593220_g10464_i0 PRJNA450343 10532 167 2.59322 4.3306774 Suberites domuncula 55567 Porifera other_Eukaryota 92 3.61e-22   NR AAX48894.1 55567 g10464 i0 83.3 13.5808383233533 54 9 97 0 162 1 1 54 AAX48894.1 S17 [Suberites domuncula] diamond 2268 92 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
31197741 31197741 PRJNA450343_P_NODE_9255_length_179_cov_1.569231_g9187_i0 PRJNA450343 9255 179 1.569231 2.80892349 Metazoa 33208 Porifera other_Eukaryota 75.9 3.31e-14   NR XP_064387545.1 6063 g9187 i0 91.7 12.0335195530726 36 3 60.3 0 108 1 1 36 XP_064387545.1 latrophilin-like protein 1 isoform X4 [Halichondria panicea] diamond 2154 76.6 0.990861618798956 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
32447517 32447517 PRJNA450343_P_NODE_9719_length_175_cov_1.214286_g9651_i0 PRJNA450343 9719 175 1.214286 2.1250005 Amphimedon queenslandica 400682 Porifera other_Eukaryota 124 2.76e-34   NR XP_003386065.1 400682 g9651 i0 91.2 5.91428571428571 57 5 97.7 0 171 1 70 126 XP_003386065.1 PREDICTED: ubiquitin-conjugating enzyme E2 G1-like [Amphimedon queenslandica] diamond 1035 124 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica

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