RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA562549" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA562549 · 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
8783729 8783729 PRJNA562549_P_NODE_21227_length_253_cov_1.458333_g20994_i0 PRJNA562549 21227 253 1.458333 3.68958249 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 265 2.71e-66   NTclustered gi|1917931691|gb|MT811915.1| 82946 g20994 i0 85.714 87.7470355731225 252 34 99 2 1 251 1084 1334 Pythium periplocum culture CBS:532.74 tubulin alpha chain (Tua) mRNA, complete cds blastn 22200 265 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium periplocum
23498003 23498003 PRJNA562549_P_NODE_14139_length_306_cov_1.061224_g13906_i0 PRJNA562549 14139 306 1.061224 3.24734544 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 226 1.59e-54   NTclustered gi|301107276|ref|XM_002902675.1| 403677 g13906 i0 81.404 73.921568627451 285 45 92 6 20 300 592 872 Phytophthora infestans T30-4 adenosylhomocysteinase (PITG_10198), partial mRNA blastn 22620 226 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
24772026 24772026 PRJNA562549_P_NODE_31680_length_210_cov_3.006711_g31447_i0 PRJNA562549 31680 210 3.006711 6.3140931 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 220 4.77e-53   NTclustered gi|166047767|emb|CU362882.1| 100861 g31447 i0 92.258 76.5333333333333 155 12 74 0 45 199 98 252 Aphanomyces euteiches cDNA blastn 16072 220 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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