RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Metazoa · 8 ✖

tax_clade 1

bioproject 1

  • PRJEB11748 · 8 ✖
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
8942478 8942478 PRJEB11748_P_NODE_182248_length_300_cov_1.334728_g180065_i0 PRJEB11748 182248 300 1.334728 4.004184 Oscarella lobularis 121494 Porifera other_Eukaryota 52.8 0.028   NTclustered gi|2746777157|ref|XM_065972481.1| 121494 g180065 i0 100 0.0933333333333333 28 0 9 0 73 100 329 302 PREDICTED: Oscarella lobularis E3 ubiquitin-protein ligase TRIM37-like (LOC136185367), mRNA blastn 28 52.8 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis
9912853 9912853 PRJEB11748_P_NODE_370588_length_187_cov_5.126984_g368405_i0 PRJEB11748 370588 187 5.126984 9.58746008 root 1 Root_unresolved Root_unresolved 79.3 3.91e-16   NR CAI8010652.1 519541 g368405 i0 80 2.16577540106952 45 9 72.2 0 175 41 103 147 CAI8010652.1 Uncharacterized protein BH2278 [Geodia barretti] diamond 405 79.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
13736919 13736919 PRJEB11748_P_NODE_201211_length_282_cov_21.316742_g199028_i0 PRJEB11748 201211 282 21.316742 60.11321244 Demospongiae 6042 Porifera other_Eukaryota 237 6.690000000000001e-58   NTclustered gi|1918108416|gb|MW150047.1| 593584 g199028 i0 84.17 91.8404255319149 259 25 89 11 25 274 191 442 Carteriospongia foliascens isolate CSGI08 large subunit ribosomal RNA gene, partial sequence blastn 25899 237 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Thorectidae Phyllospongia Phyllospongia foliascens
14045686 14045686 PRJEB11748_P_NODE_291952_length_223_cov_6.228395_g289769_i0 PRJEB11748 291952 223 6.228395 13.88932085 Hippospongia lachne 479639 Porifera other_Eukaryota 99 2.51e-16   NTclustered gi|387166032|gb|JQ606797.1| 479639 g289769 i0 91.549 2.33183856502242 71 6 32 0 25 95 122 52 Hippospongia lachne ATP synthase beta chain (ATPB) mRNA, partial cds blastn 520 99 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Spongiidae Hippospongia Hippospongia lachne
25210302 25210302 PRJEB11748_P_NODE_300860_length_219_cov_2.348101_g298677_i0 PRJEB11748 300860 219 2.348101 5.14234119 root 1 Root_unresolved Root_unresolved 87.8 3.59e-18   NR CAI8038099.1 519541 g298677 i0 61 3.94520547945205 59 20 76.7 1 33 200 16 74 CAI8038099.1 Assimilatory nitrate reductase catalytic subunit [Geodia barretti] diamond 864 88.6 0.99097065462754 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
31865855 31865855 PRJEB11748_P_NODE_174277_length_307_cov_19.154472_g172094_i0 PRJEB11748 174277 307 19.154472 58.80422904 Amphimedon queenslandica 400682 Porifera other_Eukaryota 43.5 0.0404   NR XP_019855979.1 400682 g172094 i0 31.7 0.801302931596091 82 47 73.3 2 39 263 190 269 XP_019855979.1 PREDICTED: BRCA1-associated protein-like [Amphimedon queenslandica] diamond 246 43.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
32404028 32404028 PRJEB11748_P_NODE_13379_length_1293_cov_4.896916_g12192_i0 PRJEB11748 13379 1293 4.896916 63.31712388 Dysidea avara 196820 Porifera other_Eukaryota 55.5 3.67e-4   NR XP_065905315.1 196820 g12192 i0 32 1.25986078886311 147 63 26.5 3 810 1151 184 326 XP_065905315.1 ATP-dependent DNA helicase PIF1-like [Dysidea avara] diamond 1629 55.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
32688024 32688024 PRJEB11748_P_NODE_217880_length_269_cov_2.951923_g215697_i0 PRJEB11748 217880 269 2.951923 7.94067287 Corticium candelabrum 121492 Porifera other_Eukaryota 45.4 0.00585   NR XP_062500681.1 121492 g215697 i0 35.8 0.747211895910781 67 42 73.6 1 43 240 256 322 XP_062500681.1 uncharacterized protein LOC134177920 [Corticium candelabrum] diamond 201 45.4 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);;