RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

tax_kingdom 1

  • Metazoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA352850 · 4 ✖
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
1071602 1071602 PRJNA352850_P_NODE_65581_length_281_cov_1.978448_g62748_i0 PRJNA352850 65581 281 1.978448 5.55943888 Metazoa 33208 Porifera other_Eukaryota 100 1.65e-24   NR XP_062522407.1 121492 g62748 i0 58.4 2.86120996441281 89 37 95 0 280 14 86 174 XP_062522407.1 large ribosomal subunit protein eL20-like [Corticium candelabrum] diamond 804 101 0.99009900990099 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
2945361 2945361 PRJNA352850_P_NODE_11163_length_997_cov_2.655063_g8787_i0 PRJNA352850 11163 997 2.655063 26.47097811 Aiolochroia crassa 261677 Porifera other_Eukaryota 158 2.08e-33   NTclustered gi|512765256|gb|KC869494.1| 261677 g8787 i0 89.516 14.7442326980943 124 13 12 0 49 172 1334 1211 Aiolochroia crassa voucher P04 28S ribosomal RNA gene, partial sequence blastn 14700 158 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Verongiida Aplysinidae Aiolochroia Aiolochroia crassa
27707046 27707046 PRJNA352850_P_NODE_24064_length_569_cov_12.603846_g21253_i0 PRJNA352850 24064 569 12.603846 71.71588374 Amphimedon queenslandica 400682 Porifera other_Eukaryota 53.5 2.24e-5   NR XP_003388485.1 400682 g21253 i0 33.3 1.04920913884007 93 61 49 1 69 347 50 141 XP_003388485.1 PREDICTED: cofilin-like [Amphimedon queenslandica] diamond 597 53.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28544912 28544912 PRJNA352850_P_NODE_70227_length_268_cov_1.388128_g67394_i0 PRJNA352850 70227 268 1.388128 3.72018304 Metazoa 33208 Porifera other_Eukaryota 77.4 2.65e-14   NR XP_065834967.1 121494 g67394 i0 75.6 7.0634328358209 45 11 50.4 0 23 157 355 399 XP_065834967.1 obg-like ATPase 1 [Oscarella lobularis] diamond 1893 77.8 0.994858611825193 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Oscarellidae Oscarella Oscarella lobularis

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