RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where bioproject = "PRJEB14664", tax_clade = "Opisthokonta" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Porifera · 20 ✖

tax_kingdom 1

tax_clade 1

  • Opisthokonta · 20 ✖

bioproject 1

  • PRJEB14664 · 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
2571019 2571019 PRJEB14664_P_NODE_12343_length_209_cov_0.971264_g12213_i0 PRJEB14664 12343 209 0.971264 2.02994176 Opisthokonta 33154 Porifera other_Eukaryota 124 1.85e-34   NR XP_003389687.1 400682 g12213 i0 85.5 80.1961722488038 69 10 99 0 1 207 14 82 XP_003389687.1 PREDICTED: 60S ribosomal protein L23 [Amphimedon queenslandica] diamond 16761 124 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
2571133 2571133 PRJEB14664_P_NODE_4803_length_391_cov_3.679775_g4673_i0 PRJEB14664 4803 391 3.679775 14.38792025 Dysidea avara 196820 Porifera other_Eukaryota 147 9.54e-43   NR XP_065916847.1 196820 g4673 i0 72.6 8.13299232736573 117 32 89.8 0 38 388 1 117 XP_065916847.1 large ribosomal subunit protein uL29-like [Dysidea avara] diamond 3180 147 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
2571150 2571150 PRJEB14664_P_NODE_63_length_2607_cov_4.388802_g57_i0 PRJEB14664 63 2607 4.388802 114.41606814 Metazoa 33208 Porifera other_Eukaryota 690 2.2e-234   NR XP_064391610.1 6063 g57 i0 65.6 13.1472957422325 518 168 59.1 5 68 1609 13 524 XP_064391610.1 major vault protein-like [Halichondria panicea] diamond 34275 695 0.992805755395683 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
8638851 8638851 PRJEB14664_P_NODE_967_length_935_cov_3.348889_g892_i0 PRJEB14664 967 935 3.348889 31.31211215 Porifera 6040 Porifera other_Eukaryota 321 1.05e-102   NR XP_019850454.1 400682 g892 i0 54 7.77754010695187 302 139 96.9 0 908 3 226 527 XP_019850454.1 PREDICTED: annexin A4-like isoform X1 [Amphimedon queenslandica] diamond 7272 321 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
8948281 8948281 PRJEB14664_P_NODE_88_length_2333_cov_4.579634_g80_i0 PRJEB14664 88 2333 4.579634 106.84286122 Merlia normani 1325619 Porifera other_Eukaryota 193 1.3599999999999999e-43   NTclustered gi|514227047|gb|KC952723.1| 1325619 g80 i0 82.883 13.1225889412773 222 29 9 9 739 954 249 31 Merlia normani voucher MNRJ15831 16S ribosomal RNA gene, partial sequence; mitochondrial blastn 30615 193 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Merliida Merliidae Merlia Merlia normani
9913938 9913938 PRJEB14664_P_NODE_4148_length_430_cov_2.458228_g4021_i0 PRJEB14664 4148 430 2.458228 10.5703804 Corticium candelabrum 121492 Porifera other_Eukaryota 113 5.01e-26   NR XP_062510978.1 121492 g4021 i0 43 0.990697674418605 142 64 99.1 3 428 3 402 526 XP_062510978.1 uncharacterized protein LOC134186907 [Corticium candelabrum] diamond 426 113 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
11499311 11499311 PRJEB14664_P_NODE_590_length_1175_cov_2.534211_g533_i0 PRJEB14664 590 1175 2.534211 29.77697925 Oscarella lobularis 121494 Porifera other_Eukaryota 419 9.45e-138   NR XP_065831306.1 121494 g533 i0 54.7 0.947234042553191 371 155 93.7 4 2 1102 349 710 XP_065831306.1 uncharacterized protein [Oscarella lobularis] diamond 1113 419 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
12774870 12774870 PRJEB14664_P_NODE_8051_length_280_cov_3.808163_g7921_i0 PRJEB14664 8051 280 3.808163 10.6628564 Metazoa 33208 Porifera other_Eukaryota 123 6.04e-34   NR XP_062513731.1 121492 g7921 i0 69.7 3.81428571428571 89 27 95.4 0 2 268 28 116 XP_062513731.1 large ribosomal subunit protein eL31-like [Corticium candelabrum] diamond 1068 123 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
14049287 14049287 PRJEB14664_P_NODE_13612_length_195_cov_1.481250_g13482_i0 PRJEB14664 13612 195 1.48125 2.8884375 Geodia barretti 519541 Porifera other_Eukaryota 72.8 1.97e-13   NR CAI8022810.1 519541 g13482 i0 53.1 0.984615384615385 64 30 98.5 0 2 193 83 146 CAI8022810.1 60S ribosomal protein L7a [Geodia barretti] diamond 192 72.8 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
14049449 14049449 PRJEB14664_P_NODE_9912_length_243_cov_1.971154_g9782_i0 PRJEB14664 9912 243 1.971154 4.78990422 Oscarella lobularis 121494 Porifera other_Eukaryota 71.3 6.05e-8   NTclustered gi|2746761540|ref|XM_065984752.1| 121494 g9782 i0 92 16.3827160493827 50 4 21 0 143 192 983 934 PREDICTED: Oscarella lobularis ice-structuring glycoprotein-like (LOC136195428), mRNA blastn 3981 71.3 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
20421971 20421971 PRJEB14664_P_NODE_6577_length_320_cov_2.592982_g6447_i0 PRJEB14664 6577 320 2.592982 8.2975424 Opisthokonta 33154 Porifera other_Eukaryota 124 2.12e-33   NR XP_065903164.1 196820 g6447 i0 59 4.753125 100 40 92.8 1 297 1 8 107 XP_065903164.1 muscle-specific protein 20-like [Dysidea avara] diamond 1521 124 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
26811563 26811563 PRJEB14664_P_NODE_12621_length_205_cov_1.970588_g12491_i0 PRJEB14664 12621 205 1.970588 4.0397054 Hymeniacidon perlevis 177573 Porifera other_Eukaryota 79.7 9.1e-17   NR ABO26247.1 177573 g12491 i0 52.8 1.30243902439024 89 21 99.5 1 2 205 75 163 ABO26247.1 14-3-3 K, partial [Hymeniacidon perlevis] diamond 267 79.7 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Hymeniacidon Hymeniacidon perlevis
28675403 28675403 PRJEB14664_P_NODE_12927_length_202_cov_1.676647_g12797_i0 PRJEB14664 12927 202 1.676647 3.38682694 Dysidea avara 196820 Porifera other_Eukaryota 98.2 3.33e-22   NR XP_065913902.1 196820 g12797 i0 65.6 2.86633663366337 64 22 95 0 2 193 128 191 XP_065913902.1 carboxypeptidase B-like [Dysidea avara] diamond 579 98.2 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
29117514 29117514 PRJEB14664_P_NODE_7769_length_287_cov_2.222222_g7639_i0 PRJEB14664 7769 287 2.222222 6.37777714 Sycon ciliatum 27933 Porifera other_Eukaryota 45.8 0.00497   NR XP_065196663.1 27933 g7639 i0 37.9 0.606271777003484 58 35 60.6 1 189 16 23 79 XP_065196663.1 carboxypeptidase B-like [Sycon ciliatum] diamond 174 45.8 1 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
29275017 29275017 PRJEB14664_P_NODE_18429_length_159_cov_1.290323_g18299_i0 PRJEB14664 18429 159 1.290323 2.05161357 Corticium candelabrum 121492 Porifera other_Eukaryota 62 1.85e-9   NR XP_062515280.1 121492 g18299 i0 49 0.962264150943396 51 26 96.2 0 155 3 389 439 XP_062515280.1 PH domain-containing protein DDB_G0267786-like [Corticium candelabrum] diamond 153 62 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
29457972 29457972 PRJEB14664_P_NODE_11750_length_216_cov_1.546961_g11620_i0 PRJEB14664 11750 216 1.546961 3.34143576 root 1 Root_unresolved Root_unresolved 107 1.38e-26   NR XP_064382981.1 6063 g11620 i0 66.2 2.875 71 24 98.6 0 2 214 153 223 XP_064382981.1 small ribosomal subunit protein eS4-like [Halichondria panicea] diamond 621 107 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Halichondriidae Halichondria Halichondria panicea
30311562 30311562 PRJEB14664_P_NODE_13232_length_199_cov_1.396341_g13102_i0 PRJEB14664 13232 199 1.396341 2.77871859 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 97.8 2.9e-22   NR XP_065175017.1 27933 g13102 i0 74.6 13.4924623115578 63 16 95 0 11 199 250 312 XP_065175017.1 fructose-bisphosphate aldolase C-like [Sycon ciliatum] diamond 2685 98.2 0.995926680244399 Eukaryota Opisthokonta Metazoa Porifera Calcarea Leucosolenida Sycettidae Sycon Sycon ciliatum
30917910 30917910 PRJEB14664_P_NODE_5754_length_348_cov_1.488818_g5624_i0 PRJEB14664 5754 348 1.488818 5.18108664 Corticium candelabrum 121492 Porifera other_Eukaryota 187 8.399999999999998e-56   NR XP_062507119.1 121492 g5624 i0 71.3 2 115 33 99.1 0 2 346 65 179 XP_062507119.1 beta-1,3-glucan-binding protein-like [Corticium candelabrum] diamond 696 187 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
31227216 31227216 PRJEB14664_P_NODE_1815_length_687_cov_2.707055_g1710_i0 PRJEB14664 1815 687 2.707055 18.59746785 Porifera 6040 Porifera other_Eukaryota 317 7.42e-104   NR XP_065833345.1 121494 g1710 i0 66.4 2.8646288209607 220 74 96.1 0 2 661 214 433 XP_065833345.1 uncharacterized protein [Oscarella lobularis] diamond 1968 317 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
32782668 32782668 PRJEB14664_P_NODE_8800_length_264_cov_2.096070_g8670_i0 PRJEB14664 8800 264 2.09607 5.5336248 Dysidea avara 196820 Porifera other_Eukaryota 133 5.52e-34   NR XP_065906866.1 196820 g8670 i0 69 2.92045454545455 87 26 97.7 1 262 5 219 305 XP_065906866.1 uncharacterized protein [Dysidea avara] diamond 771 133 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);;