RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where bioproject = "PRJNA505329", 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

  • PRJNA505329 · 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
3034668 3034668 PRJNA505329_P_NODE_46783_length_165_cov_0.896552_g46312_i0 PRJNA505329 46783 165 0.896552 1.4793108 Peronospora mesembryanthemi 1869342 SAR_Eukaryotes SAR_Eukaryotes 302 1.24e-77   NTclustered gi|1359853156|gb|MH057163.1| 1869342 g46312 i0 100 73.0969696969697 163 0 99 0 3 165 580 742 Peronospora mesembryanthemi strain 15-2751 large subunit ribosomal RNA gene, partial sequence blastn 12061 302 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora mesembryanthemi
10686965 10686965 PRJNA505329_P_NODE_17289_length_224_cov_1.737143_g16818_i0 PRJNA505329 17289 224 1.737143 3.89120032 Peronospora calotheca 162108 SAR_Eukaryotes SAR_Eukaryotes 337 4.909999999999999e-88   NTclustered gi|33520215|gb|AY273960.1| 162108 g16818 i0 93.778 100.508928571429 225 13 100 1 1 224 734 510 Peronospora calotheca large subunit ribosomal RNA gene, partial sequence blastn 22514 337 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora calotheca
18334859 18334859 PRJNA505329_P_NODE_16295_length_233_cov_2.391304_g15824_i0 PRJNA505329 16295 233 2.391304 5.57173832 Hyaloperonospora parasitica 123356 SAR_Eukaryotes SAR_Eukaryotes 117 7.290000000000001e-22   NTclustered gi|171701935|emb|CU694967.2| 123356 g15824 i0 95.833 1.96995708154506 72 3 31 0 23 94 75431 75360 H.parasitica DNA sequence from clone HpEmoy2-19C20, complete sequence blastn 459 117 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora parasitica
20236877 20236877 PRJNA505329_P_NODE_47296_length_164_cov_1.791304_g46825_i0 PRJNA505329 47296 164 1.791304 2.93773856 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 300 4.43e-77   NTclustered gi|338798059|gb|HQ665120.1| 4784 g46825 i0 100 98.780487804878 162 0 99 0 3 164 1156 1317 Phytophthora capsici isolate CBS 128.23 28S large subunit ribosomal RNA gene, partial sequence blastn 16200 300 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
25336771 25336771 PRJNA505329_P_NODE_39840_length_172_cov_1.747967_g39369_i0 PRJNA505329 39840 172 1.747967 3.00650324 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 302 1.3e-77   NTclustered gi|90655130|gb|DQ361251.1| 4784 g39369 i0 98.817 98.2732558139535 169 2 98 0 1 169 410 242 Phytophthora capsici large subunit ribosomal RNA gene, partial sequence blastn 16903 302 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici

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