RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 5 ✖

tax_clade 1

bioproject 1

  • PRJNA312107 · 5 ✖

analysis 1

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
9991785 9991785 PRJNA312107_P_NODE_18108_length_171_cov_1.590164_g17942_i0 PRJNA312107 18108 171 1.590164 2.71918044 Saprolegniaceae 4764 SAR_Eukaryotes SAR_Eukaryotes 316 4.6e-82   NTclustered gi|5327222|emb|AJ238657.1| 92969 g17942 i0 100 99.3625730994152 171 0 100 0 1 171 826 656 Pythiopsis cymosa 18S rRNA gene, partial blastn 16991 316 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Pythiopsis Pythiopsis cymosa
18229255 18229255 PRJNA312107_P_NODE_16335_length_181_cov_1.409091_g16169_i0 PRJNA312107 16335 181 1.409091 2.55045471 Aphanomyces sp. AR_11 120501 SAR_Eukaryotes SAR_Eukaryotes 307 2.97e-79   NTclustered gi|7658192|gb|AF119585.1| 120501 g16169 i0 97.238 73.7458563535912 181 5 100 0 1 181 613 433 Aphanomyces sp. AR_11 strain AR 11 large subunit ribosomal RNA gene, partial sequence blastn 13348 307 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp. AR_11
20779104 20779104 PRJNA312107_P_NODE_19457_length_168_cov_1.310924_g19291_i0 PRJNA312107 19457 168 1.310924 2.20235232 Peronospora lamii 162118 SAR_Eukaryotes SAR_Eukaryotes 300 4.56e-77   NTclustered gi|23306511|gb|AY035494.1| 162118 g19291 i0 98.81 97.6726190476191 168 2 100 0 1 168 556 389 Peronospora lamii isolate MG 14-1 large subunit ribosomal RNA gene, partial sequence blastn 16409 300 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora lamii
22054076 22054076 PRJNA312107_P_NODE_11618_length_213_cov_1.201220_g11452_i0 PRJNA312107 11618 213 1.20122 2.5585986 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 383 5.8499999999999996e-102   NTclustered gi|698793876|ref|XR_717098.1| 112090 g11452 i0 99.061 99.131455399061 213 2 100 0 1 213 2119 1907 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 21115 383 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
23329590 23329590 PRJNA312107_P_NODE_12499_length_206_cov_1.324841_g12333_i0 PRJNA312107 12499 206 1.324841 2.72917246 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 364 2.0399999999999993e-96   NTclustered gi|698793876|ref|XR_717098.1| 112090 g12333 i0 98.544 85.4223300970874 206 3 100 0 1 206 2131 2336 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 17597 364 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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