RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJEB49404", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB49404 · 7 ✖

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
3940485 3940485 PRJEB49404_P_NODE_576484_length_164_cov_1.312000_g562683_i0 PRJEB49404 576484 164 1.312 2.15168 Schizostauron trachyderma 2770866 SAR_Eukaryotes SAR_Eukaryotes 60.2 8.18e-5   NTclustered gi|2125739626|gb|MZ520767.1| 2770866 g562683 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
10297746 10297746 PRJEB49404_P_NODE_163209_length_406_cov_5.362398_g149423_i0 PRJEB49404 163209 406 5.362398 21.77133588 Phaeodactylum tricornutum 2850 SAR_Eukaryotes SAR_Eukaryotes 579 1.45e-160   NTclustered gi|146762526|gb|EF553458.1| 2850 g149423 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
14144987 14144987 PRJEB49404_P_NODE_623752_length_155_cov_1.387931_g609951_i0 PRJEB49404 623752 155 1.387931 2.15129305 Naviculales sp. 2126271 SAR_Eukaryotes SAR_Eukaryotes 231 1.53e-56   NTclustered gi|2785082235|gb|PQ157946.1| 2126271 g609951 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.
16678820 16678820 PRJEB49404_P_NODE_322094_length_251_cov_1.037736_g308293_i0 PRJEB49404 322094 251 1.037736 2.60471736 Entomoneis sp. 186043 SAR_Eukaryotes SAR_Eukaryotes 102 2.23e-17   NTclustered gi|1372147530|gb|MF997419.1| 186043 g308293 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.
17568944 17568944 PRJEB49404_P_NODE_559874_length_167_cov_2.398438_g546073_i0 PRJEB49404 559874 167 2.398438 4.00539146 Thalassiosirales 33847 SAR_Eukaryotes SAR_Eukaryotes 303 3.5e-78   NTclustered gi|2739942923|dbj|LC814783.1| 41457 g546073 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
21787081 21787081 PRJEB49404_P_NODE_493418_length_183_cov_3.236111_g479617_i0 PRJEB49404 493418 183 3.236111 5.92208313 Sellaphora blackfordensis 433383 SAR_Eukaryotes SAR_Eukaryotes 193 8.8e-45   NTclustered gi|1829658070|gb|MN319622.1| 433383 g479617 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
27159668 27159668 PRJEB49404_P_NODE_594202_length_160_cov_2.363636_g580401_i0 PRJEB49404 594202 160 2.363636 3.7818176 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0321   NR CAB9497903.1 568900 g580401 i0 43.9 0.76875 41 23 76.9 0 37 159 1770 1810 CAB9497903.1 expressed unknown protein [Seminavis robusta] diamond 123 41.6 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);;