RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB30004", tax_phylum = "Bacillariophyta" and tax_superkingdom = "Eukaryota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

  • Eukaryota · 7 ✖

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB30004 · 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
1321104 1321104 PRJEB30004_P_NODE_528562_length_183_cov_3.236111_g512935_i0 PRJEB30004 528562 183 3.236111 5.92208313 Sellaphora blackfordensis 433383 SAR_Eukaryotes SAR_Eukaryotes 193 8.8e-45   NTclustered gi|1829658070|gb|MN319622.1| 433383 g512935 i0 89.865 67.0491803278689 148 15 81 0 1 148 285 432 Sellaphora blackfordensis voucher (Bfp04)02 28S ribosomal RNA gene, partial sequence blastn 12270 193 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Sellaphoraceae Sellaphora Sellaphora blackfordensis
2263999 2263999 PRJEB30004_P_NODE_596262_length_167_cov_2.882812_g580635_i0 PRJEB30004 596262 167 2.882812 4.81429604 Thalassiosirales 33847 SAR_Eukaryotes SAR_Eukaryotes 303 3.5e-78   NTclustered gi|2739942923|dbj|LC814783.1| 41457 g580635 i0 99.401 197.928143712575 167 1 100 0 1 167 4647 4481 Skeletonema pseudocostatum NIES-2843 chloroplast DNA, complete genome blastn 33054 303 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema pseudocostatum
8978014 8978014 PRJEB30004_P_NODE_613608_length_164_cov_1.312000_g597981_i0 PRJEB30004 613608 164 1.312 2.15168 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 60.2 8.18e-5   NTclustered gi|2125739626|gb|MZ520767.1| 2770866 g597981 i0 97.143 1.32317073170732 35 1 21 0 103 137 16520 16486 Schizostauron trachyderma strain SZCZE1420 mitochondrion, complete genome blastn 217 60.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Stauroneidaceae Schizostauron Schizostauron trachyderma
10255963 10255963 PRJEB30004_P_NODE_661469_length_155_cov_1.387931_g645842_i0 PRJEB30004 661469 155 1.387931 2.15129305 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 231 1.53e-56   NTclustered gi|2785082235|gb|PQ157946.1| 2126271 g645842 i0 93.59 102.948387096774 156 8 100 2 1 155 5668 5514 Naviculales sp. strain SZCZO2114 mitochondrion, complete genome blastn 15957 231 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales     Naviculales sp.
15016319 15016319 PRJEB30004_P_NODE_141132_length_488_cov_4.035635_g125598_i0 PRJEB30004 141132 488 4.035635 19.6938988 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 846 0   NTclustered gi|2194766164|gb|OK505009.1| 2856 g125598 i0 97.951 199 488 10 100 0 1 488 19116 19603 Cylindrotheca closterium chloroplast, complete genome blastn 97112 852 0.992957746478873 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
17889899 17889899 PRJEB30004_P_NODE_351095_length_251_cov_1.037736_g335468_i0 PRJEB30004 351095 251 1.037736 2.60471736 Entomoneis sp. 186043 SAR_Eukaryotes SAR_Eukaryotes 102 2.23e-17   NTclustered gi|1372147530|gb|MF997419.1| 186043 g335468 i0 75.304 0.98406374501992 247 44 96 16 1 240 21460 21224 Entomoneis sp. mitochondrion, complete genome blastn 247 102 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis sp.
24256208 24256208 PRJEB30004_P_NODE_181420_length_406_cov_5.362398_g165811_i0 PRJEB30004 181420 406 5.362398 21.77133588 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 579 1.45e-160   NTclustered gi|146762526|gb|EF553458.1| 2850 g165811 i0 92.593 100.137931034483 405 27 99 3 2 405 4085 4487 Phaeodactylum tricornutum strain CCAP 1055/1 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 40656 579 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum

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