RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA695273", 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

  • PRJNA695273 · 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
678457 678457 PRJNA695273_P_NODE_54941_length_368_cov_1.566102_g54183_i0 PRJNA695273 54941 368 1.566102 5.76325536 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 161 1.19e-48   NR AID23573.1 2850 g54183 i0 79.1 2.22554347826087 91 19 74.2 0 368 96 21 111 AID23573.1 ribosomal protein, partial [Phaeodactylum tricornutum] diamond 819 162 0.993827160493827 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
5011840 5011840 PRJNA695273_P_NODE_93904_length_286_cov_2.422535_g93146_i0 PRJNA695273 93904 286 2.422535 6.9284501 Stephanodiscus 29206 SAR_Eukaryotes SAR_Eukaryotes 529 1e-145   NTclustered gi|98978951|gb|DQ512470.1| 29207 g93146 i0 100 100 286 0 100 0 1 286 83 368 Stephanodiscus hantzschii strain WTC21 large subunit ribosomal RNA gene, partial sequence blastn 28600 529 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
12661615 12661615 PRJNA695273_P_NODE_148290_length_244_cov_1.678363_g147532_i0 PRJNA695273 148290 244 1.678363 4.09520572 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 451 1.86e-122   NTclustered gi|268633306|gb|GQ844874.1| 29207 g147532 i0 100 100 244 0 100 0 1 244 175 418 Stephanodiscus hantzschii isolate UTCC 267 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 24400 451 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
20308891 20308891 PRJNA695273_P_NODE_25556_length_546_cov_2.219873_g24802_i0 PRJNA695273 25556 546 2.219873 12.12050658 Stephanodiscaceae 1365474 SAR_Eukaryotes SAR_Eukaryotes 1002 0   NTclustered gi|2728413771|gb|OR666656.1| 386076 g24802 i0 99.817 197.990842490842 545 1 99 0 1 545 69111 69655 Discostella stelligera strain SXU-YN191 chloroplast, complete genome blastn 108103 1007 0.995034756703079 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Discostella Discostella stelligera
21584480 21584480 PRJNA695273_P_NODE_151417_length_243_cov_1.941176_g150659_i0 PRJNA695273 151417 243 1.941176 4.71705768 Thalassiosira 35127 SAR_Eukaryotes SAR_Eukaryotes 394 3.16e-105   NTclustered gi|2862228846|gb|PQ645480.1| 1048533 g150659 i0 95.885 100.065843621399 243 10 100 0 1 243 4179 3937 Thalassiosira bioculata isolate AGSB0307 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 24316 394 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Thalassiosira Thalassiosira bioculata
23629878 23629878 PRJNA695273_P_NODE_141239_length_246_cov_2.664740_g140481_i0 PRJNA695273 141239 246 2.66474 6.5552604 Stephanodiscus hantzschii 29207 SAR_Eukaryotes SAR_Eukaryotes 455 1.4500000000000002e-123   NTclustered gi|2728413202|gb|OR666652.1| 3145218 g140481 i0 100 198.040650406504 246 0 100 0 1 246 70459 70704 Stephanodiscus hantzschii f. tenuis chloroplast, complete genome blastn 48718 455 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus hantzschii
31073457 31073457 PRJNA695273_P_NODE_99615_length_280_cov_1.487923_g98857_i0 PRJNA695273 99615 280 1.487923 4.1661844 root 1 Root_unresolved Root_unresolved 75.9 1.13e-13   NR KAI2504000.1 210448 g98857 i0 40.9 9.87857142857143 93 55 99.6 0 279 1 86 178 KAI2504000.1 NPCBM-associated [Fragilaria crotonensis] diamond 2766 76.6 0.990861618798956 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis

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