RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where bioproject = "PRJNA800090" 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

  • PRJNA800090 · 3 ✖

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
9726300 9726300 PRJNA800090_P_NODE_184428_length_231_cov_0.901235_g182243_i0 PRJNA800090 184428 231 0.901235 2.08185285 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 96.7 2.18e-22   NR ETO22913.1 46433 g182243 i0 61.1 1.88311688311688 72 28 93.5 0 219 4 162 233 ETO22913.1 AMP deaminase Amd1, partial [Reticulomyxa filosa] diamond 435 96.7 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27307125 27307125 PRJNA800090_P_NODE_172823_length_236_cov_0.874251_g170638_i0 PRJNA800090 172823 236 0.874251 2.06323236 Reticulomyxa filosa 46433 SAR_Eukaryotes SAR_Eukaryotes 113 5.550000000000001e-27   NR ETO30124.1 46433 g170638 i0 62.8 0.991525423728814 78 29 99.2 0 1 234 252 329 ETO30124.1 carboxylesterase, partial [Reticulomyxa filosa] diamond 234 113 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa
27915724 27915724 PRJNA800090_P_NODE_88345_length_352_cov_0.886926_g86160_i0 PRJNA800090 88345 352 0.886926 3.12197952 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 79.3 1.94e-14   NR ETO35216.1 46433 g86160 i0 72 1.42329545454545 50 13 41.8 1 2 148 244 293 ETO35216.1 coagulation factor 5/8 type domain-containing protein [Reticulomyxa filosa] diamond 501 79.3 1 Eukaryota Sar   Foraminifera     Reticulomyxidae Reticulomyxa Reticulomyxa filosa

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