RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA1120586", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1120586 · 3 ✖

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
2303770 2303770 PRJNA1120586_P_NODE_42322_length_233_cov_1.097561_g42131_i0 PRJNA1120586 42322 233 1.097561 2.55731713 Cyclotella 29203 SAR_Eukaryotes SAR_Eukaryotes 429 8.239999999999998e-116   NTclustered gi|2589355395|ref|NC_077461.1| 29204 g42131 i0 100 199.042918454936 232 0 99 0 2 233 69838 69607 Cyclotella cryptica chloroplast, complete genome blastn 46377 429 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
5379457 5379457 PRJNA1120586_P_NODE_47405_length_229_cov_2.350000_g47214_i0 PRJNA1120586 47405 229 2.35 5.3815 Proschkinia sp. SZCZR1824 2588390 SAR_Eukaryotes SAR_Eukaryotes 78.7 3.37e-10   NTclustered gi|1681061561|gb|MH800316.1| 2588390 g47214 i0 81.188 2.79039301310044 101 16 44 3 128 227 4414 4512 Proschkinia sp. SZCZR1824 mitochondrion, complete genome blastn 639 78.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Proschkiniaceae Proschkinia Proschkinia sp. SZCZR1824
7406222 7406222 PRJNA1120586_P_NODE_26326_length_272_cov_2.009852_g26135_i0 PRJNA1120586 26326 272 2.009852 5.46679744 Coscinodiscophyceae 33836 SAR_Eukaryotes SAR_Eukaryotes 492 1.24e-134   NTclustered gi|98978879|gb|DQ512398.1| 29204 g26135 i0 99.265 99.9154411764706 272 2 100 0 1 272 106 377 Cyclotella sp. CCMP331 large subunit ribosomal RNA gene, partial sequence blastn 27177 492 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica

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