RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA1132896" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJNA1132896 · 7 ✖

analysis 1

tax_kingdom 0

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
29186351 29186351 PRJNA1132896_P_NODE_4909_length_276_cov_1.517241_g4818_i0 PRJNA1132896 4909 276 1.517241 4.18758516 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 59.3 7.95e-8   NR KAI2494492.1 210448 g4818 i0 29.8 1.82608695652174 84 57 91.3 1 24 275 215 296 KAI2494492.1 guanylate cyclase soluble subunit beta [Fragilaria crotonensis] diamond 504 59.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29375550 29375550 PRJNA1132896_P_NODE_10449_length_238_cov_2.036364_g10358_i0 PRJNA1132896 10449 238 2.036364 4.84654632 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.01   NR KAI2505682.1 210448 g10358 i0 37.7 0.970588235294118 77 46 94.5 1 230 6 832 908 KAI2505682.1 hypothetical protein MHU86_8741 [Fragilaria crotonensis] diamond 231 44.3 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29648441 29648441 PRJNA1132896_P_NODE_2430_length_352_cov_2.451613_g2339_i0 PRJNA1132896 2430 352 2.451613 8.62967776 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 94 2.59e-22   NR AID23594.1 2850 g2339 i0 80.3 3.11931818181818 61 12 52 0 3 185 12 72 AID23594.1 ubiquitin-ribosomal protein fusion S27a, partial [Phaeodactylum tricornutum] diamond 1098 94.4 0.995762711864407 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30860248 30860248 PRJNA1132896_P_NODE_7994_length_248_cov_0.880000_g7903_i0 PRJNA1132896 7994 248 0.88 2.1824 Thalassiosira pseudonana CCMP1335 296543 SAR_Eukaryotes SAR_Eukaryotes 100 1.09e-22   NR XP_002287807.1 296543 g7903 i0 63.3 1.8991935483871 79 29 95.6 0 247 11 330 408 XP_002287807.1 predicted protein [Thalassiosira pseudonana CCMP1335] diamond 471 100 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira pseudonana
32209160 32209160 PRJNA1132896_P_NODE_9458_length_243_cov_0.905882_g9367_i0 PRJNA1132896 9458 243 0.905882 2.20129326 Fragilariopsis 186035 SAR_Eukaryotes SAR_Eukaryotes 127 6.3e-33   NR OEU22687.1 635003 g9367 i0 77.9 3.75308641975309 77 17 95.1 0 242 12 341 417 OEU22687.1 DEAD-domain-containing protein [Fragilariopsis cylindrus CCMP1102] diamond 912 127 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
32304319 32304319 PRJNA1132896_P_NODE_1659_length_413_cov_1.620588_g1568_i0 PRJNA1132896 1659 413 1.620588 6.69302844 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82 4.44e-15   NR GAX12058.1 1519565 g1568 i0 50.9 1.90314769975787 116 48 81.4 5 23 358 393 503 GAX12058.1 polyadenylate-binding protein [Fistulifera solaris] diamond 786 82.8 0.990338164251208 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
32462357 32462357 PRJNA1132896_P_NODE_9119_length_244_cov_0.900585_g9028_i0 PRJNA1132896 9119 244 0.900585 2.1974274 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 65.5 3.6e-10   NR CAB9510324.1 568900 g9028 i0 46.5 1.84426229508197 71 37 86.1 1 212 3 723 793 CAB9510324.1 Phospholipid:diacylglycerol acyltransferase [Seminavis robusta] diamond 450 65.5 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta

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