RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA849172" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA849172 · 4 ✖

analysis 1

  • blastn · 4 ✖

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
3783644 3783644 PRJNA849172_P_NODE_100903_length_246_cov_0.895954_g100543_i0 PRJNA849172 100903 246 0.895954 2.20404684 root 1 Root_unresolved Root_unresolved 427 3.16e-115   NTclustered gi|166046486|emb|CU367603.1| 100861 g100543 i0 97.976 40.8739837398374 247 4 100 1 1 246 309 63 Aphanomyces euteiches cDNA blastn 10055 427 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
8489076 8489076 PRJNA849172_P_NODE_40567_length_324_cov_43.641434_g40207_i0 PRJNA849172 40567 324 43.641434 141.39824616 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 121 8.229999999999999e-23   NTclustered gi|669137463|ref|XM_008606078.1| 1156394 g40207 i0 81.818 15.0802469135802 143 26 44 0 182 324 2027 1885 Saprolegnia diclina VS20 heat shock protein 90-2 partial mRNA blastn 4886 121 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
13591682 13591682 PRJNA849172_P_NODE_9871_length_684_cov_50.407529_g9522_i0 PRJNA849172 9871 684 50.407529 344.78749836 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 263 2.9000000000000002e-65   NTclustered gi|937408816|ref|NC_027966.1| 114742 g9522 i0 76.265 1.53801169590643 573 90 81 37 125 677 32433 31887 Pythium insidiosum mitochondrial DNA, complete genome blastn 1052 263 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
25459316 25459316 PRJNA849172_P_NODE_50700_length_294_cov_5.171946_g50340_i0 PRJNA849172 50700 294 5.171946 15.20552124 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 178 4.31e-40   NTclustered gi|58202010|gb|AY898628.1| 4787 g50340 i0 88.966 50.6836734693878 145 15 49 1 3 147 2324 2467 Phytophthora infestans haplotype IIb mitochondrion, complete genome blastn 14901 178 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans

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