RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA600413", tax_clade = "Sar" and tax_phylum = "Bacillariophyta"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Bacillariophyta · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA600413 · 6 ✖

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
27617134 27617134 PRJNA600413_P_NODE_142304_length_162_cov_0.902655_g141603_i0 PRJNA600413 142304 162 0.902655 1.4623011 Fragilariopsis cylindrus CCMP11 186039 SAR_Eukaryotes SAR_Eukaryotes 69.3 3.76e-12   NR OEU11081.1 635003 g141603 i0 56 0.925925925925926 50 22 92.6 0 12 161 56 105 OEU11081.1 hypothetical protein FRACYDRAFT_193184, partial [Fragilariopsis cylindrus CCMP1102] diamond 150 69.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Fragilariopsis Fragilariopsis cylindrus
28943397 28943397 PRJNA600413_P_NODE_131188_length_163_cov_0.894737_g130487_i0 PRJNA600413 131188 163 0.894737 1.45842131 Bacillariaceae sp. 3061772 SAR_Eukaryotes SAR_Eukaryotes 60.1 9.69e-9   NR KAL3926311.1 3061772 g130487 i0 47.2 2.94478527607362 53 28 97.5 0 162 4 331 383 KAL3926311.1 MAG: hypothetical protein SGBAC_013526, partial [Bacillariaceae sp.] diamond 480 60.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae   Bacillariaceae sp.
29258600 29258600 PRJNA600413_P_NODE_27849_length_269_cov_1.159091_g27148_i0 PRJNA600413 27849 269 1.159091 3.11795479 Mayamaea pseudoterrestris 2872254 SAR_Eukaryotes SAR_Eukaryotes 52 2.7e-5   NR GKY93165.1 2872254 g27148 i0 35.5 1.50557620817844 62 40 69.1 0 2 187 315 376 GKY93165.1 hypothetical protein MPSEU_000284500 [Mayamaea pseudoterrestris] diamond 405 52 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Mayamaea Mayamaea pseudoterrestris
29985168 29985168 PRJNA600413_P_NODE_138691_length_162_cov_0.902655_g137990_i0 PRJNA600413 138691 162 0.902655 1.4623011 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 92.8 2.07e-22   NR XP_002186391.1 556484 g137990 i0 74.1 6.98148148148148 54 14 100 0 162 1 6 59 XP_002186391.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 1131 92.8 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
30174641 30174641 PRJNA600413_P_NODE_30612_length_257_cov_0.980769_g29911_i0 PRJNA600413 30612 257 0.980769 2.52057633 Cylindrotheca closterium 2856 SAR_Eukaryotes SAR_Eukaryotes 58.9 8.86e-8   NR CAJ1951312.1 2856 g29911 i0 43.7 0.828793774319066 71 38 82.9 1 41 253 756 824 CAJ1951312.1 unnamed protein product [Cylindrotheca closterium] diamond 213 58.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
30490715 30490715 PRJNA600413_P_NODE_107173_length_167_cov_0.864407_g106472_i0 PRJNA600413 107173 167 0.864407 1.44355969 Cyclotella atomus 382360 SAR_Eukaryotes SAR_Eukaryotes 48.5 1.2e-4   NR KAL3787497.1 382360 g106472 i0 57.1 0.754491017964072 42 17 73.7 1 123 1 210 251 KAL3787497.1 hypothetical protein ACHAWO_003447 [Cyclotella atomus] diamond 126 48.5 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus

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