RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "blastn", 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

  • blastn · 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
2782558 2782558 PRJNA1120060_P_NODE_1050783_length_311_cov_4.415966_g1032848_i0 PRJNA1120060 1050783 311 4.415966 13.73365426 Haliclona caerulea 1131259 Porifera other_Eukaryota 54.7 0.008   NTclustered gi|2260769234|gb|MW685914.1| 1131259 g1032848 i0 100 0.0932475884244373 29 0 9 0 108 136 961 989 Haliclona caerulea ATP-dependent RNA helicase vasa-like isoform X2 mRNA, partial cds blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Chalinidae Haliclona Haliclona caerulea
2785352 2785352 PRJNA1120060_P_NODE_1225803_length_310_cov_2.333333_g1207863_i0 PRJNA1120060 1225803 310 2.333333 7.2333323 Corticium candelabrum 121492 Porifera other_Eukaryota 52.8 0.029   NTclustered gi|2664285690|ref|XM_062646224.1| 121492 g1207863 i0 96.875 0.206451612903226 32 0 10 1 57 87 790 821 PREDICTED: Corticium candelabrum ribosomal protein S6 kinase delta-1-like (LOC134179356), transcript variant X1, mRNA blastn 64 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
5353158 5353158 PRJNA1120060_P_NODE_2314325_length_260_cov_4.459893_g2296265_i0 PRJNA1120060 2314325 260 4.459893 11.5957218 Halichondria panicea 6063 Porifera other_Eukaryota 54.7 0.007   NTclustered gi|2719012592|ref|XM_064540018.1| 6063 g2296265 i0 94.444 0.276923076923077 36 1 14 1 55 90 122 88 PREDICTED: Halichondria panicea uncharacterized LOC135343064 (LOC135343064), transcript variant X3, mRNA blastn 72 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
6619105 6619105 PRJNA1120060_P_NODE_1667546_length_286_cov_2.708920_g1649545_i0 PRJNA1120060 1667546 286 2.70892 7.7475112 Dysidea avara 196820 Porifera other_Eukaryota 52.8 0.026   NTclustered gi|2749509294|ref|XM_066063190.1| 196820 g1649545 i0 100 0.0979020979020979 28 0 10 0 117 144 637 610 PREDICTED: Dysidea avara centrosomal protein CCDC61-like (LOC136267968), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
6624824 6624824 PRJNA1120060_P_NODE_2086786_length_269_cov_2.479592_g2068746_i0 PRJNA1120060 2086786 269 2.479592 6.67010248 Dysidea avara 196820 Porifera other_Eukaryota 54.7 0.007   NTclustered gi|2749538898|ref|XM_066035694.1| 196820 g2068746 i0 100 0.539033457249071 29 0 11 0 224 252 2449 2421 PREDICTED: Dysidea avara uncharacterized protein (LOC136244156), transcript variant X3, mRNA blastn 145 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
7910105 7910105 PRJNA1120060_P_NODE_2919207_length_243_cov_1.794118_g2901114_i0 PRJNA1120060 2919207 243 1.794118 4.35970674 Amphimedon queenslandica 400682 Porifera other_Eukaryota 52.8 0.022   NTclustered gi|1133450477|ref|XM_020003336.1| 400682 g2901114 i0 100 0.345679012345679 28 0 12 0 91 118 2068 2041 PREDICTED: Amphimedon queenslandica methionine--tRNA ligase, cytoplasmic-like (LOC100632862), transcript variant X1, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
9188932 9188932 PRJNA1120060_P_NODE_3264248_length_228_cov_4.587097_g3246140_i0 PRJNA1120060 3264248 228 4.587097 10.45858116 Amphimedon queenslandica 400682 Porifera other_Eukaryota 52.8 0.02   NTclustered gi|1133470375|ref|XM_019999633.1| 400682 g3246140 i0 96.774 0.271929824561404 31 1 14 0 179 209 1593 1563 PREDICTED: Amphimedon queenslandica nucleolar transcription factor 1-like (LOC100639953), transcript variant X2, mRNA blastn 62 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
10441871 10441871 PRJNA1120060_P_NODE_1475109_length_294_cov_4.027149_g1457122_i0 PRJNA1120060 1475109 294 4.027149 11.83981806 Sycon ciliatum 27933 Porifera other_Eukaryota 54.7 0.008   NTclustered gi|2732941832|ref|XM_065338103.1| 27933 g1457122 i0 100 0.295918367346939 29 0 10 0 70 98 1674 1702 PREDICTED: Sycon ciliatum testis-expressed protein 47-like (LOC135825368), transcript variant X1, mRNA blastn 87 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
11736148 11736148 PRJNA1120060_P_NODE_2957250_length_242_cov_2.236686_g2939156_i0 PRJNA1120060 2957250 242 2.236686 5.41278012 Amphimedon queenslandica 400682 Porifera other_Eukaryota 52.8 0.022   NTclustered gi|1133484586|ref|XM_020004893.1| 400682 g2939156 i0 96.875 0.132231404958678 32 0 13 1 131 162 1525 1495 PREDICTED: Amphimedon queenslandica fibrillin-1-like (LOC100635497), partial mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
13002531 13002531 PRJNA1120060_P_NODE_2230231_length_264_cov_1.136126_g2212178_i0 PRJNA1120060 2230231 264 1.136126 2.99937264 Dysidea avara 196820 Porifera other_Eukaryota 63.9 1.11e-5   NTclustered gi|2749518822|ref|XM_066028510.1| 196820 g2212178 i0 93.023 0.162878787878788 43 3 16 0 8 50 791 833 PREDICTED: Dysidea avara heat shock cognate 71 kDa protein-like (LOC136238160), mRNA blastn 43 63.9 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
13002989 13002989 PRJNA1120060_P_NODE_2265551_length_262_cov_3.174603_g2247496_i0 PRJNA1120060 2265551 262 3.174603 8.31745986 Dysidea avara 196820 Porifera other_Eukaryota 52.8 0.024   NTclustered gi|2749581028|ref|XM_066056801.1| 196820 g2247496 i0 100 0.106870229007634 28 0 11 0 227 254 1790 1763 PREDICTED: Dysidea avara dynamin-1-like protein (LOC136262508), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
13018858 13018858 PRJNA1120060_P_NODE_379351_length_394_cov_3.246106_g361982_i0 PRJNA1120060 379351 394 3.246106 12.78965764 Amphimedon queenslandica 400682 Porifera other_Eukaryota 54.7 0.01   NTclustered gi|1133463911|ref|XM_019997157.1| 400682 g361982 i0 100 0.0736040609137056 29 0 7 0 259 287 2226 2198 PREDICTED: Amphimedon queenslandica SID1 transmembrane family member 1-like (LOC109582441), mRNA blastn 29 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
14290413 14290413 PRJNA1120060_P_NODE_3287332_length_227_cov_4.506494_g3269224_i0 PRJNA1120060 3287332 227 4.506494 10.22974138 Dysidea avara 196820 Porifera other_Eukaryota 52.8 0.02   NTclustered gi|2749501709|ref|XM_066040246.1| 196820 g3269224 i0 100 0.123348017621145 28 0 12 0 50 77 1141 1168 PREDICTED: Dysidea avara protein asteroid homolog 1-like (LOC136248464), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
15566221 15566221 PRJNA1120060_P_NODE_3475193_length_209_cov_4.639706_g3457067_i0 PRJNA1120060 3475193 209 4.639706 9.69698554 Corticium candelabrum 121492 Porifera other_Eukaryota 52.8 0.018   NTclustered gi|2664256946|ref|XM_062664867.1| 121492 g3457067 i0 100 0.133971291866029 28 0 13 0 9 36 920 947 PREDICTED: Corticium candelabrum survival of motor neuron-related-splicing factor 30-like (LOC134195788), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
18089901 18089901 PRJNA1120060_P_NODE_1462315_length_295_cov_2.882883_g1444330_i0 PRJNA1120060 1462315 295 2.882883 8.50450485 Amphimedon queenslandica 400682 Porifera other_Eukaryota 52.8 0.027   NTclustered gi|1133450078|ref|XM_020001789.1| 400682 g1444330 i0 100 0.284745762711864 28 0 9 0 2 29 2363 2390 PREDICTED: Amphimedon queenslandica uncharacterized LOC109585650 (LOC109585650), transcript variant X1, mRNA blastn 84 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
18109643 18109643 PRJNA1120060_P_NODE_2979595_length_242_cov_0.911243_g2961501_i0 PRJNA1120060 2979595 242 0.911243 2.20520806 Amphimedon queenslandica 400682 Porifera other_Eukaryota 54.7 0.006   NTclustered gi|1133494822|ref|XR_002190600.1| 400682 g2961501 i0 96.97 0.524793388429752 33 0 13 1 78 109 174 206 PREDICTED: Amphimedon queenslandica uncharacterized LOC109592865 (LOC109592865), transcript variant X2, ncRNA blastn 127 54.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
20638149 20638149 PRJNA1120060_P_NODE_1377317_length_299_cov_1.898230_g1359340_i0 PRJNA1120060 1377317 299 1.89823 5.6757077 Dysidea avara 196820 Porifera other_Eukaryota 52.8 0.028   NTclustered gi|2749594373|ref|XM_066062948.1| 196820 g1359340 i0 96.774 0.197324414715719 31 1 10 0 209 239 1173 1143 PREDICTED: Dysidea avara growth hormone-inducible transmembrane protein-like (LOC136267775), mRNA blastn 59 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
20666921 20666921 PRJNA1120060_P_NODE_412337_length_386_cov_1.293930_g394893_i0 PRJNA1120060 412337 386 1.29393 4.9945698 Dysidea avara 196820 Porifera other_Eukaryota 52.8 0.037   NTclustered gi|2749501469|ref|XM_066038745.1| 196820 g394893 i0 100 0.0725388601036269 28 0 7 0 202 229 1155 1128 PREDICTED: Dysidea avara receptor-type tyrosine-protein phosphatase S-like (LOC136247115), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
23205660 23205660 PRJNA1120060_P_NODE_2572899_length_251_cov_6.078652_g2554822_i0 PRJNA1120060 2572899 251 6.078652 15.25741652 Oscarella lobularis 121494 Porifera other_Eukaryota 52.8 0.023   NTclustered gi|2746781238|ref|XM_065974594.1| 121494 g2554822 i0 96.875 0.127490039840637 32 0 13 1 59 90 983 953 PREDICTED: Oscarella lobularis uncharacterized protein (LOC136187077), mRNA blastn 32 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
24460960 24460960 PRJNA1120060_P_NODE_1218960_length_310_cov_2.548523_g1201020_i0 PRJNA1120060 1218960 310 2.548523 7.9004213 Dysidea avara 196820 Porifera other_Eukaryota 52.8 0.029   NTclustered gi|2749530686|ref|XM_066034112.1| 196820 g1201020 i0 94.286 0.225806451612903 35 1 11 1 215 249 1435 1402 PREDICTED: Dysidea avara splicing factor ESS-2 homolog (LOC136242668), mRNA blastn 70 52.8 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);;