RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA613025 · 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
4419131 4419131 PRJNA613025_S_NODE_14244_length_292_cov_1.427984_g14090_i0 PRJNA613025 14244 292 1.427984 4.16971328 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 189 1.98e-43   NTclustered gi|673019759|ref|XM_008865619.1| 157072 g14090 i0 80.913 14.791095890411 241 44 82 2 24 263 127 366 Aphanomyces invadans 40S ribosomal protein S23 mRNA blastn 4319 189 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
6970121 6970121 PRJNA613025_S_NODE_21026_length_212_cov_1.165644_g20872_i0 PRJNA613025 21026 212 1.165644 2.47116528 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 135 1.8e-27   NTclustered gi|166035576|emb|CU354455.1| 100861 g20872 i0 92.553 9.7122641509434 94 7 44 0 1 94 749 842 Aphanomyces euteiches cDNA blastn 2059 135 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17169870 17169870 PRJNA613025_S_NODE_33374_length_162_cov_0.902655_g33220_i0 PRJNA613025 33374 162 0.902655 1.4623011 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 95.3 2.21e-15   NTclustered gi|695375632|ref|XM_009517294.1| 67593 g33220 i0 80.992 0.746913580246914 121 21 74 2 42 161 149 268 Phytophthora sojae hypothetical protein partial mRNA blastn 121 95.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
25375119 25375119 PRJNA613025_S_NODE_23520_length_196_cov_2.108844_g23366_i0 PRJNA613025 23520 196 2.108844 4.13333424 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 261 2.5900000000000002e-65   NTclustered gi|50261276|ref|NC_005984.1| 4770 g23366 i0 91.146 103.877551020408 192 17 98 0 5 196 10982 11173 Saprolegnia ferax mitochondrion, complete genome blastn 20360 263 0.992395437262357 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia ferax

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