RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where bioproject = "PRJNA690234" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Porifera · 15 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA690234 · 15 ✖
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
9598516 9598516 PRJNA690234_P_NODE_15428_length_323_cov_2.496000_g15061_i0 PRJNA690234 15428 323 2.496 8.06208 Amphimedon queenslandica 400682 Porifera other_Eukaryota 128 1.5399999999999999e-34   NR XP_011409930.1 400682 g15061 i0 60.4 4.47678018575851 96 38 89.2 0 302 15 14 109 XP_011409930.1 PREDICTED: serine/arginine-rich splicing factor 12 [Amphimedon queenslandica] diamond 1446 128 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
14698848 14698848 PRJNA690234_P_NODE_11872_length_368_cov_3.427119_g11505_i0 PRJNA690234 11872 368 3.427119 12.61179792 Dysidea avara 196820 Porifera other_Eukaryota 54.7 0.01   NTclustered gi|2749556513|ref|XM_066045316.1| 196820 g11505 i0 100 0.078804347826087 29 0 8 0 216 244 1370 1342 PREDICTED: Dysidea avara uncharacterized protein (LOC136252751), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
22347794 22347794 PRJNA690234_P_NODE_638_length_1538_cov_28.548123_g494_i0 PRJNA690234 638 1538 28.548123 439.07013174 Opisthokonta 33154 Porifera other_Eukaryota 551 7.959999999999999e-191   NR AQM52339.1 121494 g494 i0 58.6 25.8667100130039 457 175 88.8 5 36 1400 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
24896429 24896429 PRJNA690234_P_NODE_24000_length_258_cov_4.610811_g23633_i0 PRJNA690234 24000 258 4.610811 11.89589238 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 186 1.24e-56   NR KAI6659163.1 111878 g23633 i0 96.5 514 86 3 100 0 1 258 77 162 KAI6659163.1 Serine/threonine-protein phosphatase PP1-beta catalytic subunit [Oopsacas minuta] diamond 132612 187 0.994652406417112 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
27303784 27303784 PRJNA690234_P_NODE_12683_length_356_cov_1.653710_g12316_i0 PRJNA690234 12683 356 1.65371 5.8872076 Halichondria panicea 6063 Porifera other_Eukaryota 48.1 0.00171   NR XP_064396833.1 6063 g12316 i0 35.5 0.640449438202247 76 46 61.5 1 264 46 511 586 XP_064396833.1 TBC1 domain family member 15-like [Halichondria panicea] diamond 228 48.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28093055 28093055 PRJNA690234_P_NODE_19905_length_284_cov_1.981043_g19538_i0 PRJNA690234 19905 284 1.981043 5.62616212 Oscarella lobularis 121494 Porifera other_Eukaryota 96.7 6.94e-21   NR XP_065841251.1 121494 g19538 i0 50.5 5.92605633802817 93 46 98.2 0 283 5 455 547 XP_065841251.1 26S proteasome non-ATPase regulatory subunit 1-like [Oscarella lobularis] diamond 1683 96.7 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28472103 28472103 PRJNA690234_P_NODE_17066_length_307_cov_1.871795_g16699_i0 PRJNA690234 17066 307 1.871795 5.74641065 Corticium candelabrum 121492 Porifera other_Eukaryota 53.5 6.42e-6   NR XP_062507813.1 121492 g16699 i0 44.6 0.635179153094462 65 34 61.6 1 289 101 102 166 XP_062507813.1 Golgi apparatus membrane protein TVP23 homolog B-like isoform X1 [Corticium candelabrum] diamond 195 53.5 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29115007 29115007 PRJNA690234_P_NODE_6528_length_506_cov_1.080831_g6163_i0 PRJNA690234 6528 506 1.080831 5.46900486 Metazoa 33208 Porifera other_Eukaryota 154 4.5099999999999996e-42   NR XP_065891123.1 196820 g6163 i0 50.3 6.43280632411067 145 70 85.4 2 503 72 4 147 XP_065891123.1 stromal membrane-associated protein 1-like [Dysidea avara] diamond 3255 154 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29229972 29229972 PRJNA690234_P_NODE_5569_length_551_cov_1.864017_g5206_i0 PRJNA690234 5569 551 1.864017 10.27073367 Oscarella lobularis 121494 Porifera other_Eukaryota 249 4.75e-79   NR XP_065829482.1 121494 g5206 i0 61.1 6.83847549909256 180 70 98 0 548 9 176 355 XP_065829482.1 glutamine synthetase-like [Oscarella lobularis] diamond 3768 249 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29261141 29261141 PRJNA690234_P_NODE_8369_length_443_cov_2.948649_g8003_i0 PRJNA690234 8369 443 2.948649 13.06251507 Dysidea avara 196820 Porifera other_Eukaryota 56.6 3.61e-6   NR XP_065884160.1 196820 g8003 i0 35 1.08352144469526 80 47 50.8 1 217 441 50 129 XP_065884160.1 procathepsin L-like [Dysidea avara] diamond 480 56.6 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29576846 29576846 PRJNA690234_P_NODE_9910_length_405_cov_2.737952_g9544_i0 PRJNA690234 9910 405 2.737952 11.0887056 Geodia barretti 519541 Porifera other_Eukaryota 114 1.43e-28   NR CAI7998431.1 519541 g9544 i0 49.1 0.859259259259259 116 58 85.2 1 2 346 88 203 CAI7998431.1 Osteoclast-stimulating factor 1 [Geodia barretti] diamond 348 114 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
30935584 30935584 PRJNA690234_P_NODE_4254_length_637_cov_1.808511_g3897_i0 PRJNA690234 4254 637 1.808511 11.52021507 Amphimedon queenslandica 400682 Porifera other_Eukaryota 184 2.29e-50   NR XP_019857001.1 400682 g3897 i0 51.6 0.885400313971743 188 79 85.7 4 634 89 502 683 XP_019857001.1 PREDICTED: LIM domain kinase 1-like isoform X2 [Amphimedon queenslandica] diamond 564 184 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
31409663 31409663 PRJNA690234_P_NODE_16276_length_315_cov_1.685950_g15909_i0 PRJNA690234 16276 315 1.68595 5.3107425 Sycon ciliatum 27933 Porifera other_Eukaryota 124 4.6999999999999996e-32   NR XP_065191053.1 27933 g15909 i0 51.4 1 105 49 98.1 2 3 311 143 247 XP_065191053.1 protein SCO1 homolog, mitochondrial-like [Sycon ciliatum] diamond 315 124 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31409678 31409678 PRJNA690234_P_NODE_9836_length_407_cov_1.398204_g9470_i0 PRJNA690234 9836 407 1.398204 5.69069028 Amphimedon queenslandica 400682 Porifera other_Eukaryota 139 4.01e-39   NR XP_003383680.1 400682 g9470 i0 59.3 4.997542997543 113 46 83.3 0 405 67 48 160 XP_003383680.1 PREDICTED: AP-1 complex subunit sigma-2-like isoform X1 [Amphimedon queenslandica] diamond 2034 139 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
32591633 32591633 PRJNA690234_P_NODE_12979_length_352_cov_1.548387_g12612_i0 PRJNA690234 12979 352 1.548387 5.45032224 Metazoa 33208 Porifera other_Eukaryota 162 7.02e-45   NR XP_062515616.1 121492 g12612 i0 61.5 29.8806818181818 117 45 99.7 0 2 352 389 505 XP_062515616.1 4-trimethylaminobutyraldehyde dehydrogenase-like [Corticium candelabrum] diamond 10518 162 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum

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