RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

2 rows where analysis = "blastn", bioproject = "PRJNA889065" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 2 ✖

tax_clade 1

bioproject 1

  • PRJNA889065 · 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
11445992 11445992 PRJNA889065_S_NODE_23929_length_199_cov_1.179487_g23691_i0 PRJNA889065 23929 199 1.179487 2.34717913 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 368 1.51e-97   NTclustered gi|1923460172|gb|MW187638.1| 1125843 g23691 i0 100 101.015075376884 199 0 100 0 1 199 245 443 Aphanomyces sinensis isolate CCRJB_22 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 20102 368 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sinensis
19093661 19093661 PRJNA889065_S_NODE_175_length_1291_cov_5.836538_g137_i0 PRJNA889065 175 1291 5.836538 75.34970558 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 211 2.06e-49   NTclustered gi|937408816|ref|NC_027966.1| 114742 g137 i0 79.739 25.5267234701782 306 51 23 10 799 1098 10097 9797 Pythium insidiosum mitochondrial DNA, complete genome blastn 32955 213 0.990610328638498 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum

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