RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "blastn", bioproject = "PRJNA493827" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 14 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA493827 · 14 ✖

analysis 1

  • blastn · 14 ✖
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
471883 471883 PRJNA493827_P_NODE_206921_length_246_cov_1.335260_g204723_i0 PRJNA493827 206921 246 1.33526 3.2847396 Sycon ciliatum 27933 Porifera other_Eukaryota 52.8 0.022   NTclustered gi|2732908006|ref|XM_065342033.1| 27933 g204723 i0 100 0.113821138211382 28 0 11 0 86 113 4822 4795 PREDICTED: Sycon ciliatum uncharacterized LOC135829634 (LOC135829634), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
473410 473410 PRJNA493827_P_NODE_56281_length_471_cov_2.138191_g54088_i0 PRJNA493827 56281 471 2.138191 10.07087961 Corticium candelabrum 121492 Porifera other_Eukaryota 52.8 0.046   NTclustered gi|2664260756|ref|XM_062665769.1| 121492 g54088 i0 100 0.059447983014862 28 0 6 0 443 470 563 536 PREDICTED: Corticium candelabrum uncharacterized LOC134196592 (LOC134196592), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
3020837 3020837 PRJNA493827_P_NODE_123423_length_308_cov_0.880851_g121225_i0 PRJNA493827 123423 308 0.880851 2.71302108 Corticium candelabrum 121492 Porifera other_Eukaryota 58.4 6.18e-4   NTclustered gi|2664244428|ref|XM_062662286.1| 121492 g121225 i0 97.059 1.62012987012987 34 1 11 0 77 110 1805 1838 PREDICTED: Corticium candelabrum 60 kDa heat shock protein, mitochondrial-like (LOC134193457), mRNA blastn 499 58.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
3020990 3020990 PRJNA493827_P_NODE_129823_length_300_cov_1.356828_g127625_i0 PRJNA493827 129823 300 1.356828 4.070484 Corticium candelabrum 121492 Porifera other_Eukaryota 139 2.08e-28   NTclustered gi|2575805697|emb|OY729849.1| 121492 g127625 i0 82.143 54.4833333333333 168 24 55 6 1 164 1707 1872 Corticium candelabrum genome assembly, organelle: mitochondrion blastn 16345 139 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
4300820 4300820 PRJNA493827_P_NODE_82824_length_378_cov_1.655738_g80626_i0 PRJNA493827 82824 378 1.655738 6.25868964 Haliclona sp. BKON-2565 3127636 Porifera other_Eukaryota 204 9.39e-48   NTclustered gi|2899163455|gb|PP464275.1| 3127636 g80626 i0 86.813 52.8730158730159 182 24 48 0 137 318 2009 2190 Haliclona sp. BKON-2565 isolate H2565 mitochondrion, complete genome blastn 19986 204 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Chalinidae Haliclona Haliclona sp. BKON-2565
5574193 5574193 PRJNA493827_P_NODE_151665_length_278_cov_1.448780_g149467_i0 PRJNA493827 151665 278 1.44878 4.0276084 Halichondria panicea 6063 Porifera other_Eukaryota 56.5 0.002   NTclustered gi|2719014413|ref|XR_010397257.1| 6063 g149467 i0 92.308 0.140287769784173 39 3 14 0 2 40 6493 6455 PREDICTED: Halichondria panicea uncharacterized LOC135343896 (LOC135343896), ncRNA blastn 39 56.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
13859512 13859512 PRJNA493827_P_NODE_58711_length_460_cov_0.971576_g56515_i0 PRJNA493827 58711 460 0.971576 4.4692496 Tetractinellida 1779164 Porifera other_Eukaryota 58.4 0.001   NTclustered gi|2689368883|emb|OZ019967.1| 37505 g56515 i0 100 0.778260869565217 31 0 7 0 123 153 1832 1802 Theonella swinhoei genome assembly, organelle: mitochondrion blastn 358 58.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Theonellidae Theonella Theonella swinhoei
14499579 14499579 PRJNA493827_P_NODE_161392_length_270_cov_0.791878_g159194_i0 PRJNA493827 161392 270 0.791878 2.1380706 Oscarella lobularis 121494 Porifera other_Eukaryota 82.4 3.16e-11   NTclustered gi|2746761520|ref|XM_065984741.1| 121494 g159194 i0 84.524 0.311111111111111 84 11 31 2 188 270 732 650 PREDICTED: Oscarella lobularis ras-related C3 botulinum toxin substrate 1-like (LOC136195419), mRNA blastn 84 82.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
19595607 19595607 PRJNA493827_P_NODE_110856_length_325_cov_1.023810_g108658_i0 PRJNA493827 110856 325 1.02381 3.3273825 Dysidea avara 196820 Porifera other_Eukaryota 54.7 0.008   NTclustered gi|2749514101|ref|XM_066026259.1| 196820 g108658 i0 96.97 0.101538461538462 33 0 10 1 37 69 1033 1002 PREDICTED: Dysidea avara uncharacterized protein (LOC136236154), mRNA blastn 33 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
19599104 19599104 PRJNA493827_P_NODE_49936_length_505_cov_1.759259_g47746_i0 PRJNA493827 49936 505 1.759259 8.88425795 Oscarella lobularis 121494 Porifera other_Eukaryota 52.8 0.049   NTclustered gi|2746756016|ref|XM_065981980.1| 121494 g47746 i0 100 0.0554455445544554 28 0 6 0 97 124 2114 2141 PREDICTED: Oscarella lobularis mitogen-activated protein kinase kinase kinase 15-like (LOC136193159), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
22782722 22782722 PRJNA493827_P_NODE_24658_length_769_cov_1.477011_g22738_i0 PRJNA493827 24658 769 1.477011 11.35821459 Oscarella 121493 Porifera other_Eukaryota 176 4.39e-39   NTclustered gi|2390907861|emb|OX382170.1| 121494 g22738 i0 77.244 28.5461638491547 312 63 40 7 170 475 12351 12660 Oscarella lobularis genome assembly, organelle: mitochondrion blastn 21952 176 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
23423416 23423416 PRJNA493827_P_NODE_168919_length_263_cov_1.621053_g166721_i0 PRJNA493827 168919 263 1.621053 4.26336939 Diacarnus erythraeanus 879318 Porifera other_Eukaryota 226 1.3399999999999998e-54   NTclustered gi|2701815514|emb|OZ024687.1| 879318 g166721 i0 82.264 81.9315589353612 265 44 100 3 1 263 17784 17521 Diacarnus erythraeanus genome assembly, organelle: mitochondrion blastn 21548 226 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Poecilosclerida Podospongiidae Diacarnus Diacarnus erythraeanus
23423456 23423456 PRJNA493827_P_NODE_171119_length_261_cov_2.250000_g168921_i0 PRJNA493827 171119 261 2.25 5.8725 Corticium candelabrum 121492 Porifera other_Eukaryota 58.4 5.12e-4   NTclustered gi|2664233471|ref|XM_062656582.1| 121492 g168921 i0 100 11.1226053639847 31 0 12 0 3 33 495 525 PREDICTED: Corticium candelabrum nucleosome assembly protein 1-like 1-B (LOC134188412), mRNA blastn 2903 58.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
24697871 24697871 PRJNA493827_P_NODE_211620_length_245_cov_1.343023_g209422_i0 PRJNA493827 211620 245 1.343023 3.29040635 Dysidea avara 196820 Porifera other_Eukaryota 150 7.62e-32   NTclustered gi|2749507860|ref|XM_066028672.1| 196820 g209422 i0 78.39 21.4938775510204 236 47 96 4 3 236 286 519 PREDICTED: Dysidea avara tubulin alpha-1A chain-like (LOC136238273), mRNA blastn 5266 150 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara

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