RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1240804" and tax_phylum = "Foraminifera"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Foraminifera · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA1240804 · 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
6153223 6153223 PRJNA1240804_P_NODE_98005_length_174_cov_3.576000_g97639_i0 PRJNA1240804 98005 174 3.576 6.22224 root 1 Root_unresolved Root_unresolved 281 1.71e-71   NTclustered gi|314905788|gb|HM213242.1| 46086 g97639 i0 98.734 95.4942528735632 158 2 91 0 1 158 746 589 Elphidium aculeatum isolate A53.73 small subunit ribosomal RNA (SSU) gene, partial sequence; plastid blastn 16616 281 1 Eukaryota Sar   Foraminifera   Rotaliida Elphidiidae Elphidium Elphidium aculeatum
9978351 9978351 PRJNA1240804_P_NODE_58488_length_207_cov_1.215190_g58122_i0 PRJNA1240804 58488 207 1.21519 2.5154433 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 134 6.2900000000000006e-27   NTclustered gi|998623040|dbj|LC049319.1| 69028 g58122 i0 89.623 7.69082125603865 106 9 51 2 14 118 4062 4166 Globorotalia inflata gene for 28S rRNA, partial sequence, isolate: 11-9-T65 blastn 1592 134 1 Eukaryota Sar   Foraminifera   Rotaliida Globorotaliidae Globorotalia Globorotalia inflata
13803686 13803686 PRJNA1240804_P_NODE_57331_length_208_cov_2.440252_g56965_i0 PRJNA1240804 57331 208 2.440252 5.07572416 Rotaliida 29185 SAR_Eukaryotes SAR_Eukaryotes 121 4.9199999999999987e-23   NTclustered gi|643022|emb|X78521.1| 35210 g56965 i0 84.733 6.51442307692308 131 8 58 4 75 194 2003 1874 R.elatiana complete gene of large subunit rRNA blastn 1355 122 0.991803278688525 Eukaryota Sar   Foraminifera   Rotaliida Rotaliidae Rotaliella Rotaliella elatiana

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