RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA675331" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA675331 · 2 ✖

analysis 1

  • blastn · 2 ✖

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
16471314 16471314 PRJNA675331_P_NODE_2673_length_568_cov_2.135354_g2505_i0 PRJNA675331 2673 568 2.135354 12.12881072 Fabomonas 1291204 SAR_Eukaryotes SAR_Eukaryotes 147 2.5e-30   NTclustered gi|220983376|dbj|AB453012.1| 552662 g2505 i0 87.5 21.4066901408451 128 15 23 1 441 568 1667 1541 Cercozoa sp. YPF501 gene for nuclear large subunit ribosomal RNA, partial sequence blastn 12159 148 0.993243243243243 Eukaryota Sar   Cercozoa         Cercozoa sp. YPF501
23600551 23600551 PRJNA675331_P_NODE_16259_length_263_cov_1.215789_g16087_i0 PRJNA675331 16259 263 1.215789 3.19752507 Aulacantha scolymantha 238793 SAR_Eukaryotes SAR_Eukaryotes 167 8.22e-37   NTclustered gi|528530870|emb|HG316279.1| 238793 g16087 i0 85.625 12.3992395437262 160 21 60 2 99 257 140 298 Aulacantha scolymantha partial mRNA for Rps14, isolate Asco01, clone UN06628 blastn 3261 167 1 Eukaryota Sar   Cercozoa Thecofilosea Phaeocystida Aulacanthidae Aulacantha Aulacantha scolymantha

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