RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Metazoa · 17 ✖

tax_clade 1

bioproject 1

  • PRJNA685607 · 17 ✖
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
4494457 4494457 PRJNA685607_P_NODE_97084_length_241_cov_0.904762_g96725_i0 PRJNA685607 97084 241 0.904762 2.18047642 Porifera 6040 Porifera other_Eukaryota 86.7 5.78e-18   NR XP_065184168.1 27933 g96725 i0 56.3 4.44398340248963 71 29 88.4 1 5 217 57 125 XP_065184168.1 uncharacterized protein LOC135814898 [Sycon ciliatum] diamond 1071 87 0.996551724137931 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
5770053 5770053 PRJNA685607_P_NODE_80025_length_246_cov_0.890173_g79666_i0 PRJNA685607 80025 246 0.890173 2.18982558 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 119 1.47e-30   NR XP_064395651.1 6063 g79666 i0 69.5 50.9756097560976 82 24 100 1 1 246 26 106 XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea] diamond 12540 120 0.991666666666667 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
9594896 9594896 PRJNA685607_P_NODE_35588_length_312_cov_1.372385_g35229_i0 PRJNA685607 35588 312 1.372385 4.2818412 Aphrocallistes beatrix 398365 Porifera other_Eukaryota 104 7.94e-18   NTclustered gi|222419933|emb|FM946126.1| 398365 g35229 i0 75.641 35.8044871794872 234 44 73 11 1 228 150 376 Aphrocallistes beatrix partial 28S rRNA gene blastn 11171 104 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Sceptrulophora Aphrocallistidae Aphrocallistes Aphrocallistes beatrix
10870371 10870371 PRJNA685607_P_NODE_63029_length_254_cov_1.276243_g62670_i0 PRJNA685607 63029 254 1.276243 3.24165722 Sycon ciliatum 27933 Porifera other_Eukaryota 195 3.62e-45   NTclustered gi|457867044|emb|HF570316.1| 27933 g62670 i0 83.568 83.1811023622047 213 29 83 6 32 241 504 295 Sycon ciliatum mRNA for Ubiquitin and ubiquitin-like proteins (ubc gene) blastn 21128 195 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
12145589 12145589 PRJNA685607_P_NODE_23890_length_354_cov_1.113879_g23531_i0 PRJNA685607 23890 354 1.113879 3.94313166 Amphimedon queenslandica 400682 Porifera other_Eukaryota 311 5e-80   NTclustered gi|1133459419|ref|XM_003385902.3| 400682 g23531 i0 84.112 172.282485875706 321 51 91 0 25 345 310 630 PREDICTED: Amphimedon queenslandica polyubiquitin-B (LOC100636532), mRNA blastn 60988 311 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
13420362 13420362 PRJNA685607_P_NODE_74391_length_248_cov_0.880000_g74032_i0 PRJNA685607 74391 248 0.88 2.1824 Sycon ciliatum 27933 Porifera other_Eukaryota 114 1.89e-27   NR XP_065183777.1 27933 g74032 i0 59.8 2.10483870967742 87 28 96.8 1 6 245 472 558 XP_065183777.1 uncharacterized protein LOC135814571 [Sycon ciliatum] diamond 522 114 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
14695336 14695336 PRJNA685607_P_NODE_6472_length_605_cov_1.116541_g6124_i0 PRJNA685607 6472 605 1.116541 6.75507305 Hyrtios reticulatus 1162751 Porifera other_Eukaryota 132 7.480000000000001e-26   NTclustered gi|512765404|gb|KC869642.1| 1162751 g6124 i0 91.089 15.9057851239669 101 4 31 5 506 604 2047 2144 Hyrtios reticulatus voucher NCI426 28S ribosomal RNA gene, partial sequence blastn 9623 132 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Thorectidae Hyrtios Hyrtios reticulatus
26713710 26713710 PRJNA685607_P_NODE_88961_length_243_cov_0.905882_g88602_i0 PRJNA685607 88961 243 0.905882 2.20129326 Metazoa 33208 Porifera other_Eukaryota 107 6.1499999999999986e-28   NR XP_062513731.1 121492 g88602 i0 72.2 17.3703703703704 72 20 88.9 0 241 26 52 123 XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] diamond 4221 108 0.990740740740741 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
27030529 27030529 PRJNA685607_P_NODE_59462_length_260_cov_1.641711_g59103_i0 PRJNA685607 59462 260 1.641711 4.2684486 Metazoa 33208 Porifera other_Eukaryota 129 2.27e-32   NR XP_064388772.1 6063 g59103 i0 74.7 20.1576923076923 83 21 95.8 0 10 258 713 795 XP_064388772.1 aldehyde dehydrogenase family 16 member A1-like [Halichondria panicea] diamond 5241 130 0.992307692307692 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27461594 27461594 PRJNA685607_P_NODE_38363_length_304_cov_3.844156_g38004_i0 PRJNA685607 38363 304 3.844156 11.68623424 Oscarella lobularis 121494 Porifera other_Eukaryota 145 2.09e-42   NR XP_065826293.1 121494 g38004 i0 74.7 8.56578947368421 95 24 93.8 0 18 302 1 95 XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] diamond 2604 145 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
27536230 27536230 PRJNA685607_P_NODE_24043_length_353_cov_1.650000_g23684_i0 PRJNA685607 24043 353 1.65 5.8245 Opisthokonta 33154 Porifera other_Eukaryota 68.2 5.42e-12   NR XP_003391081.1 400682 g23684 i0 47.9 4.62322946175637 71 36 60.3 1 342 130 1 70 XP_003391081.1 PREDICTED: 60S acidic ribosomal protein P2-like [Amphimedon queenslandica] diamond 1632 68.6 0.994169096209913 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28061255 28061255 PRJNA685607_P_NODE_46265_length_286_cov_1.084507_g45906_i0 PRJNA685607 46265 286 1.084507 3.10169002 Sycon ciliatum 27933 Porifera other_Eukaryota 117 4.8e-30   NR XP_065186579.1 27933 g45906 i0 63.7 23.8846153846154 91 31 93.4 1 20 286 1 91 XP_065186579.1 small ribosomal subunit protein eS1-like [Sycon ciliatum] diamond 6831 117 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28388602 28388602 PRJNA685607_P_NODE_32486_length_322_cov_0.911647_g32127_i0 PRJNA685607 32486 322 0.911647 2.93550334 Metazoa 33208 Porifera other_Eukaryota 128 3.6899999999999996e-34   NR KAI6660403.1 111878 g32127 i0 60.2 14.4409937888199 103 41 96 0 14 322 84 186 KAI6660403.1 hypothetical protein LOD99_13989 [Oopsacas minuta] diamond 4650 128 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28566492 28566492 PRJNA685607_P_NODE_56427_length_266_cov_1.196891_g56068_i0 PRJNA685607 56427 266 1.196891 3.18373006 Suberites domuncula 55567 Porifera other_Eukaryota 107 1.04e-25   NR AAX48841.1 55567 g56068 i0 62.9 1.00375939849624 89 32 99.2 1 264 1 136 224 AAX48841.1 L10e/P0 [Suberites domuncula] diamond 267 107 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
29229808 29229808 PRJNA685607_P_NODE_83749_length_245_cov_0.895349_g83390_i0 PRJNA685607 83749 245 0.895349 2.19360505 Sycon ciliatum 27933 Porifera other_Eukaryota 82.4 4.17e-16   NR XP_065179717.1 27933 g83390 i0 52.4 2.04489795918367 82 36 96.7 1 243 7 410 491 XP_065179717.1 1-phosphatidylinositol 4,5-bisphosphate phosphodiesterase gamma-1-like [Sycon ciliatum] diamond 501 82.4 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29671249 29671249 PRJNA685607_P_NODE_51270_length_276_cov_0.827586_g50911_i0 PRJNA685607 51270 276 0.827586 2.28413736 Sycon ciliatum 27933 Porifera other_Eukaryota 62.4 4.18e-9   NR XP_065191569.1 27933 g50911 i0 45.7 1.89130434782609 81 41 87 2 275 36 119 197 XP_065191569.1 countin-3-like [Sycon ciliatum] diamond 522 62.4 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32085260 32085260 PRJNA685607_P_NODE_85138_length_244_cov_1.350877_g84779_i0 PRJNA685607 85138 244 1.350877 3.29613988 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 127 1.3699999999999998e-35   NR XP_065826293.1 121494 g84779 i0 70.4 10.9180327868852 81 24 99.6 0 243 1 13 93 XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] diamond 2664 127 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis

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