RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA588137" and tax_phylum = "Cnidaria"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cnidaria · 7 ✖

tax_kingdom 1

tax_clade 1

bioproject 1

  • PRJNA588137 · 7 ✖

analysis 1

  • diamond · 7 ✖
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
22241872 22241872 PRJNA588137_S_NODE_5298_length_268_cov_1.230769_g5265_i0 PRJNA588137 5298 268 1.230769 3.29846092 Metazoa 33208 Cnidaria other_Eukaryota 149 6.899999999999998e-44   NR XP_029193069.2 45264 g5265 i0 77.3 76.8022388059701 88 20 98.5 0 266 3 36 123 XP_029193069.2 40S ribosomal protein S15a isoform X1 [Acropora millepora] diamond 20583 149 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Acroporidae Acropora Acropora millepora
28847980 28847980 PRJNA588137_S_NODE_5768_length_260_cov_0.882353_g5735_i0 PRJNA588137 5768 260 0.882353 2.2941178 Stylophora pistillata 50429 Cnidaria other_Eukaryota 68.6 3.71e-11   NR PFX23400.1 50429 g5735 i0 83.3 0.484615384615385 42 7 48.5 0 133 258 447 488 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 126 68.6 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
28879650 28879650 PRJNA588137_S_NODE_4728_length_279_cov_1.334951_g4695_i0 PRJNA588137 4728 279 1.334951 3.72451329 Stylophora pistillata 50429 Cnidaria other_Eukaryota 115 1.8e-27   NR PFX23400.1 50429 g4695 i0 72.5 0.978494623655914 91 25 97.8 0 5 277 331 421 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 273 115 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
30932810 30932810 PRJNA588137_S_NODE_5654_length_262_cov_0.777778_g5621_i0 PRJNA588137 5654 262 0.777778 2.03777836 Stylophora pistillata 50429 Cnidaria other_Eukaryota 133 3.41e-34   NR PFX23400.1 50429 g5621 i0 80.5 0.99618320610687 87 17 99.6 0 262 2 460 546 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 261 133 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
31818019 31818019 PRJNA588137_S_NODE_1277_length_434_cov_1.066482_g1244_i0 PRJNA588137 1277 434 1.066482 4.62853188 Stylophora pistillata 50429 Cnidaria other_Eukaryota 153 1.58e-40   NR PFX23400.1 50429 g1244 i0 63.8 2.77188940092166 141 51 97.5 0 11 433 406 546 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 1203 153 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
32514462 32514462 PRJNA588137_S_NODE_2379_length_345_cov_0.941176_g2346_i0 PRJNA588137 2379 345 0.941176 3.2470572 Stylophora pistillata 50429 Cnidaria other_Eukaryota 167 2.57e-46   NR PFX23400.1 50429 g2346 i0 80.7 0.991304347826087 114 22 99.1 0 3 344 433 546 PFX23400.1 Carbonic anhydrase 2 [Stylophora pistillata] diamond 342 167 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Pocilloporidae Stylophora Stylophora pistillata
32546022 32546022 PRJNA588137_S_NODE_5039_length_273_cov_1.155000_g5006_i0 PRJNA588137 5039 273 1.155 3.15315 Porites evermanni 104178 Cnidaria other_Eukaryota 69.7 1.61e-11   NR CAH3187153.1 104178 g5006 i0 56.6 1.17582417582418 53 21 58.2 1 80 238 290 340 CAH3187153.1 unnamed protein product [Porites evermanni] diamond 321 69.7 1 Eukaryota Opisthokonta Metazoa Cnidaria Anthozoa Scleractinia Poritidae Porites Porites evermanni

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