RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Metazoa · 21 ✖

tax_clade 1

bioproject 1

  • PRJNA438572 · 21 ✖
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
6812612 6812612 PRJNA438572_P_NODE_10906_length_311_cov_1.310924_g10787_i0 PRJNA438572 10906 311 1.310924 4.07697364 Sycon ciliatum 27933 Porifera other_Eukaryota 158 5.9899999999999985e-34   NTclustered gi|2732895820|ref|XM_065319255.1| 27933 g10787 i0 82.065 5.85530546623794 184 33 59 0 128 311 603 786 PREDICTED: Sycon ciliatum ras-related C3 botulinum toxin substrate 1-like (LOC135805243), mRNA blastn 1821 158 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
6812947 6812947 PRJNA438572_P_NODE_6406_length_396_cov_1.600619_g6287_i0 PRJNA438572 6406 396 1.600619 6.33845124 Oscarella lobularis 121494 Porifera other_Eukaryota 129 6.14e-33   NR XP_065843711.1 121494 g6287 i0 52.1 3.97727272727273 117 51 85.6 2 365 27 6 121 XP_065843711.1 thioredoxin domain-containing protein 5-like [Oscarella lobularis] diamond 1575 129 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
8088297 8088297 PRJNA438572_P_NODE_3027_length_564_cov_9.217923_g2909_i0 PRJNA438572 3027 564 9.217923 51.98908572 Corticium candelabrum 121492 Porifera other_Eukaryota 154 1.44e-44   NR XP_062513731.1 121492 g2909 i0 65.3 0.643617021276596 121 42 64.4 0 56 418 2 122 XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] diamond 363 154 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
16393551 16393551 PRJNA438572_P_NODE_16173_length_258_cov_1.264865_g16054_i0 PRJNA438572 16173 258 1.264865 3.2633517 Corticium candelabrum 121492 Porifera other_Eukaryota 126 9.47e-33   NR XP_062500839.1 121492 g16054 i0 65.5 0.976744186046512 84 29 97.7 0 253 2 100 183 XP_062500839.1 uncharacterized protein LOC134178068 [Corticium candelabrum] diamond 252 126 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
27423884 27423884 PRJNA438572_P_NODE_12023_length_296_cov_1.991031_g11904_i0 PRJNA438572 12023 296 1.991031 5.89345176 Halichondria panicea 6063 Porifera other_Eukaryota 95.1 1.04e-22   NR XP_064387449.1 6063 g11904 i0 54.7 3.55743243243243 75 34 76 0 231 7 13 87 XP_064387449.1 NADH dehydrogenase [ubiquinone] 1 alpha subcomplex subunit 12-like [Halichondria panicea] diamond 1053 95.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28260692 28260692 PRJNA438572_P_NODE_9126_length_337_cov_2.121212_g9007_i0 PRJNA438572 9126 337 2.121212 7.14848444 Porifera 6040 Porifera other_Eukaryota 80.1 9.17e-15   NR XP_064391097.1 6063 g9007 i0 58.7 2.50148367952522 63 26 56.1 0 226 38 17 79 XP_064391097.1 conserved oligomeric Golgi complex subunit 1-like [Halichondria panicea] diamond 843 80.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28370796 28370796 PRJNA438572_P_NODE_14586_length_272_cov_2.351759_g14467_i0 PRJNA438572 14586 272 2.351759 6.39678448 Halichondria panicea 6063 Porifera other_Eukaryota 52 2.5e-5   NR XP_064387443.1 6063 g14467 i0 40 0.772058823529412 70 42 77.2 0 57 266 5 74 XP_064387443.1 voltage-dependent anion-selective channel protein 2-like [Halichondria panicea] diamond 210 52 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28576579 28576579 PRJNA438572_P_NODE_23627_length_243_cov_0.917647_g23508_i0 PRJNA438572 23627 243 0.917647 2.22988221 Opisthokonta 33154 Porifera other_Eukaryota 63.9 1.31e-9   NR XP_065199181.1 27933 g23508 i0 40 5.14814814814815 85 41 92.6 1 7 231 735 819 XP_065199181.1 uncharacterized protein LOC135830891 isoform X3 [Sycon ciliatum] diamond 1251 64.3 0.993779160186625 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29191920 29191920 PRJNA438572_P_NODE_3629_length_518_cov_1.391011_g3511_i0 PRJNA438572 3629 518 1.391011 7.20543698 Geodia barretti 519541 Porifera other_Eukaryota 92.8 6.26e-20   NR CAI8029397.1 519541 g3511 i0 51 1.12934362934363 98 40 54.4 3 237 518 97 190 CAI8029397.1 hypothetical protein GBAR_LOCUS16700 [Geodia barretti] diamond 585 92.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29223541 29223541 PRJNA438572_P_NODE_1389_length_804_cov_6.798906_g1290_i0 PRJNA438572 1389 804 6.798906 54.66320424 Geodia barretti 519541 Porifera other_Eukaryota 143 1.94e-38   NR CAI8030757.1 519541 g1290 i0 50.6 0.619402985074627 166 67 59.3 6 280 756 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 498 143 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29475661 29475661 PRJNA438572_P_NODE_17110_length_253_cov_0.866667_g16991_i0 PRJNA438572 17110 253 0.866667 2.19266751 Dysidea avara 196820 Porifera other_Eukaryota 75.5 1.24e-13   NR XP_065887598.1 196820 g16991 i0 40.5 0.99604743083004 84 48 97.2 1 2 247 233 316 XP_065887598.1 crystal protein-like [Dysidea avara] diamond 252 75.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29475673 29475673 PRJNA438572_P_NODE_8670_length_346_cov_1.142857_g8551_i0 PRJNA438572 8670 346 1.142857 3.95428522 Dysidea avara 196820 Porifera other_Eukaryota 124 1.56e-33   NR XP_065905867.1 196820 g8551 i0 58.1 1.78612716763006 105 44 91 0 317 3 1 105 XP_065905867.1 transcription factor BTF3 homolog 4-like isoform X1 [Dysidea avara] diamond 618 124 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29586639 29586639 PRJNA438572_P_NODE_21330_length_246_cov_1.416185_g21211_i0 PRJNA438572 21330 246 1.416185 3.4838151 root 1 Root_unresolved Root_unresolved 134 3.07e-34   NR CAI8052649.1 519541 g21211 i0 77.5 8.53658536585366 80 18 97.6 0 245 6 408 487 CAI8052649.1 Major vault protein [Geodia barretti] diamond 2100 134 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
30377073 30377073 PRJNA438572_P_NODE_17572_length_252_cov_0.871508_g17453_i0 PRJNA438572 17572 252 0.871508 2.19620016 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 83.6 1.81e-16   NR XP_065199063.1 27933 g17453 i0 44.3 5.39285714285714 79 44 94 0 1 237 404 482 XP_065199063.1 calcium/calmodulin-dependent protein kinase kinase 1-like [Sycon ciliatum] diamond 1359 84.3 0.991696322657177 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31845909 31845909 PRJNA438572_P_NODE_11797_length_299_cov_1.380531_g11678_i0 PRJNA438572 11797 299 1.380531 4.12778769 Hymeniacidon perlevis 177573 Porifera other_Eukaryota 119 1.2499999999999999e-31   NR ABO26247.1 177573 g11678 i0 61.6 0.993311036789298 99 37 98.3 1 2 295 36 134 ABO26247.1 14-3-3 K, partial [Hymeniacidon perlevis] diamond 297 119 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Hymeniacidon Hymeniacidon perlevis
31877487 31877487 PRJNA438572_P_NODE_12257_length_294_cov_1.058824_g12138_i0 PRJNA438572 12257 294 1.058824 3.11294256 Oscarella lobularis 121494 Porifera other_Eukaryota 61.6 4.03e-9   NR XP_065845145.1 121494 g12138 i0 34.5 3.09183673469388 110 53 92.9 2 3 275 20 129 XP_065845145.1 cysteine and glycine-rich protein 1-like [Oscarella lobularis] diamond 909 61.6 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
31893936 31893936 PRJNA438572_P_NODE_11817_length_299_cov_1.110619_g11698_i0 PRJNA438572 11817 299 1.110619 3.32075081 Opisthokonta 33154 Porifera other_Eukaryota 108 6.36e-27   NR XP_065178750.1 27933 g11698 i0 57.4 11.1571906354515 94 40 94.3 0 1 282 133 226 XP_065178750.1 elongation factor 1-delta-like isoform X3 [Sycon ciliatum] diamond 3336 109 0.990825688073395 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32067386 32067386 PRJNA438572_P_NODE_15118_length_268_cov_0.897436_g14999_i0 PRJNA438572 15118 268 0.897436 2.40512848 Sycon ciliatum 27933 Porifera other_Eukaryota 71.2 2.36e-12   NR XP_065188176.1 27933 g14999 i0 44.9 0.996268656716418 89 44 94 1 10 261 108 196 XP_065188176.1 uncharacterized protein LOC135818920 [Sycon ciliatum] diamond 267 71.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32447435 32447435 PRJNA438572_P_NODE_18959_length_250_cov_0.881356_g18840_i0 PRJNA438572 18959 250 0.881356 2.20339 Oscarella lobularis 121494 Porifera other_Eukaryota 126 4.0699999999999997e-32   NR XP_065842109.1 121494 g18840 i0 68.7 0.996 83 26 99.6 0 250 2 231 313 XP_065842109.1 uncharacterized protein [Oscarella lobularis] diamond 249 126 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32778741 32778741 PRJNA438572_P_NODE_21740_length_246_cov_0.901734_g21621_i0 PRJNA438572 21740 246 0.901734 2.21826564 Metazoa 33208 Porifera other_Eukaryota 116 4.95e-30   NR XP_065909141.1 196820 g21621 i0 68.8 39.0243902439024 80 25 97.6 0 242 3 5 84 XP_065909141.1 proteasome subunit alpha type-5-like [Dysidea avara] diamond 9600 116 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32857064 32857064 PRJNA438572_P_NODE_11700_length_300_cov_2.440529_g11581_i0 PRJNA438572 11700 300 2.440529 7.321587 Halichondria panicea 6063 Porifera other_Eukaryota 65.5 1.5e-10   NR XP_064404742.1 6063 g11581 i0 37.8 4.9 98 51 98 3 296 3 2 89 XP_064404742.1 large ribosomal subunit protein uL6-like [Halichondria panicea] diamond 1470 65.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea

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