RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA680334 · 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
1925187 1925187 PRJNA680334_S_NODE_101222_length_153_cov_1.850000_g100736_i0 PRJNA680334 101222 153 1.85 2.8305 Pinnularia borealis 1089218 SAR_Eukaryotes SAR_Eukaryotes 283 4.0799999999999995e-72   NTclustered gi|1509777192|gb|MH707916.1| 1089218 g100736 i0 100 98.6797385620915 153 0 100 0 1 153 5 157 Pinnularia borealis voucher (Sterre6)a 28S ribosomal RNA gene, partial sequence blastn 15098 283 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Pinnulariaceae Pinnularia Pinnularia borealis
13923313 13923313 PRJNA680334_S_NODE_6411_length_358_cov_243710.544615_g5925_i0 PRJNA680334 6411 358 243710.544615 872483.7497217 Hantzschia 186033 SAR_Eukaryotes SAR_Eukaryotes 451 2.8600000000000003e-122   NTclustered gi|725539095|gb|KM407568.1| 186034 g5925 i0 97.719 73.6256983240224 263 5 73 1 96 357 319 57 Hantzschia amphioxys isolate Ant025-E04 28S ribosomal RNA gene, partial sequence blastn 26358 451 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Hantzschia Hantzschia amphioxys
22846714 22846714 PRJNA680334_S_NODE_51898_length_189_cov_18.115385_g51412_i0 PRJNA680334 51898 189 18.115385 34.23807765 Nitzschia 2857 SAR_Eukaryotes SAR_Eukaryotes 294 2.44e-75   NTclustered gi|2524387100|emb|OY101133.1| 3034176 g51412 i0 94.709 194.275132275132 189 10 100 0 1 189 32047 31859 Nitzschia sp. pyKryTriq1 genome assembly, organelle: plastid:chloroplast blastn 36718 294 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia sp. pyKryTriq1

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