RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "diamond", bioproject = "PRJNA395690" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA395690 · 8 ✖

analysis 1

  • diamond · 8 ✖

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
13832545 13832545 PRJNA395690_P_NODE_34971_length_162_cov_0.902655_g34819_i0 PRJNA395690 34971 162 0.902655 1.4623011 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 95.9 7.76e-23   NR CAJ1953473.1 2856 g34819 i0 87 6 54 7 100 0 1 162 155 208 CAJ1953473.1 unnamed protein product [Cylindrotheca closterium] diamond 972 95.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
26600226 26600226 PRJNA395690_P_NODE_28761_length_167_cov_0.864407_g28609_i0 PRJNA395690 28761 167 0.864407 1.44355969 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 62 8.3e-10   NR KAI2511482.1 210448 g28609 i0 72.1 0.772455089820359 43 10 77.2 1 131 3 8 48 KAI2511482.1 PPPDE putative peptidase domain-containing protein [Fragilaria crotonensis] diamond 129 62 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
27012023 27012023 PRJNA395690_P_NODE_33882_length_163_cov_0.894737_g33730_i0 PRJNA395690 33882 163 0.894737 1.45842131 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 89.4 1.69e-20   NR XP_002186010.1 556484 g33730 i0 86.8 2.92638036809816 53 7 97.5 0 161 3 124 176 XP_002186010.1 predicted protein, partial [Phaeodactylum tricornutum CCAP 1055/1] diamond 477 89.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
27565897 27565897 PRJNA395690_P_NODE_13264_length_224_cov_0.868571_g13112_i0 PRJNA395690 13264 224 0.868571 1.94559904 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 55.5 6.12e-8   NR KAI2513692.1 210448 g13112 i0 62.5 1.125 40 15 53.6 0 4 123 46 85 KAI2513692.1 hypothetical protein MHU86_832 [Fragilaria crotonensis] diamond 252 55.5 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
28212116 28212116 PRJNA395690_P_NODE_33746_length_163_cov_0.894737_g33594_i0 PRJNA395690 33746 163 0.894737 1.45842131 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0127   NR KAL3919812.1 3061772 g33594 i0 40.7 0.993865030674847 54 30 95.7 1 4 159 154 207 KAL3919812.1 MAG: hypothetical protein SGILL_003567 [Bacillariaceae sp.] diamond 162 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29096529 29096529 PRJNA395690_P_NODE_23168_length_179_cov_1.453846_g23016_i0 PRJNA395690 23168 179 1.453846 2.60238434 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 48.1 1.99e-4   NR KAI2507915.1 210448 g23016 i0 48.4 1.07262569832402 64 24 98.9 3 1 177 71 130 KAI2507915.1 peptidase [Fragilaria crotonensis] diamond 192 48.1 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30675505 30675505 PRJNA395690_P_NODE_18453_length_190_cov_1.425532_g18301_i0 PRJNA395690 18453 190 1.425532 2.7085108 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 101 2.5e-24   NR XP_002184230.1 556484 g18301 i0 69.6 1.08947368421053 69 15 99.5 1 190 2 172 240 XP_002184230.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 207 101 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30801963 30801963 PRJNA395690_P_NODE_21934_length_182_cov_1.488722_g21782_i0 PRJNA395690 21934 182 1.488722 2.70947404 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0165   NR GAX13776.1 1519565 g21782 i0 43.6 1.31868131868132 39 22 64.3 0 119 3 51 89 GAX13776.1 hypothetical protein FisN_30Lh067 [Fistulifera solaris] diamond 240 42.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris

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