RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA1120060" 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

tax_clade 1

bioproject 1

  • PRJNA1120060 · 20 ✖

analysis 1

  • diamond · 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
27090978 27090978 PRJNA1120060_P_NODE_624162_length_344_cov_7.070111_g606407_i0 PRJNA1120060 624162 344 7.070111 24.32118184 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 64.7 2.28e-9   NR KAI6659068.1 111878 g606407 i0 43.2 6.66279069767442 74 42 64.5 0 227 6 414 487 KAI6659068.1 hypothetical protein LOD99_14744 [Oopsacas minuta] diamond 2292 64.7 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
27280478 27280478 PRJNA1120060_P_NODE_1532843_length_292_cov_1.424658_g1514854_i0 PRJNA1120060 1532843 292 1.424658 4.16000136 Opisthokonta 33154 Porifera other_Eukaryota 71.2 6.27e-12   NR XP_064406950.1 6063 g1514854 i0 45.3 12.2157534246575 75 41 77.1 0 6 230 79 153 XP_064406950.1 polyubiquitin-C-like [Halichondria panicea] diamond 3567 71.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
27354693 27354693 PRJNA1120060_P_NODE_94983_length_579_cov_1.037549_g80721_i0 PRJNA1120060 94983 579 1.037549 6.00740871 Amphimedon queenslandica 400682 Porifera other_Eukaryota 49.7 0.00298   NR XP_011410001.1 400682 g80721 i0 43.4 1.24352331606218 53 25 24.9 2 311 168 428 480 XP_011410001.1 PREDICTED: uncharacterized protein LOC105316640 [Amphimedon queenslandica] diamond 720 49.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
27733525 27733525 PRJNA1120060_P_NODE_516944_length_363_cov_3.096552_g499311_i0 PRJNA1120060 516944 363 3.096552 11.24048376 Corticium candelabrum 121492 Porifera other_Eukaryota 58.2 2.46e-7   NR XP_062506256.1 121492 g499311 i0 47.3 0.925619834710744 55 29 45.5 0 356 192 66 120 XP_062506256.1 uncharacterized protein K02A2.6-like [Corticium candelabrum] diamond 336 58.2 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
27985500 27985500 PRJNA1120060_P_NODE_3210985_length_231_cov_2.367089_g3192878_i0 PRJNA1120060 3210985 231 2.367089 5.46797559 Dysidea avara 196820 Porifera other_Eukaryota 43.1 0.023   NR XP_065906784.1 196820 g3192878 i0 35.7 0.909090909090909 70 44 89.6 1 5 211 243 312 XP_065906784.1 uncharacterized protein [Dysidea avara] diamond 210 43.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28017427 28017427 PRJNA1120060_P_NODE_366705_length_398_cov_1.492308_g349383_i0 PRJNA1120060 366705 398 1.492308 5.93938584 Corticium candelabrum 121492 Porifera other_Eukaryota 47 0.00551   NR XP_062499407.1 121492 g349383 i0 34.7 0.738693467336683 98 55 70.9 6 383 102 66 158 XP_062499407.1 uncharacterized protein LOC134176759 [Corticium candelabrum] diamond 294 47 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28269584 28269584 PRJNA1120060_P_NODE_3421166_length_214_cov_4.695035_g3403044_i0 PRJNA1120060 3421166 214 4.695035 10.0473749 Sycon ciliatum 27933 Porifera other_Eukaryota 42.7 0.0256   NR XP_065192036.1 27933 g3403044 i0 41.2 0.714953271028037 51 28 68.7 1 33 179 1371 1421 XP_065192036.1 uncharacterized protein LOC135823121 [Sycon ciliatum] diamond 153 42.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28512089 28512089 PRJNA1120060_P_NODE_994027_length_312_cov_2.623431_g976098_i0 PRJNA1120060 994027 312 2.623431 8.18510472 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 47 0.00287   NR XP_064399907.1 6063 g976098 i0 64 0.855769230769231 25 9 24 0 117 43 332 356 XP_064399907.1 uncharacterized protein LOC135346269 [Halichondria panicea] diamond 267 47 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
28585114 28585114 PRJNA1120060_P_NODE_2470387_length_255_cov_1.423077_g2452317_i0 PRJNA1120060 2470387 255 1.423077 3.62884635 Amphimedon queenslandica 400682 Porifera other_Eukaryota 43.1 0.0324   NR XP_019855240.1 400682 g2452317 i0 38.7 0.729411764705882 62 37 72.9 1 20 205 786 846 XP_019855240.1 PREDICTED: WD repeat-containing protein 81-like [Amphimedon queenslandica] diamond 186 43.1 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28742912 28742912 PRJNA1120060_P_NODE_2576627_length_251_cov_4.011236_g2558550_i0 PRJNA1120060 2576627 251 4.011236 10.06820236 Sycon ciliatum 27933 Porifera other_Eukaryota 42.7 0.0417   NR XP_065179623.1 27933 g2558550 i0 40 0.537848605577689 45 27 53.8 0 117 251 353 397 XP_065179623.1 proline-, glutamic acid- and leucine-rich protein 1-like isoform X2 [Sycon ciliatum] diamond 135 42.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29058735 29058735 PRJNA1120060_P_NODE_2557708_length_252_cov_1.547486_g2539633_i0 PRJNA1120060 2557708 252 1.547486 3.89966472 Halichondria panicea 6063 Porifera other_Eukaryota 43.9 0.0164   NR XP_064388291.1 6063 g2539633 i0 45.5 0.523809523809524 44 24 52.4 0 244 113 516 559 XP_064388291.1 polyubiquitin-C-like [Halichondria panicea] diamond 132 43.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30290311 30290311 PRJNA1120060_P_NODE_2044012_length_271_cov_1.479798_g2025975_i0 PRJNA1120060 2044012 271 1.479798 4.01025258 Dysidea avara 196820 Porifera other_Eukaryota 42.7 0.0465   NR XP_065883171.1 196820 g2025975 i0 40.4 0.6309963099631 57 28 56.5 1 195 43 29 85 XP_065883171.1 zinc finger and SCAN domain-containing protein 12-like [Dysidea avara] diamond 171 42.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30312544 30312544 PRJNA1120060_P_NODE_2894832_length_244_cov_0.900585_g2876743_i0 PRJNA1120060 2894832 244 0.900585 2.1974274 root 1 Root_unresolved Root_unresolved 64.3 9.79e-10   NR XP_062521530.1 121492 g2876743 i0 43.5 1.7827868852459 69 38 83.6 1 238 35 302 370 XP_062521530.1 E3 ubiquitin-protein ligase RNF213-like [Corticium candelabrum] diamond 435 64.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
30596286 30596286 PRJNA1120060_P_NODE_851213_length_314_cov_3.377593_g833293_i0 PRJNA1120060 851213 314 3.377593 10.60564202 Metazoa 33208 Porifera other_Eukaryota 103 4.15e-25   NR XP_065896209.1 196820 g833293 i0 49.5 3.9171974522293 105 48 97.5 2 7 312 64 166 XP_065896209.1 uncharacterized protein [Dysidea avara] diamond 1230 103 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30637001 30637001 PRJNA1120060_P_NODE_1557273_length_291_cov_1.252294_g1539282_i0 PRJNA1120060 1557273 291 1.252294 3.64417554 Sycon ciliatum 27933 Porifera other_Eukaryota 43.5 0.036   NR XP_065177705.1 27933 g1539282 i0 28.6 0.938144329896907 91 56 88.7 3 33 290 412 498 XP_065177705.1 uncharacterized protein LOC135808442 [Sycon ciliatum] diamond 273 43.5 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31386559 31386559 PRJNA1120060_P_NODE_2582516_length_251_cov_2.825843_g2564439_i0 PRJNA1120060 2582516 251 2.825843 7.09286593 Metazoa 33208 Porifera other_Eukaryota 54.7 2.47e-6   NR XP_062503949.1 121492 g2564439 i0 54.3 3.94422310756972 46 21 55 0 1 138 161 206 XP_062503949.1 uncharacterized protein LOC134180778 [Corticium candelabrum] diamond 990 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31395661 31395661 PRJNA1120060_P_NODE_1389176_length_298_cov_3.431111_g1371196_i0 PRJNA1120060 1389176 298 3.431111 10.22471078 Sycon ciliatum 27933 Porifera other_Eukaryota 44.7 0.0153   NR XP_065181179.1 27933 g1371196 i0 39.6 0.483221476510067 48 27 48.3 1 207 64 3 48 XP_065181179.1 uncharacterized protein LOC135811869 [Sycon ciliatum] diamond 144 44.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32251123 32251123 PRJNA1120060_P_NODE_3056338_length_238_cov_2.793939_g3038237_i0 PRJNA1120060 3056338 238 2.793939 6.64957482 Dysidea avara 196820 Porifera other_Eukaryota 49.3 1.73e-4   NR XP_065891207.1 196820 g3038237 i0 55.6 1.81512605042017 45 20 56.7 0 136 2 48 92 XP_065891207.1 polyubiquitin-like [Dysidea avara] diamond 432 49.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32314694 32314694 PRJNA1120060_P_NODE_3587819_length_200_cov_4.015748_g3569692_i0 PRJNA1120060 3587819 200 4.015748 8.031496 Sycon ciliatum 27933 Porifera other_Eukaryota 43.1 0.0159   NR XP_065185957.1 27933 g3569692 i0 43.2 0.66 44 24 66 1 136 5 315 357 XP_065185957.1 uncharacterized protein LOC135816782 [Sycon ciliatum] diamond 132 43.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
32840151 32840151 PRJNA1120060_P_NODE_1544480_length_291_cov_2.912844_g1526489_i0 PRJNA1120060 1544480 291 2.912844 8.47637604 root 1 Root_unresolved Root_unresolved 48.1 8.63e-4   NR XP_062500277.1 121492 g1526489 i0 32.9 2.68041237113402 70 47 72.2 0 285 76 213 282 XP_062500277.1 uncharacterized protein LOC134177507 [Corticium candelabrum] diamond 780 48.5 0.991752577319588 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);;