RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Metazoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJEB36940 · 20 ✖
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
56901 56901 PRJEB36940_P_NODE_7981_length_306_cov_2.042918_g7852_i0 PRJEB36940 7981 306 2.042918 6.25132908 Plakortis sp. CU203 2849318 Porifera other_Eukaryota 145 4.58e-30   NTclustered gi|2055839537|gb|MZ416381.1| 2849318 g7852 i0 85.517 47.6732026143791 145 13 47 5 163 306 699 836 Plakortis sp. CU203 small subunit ribosomal RNA gene, partial sequence blastn 14588 145 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Plakortis Plakortis sp. CU203
2606685 2606685 PRJEB36940_P_NODE_15303_length_244_cov_0.888889_g15174_i0 PRJEB36940 15303 244 0.888889 2.16888916 Hymeniacidon perlevis 177573 Porifera other_Eukaryota 92 2.3400000000000003e-21   NR ABO26247.1 177573 g15174 i0 59.3 0.995901639344262 81 32 98.4 1 5 244 38 118 ABO26247.1 14-3-3 K, partial [Hymeniacidon perlevis] diamond 243 92 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Hymeniacidon Hymeniacidon perlevis
5159171 5159171 PRJEB36940_P_NODE_5845_length_355_cov_1.343972_g5716_i0 PRJEB36940 5845 355 1.343972 4.7711006 Geodia barretti 519541 Porifera other_Eukaryota 67.8 2.03e-11   NR CAI8058552.1 519541 g5716 i0 64.7 2.60281690140845 51 18 43.1 0 154 2 31 81 CAI8058552.1 60S ribosomal protein L23a, partial [Geodia barretti] diamond 924 67.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
11534900 11534900 PRJEB36940_P_NODE_12630_length_251_cov_1.376404_g12501_i0 PRJEB36940 12630 251 1.376404 3.45477404 Corticium candelabrum 121492 Porifera other_Eukaryota 65.8 2.92e-6   NTclustered gi|2664285434|ref|XM_062646157.1| 121492 g12501 i0 93.182 15.2988047808765 44 3 18 0 11 54 7692 7649 PREDICTED: Corticium candelabrum cullin-7-like (LOC134179294), mRNA blastn 3840 65.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
16633716 16633716 PRJEB36940_P_NODE_8454_length_298_cov_1.297778_g8325_i0 PRJEB36940 8454 298 1.297778 3.86737844 Opisthokonta 33154 Porifera other_Eukaryota 157 3.64e-47   NR XP_064400374.1 6063 g8325 i0 74.7 21.2818791946309 95 24 95.6 0 13 297 4 98 XP_064400374.1 ubiquitin-conjugating enzyme E2 N [Halichondria panicea] diamond 6342 157 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
24282496 24282496 PRJEB36940_P_NODE_10260_length_274_cov_1.164179_g10131_i0 PRJEB36940 10260 274 1.164179 3.18985046 Sycon ciliatum 27933 Porifera other_Eukaryota 100 1.61e-22   NR XP_065194552.1 27933 g10131 i0 68.8 2.82481751824818 64 20 70.1 0 274 83 445 508 XP_065194552.1 delta(5) fatty acid desaturase A-like [Sycon ciliatum] diamond 774 100 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27317954 27317954 PRJEB36940_P_NODE_11863_length_256_cov_1.693989_g11734_i0 PRJEB36940 11863 256 1.693989 4.33661184 Halichondria panicea 6063 Porifera other_Eukaryota 52 2.14e-5   NR XP_064383316.1 6063 g11734 i0 44.1 4.69921875 68 33 73.8 1 251 63 248 315 XP_064383316.1 large ribosomal subunit protein uL10-like isoform X1 [Halichondria panicea] diamond 1203 52 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27437857 27437857 PRJEB36940_P_NODE_1943_length_603_cov_3.796226_g1821_i0 PRJEB36940 1943 603 3.796226 22.89124278 Porifera 6040 Porifera other_Eukaryota 78.6 5.76e-14   NR XP_065198597.1 27933 g1821 i0 29.8 3.61194029850746 181 117 88.1 6 51 581 26 200 XP_065198597.1 stAR-related lipid transfer protein 5-like [Sycon ciliatum] diamond 2178 78.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27791593 27791593 PRJEB36940_P_NODE_9144_length_288_cov_0.939535_g9015_i0 PRJEB36940 9144 288 0.939535 2.7058608 Dysidea avara 196820 Porifera other_Eukaryota 99.8 1.29e-23   NR XP_065919271.1 196820 g9015 i0 67.6 1.58333333333333 74 24 77.1 0 65 286 107 180 XP_065919271.1 N-alpha-acetyltransferase 30-like [Dysidea avara] diamond 456 99.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27823241 27823241 PRJEB36940_P_NODE_8004_length_306_cov_1.330472_g7875_i0 PRJEB36940 8004 306 1.330472 4.07124432 Suberites domuncula 55567 Porifera other_Eukaryota 47.4 6.92e-4   NR ABL85455.1 55567 g7875 i0 40.5 0.725490196078431 74 43 71.6 1 83 301 37 110 ABL85455.1 actin related protein 2/3 complex subunit 5 [Suberites domuncula] diamond 222 47.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
27854571 27854571 PRJEB36940_P_NODE_11125_length_264_cov_1.575916_g10996_i0 PRJEB36940 11125 264 1.575916 4.16041824 Sycon ciliatum 27933 Porifera other_Eukaryota 73.6 2.09e-14   NR XP_065181103.1 27933 g10996 i0 42 0.920454545454545 81 46 92 1 22 264 12 91 XP_065181103.1 thioredoxin domain-containing protein 17-like [Sycon ciliatum] diamond 243 73.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28044051 28044051 PRJEB36940_P_NODE_15065_length_244_cov_0.912281_g14936_i0 PRJEB36940 15065 244 0.912281 2.22596564 Corticium candelabrum 121492 Porifera other_Eukaryota 59.3 4.08e-8   NR XP_062516292.1 121492 g14936 i0 37.5 0.983606557377049 80 47 98.4 1 243 4 191 267 XP_062516292.1 E3 ubiquitin-protein ligase Ufd4-like [Corticium candelabrum] diamond 240 59.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28770195 28770195 PRJEB36940_P_NODE_1027_length_823_cov_22.622667_g915_i0 PRJEB36940 1027 823 22.622667 186.18454941 Geodia barretti 519541 Porifera other_Eukaryota 139 4.9899999999999995e-37   NR CAI8030757.1 519541 g915 i0 48.8 1.18104495747266 166 70 58 6 563 87 18 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 972 139 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29590831 29590831 PRJEB36940_P_NODE_4330_length_411_cov_0.917160_g4201_i0 PRJEB36940 4330 411 0.91716 3.7695276 Halichondria panicea 6063 Porifera other_Eukaryota 90.9 1.19e-19   NR XP_064404297.1 6063 g4201 i0 37.2 0.941605839416058 129 78 93.4 3 24 407 16 142 XP_064404297.1 exosome complex component CSL4-like [Halichondria panicea] diamond 387 90.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30096403 30096403 PRJEB36940_P_NODE_7292_length_320_cov_1.360324_g7163_i0 PRJEB36940 7292 320 1.360324 4.3530368 Oopsacas minuta 111878 Porifera other_Eukaryota 52.8 2.68e-5   NR KAI6646112.1 111878 g7163 i0 31.2 0.871875 93 61 87.2 2 41 319 372 461 KAI6646112.1 hypothetical protein LOD99_9463 [Oopsacas minuta] diamond 279 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
30848277 30848277 PRJEB36940_P_NODE_15034_length_244_cov_1.350877_g14905_i0 PRJEB36940 15034 244 1.350877 3.29613988 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 51.6 2.82e-5   NR XP_064399935.1 6063 g14905 i0 38.1 6.95901639344262 63 37 76.2 2 195 10 291 352 XP_064399935.1 uncharacterized protein LOC135346290 [Halichondria panicea] diamond 1698 51.6 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30918154 30918154 PRJEB36940_P_NODE_4234_length_415_cov_2.722222_g4105_i0 PRJEB36940 4234 415 2.722222 11.2972213 Suberites domuncula 55567 Porifera other_Eukaryota 134 9.12e-38   NR AAX48868.1 55567 g4105 i0 64.2 1.77831325301205 123 43 88.9 1 18 386 1 122 AAX48868.1 L35 [Suberites domuncula] diamond 738 134 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
31259066 31259066 PRJEB36940_P_NODE_15055_length_244_cov_0.912281_g14926_i0 PRJEB36940 15055 244 0.912281 2.22596564 Porifera 6040 Porifera other_Eukaryota 62.8 1.92e-9   NR XP_065833376.1 121494 g14926 i0 44.7 1.84426229508197 76 37 87.3 1 2 214 185 260 XP_065833376.1 leucine-rich melanocyte differentiation-associated protein-like [Oscarella lobularis] diamond 450 63.2 0.993670886075949 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32556441 32556441 PRJEB36940_P_NODE_8499_length_297_cov_1.379464_g8370_i0 PRJEB36940 8499 297 1.379464 4.09700808 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 142 7.109999999999999e-37   NR XP_065903858.1 196820 g8370 i0 72.1 1.84848484848485 86 24 86.9 0 3 260 636 721 XP_065903858.1 uncharacterized protein [Dysidea avara] diamond 549 142 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32656806 32656806 PRJEB36940_P_NODE_12180_length_253_cov_1.083333_g12051_i0 PRJEB36940 12180 253 1.083333 2.74083249 Sycon ciliatum 27933 Porifera other_Eukaryota 51.2 4.26e-5   NR XP_065185382.1 27933 g12051 i0 30.4 0.936758893280632 79 55 93.7 0 251 15 465 543 XP_065185382.1 programmed cell death 6-interacting protein-like [Sycon ciliatum] diamond 237 51.2 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);;