RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where bioproject = "PRJNA798511", tax_kingdom = "Metazoa" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Porifera · 16 ✖

tax_kingdom 1

  • Metazoa · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA798511 · 16 ✖
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
5893743 5893743 PRJNA798511_P_NODE_28145_length_570_cov_2.989940_g23923_i0 PRJNA798511 28145 570 2.98994 17.042658 Suberites domuncula 55567 Porifera other_Eukaryota 75 1.2e-8   NTclustered gi|61654659|gb|AY857437.1| 55567 g23923 i0 84.932 0.250877192982456 73 11 13 0 3 75 446 374 Suberites domuncula L23a mRNA, complete cds blastn 143 75 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
17369542 17369542 PRJNA798511_P_NODE_85494_length_256_cov_0.879781_g81228_i0 PRJNA798511 85494 256 0.879781 2.25223936 Dysidea avara 196820 Porifera other_Eukaryota 52.8 0.023   NTclustered gi|2749561033|ref|XR_010700655.1| 196820 g81228 i0 100 0.109375 28 0 11 0 155 182 2601 2628 PREDICTED: Dysidea avara uncharacterized lncRNA (LOC136254667), ncRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27464908 27464908 PRJNA798511_P_NODE_70103_length_289_cov_1.282407_g65837_i0 PRJNA798511 70103 289 1.282407 3.70615623 Dysidea avara 196820 Porifera other_Eukaryota 94 7.800000000000001e-22   NR XP_065902475.1 196820 g65837 i0 55.4 0.955017301038062 92 40 95.5 1 14 289 14 104 XP_065902475.1 uncharacterized protein [Dysidea avara] diamond 276 94 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
27591285 27591285 PRJNA798511_P_NODE_87504_length_252_cov_1.245810_g83238_i0 PRJNA798511 87504 252 1.24581 3.1394412 Amphimedon queenslandica 400682 Porifera other_Eukaryota 80.5 9.82e-16   NR XP_011408502.2 400682 g83238 i0 51.3 0.952380952380952 80 39 95.2 0 240 1 229 308 XP_011408502.2 PREDICTED: zinc finger BED domain-containing protein 1-like [Amphimedon queenslandica] diamond 240 80.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28348803 28348803 PRJNA798511_P_NODE_33626_length_487_cov_2.321256_g29368_i0 PRJNA798511 33626 487 2.321256 11.30451672 Sycon ciliatum 27933 Porifera other_Eukaryota 55.1 2.42e-5   NR XP_065191239.1 27933 g29368 i0 39.8 2.40246406570842 83 42 51.1 3 249 1 413 487 XP_065191239.1 uncharacterized protein LOC135822406 [Sycon ciliatum] diamond 1170 55.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28452763 28452763 PRJNA798511_P_NODE_45846_length_380_cov_0.960912_g41581_i0 PRJNA798511 45846 380 0.960912 3.6514656 Metazoa 33208 Porifera other_Eukaryota 75.1 7.72e-13   NR XP_065911078.1 196820 g41581 i0 64.8 2.59736842105263 54 19 42.6 0 380 219 126 179 XP_065911078.1 signal recognition particle subunit SRP54-like [Dysidea avara] diamond 987 75.5 0.994701986754967 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
28569792 28569792 PRJNA798511_P_NODE_81727_length_263_cov_1.357895_g77461_i0 PRJNA798511 81727 263 1.357895 3.57126385 Amphimedon queenslandica 400682 Porifera other_Eukaryota 53.5 7.41e-6   NR XP_003391733.2 400682 g77461 i0 40 1.57414448669202 65 39 74.1 0 258 64 133 197 XP_003391733.2 PREDICTED: zinc finger BED domain-containing protein 1-like [Amphimedon queenslandica] diamond 414 53.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28736793 28736793 PRJNA798511_P_NODE_74287_length_279_cov_1.242718_g70021_i0 PRJNA798511 74287 279 1.242718 3.46718322 Metazoa 33208 Porifera other_Eukaryota 68.2 3.65e-11   NR XP_062523628.1 121492 g70021 i0 53.6 4.96774193548387 69 31 73.1 1 215 12 64 132 XP_062523628.1 uncharacterized protein LOC134198281 [Corticium candelabrum] diamond 1386 68.6 0.994169096209913 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
28822146 28822146 PRJNA798511_P_NODE_71288_length_286_cov_1.262911_g67022_i0 PRJNA798511 71288 286 1.262911 3.61192546 Dysidea avara 196820 Porifera other_Eukaryota 103 2.3499999999999994e-23   NR XP_065901351.1 196820 g67022 i0 52.7 3.9020979020979 93 44 97.6 0 282 4 307 399 XP_065901351.1 uncharacterized protein [Dysidea avara] diamond 1116 103 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29138425 29138425 PRJNA798511_P_NODE_39389_length_426_cov_1.569405_g35127_i0 PRJNA798511 39389 426 1.569405 6.6856653 Sycon ciliatum 27933 Porifera other_Eukaryota 71.6 2.03e-11   NR XP_065174484.1 27933 g35127 i0 50.7 0.485915492957746 69 33 47.9 1 189 392 71 139 XP_065174484.1 uncharacterized protein LOC135804521 [Sycon ciliatum] diamond 207 71.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29548423 29548423 PRJNA798511_P_NODE_22070_length_726_cov_1.845329_g17999_i0 PRJNA798511 22070 726 1.845329 13.39708854 Dysidea avara 196820 Porifera other_Eukaryota 92 3.15e-17   NR XP_065883270.1 196820 g17999 i0 34.3 2.94214876033058 178 100 69.8 4 150 656 352 521 XP_065883270.1 uncharacterized protein [Dysidea avara] diamond 2136 92 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31254596 31254596 PRJNA798511_P_NODE_85955_length_255_cov_1.142857_g81689_i0 PRJNA798511 85955 255 1.142857 2.91428535 Dysidea avara 196820 Porifera other_Eukaryota 47.8 6.65e-4   NR XP_065893269.1 196820 g81689 i0 40.2 1.56470588235294 82 42 88.2 2 251 27 61 142 XP_065893269.1 zinc finger protein with KRAB and SCAN domains 2-like [Dysidea avara] diamond 399 47.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31476137 31476137 PRJNA798511_P_NODE_103516_length_241_cov_0.869048_g99250_i0 PRJNA798511 103516 241 0.869048 2.09440568 Dysidea avara 196820 Porifera other_Eukaryota 67.8 5.16e-11   NR XP_065887226.1 196820 g99250 i0 47.4 2.20331950207469 57 30 71 0 11 181 258 314 XP_065887226.1 uncharacterized protein [Dysidea avara] diamond 531 67.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31634091 31634091 PRJNA798511_P_NODE_45716_length_380_cov_2.345277_g41451_i0 PRJNA798511 45716 380 2.345277 8.9120526 Sycon ciliatum 27933 Porifera other_Eukaryota 58.9 3.98e-7   NR XP_065198712.1 27933 g41451 i0 62.5 2.18684210526316 48 16 36.3 1 286 149 706 753 XP_065198712.1 uncharacterized protein LOC135830379, partial [Sycon ciliatum] diamond 831 58.9 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31728959 31728959 PRJNA798511_P_NODE_13357_length_1199_cov_3.256661_g10258_i0 PRJNA798511 13357 1199 3.256661 39.04736539 Dysidea avara 196820 Porifera other_Eukaryota 84 8.29e-14   NR XP_065916423.1 196820 g10258 i0 28 1.57881567973311 157 111 39.3 1 843 373 73 227 XP_065916423.1 uncharacterized protein [Dysidea avara] diamond 1893 84 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32086120 32086120 PRJNA798511_P_NODE_55158_length_334_cov_3.137931_g50892_i0 PRJNA798511 55158 334 3.137931 10.48068954 Metazoa 33208 Porifera other_Eukaryota 93.6 1.27e-19   NR XP_065901351.1 196820 g50892 i0 45 10.6526946107784 111 58 98.8 2 1 330 272 380 XP_065901351.1 uncharacterized protein [Dysidea avara] diamond 3558 93.6 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);;