RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Metazoa · 18 ✖

tax_clade 1

bioproject 1

  • PRJEB10320 · 18 ✖
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
1287804 1287804 PRJEB10320_P_NODE_22482_length_177_cov_1.274648_g22224_i0 PRJEB10320 22482 177 1.274648 2.25612696 Amphimedon queenslandica 400682 Porifera other_Eukaryota 89.8 1.14e-13   NTclustered gi|1133467918|ref|XM_011406801.2| 400682 g22224 i0 92.063 1.50847457627119 63 5 36 0 1 63 238 176 PREDICTED: Amphimedon queenslandica putative transmembrane protein DDB_G0267530 (LOC105313402), mRNA blastn 267 89.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
2257696 2257696 PRJEB10320_P_NODE_922_length_1051_cov_3.859252_g801_i0 PRJEB10320 922 1051 3.859252 40.56073852 Amphimedon queenslandica 400682 Porifera other_Eukaryota 362 5.379999999999999e-121   NR XP_019864009.1 400682 g801 i0 58.3 2.74595623215985 331 123 91.9 6 1032 67 2 326 XP_019864009.1 PREDICTED: cathepsin L1-like isoform X3 [Amphimedon queenslandica] diamond 2886 362 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
15315716 15315716 PRJEB10320_P_NODE_12873_length_262_cov_1.629956_g12615_i0 PRJEB10320 12873 262 1.629956 4.27048472 Metazoa 33208 Porifera other_Eukaryota 106 2.18e-27   NR AAX48866.1 55567 g12615 i0 62.8 6.44656488549618 78 29 89.3 0 28 261 4 81 AAX48866.1 L32 [Suberites domuncula] diamond 1689 107 0.990654205607477 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
26621139 26621139 PRJEB10320_P_NODE_10821_length_295_cov_1.107692_g10563_i0 PRJEB10320 10821 295 1.107692 3.2676914 Dysidea avara 196820 Porifera other_Eukaryota 103 7.499999999999999e-24   NR XP_065910737.1 196820 g10563 i0 57.5 1.6271186440678 80 34 81.4 0 262 23 135 214 XP_065910737.1 lysosomal acid lipase/cholesteryl ester hydrolase-like [Dysidea avara] diamond 480 103 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27216053 27216053 PRJEB10320_P_NODE_16582_length_220_cov_1.070270_g16324_i0 PRJEB10320 16582 220 1.07027 2.354594 Metazoa 33208 Porifera other_Eukaryota 50.8 3.82e-5   NR XP_064387395.1 6063 g16324 i0 38.4 5.93181818181818 73 43 98.2 2 3 218 1151 1222 XP_064387395.1 uncharacterized protein LOC135335773 isoform X3 [Halichondria panicea] diamond 1305 50.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27690436 27690436 PRJEB10320_P_NODE_21184_length_185_cov_1.066667_g20926_i0 PRJEB10320 21184 185 1.066667 1.97333395 Opisthokonta 33154 Porifera other_Eukaryota 101 1.53e-23   NR XP_065182952.1 27933 g20926 i0 77 36.5189189189189 61 14 98.9 0 184 2 243 303 XP_065182952.1 actin-related protein 2-B [Sycon ciliatum] diamond 6756 102 0.990196078431373 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27980354 27980354 PRJEB10320_P_NODE_10245_length_305_cov_1.814815_g9987_i0 PRJEB10320 10245 305 1.814815 5.53518575 Halichondria panicea 6063 Porifera other_Eukaryota 70.5 1.44e-11   NR XP_064381805.1 6063 g9987 i0 46.3 0.786885245901639 80 43 78.7 0 301 62 230 309 XP_064381805.1 sperm-associated antigen 1-like [Halichondria panicea] diamond 240 70.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28169774 28169774 PRJEB10320_P_NODE_9846_length_313_cov_1.877698_g9588_i0 PRJEB10320 9846 313 1.877698 5.87719474 Oscarella lobularis 121494 Porifera other_Eukaryota 75.9 5.12e-14   NR XP_065836436.1 121494 g9588 i0 65.5 1.21725239616613 58 20 55.6 0 3 176 140 197 XP_065836436.1 small ribosomal subunit protein eS6-like [Oscarella lobularis] diamond 381 75.9 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28390764 28390764 PRJEB10320_P_NODE_14046_length_247_cov_1.537736_g13788_i0 PRJEB10320 14046 247 1.537736 3.79820792 Amphimedon queenslandica 400682 Porifera other_Eukaryota 57.4 2.04e-7   NR XP_019850607.1 400682 g13788 i0 62.5 0.97165991902834 40 15 48.6 0 1 120 233 272 XP_019850607.1 PREDICTED: carbonyl reductase [NADPH] 1-like isoform X3 [Amphimedon queenslandica] diamond 240 57.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28542782 28542782 PRJEB10320_P_NODE_14627_length_240_cov_1.170732_g14369_i0 PRJEB10320 14627 240 1.170732 2.8097568 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 102 9.26e-24   NR XP_065187034.1 27933 g14369 i0 59.5 1.85 74 29 92.5 1 238 17 300 372 XP_065187034.1 beta-1,3-glucan-binding protein-like [Sycon ciliatum] diamond 444 102 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29117176 29117176 PRJEB10320_P_NODE_23849_length_169_cov_1.791045_g23591_i0 PRJEB10320 23849 169 1.791045 3.02686605 Oscarella lobularis 121494 Porifera other_Eukaryota 89.4 4.860000000000001e-21   NR XP_065833988.1 121494 g23591 i0 74.5 1.95266272189349 55 14 97.6 0 167 3 1 55 XP_065833988.1 small ribosomal subunit protein eS26-like [Oscarella lobularis] diamond 330 89.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29300355 29300355 PRJEB10320_P_NODE_25789_length_160_cov_1.600000_g25531_i0 PRJEB10320 25789 160 1.6 2.56 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 66.2 6.21e-11   NR XP_065884101.1 196820 g25531 i0 53.8 10.14375 52 24 97.5 0 1 156 426 477 XP_065884101.1 uncharacterized protein [Dysidea avara] diamond 1623 66.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29363587 29363587 PRJEB10320_P_NODE_12369_length_269_cov_1.606838_g12111_i0 PRJEB10320 12369 269 1.606838 4.32239422 Opisthokonta 33154 Porifera other_Eukaryota 108 3.7100000000000005e-27   NR XP_065191529.1 27933 g12111 i0 61.4 4.61710037174721 83 32 92.6 0 256 8 33 115 XP_065191529.1 small ribosomal subunit protein eS10-like isoform X1 [Sycon ciliatum] diamond 1242 108 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29495852 29495852 PRJEB10320_P_NODE_4910_length_479_cov_1.952703_g4665_i0 PRJEB10320 4910 479 1.952703 9.35344737 Oopsacas minuta 111878 Porifera other_Eukaryota 45.4 0.0413   NR KAI6650539.1 111878 g4665 i0 31.8 0.551148225469729 88 53 52.6 3 477 226 450 534 KAI6650539.1 hypothetical protein LOD99_7590 [Oopsacas minuta] diamond 264 45.4 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
30532067 30532067 PRJEB10320_P_NODE_19093_length_199_cov_1.347561_g18835_i0 PRJEB10320 19093 199 1.347561 2.68164639 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 79.7 9.84e-16   NR XP_065893172.1 196820 g18835 i0 62.5 3.93467336683417 64 18 96.5 1 193 2 128 185 XP_065893172.1 L-serine dehydratase/L-threonine deaminase-like [Dysidea avara] diamond 783 79.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31012196 31012196 PRJEB10320_P_NODE_21295_length_184_cov_1.516779_g21037_i0 PRJEB10320 21295 184 1.516779 2.79087336 Halichondria panicea 6063 Porifera other_Eukaryota 84.7 2.2e-17   NR XP_064383757.1 6063 g21037 i0 60.3 0.945652173913043 58 23 94.6 0 3 176 351 408 XP_064383757.1 protein dcd1B-like [Halichondria panicea] diamond 174 84.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31707817 31707817 PRJEB10320_P_NODE_28657_length_150_cov_1.043478_g28399_i0 PRJEB10320 28657 150 1.043478 1.565217 Sycon ciliatum 27933 Porifera other_Eukaryota 53.1 2.28e-6   NR XP_065191614.1 27933 g28399 i0 47.6 0.84 42 22 84 0 1 126 3250 3291 XP_065191614.1 protein eyes shut homolog isoform X2 [Sycon ciliatum] diamond 126 53.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32719557 32719557 PRJEB10320_P_NODE_21400_length_183_cov_2.864865_g21142_i0 PRJEB10320 21400 183 2.864865 5.24270295 Dysidea avara 196820 Porifera other_Eukaryota 90.5 1.92e-20   NR XP_065910110.1 196820 g21142 i0 77.6 1.9344262295082 58 13 95.1 0 176 3 86 143 XP_065910110.1 cilia- and flagella-associated protein 299-like isoform X2 [Dysidea avara] diamond 354 90.5 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);;