RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJNA1087264", 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 · 18 ✖

tax_kingdom 1

  • Metazoa · 18 ✖

tax_clade 1

bioproject 1

  • PRJNA1087264 · 18 ✖
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
5296762 5296762 PRJNA1087264_P_NODE_1185_length_611_cov_2.519573_g1111_i0 PRJNA1087264 1185 611 2.519573 15.39459103 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 232 1.0300000000000001e-71   NR CCQ42791.1 433461 g1111 i0 80 6.03436988543372 135 27 66.3 0 3 407 251 385 CCQ42791.1 methionine adenosyltransferase homolog A [Leucosolenia complicata] diamond 3687 233 0.995708154506438 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Leucosoleniidae Leucosolenia Leucosolenia complicata
16771047 16771047 PRJNA1087264_P_NODE_5674_length_268_cov_1.082192_g5592_i0 PRJNA1087264 5674 268 1.082192 2.90027456 Halichondria panicea 6063 Porifera other_Eukaryota 178 3.88e-40   NTclustered gi|2719047883|ref|XM_064532147.1| 6063 g5592 i0 79.6 12.7313432835821 250 49 93 2 20 268 3874 3626 PREDICTED: Halichondria panicea colorectal mutant cancer protein-like (LOC135336384), mRNA blastn 3412 178 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
26592451 26592451 PRJNA1087264_P_NODE_12181_length_181_cov_1.159091_g12099_i0 PRJNA1087264 12181 181 1.159091 2.09795471 Halichondria panicea 6063 Porifera other_Eukaryota 55.8 3.72e-7   NR XP_064404546.1 6063 g12099 i0 47.4 0.94475138121547 57 28 94.5 1 176 6 173 227 XP_064404546.1 uncharacterized protein LOC135349847 [Halichondria panicea] diamond 171 55.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
26678891 26678891 PRJNA1087264_P_NODE_7701_length_227_cov_0.887640_g7619_i0 PRJNA1087264 7701 227 0.88764 2.0149428 Metazoa 33208 Porifera other_Eukaryota 57.4 2.07e-7   NR XP_065890435.1 196820 g7619 i0 44.6 1.66519823788546 65 33 81.9 1 227 42 643 707 XP_065890435.1 filamin-B-like [Dysidea avara] diamond 378 57.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
26750611 26750611 PRJNA1087264_P_NODE_17361_length_165_cov_0.879310_g17279_i0 PRJNA1087264 17361 165 0.87931 1.4508615 Hymeniacidon perlevis 177573 Porifera other_Eukaryota 62.4 2.74e-10   NR ABO26247.1 177573 g17279 i0 66 0.854545454545454 47 16 85.5 0 149 9 62 108 ABO26247.1 14-3-3 K, partial [Hymeniacidon perlevis] diamond 141 62.4 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Hymeniacidon Hymeniacidon perlevis
28141611 28141611 PRJNA1087264_P_NODE_11785_length_184_cov_0.925926_g11703_i0 PRJNA1087264 11785 184 0.925926 1.70370384 Oscarella lobularis 121494 Porifera other_Eukaryota 90.9 1.8e-19   NR XP_065826796.1 121494 g11703 i0 69.5 3.8804347826087 59 18 96.2 0 180 4 105 163 XP_065826796.1 protein disulfide-isomerase 2-like [Oscarella lobularis] diamond 714 90.9 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
28764176 28764176 PRJNA1087264_P_NODE_387_length_1018_cov_2.065015_g331_i1 PRJNA1087264 387 1018 2.065015 21.0218527 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 302 2.85e-98   NR XP_065181635.1 27933 g331 i1 54.8 27.3477406679764 292 127 84.6 2 976 116 1 292 XP_065181635.1 large ribosomal subunit protein uL18-like [Sycon ciliatum] diamond 27840 305 0.99016393442623 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28795660 28795660 PRJNA1087264_P_NODE_2507_length_422_cov_1.981233_g2426_i0 PRJNA1087264 2507 422 1.981233 8.36080326 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 129 1.99e-35   NR XP_065199206.1 27933 g2426 i0 56.3 7.4218009478673 119 49 84.6 1 391 35 3 118 XP_065199206.1 large ribosomal subunit protein eL22-like [Sycon ciliatum] diamond 3132 129 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28890453 28890453 PRJNA1087264_P_NODE_11948_length_182_cov_1.917293_g11866_i0 PRJNA1087264 11948 182 1.917293 3.48947326 Metazoa 33208 Porifera other_Eukaryota 83.6 6.7e-17   NR XP_065177937.1 27933 g11866 i0 74.1 6.24725274725275 54 14 89 0 163 2 353 406 XP_065177937.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 1-like [Sycon ciliatum] diamond 1137 83.6 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
28994174 28994174 PRJNA1087264_P_NODE_3908_length_330_cov_1.619217_g3826_i0 PRJNA1087264 3908 330 1.619217 5.3434161 Corticium candelabrum 121492 Porifera other_Eukaryota 57.8 5.57e-7   NR XP_062508375.1 121492 g3826 i0 59.5 1.52727272727273 42 17 38.2 0 1 126 701 742 XP_062508375.1 supervillin-like isoform X2 [Corticium candelabrum] diamond 504 57.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29183500 29183500 PRJNA1087264_P_NODE_2969_length_383_cov_1.679641_g2888_i0 PRJNA1087264 2969 383 1.679641 6.43302503 Amphimedon queenslandica 400682 Porifera other_Eukaryota 68.2 2.4e-10   NR XP_019849166.1 400682 g2888 i0 36.6 2.90600522193211 123 75 94.8 2 383 21 807 928 XP_019849166.1 PREDICTED: uncharacterized protein LOC100640739 [Amphimedon queenslandica] diamond 1113 68.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
30415423 30415423 PRJNA1087264_P_NODE_11853_length_183_cov_1.485075_g11771_i0 PRJNA1087264 11853 183 1.485075 2.71768725 Sycon ciliatum 27933 Porifera other_Eukaryota 57 1.53e-7   NR XP_065178514.1 27933 g11771 i0 45.2 1.95081967213115 62 25 93.4 2 6 176 385 442 XP_065178514.1 protein DD3-3-like [Sycon ciliatum] diamond 357 57 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31047284 31047284 PRJNA1087264_P_NODE_19535_length_163_cov_0.894737_g19453_i0 PRJNA1087264 19535 163 0.894737 1.45842131 Sycon ciliatum 27933 Porifera other_Eukaryota 76.3 1.93e-14   NR XP_065190022.1 27933 g19453 i0 74.4 0.791411042944785 43 11 79.1 0 163 35 500 542 XP_065190022.1 uncharacterized protein LOC135820899 [Sycon ciliatum] diamond 129 76.3 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31047285 31047285 PRJNA1087264_P_NODE_21395_length_161_cov_0.910714_g21313_i0 PRJNA1087264 21395 161 0.910714 1.46624954 Sycon ciliatum 27933 Porifera other_Eukaryota 43.1 0.0087   NR XP_065196878.1 27933 g21313 i0 41.5 2.53416149068323 41 24 76.4 0 11 133 196 236 XP_065196878.1 clavesin-1-like [Sycon ciliatum] diamond 408 43.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31521360 31521360 PRJNA1087264_P_NODE_1196_length_609_cov_2.225000_g1122_i0 PRJNA1087264 1196 609 2.225 13.55025 Corticium candelabrum 121492 Porifera other_Eukaryota 125 3.1299999999999996e-32   NR XP_062517332.1 121492 g1122 i0 63.6 2.06896551724138 88 32 43.3 0 342 605 82 169 XP_062517332.1 large ribosomal subunit protein uL22-like [Corticium candelabrum] diamond 1260 125 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
32185685 32185685 PRJNA1087264_P_NODE_1638_length_525_cov_2.560924_g1558_i0 PRJNA1087264 1638 525 2.560924 13.444851 Geodia barretti 519541 Porifera other_Eukaryota 148 1.04e-41   NR CAI8030757.1 519541 g1558 i0 52.8 0.908571428571429 159 60 86.9 6 4 459 25 175 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 477 148 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
32335464 32335464 PRJNA1087264_P_NODE_1539_length_540_cov_2.354379_g1462_i0 PRJNA1087264 1539 540 2.3543790000000002 12.7136466 Metazoa 33208 Porifera other_Eukaryota 235 6.21e-70   NR XP_065827681.1 121494 g1462 i0 64.4 19 180 63 100 1 540 1 453 631 XP_065827681.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 2-like [Oscarella lobularis] diamond 10260 237 0.991561181434599 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32817148 32817148 PRJNA1087264_P_NODE_18640_length_164_cov_0.886957_g18558_i0 PRJNA1087264 18640 164 0.886957 1.45460948 Corticium candelabrum 121492 Porifera other_Eukaryota 82.8 1.8e-17   NR XP_062502332.1 121492 g18558 i0 62.7 2.72560975609756 51 19 93.3 0 158 6 110 160 XP_062502332.1 proteasome subunit alpha type-3-like [Corticium candelabrum] diamond 447 82.8 1 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);;