RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA564810 · 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
17711474 17711474 PRJNA564810_S_NODE_1794_length_346_cov_4.085409_g1772_i0 PRJNA564810 1794 346 4.085409 14.13551514 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 211 5.11e-50   NTclustered gi|937408816|ref|NC_027966.1| 114742 g1772 i0 79.739 94.7109826589595 306 51 87 10 45 344 9797 10097 Pythium insidiosum mitochondrial DNA, complete genome blastn 32770 213 0.990610328638498 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
18406200 18406200 PRJNA564810_S_NODE_455_length_509_cov_2.619369_g434_i0 PRJNA564810 455 509 2.619369 13.33258821 Hyaloperonospora arabidopsidis 272952 SAR_Eukaryotes SAR_Eukaryotes 117 1.7400000000000003e-21   NTclustered gi|2248512796|ref|NC_063789.1| 272952 g434 i0 77.949 59.2848722986248 195 37 38 5 51 243 917 1107 Hyaloperonospora arabidopsidis isolate Noks1 mitochondrion, complete genome blastn 30176 117 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora arabidopsidis

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