RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJEB49404", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 5 ✖

tax_clade 1

bioproject 1

  • PRJEB49404 · 5 ✖

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
96341 96341 PRJEB49404_P_NODE_198061_length_354_cov_5.184127_g184262_i0 PRJEB49404 198061 354 5.184127 18.35180958 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 638 2.02e-178   NTclustered gi|698793876|ref|XR_717098.1| 112090 g184262 i0 99.153 101.635593220339 354 3 100 0 1 354 2508 2155 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 35979 638 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
990916 990916 PRJEB49404_P_NODE_221621_length_327_cov_2.479167_g207822_i0 PRJEB49404 221621 327 2.479167 8.10687609 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 187 8.08e-43   NTclustered gi|2440150|emb|X75631.1| 4788 g207822 i0 89.726 44.3547400611621 146 15 45 0 180 325 3464 3319 P.megasperma gene for 28S ribosomal RNA blastn 14504 187 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megasperma
5214898 5214898 PRJEB49404_P_NODE_537145_length_172_cov_4.007519_g523344_i0 PRJEB49404 537145 172 4.007519 6.89293268 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 213 6.25e-51   NTclustered gi|813199067|ref|XR_001099866.1| 695850 g523344 i0 89.474 35.703488372093 171 14 98 4 4 172 1665 1497 Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA blastn 6141 213 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
12469938 12469938 PRJEB49404_P_NODE_207830_length_342_cov_7.396040_g194031_i0 PRJEB49404 207830 342 7.39604 25.2944568 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 627 4.22e-175   NTclustered gi|363498776|gb|JN662487.1| 120398 g194031 i0 99.708 99.8771929824561 342 1 100 0 1 342 720 379 Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 34158 632 0.992088607594937 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
28012887 28012887 PRJEB49404_P_NODE_619085_length_156_cov_1.051282_g605284_i0 PRJEB49404 619085 156 1.051282 1.63999992 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 48.9 7.48e-5   NR KAF0724015.1 100861 g605284 i0 57.6 4.55769230769231 33 14 63.5 0 101 3 993 1025 KAF0724015.1 hypothetical protein Ae201684_017215 [Aphanomyces euteiches] diamond 711 49.3 0.991886409736308 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);;