RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA785164", 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 · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA785164 · 3 ✖

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
8419316 8419316 PRJNA785164_P_NODE_40227_length_284_cov_1.530806_g39762_i0 PRJNA785164 40227 284 1.5308059999999999 4.34748904 Fragilaria famelica 1003135 SAR_Eukaryotes SAR_Eukaryotes 152 2.51e-32   NTclustered gi|2862228909|gb|PQ645543.1| 1003135 g39762 i0 77.032 43.1549295774648 283 53 99 8 1 282 3771 3500 Fragilaria famelica isolate AGSB0425 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 12256 152 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria famelica
24165220 24165220 PRJNA785164_P_NODE_62839_length_237_cov_5.591463_g62374_i0 PRJNA785164 62839 237 5.591463 13.25176731 Entomoneis 186042 SAR_Eukaryotes SAR_Eukaryotes 230 9.16e-56   NTclustered gi|2202538958|gb|OM891864.1| 216750 g62374 i0 86.603 9.79746835443038 209 26 88 2 13 220 4053 3846 Entomoneis cf. alata 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 2322 230 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae   Entomoneidaceae Entomoneis Entomoneis cf. alata
30306927 30306927 PRJNA785164_P_NODE_24352_length_378_cov_1.409836_g23887_i0 PRJNA785164 24352 378 1.409836 5.32918008 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 96.7 1.53e-20   NR KAL3942371.1 3061772 g23887 i0 52.4 1.31746031746032 82 39 65.1 0 2 247 135 216 KAL3942371.1 MAG: hypothetical protein SGBAC_003437 [Bacillariaceae sp.] diamond 498 96.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.

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