RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where bioproject = "PRJNA964500", tax_clade = "Sar" 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

  • PRJNA964500 · 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
3492542 3492542 PRJNA964500_S_NODE_6643_length_220_cov_50418.036649_g6551_i0 PRJNA964500 6643 220 50418.036649 110919.6806278 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 276 1.06e-69   NTclustered gi|1169296926|gb|KY364696.1| 29205 g6551 i0 96.407 70.5681818181818 167 6 76 0 1 167 4022 4188 Cyclotella meneghiniana 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 15525 276 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
13695521 13695521 PRJNA964500_S_NODE_8231_length_202_cov_12.520231_g8139_i0 PRJNA964500 8231 202 12.520231 25.29086662 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 311 2.63e-80   NTclustered gi|1169296927|gb|KY364697.1| 29204 g8139 i0 98.305 87.6237623762376 177 3 88 0 26 202 4377 4201 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 17700 311 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
16567998 16567998 PRJNA964500_S_NODE_8033_length_204_cov_51.382857_g7941_i0 PRJNA964500 8033 204 51.382857 104.82102828 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 344 2.62e-90   NTclustered gi|1169296927|gb|KY364697.1| 29204 g7941 i0 98.958 97.9558823529412 192 2 94 0 1 192 4430 4621 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 19983 344 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
17519920 17519920 PRJNA964500_S_NODE_8854_length_196_cov_7468.520958_g8762_i0 PRJNA964500 8854 196 7468.520958 14638.30107768 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 257 3.3500000000000004e-64   NTclustered gi|98978886|gb|DQ512405.1| 29205 g8762 i0 100 70.9642857142857 139 0 71 0 10 148 274 136 Cyclotella menegheniana strain LS03-01 large subunit ribosomal RNA gene, partial sequence blastn 13909 257 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
18793642 18793642 PRJNA964500_S_NODE_6035_length_229_cov_46977.820000_g5943_i0 PRJNA964500 6035 229 46977.82 107579.2078 Stephanocyclus meneghinianus 29205 SAR_Eukaryotes SAR_Eukaryotes 322 1.41e-83   NTclustered gi|98990680|gb|DQ514856.1| 29205 g5943 i0 98.361 79.7903930131004 183 3 80 0 1 183 601 783 Cyclotella menegheniana strain LS03-01 18S small subunit ribosomal RNA gene, partial sequence blastn 18272 322 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Thalassiosiraceae Stephanocyclus Stephanocyclus meneghinianus
19116895 19116895 PRJNA964500_S_NODE_5975_length_230_cov_47778.582090_g5883_i0 PRJNA964500 5975 230 47778.58209 109890.738807 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 327 3.05e-85   NTclustered gi|1169296927|gb|KY364697.1| 29204 g5883 i0 98.913 80 184 1 80 1 48 230 1634 1451 Cyclotella cryptica 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, complete sequence blastn 18400 327 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
20391776 20391776 PRJNA964500_S_NODE_12516_length_171_cov_5.859155_g12424_i0 PRJNA964500 12516 171 5.859155 10.01915505 Bacillariophyta 2836 SAR_Eukaryotes SAR_Eukaryotes 263 6.08e-66   NTclustered gi|2202538974|gb|OM891880.1| 355634 g12424 i0 98.013 66.8304093567251 151 3 88 0 13 163 4391 4241 Navicula arenaria 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 11428 263 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Navicula Navicula arenaria

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