RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where bioproject = "PRJEB12237", 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

  • PRJEB12237 · 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
5123063 5123063 PRJEB12237_P_NODE_3725_length_339_cov_2.138158_g3529_i0 PRJEB12237 3725 339 2.138158 7.24835562 Metazoa 33208 Porifera other_Eukaryota 147 6.0999999999999996e-43   NR XP_065826293.1 121494 g3529 i0 82.5 6.3716814159292 80 14 70.8 0 339 100 51 130 XP_065826293.1 small ribosomal subunit protein uS8 [Oscarella lobularis] diamond 2160 147 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
7672917 7672917 PRJEB12237_P_NODE_767_length_827_cov_3.219697_g635_i0 PRJEB12237 767 827 3.219697 26.62689419 Metazoa 33208 Porifera other_Eukaryota 263 5.61e-84   NR XP_065181635.1 27933 g635 i0 53.9 16.8790810157195 254 110 90 3 1 744 35 287 XP_065181635.1 large ribosomal subunit protein uL18-like [Sycon ciliatum] diamond 13959 263 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
16597463 16597463 PRJEB12237_P_NODE_1214_length_662_cov_3.792663_g1051_i0 PRJEB12237 1214 662 3.792663 25.10742906 Corticium candelabrum 121492 Porifera other_Eukaryota 146 1.57e-39   NR XP_062516318.1 121492 g1051 i0 65.2 1.22809667673716 132 46 59.8 0 661 266 102 233 XP_062516318.1 small ribosomal subunit protein eS6-like [Corticium candelabrum] diamond 813 146 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
16597492 16597492 PRJEB12237_P_NODE_454_length_1049_cov_3.047337_g360_i0 PRJEB12237 454 1049 3.047337 31.96656513 Metazoa 33208 Porifera other_Eukaryota 336 1.4699999999999994e-110   NR XP_003383564.1 400682 g360 i0 61.1 7.42135367016206 288 108 81.8 3 1049 192 51 336 XP_003383564.1 PREDICTED: 60S ribosomal protein L4-A-like [Amphimedon queenslandica] diamond 7785 336 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
22662561 22662561 PRJEB12237_P_NODE_7038_length_214_cov_0.944134_g6842_i0 PRJEB12237 7038 214 0.944134 2.02044676 Suberitida 1779162 Porifera other_Eukaryota 222 1.36e-53   NTclustered gi|321266729|gb|HQ379324.1| 279590 g6842 i0 85.581 100.752336448598 215 28 100 3 1 214 367 579 Suberites massa voucher BELUM:Mc4528 28S ribosomal RNA gene, partial sequence blastn 21561 222 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites massa
26614999 26614999 PRJEB12237_P_NODE_7641_length_201_cov_1.120482_g7445_i0 PRJEB12237 7641 201 1.120482 2.25216882 Metazoa 33208 Porifera other_Eukaryota 60.8 8.83e-9   NR XP_019849217.1 400682 g7445 i0 43.3 3.95522388059702 67 38 100 0 201 1 46 112 XP_019849217.1 PREDICTED: 26S proteasome non-ATPase regulatory subunit 12-like [Amphimedon queenslandica] diamond 795 60.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
26709787 26709787 PRJEB12237_P_NODE_541_length_969_cov_2.817987_g439_i0 PRJEB12237 541 969 2.817987 27.30629403 Opisthokonta 33154 Porifera other_Eukaryota 360 1.68e-115   NR XP_065827681.1 121494 g439 i0 59.9 31.2600619195046 297 109 92 2 964 74 449 735 XP_065827681.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 2-like [Oscarella lobularis] diamond 30291 360 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
27380859 27380859 PRJEB12237_P_NODE_5863_length_243_cov_2.475962_g5667_i0 PRJEB12237 5863 243 2.475962 6.01658766 Geodia barretti 519541 Porifera other_Eukaryota 62.8 3.17e-9   NR CAI8057942.1 519541 g5667 i0 40 0.925925925925926 75 45 92.6 0 3 227 484 558 CAI8057942.1 Filamin-B [Geodia barretti] diamond 225 62.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
27406184 27406184 PRJEB12237_P_NODE_10123_length_167_cov_1.757576_g9927_i0 PRJEB12237 10123 167 1.757576 2.93515192 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 96.3 9.32e-23   NR AAX48832.1 55567 g9927 i0 78.2 17.7844311377245 55 12 98.8 0 1 165 33 87 AAX48832.1 L2/L8, partial [Suberites domuncula] diamond 2970 97.1 0.991761071060762 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
29685258 29685258 PRJEB12237_P_NODE_2510_length_444_cov_3.026895_g2314_i0 PRJEB12237 2510 444 3.026895 13.4394138 Dysidea avara 196820 Porifera other_Eukaryota 62.8 3.31e-8   NR XP_065890435.1 196820 g2314 i0 42.5 1.43918918918919 73 39 47.3 1 432 223 635 707 XP_065890435.1 filamin-B-like [Dysidea avara] diamond 639 62.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29748460 29748460 PRJEB12237_P_NODE_7451_length_205_cov_0.941176_g7255_i0 PRJEB12237 7451 205 0.941176 1.9294108 Halichondria panicea 6063 Porifera other_Eukaryota 63.5 1.9e-10   NR XP_064400518.1 6063 g7255 i0 46.5 1.0390243902439 71 34 98 1 1 201 80 150 XP_064400518.1 uncharacterized protein LOC135346725 [Halichondria panicea] diamond 213 63.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30190883 30190883 PRJEB12237_P_NODE_5412_length_258_cov_1.385650_g5216_i0 PRJEB12237 5412 258 1.38565 3.574977 Sycon ciliatum 27933 Porifera other_Eukaryota 45.1 0.00708   NR XP_065182620.1 27933 g5216 i0 30 1.62790697674419 70 46 81.4 1 212 3 3510 3576 XP_065182620.1 serine-rich adhesin for platelets-like [Sycon ciliatum] diamond 420 45.1 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31201614 31201614 PRJEB12237_P_NODE_8515_length_187_cov_2.092105_g8319_i0 PRJEB12237 8515 187 2.092105 3.91223635 Corticium candelabrum 121492 Porifera other_Eukaryota 84.7 2.87e-17   NR XP_062503430.1 121492 g8319 i0 59 0.978609625668449 61 25 97.9 0 2 184 367 427 XP_062503430.1 uncharacterized protein LOC134180315 [Corticium candelabrum] diamond 183 84.7 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31448825 31448825 PRJEB12237_P_NODE_10736_length_161_cov_2.222222_g10540_i0 PRJEB12237 10736 161 2.222222 3.57777742 Metazoa 33208 Porifera other_Eukaryota 67.8 1.78e-11   NR XP_065197126.1 27933 g10540 i0 68.2 6.33540372670807 44 14 82 0 133 2 357 400 XP_065197126.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 2-like [Sycon ciliatum] diamond 1020 68.2 0.994134897360704 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
31606912 31606912 PRJEB12237_P_NODE_1336_length_625_cov_4.284746_g1169_i0 PRJEB12237 1336 625 4.284746 26.7796625 Porifera 6040 Porifera other_Eukaryota 174 1.34e-51   NR XP_062508348.1 121492 g1169 i0 70.9 6.1248 127 37 61 0 424 44 36 162 XP_062508348.1 large ribosomal subunit protein uL23-like [Corticium candelabrum] diamond 3828 175 0.994285714285714 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31765002 31765002 PRJEB12237_P_NODE_8677_length_185_cov_1.333333_g8481_i0 PRJEB12237 8677 185 1.333333 2.46666605 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 47.4 4.01e-4   NR XP_065844640.1 121494 g8481 i0 36.1 1.92972972972973 61 39 98.9 0 184 2 382 442 XP_065844640.1 nucleolar RNA helicase 2-like [Oscarella lobularis] diamond 357 47.4 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32656501 32656501 PRJEB12237_P_NODE_6340_length_230_cov_1.523077_g6144_i0 PRJEB12237 6340 230 1.523077 3.5030771 Halichondria panicea 6063 Porifera other_Eukaryota 119 1.15e-30   NR XP_064395651.1 6063 g6144 i0 69.3 2.94782608695652 75 23 97.8 0 3 227 110 184 XP_064395651.1 large ribosomal subunit protein uL18 [Halichondria panicea] diamond 678 119 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
32688170 32688170 PRJEB12237_P_NODE_1080_length_704_cov_2.641256_g925_i0 PRJEB12237 1080 704 2.641256 18.59444224 Geodia barretti 519541 Porifera other_Eukaryota 130 4.38e-34   NR CAI8030757.1 519541 g925 i0 49.7 0.660511363636364 155 63 63.1 6 445 2 18 164 CAI8030757.1 hypothetical protein GBAR_LOCUS17449 [Geodia barretti] diamond 465 130 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti

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