RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where bioproject = "PRJNA1248424" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 13 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA1248424 · 13 ✖

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
4180329 4180329 PRJNA1248424_P_NODE_65364_length_261_cov_1.228723_g59295_i0 PRJNA1248424 65364 261 1.228723 3.20696703 Sycon ciliatum 27933 Porifera other_Eukaryota 90.9 3.850000000000001e-21   NR CCQ18628.1 27933 g59295 i0 56 3.29885057471264 75 33 86.2 0 260 36 62 136 CCQ18628.1 40S ribosomal protein S2 [Sycon ciliatum] diamond 861 90.9 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
13107270 13107270 PRJNA1248424_P_NODE_77791_length_243_cov_0.905882_g71722_i0 PRJNA1248424 77791 243 0.905882 2.20129326 Dysidea avara 196820 Porifera other_Eukaryota 92.4 1.26e-19   NR XP_065915240.1 196820 g71722 i0 49.4 4.8641975308642 79 40 97.5 0 243 7 830 908 XP_065915240.1 uncharacterized protein [Dysidea avara] diamond 1182 92.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
14380878 14380878 PRJNA1248424_P_NODE_11012_length_1631_cov_35.711810_g344_i2 PRJNA1248424 11012 1631 35.71181 582.4596211 Halichondria panicea 6063 Porifera other_Eukaryota 235 3.62e-68   NR XP_064390711.1 6063 g344 i2 42.5 1.01532801961987 275 156 50.2 2 1362 544 71 345 XP_064390711.1 uncharacterized protein LOC135338492 [Halichondria panicea] diamond 1656 235 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
16929478 16929478 PRJNA1248424_P_NODE_24734_length_660_cov_1.729131_g18812_i0 PRJNA1248424 24734 660 1.729131 11.4122646 Metazoa 33208 Porifera other_Eukaryota 100 9.4499999999999992e-21   NR XP_065174753.1 27933 g18812 i0 39.1 4.98636363636364 138 84 62.7 0 550 137 281 418 XP_065174753.1 uncharacterized protein LOC135804736 [Sycon ciliatum] diamond 3291 100 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
23305056 23305056 PRJNA1248424_P_NODE_46479_length_328_cov_1.172549_g40413_i0 PRJNA1248424 46479 328 1.172549 3.84596072 Metazoa 33208 Porifera other_Eukaryota 183 8.37e-57   NR AAX48843.1 55567 g40413 i0 79.6 117.521341463415 108 22 98.8 0 326 3 19 126 AAX48843.1 L11 [Suberites domuncula] diamond 38547 184 0.994565217391304 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
28291670 28291670 PRJNA1248424_P_NODE_68906_length_251_cov_1.297753_g62837_i0 PRJNA1248424 68906 251 1.297753 3.25736003 Metazoa 33208 Porifera other_Eukaryota 47 0.00133   NR XP_065185504.1 27933 g62837 i0 51.9 20.0557768924303 54 17 53.8 1 249 115 111 164 XP_065185504.1 delta-1-pyrroline-5-carboxylate synthase-like isoform X2 [Sycon ciliatum] diamond 5034 47.4 0.991561181434599 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28652686 28652686 PRJNA1248424_P_NODE_48427_length_318_cov_1.979592_g42360_i0 PRJNA1248424 48427 318 1.979592 6.29510256 Oopsacas minuta 111878 Porifera other_Eukaryota 46.2 0.00481   NR KAI6660524.1 111878 g42360 i0 48.9 1.08490566037736 45 23 42.5 0 162 296 109 153 KAI6660524.1 Heterogeneous nuclear ribonucleoprotein 27C-like [Oopsacas minuta] diamond 345 46.2 1 Eukaryota Opisthokonta Metazoa Porifera Hexactinellida Lyssacinosida Leucopsacidae Oopsacas Oopsacas minuta
28747363 28747363 PRJNA1248424_P_NODE_23387_length_709_cov_1.932390_g17554_i0 PRJNA1248424 23387 709 1.93239 13.7006451 Sycon ciliatum 27933 Porifera other_Eukaryota 66.6 1.12e-8   NR XP_065174484.1 27933 g17554 i0 36.4 0.418899858956276 99 62 41.5 1 414 707 6 104 XP_065174484.1 uncharacterized protein LOC135804521 [Sycon ciliatum] diamond 297 66.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28968464 28968464 PRJNA1248424_P_NODE_37968_length_393_cov_1.425000_g31910_i0 PRJNA1248424 37968 393 1.425 5.60025 Dysidea avara 196820 Porifera other_Eukaryota 51.2 1.75e-4   NR XP_065901452.1 196820 g31910 i0 59 0.297709923664122 39 16 29.8 0 84 200 275 313 XP_065901452.1 uncharacterized protein [Dysidea avara] diamond 117 51.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
30578885 30578885 PRJNA1248424_P_NODE_58573_length_279_cov_1.694175_g52505_i0 PRJNA1248424 58573 279 1.694175 4.72674825 Dysidea avara 196820 Porifera other_Eukaryota 47.8 8.77e-4   NR XP_065911123.1 196820 g52505 i0 36.1 2.83870967741935 83 50 87.1 2 2 244 186 267 XP_065911123.1 uncharacterized protein [Dysidea avara] diamond 792 47.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31210548 31210548 PRJNA1248424_P_NODE_42175_length_356_cov_1.742049_g36113_i0 PRJNA1248424 42175 356 1.742049 6.20169444 Corticium candelabrum 121492 Porifera other_Eukaryota 47.8 0.00234   NR XP_062503890.1 121492 g36113 i0 39.4 2.32584269662921 66 36 52.2 1 64 249 191 256 XP_062503890.1 52 kDa repressor of the inhibitor of the protein kinase-like [Corticium candelabrum] diamond 828 47.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31387473 31387473 PRJNA1248424_P_NODE_56896_length_284_cov_0.834123_g50828_i0 PRJNA1248424 56896 284 0.834123 2.36890932 Metazoa 33208 Porifera other_Eukaryota 45.4 0.00667   NR XP_064398736.1 6063 g50828 i0 46.7 1.90140845070423 45 24 47.5 0 138 4 340 384 XP_064398736.1 inositol 1,4,5-trisphosphate receptor type 1-like [Halichondria panicea] diamond 540 45.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
31671874 31671874 PRJNA1248424_P_NODE_38697_length_385_cov_2.038462_g32637_i0 PRJNA1248424 38697 385 2.038462 7.8480787 Metazoa 33208 Porifera other_Eukaryota 63.5 8.81e-9   NR XP_065174753.1 27933 g32637 i0 52.8 4.86233766233766 53 25 41.3 0 354 196 281 333 XP_065174753.1 uncharacterized protein LOC135804736 [Sycon ciliatum] diamond 1872 63.5 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);;