RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA986481" 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

  • PRJNA986481 · 3 ✖

analysis 1

  • blastn · 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
2547777 2547777 PRJNA986481_P_NODE_36722_length_269_cov_1.418182_g36197_i0 PRJNA986481 36722 269 1.418182 3.81490958 Skeletonema 2842 SAR_Eukaryotes SAR_Eukaryotes 143 1.42e-29   NTclustered gi|2739942912|dbj|LC814772.1| 267566 g36197 i0 84.615 50.1598513011152 143 22 53 0 126 268 855 997 Skeletonema dohrnii SD_MZ01 mitochondrial DNA, complete genome blastn 13493 143 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Thalassiosirales Skeletonemataceae Skeletonema Skeletonema dohrnii
4801403 4801403 PRJNA986481_P_NODE_31264_length_292_cov_2.288066_g30739_i0 PRJNA986481 31264 292 2.288066 6.68115272 Haslea nusantara 2600302 SAR_Eukaryotes SAR_Eukaryotes 87.9 7.42e-13   NTclustered gi|1735238366|ref|NC_044492.1| 2600302 g30739 i0 86.585 0.280821917808219 82 8 27 2 2 81 2682 2602 Haslea nusantara mitochondrion, complete genome blastn 82 87.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Haslea Haslea nusantara
17551926 17551926 PRJNA986481_P_NODE_8534_length_557_cov_4.421260_g8025_i0 PRJNA986481 8534 557 4.42126 24.6264182 Durinskia baltica diatom endosymbiont 1079368 SAR_Eukaryotes SAR_Eukaryotes 195 8.61e-45   NTclustered gi|347800972|gb|JN378735.1| 1079368 g8025 i0 84.5 12.8904847396768 200 27 36 4 39 236 19069 18872 Endosymbiont of Durinskia baltica mitochondrion, partial genome blastn 7180 195 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae       Durinskia baltica diatom endosymbiont

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