RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJNA657343", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 20 ✖

tax_kingdom 1

  • Metazoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA657343 · 20 ✖

analysis 1

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
3173869 3173869 PRJNA657343_P_NODE_29343_length_180_cov_2.664122_g29319_i0 PRJNA657343 29343 180 2.664122 4.7954196 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 106 6.73e-25   NR XP_065882675.1 196820 g29319 i0 85.7 31.75 56 8 93.3 0 6 173 607 662 XP_065882675.1 dolichyl-diphosphooligosaccharide--protein glycosyltransferase subunit STT3B-like [Dysidea avara] diamond 5715 107 0.990654205607477 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
4450959 4450959 PRJNA657343_P_NODE_34964_length_169_cov_1.275000_g34940_i0 PRJNA657343 34964 169 1.275 2.15475 Dysidea avara 196820 Porifera other_Eukaryota 77 1.14e-14   NR XP_065886888.1 196820 g34940 i0 70.8 1.72189349112426 48 14 85.2 0 148 5 1032 1079 XP_065886888.1 phospholipid-transporting ATPase ABCA1-like [Dysidea avara] diamond 291 77 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
8276549 8276549 PRJNA657343_P_NODE_9147_length_277_cov_2.802632_g9123_i0 PRJNA657343 9147 277 2.802632 7.76329064 Demospongiae 6042 Porifera other_Eukaryota 131 9.16e-35   NR XP_003384600.1 400682 g9123 i0 75.3 9.77978339350181 81 20 87.7 0 259 17 20 100 XP_003384600.1 PREDICTED: protein disulfide isomerase-like 2-1 [Amphimedon queenslandica] diamond 2709 132 0.992424242424242 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
17201270 17201270 PRJNA657343_P_NODE_8794_length_281_cov_4.327586_g8770_i0 PRJNA657343 8794 281 4.327586 12.16051666 Opisthokonta 33154 Porifera other_Eukaryota 87.8 7.98e-20   NR XP_064401835.1 6063 g8770 i0 48.8 4.7508896797153 86 43 91.8 1 13 270 36 120 XP_064401835.1 large ribosomal subunit protein eL27-like [Halichondria panicea] diamond 1335 88.6 0.99097065462754 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
23575944 23575944 PRJNA657343_P_NODE_879_length_629_cov_6.715517_g861_i0 PRJNA657343 879 629 6.715517 42.24060193 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 270 5.549999999999999e-87   NR CCQ18610.1 27933 g861 i0 67 56.6232114467409 209 68 99.7 1 2 628 28 235 CCQ18610.1 ribosomal protein RPL1/RPL2/RL4L4 [Sycon ciliatum] diamond 35616 271 0.996309963099631 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
26701339 26701339 PRJNA657343_P_NODE_10741_length_261_cov_1.797170_g10717_i0 PRJNA657343 10741 261 1.79717 4.6906137 Sycon ciliatum 27933 Porifera other_Eukaryota 99 1.5199999999999995e-23   NR XP_065175506.1 27933 g10717 i0 60.6 0.758620689655172 66 26 75.9 0 222 25 132 197 XP_065175506.1 cysteine and glycine-rich protein 1-like [Sycon ciliatum] diamond 198 99 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
27207538 27207538 PRJNA657343_P_NODE_14162_length_236_cov_1.080214_g14138_i0 PRJNA657343 14162 236 1.080214 2.54930504 Dysidea avara 196820 Porifera other_Eukaryota 104 7.18e-24   NR XP_065909784.1 196820 g14138 i0 68.1 4.41101694915254 69 22 87.7 0 26 232 12 80 XP_065909784.1 ubiquitin-like modifier-activating enzyme 6 [Dysidea avara] diamond 1041 104 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28060416 28060416 PRJNA657343_P_NODE_11225_length_257_cov_1.427885_g11201_i0 PRJNA657343 11225 257 1.427885 3.66966445 Dysidea avara 196820 Porifera other_Eukaryota 59.7 4.71e-8   NR XP_065919067.1 196820 g11201 i0 43.8 1.80933852140078 73 41 85.2 0 23 241 116 188 XP_065919067.1 ras-specific guanine nucleotide-releasing factor RalGPS2-like isoform X2 [Dysidea avara] diamond 465 59.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28376138 28376138 PRJNA657343_P_NODE_8366_length_286_cov_3.852321_g8342_i0 PRJNA657343 8366 286 3.852321 11.01763806 Corticium candelabrum 121492 Porifera other_Eukaryota 111 3.24e-29   NR XP_062516633.1 121492 g8342 i0 66.7 0.944055944055944 90 28 94.4 1 3 272 34 121 XP_062516633.1 small ribosomal subunit protein eS17-like [Corticium candelabrum] diamond 270 111 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28944843 28944843 PRJNA657343_P_NODE_21248_length_203_cov_1.266234_g21224_i0 PRJNA657343 21248 203 1.266234 2.57045502 Oscarella lobularis 121494 Porifera other_Eukaryota 45.1 0.00342   NR XP_065845773.1 121494 g21224 i0 42.9 1.24137931034483 42 24 62.1 0 37 162 572 613 XP_065845773.1 uncharacterized protein [Oscarella lobularis] diamond 252 45.1 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
29039522 29039522 PRJNA657343_P_NODE_34068_length_170_cov_3.264463_g34044_i0 PRJNA657343 34068 170 3.264463 5.5495871 Amphimedon queenslandica 400682 Porifera other_Eukaryota 43.1 0.0104   NR NP_001266228.1 400682 g34044 i0 46.7 0.794117647058823 45 22 79.4 1 167 33 475 517 NP_001266228.1 neurogenic locus notch homolog precursor [Amphimedon queenslandica] diamond 135 43.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
29240983 29240983 PRJNA657343_P_NODE_489_length_751_cov_7.287749_g476_i0 PRJNA657343 489 751 7.287749 54.73099499 Metazoa 33208 Porifera other_Eukaryota 133 6.76e-33   NR XP_065198312.1 27933 g476 i0 46.9 1.65379494007989 145 72 57.5 4 17 448 220 360 XP_065198312.1 S-adenosylmethionine decarboxylase proenzyme-like [Sycon ciliatum] diamond 1242 133 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30081152 30081152 PRJNA657343_P_NODE_28312_length_183_cov_1.343284_g28288_i0 PRJNA657343 28312 183 1.343284 2.45820972 Sycon ciliatum 27933 Porifera other_Eukaryota 51.2 1.73e-5   NR XP_065187173.1 27933 g28288 i0 41.9 1.01639344262295 62 34 98.4 1 4 183 192 253 XP_065187173.1 beta-secretase 2-like [Sycon ciliatum] diamond 186 51.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30808061 30808061 PRJNA657343_P_NODE_33614_length_171_cov_2.418033_g33590_i0 PRJNA657343 33614 171 2.418033 4.13483643 Oscarella lobularis 121494 Porifera other_Eukaryota 66.6 5.05e-11   NR XP_065846742.1 121494 g33590 i0 54.7 0.929824561403509 53 24 93 0 5 163 236 288 XP_065846742.1 uncharacterized protein [Oscarella lobularis] diamond 159 66.6 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
31061060 31061060 PRJNA657343_P_NODE_35255_length_169_cov_0.866667_g35231_i0 PRJNA657343 35255 169 0.866667 1.46466723 Sycon ciliatum 27933 Porifera other_Eukaryota 51.2 1.43e-5   NR XP_065187533.1 27933 g35231 i0 49 5.09467455621302 51 25 90.5 1 7 159 1448 1497 XP_065187533.1 uncharacterized protein LOC135818131 isoform X1 [Sycon ciliatum] diamond 861 51.2 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31294236 31294236 PRJNA657343_P_NODE_20915_length_204_cov_1.316129_g20891_i0 PRJNA657343 20915 204 1.316129 2.68490316 Metazoa 33208 Porifera other_Eukaryota 46.6 9.37e-4   NR XP_065826477.1 121494 g20891 i0 47.7 1.26470588235294 44 23 64.7 0 197 66 313 356 XP_065826477.1 guanine nucleotide-binding protein G(o) subunit alpha-like [Oscarella lobularis] diamond 258 47 0.991489361702128 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
31440114 31440114 PRJNA657343_P_NODE_5016_length_346_cov_1.595960_g4993_i0 PRJNA657343 5016 346 1.59596 5.5220216 Geodia barretti 519541 Porifera other_Eukaryota 95.1 4.44e-21   NR CAI8009348.1 519541 g4993 i0 57.6 1.47398843930636 85 35 72.8 1 20 271 152 236 CAI8009348.1 Ubiquitin carboxyl-terminal hydrolase MINDY-1 [Geodia barretti] diamond 510 95.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
31756496 31756496 PRJNA657343_P_NODE_37217_length_167_cov_1.949153_g37193_i0 PRJNA657343 37217 167 1.949153 3.25508551 Geodia barretti 519541 Porifera other_Eukaryota 42.7 0.0136   NR CAI7993005.1 519541 g37193 i0 44.7 0.682634730538922 38 21 68.3 0 119 6 23 60 CAI7993005.1 Huntingtin-interacting protein 1 [Geodia barretti] diamond 114 42.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32357922 32357922 PRJNA657343_P_NODE_41859_length_164_cov_0.904348_g41835_i0 PRJNA657343 41859 164 0.904348 1.48313072 Sycon ciliatum 27933 Porifera other_Eukaryota 62.4 1.45e-9   NR XP_065178175.1 27933 g41835 i0 72.3 0.859756097560976 47 12 84.1 1 13 150 281 327 XP_065178175.1 nucleosome assembly protein 1-like 1 [Sycon ciliatum] diamond 141 62.4 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32653905 32653905 PRJNA657343_P_NODE_7560_length_297_cov_3.600806_g7536_i0 PRJNA657343 7560 297 3.600806 10.69439382 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 69.7 2.26e-13   NR XP_065828534.1 121494 g7536 i0 53.1 3.94949494949495 64 30 64.6 0 257 66 7 70 XP_065828534.1 copper transport protein ATOX1 homolog [Oscarella lobularis] diamond 1173 70.1 0.994293865905849 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);;