RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA695273" and tax_phylum = "Porifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Porifera · 6 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA695273 · 6 ✖

analysis 1

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
26861519 26861519 PRJNA695273_P_NODE_24781_length_556_cov_4.391304_g24029_i0 PRJNA695273 24781 556 4.391304 24.41565024 Suberites domuncula 55567 Porifera other_Eukaryota 166 9.219999999999999e-48   NR AAX48882.1 55567 g24029 i0 59.9 0.820143884892086 152 61 82 0 555 100 84 235 AAX48882.1 S6 [Suberites domuncula] diamond 456 166 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Suberitida Suberitidae Suberites Suberites domuncula
27777777 27777777 PRJNA695273_P_NODE_161684_length_238_cov_2.690909_g160926_i0 PRJNA695273 161684 238 2.690909 6.40436342 Amphimedon queenslandica 400682 Porifera other_Eukaryota 91.3 1.69e-19   NR XP_011406359.1 400682 g160926 i0 55.8 0.970588235294118 77 32 97.1 1 1 231 309 383 XP_011406359.1 PREDICTED: COP9 signalosome complex subunit 4-like isoform X2 [Amphimedon queenslandica] diamond 231 91.3 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Haplosclerida Niphatidae Amphimedon Amphimedon queenslandica
28914048 28914048 PRJNA695273_P_NODE_152288_length_243_cov_0.905882_g151530_i0 PRJNA695273 152288 243 0.905882 2.20129326 Geodia barretti 519541 Porifera other_Eukaryota 43.5 0.0181   NR CAI8058561.1 519541 g151530 i0 57.9 0.938271604938272 38 16 46.9 0 115 2 52 89 CAI8058561.1 Transport and Golgi organization 2 homolog [Geodia barretti] diamond 228 43.5 1 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Tetractinellida Geodiidae Geodia Geodia barretti
29872824 29872824 PRJNA695273_P_NODE_146671_length_245_cov_0.895349_g145913_i0 PRJNA695273 146671 245 0.895349 2.19360505 root 1 Root_unresolved Root_unresolved 42.4 0.0426   NR XP_065907896.1 196820 g145913 i0 36.7 1.76326530612245 49 31 60 0 162 16 5 53 XP_065907896.1 rab-like protein 3 isoform X2 [Dysidea avara] diamond 432 42.7 0.992974238875878 Eukaryota Opisthokonta Metazoa Porifera Demospongiae Dictyoceratida Dysideidae Dysidea Dysidea avara
31852612 31852612 PRJNA695273_P_NODE_31157_length_489_cov_4.336538_g30399_i0 PRJNA695273 31157 489 4.336538 21.20567082 Corticium candelabrum 121492 Porifera other_Eukaryota 162 2.7199999999999994e-48   NR XP_062516633.1 121492 g30399 i0 67.7 3.20245398773006 127 39 77.9 1 32 412 1 125 XP_062516633.1 small ribosomal subunit protein eS17-like [Corticium candelabrum] diamond 1566 162 1 Eukaryota Opisthokonta Metazoa Porifera Homoscleromorpha Homosclerophorida Plakinidae Corticium Corticium candelabrum
32359234 32359234 PRJNA695273_P_NODE_112419_length_265_cov_3.010417_g111661_i0 PRJNA695273 112419 265 3.010417 7.97760505 Dysidea avara 196820 Porifera other_Eukaryota 84.7 3.17e-17   NR XP_065884381.1 196820 g111661 i0 44.2 0.973584905660377 86 48 97.4 0 7 264 156 241 XP_065884381.1 very-long-chain 3-oxoacyl-CoA reductase-like [Dysidea avara] diamond 258 84.7 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);;