RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1215774" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJNA1215774 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
2321122 2321122 PRJNA1215774_P_NODE_82922_length_242_cov_0.911243_g82602_i0 PRJNA1215774 82922 242 0.911243 2.20520806 Peronosporales 4776 SAR_Eukaryotes SAR_Eukaryotes 442 1.1099999999999995e-119   NTclustered gi|1238675774|gb|MF783088.1| 4784 g82602 i0 99.588 100.413223140496 243 0 100 1 1 242 964 722 Phytophthora capsici isolate CACAO small subunit ribosomal RNA gene, partial sequence blastn 24300 442 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
4873853 4873853 PRJNA1215774_P_NODE_67984_length_251_cov_3.095506_g67664_i0 PRJNA1215774 67984 251 3.095506 7.76972006 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 464 2.47e-126   NTclustered gi|2204467674|gb|OM920844.1| 46767 g67664 i0 100 99.0836653386454 251 0 100 0 1 251 319 69 Blastocystis sp. isolate RP87 small subunit ribosomal RNA gene, partial sequence blastn 24870 464 1 Eukaryota Sar     Bigyra Opalinata Blastocystidae Blastocystis Blastocystis sp.
24557506 24557506 PRJNA1215774_P_NODE_62400_length_265_cov_1.458333_g62080_i0 PRJNA1215774 62400 265 1.458333 3.86458245 Hyaloperonospora brassicae 162125 SAR_Eukaryotes SAR_Eukaryotes 490 4.3299999999999986e-134   NTclustered gi|158519351|gb|EU054911.1| 162125 g62080 i0 100 99.6867924528302 265 0 100 0 1 265 463 727 Hyaloperonospora brassicae strain HV2163 (WU) large subunit ribosomal RNA gene, partial sequence blastn 26417 490 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Hyaloperonospora Hyaloperonospora brassicae

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