RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJEB25583", tax_clade = "Sar" 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

  • PRJEB25583 · 4 ✖

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
22986 22986 PRJEB25583_P_NODE_7481_length_156_cov_1.739496_g7304_i0 PRJEB25583 7481 156 1.739496 2.71361376 Hyaloperonospora parasitica 123356 SAR_Eukaryotes SAR_Eukaryotes 285 1.16e-72   NTclustered gi|23306518|gb|AY035501.1| 123356 g7304 i0 100 99.1089743589744 154 0 99 0 3 156 76 229 Hyaloperonospora parasitica isolate AR 154 large subunit ribosomal RNA gene, partial sequence blastn 15461 285 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora parasitica
10225759 10225759 PRJEB25583_P_NODE_5349_length_178_cov_1.836879_g5172_i0 PRJEB25583 5349 178 1.836879 3.26964462 Globisporangium ultimum 2052682 SAR_Eukaryotes SAR_Eukaryotes 281 1.76e-71   NTclustered gi|299830435|ref|NC_014280.1| 2052682 g5172 i0 98.742 92.8988764044944 159 1 89 1 2 159 9491 9649 Pythium ultimum mitochondrion, complete genome blastn 16536 281 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium Globisporangium ultimum
12776556 12776556 PRJEB25583_P_NODE_2351_length_268_cov_1.419913_g2174_i0 PRJEB25583 2351 268 1.419913 3.80536684 Phytophthora infestans 4787 SAR_Eukaryotes SAR_Eukaryotes 71.3 6.77e-8   NTclustered gi|301097697|ref|XM_002897897.1| 403677 g2174 i0 88.136 0.794776119402985 59 7 22 0 1 59 1044 1102 Phytophthora infestans T30-4 ribonucleoside-diphosphate reductase small chain (PITG_15659), partial mRNA blastn 213 71.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora infestans
20112958 20112958 PRJEB25583_P_NODE_3696_length_210_cov_4.878613_g3519_i0 PRJEB25583 3696 210 4.878613 10.2450873 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 361 2.6999999999999998e-95   NTclustered gi|440919553|gb|JX436353.1| 1279233 g3519 i0 98.068 98.7619047619048 207 4 99 0 4 210 130 336 Myzocytiopsis sp. GPR-2013 28S ribosomal RNA gene, partial sequence blastn 20740 361 1 Eukaryota Sar   Oomycota   Myzocytiopsidales Myzocytiopsidaceae Myzocytiopsis Myzocytiopsis sp. GPR-2013

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