RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA534016" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA534016 · 6 ✖

analysis 1

  • blastn · 6 ✖

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
1118183 1118183 PRJNA534016_P_NODE_3641_length_429_cov_7.117978_g3551_i0 PRJNA534016 3641 429 7.117978 30.53612562 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 159 2.37e-34   NTclustered gi|2311026826|gb|OP554785.1| 4798 g3551 i0 88.722 33.3263403263403 133 11 30 3 301 429 497 365 Pythium hydnosporum isolate R-28 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 14297 159 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium hydnosporum
4334345 4334345 PRJNA534016_P_NODE_10364_length_276_cov_1.807882_g10274_i0 PRJNA534016 10364 276 1.807882 4.98975432 Phytophthora ramorum 164328 SAR_Eukaryotes SAR_Eukaryotes 226 1.41e-54   NTclustered gi|2794923360|ref|XM_067881981.1| 164328 g10274 i0 89.011 66.2463768115942 182 20 66 0 91 272 1 182 Phytophthora ramorum Calmodulin (KRP23_11430), partial mRNA blastn 18284 226 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum
7496353 7496353 PRJNA534016_P_NODE_12086_length_263_cov_1.100000_g11996_i0 PRJNA534016 12086 263 1.1 2.893 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 200 8.099999999999998e-47   NTclustered gi|195970350|gb|EU880228.1| 67593 g11996 i0 80.46 79.2167300380228 261 51 99 0 1 261 414 154 Phytophthora sojae calmodulin (CAM1) mRNA, complete cds blastn 20834 200 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
14536312 14536312 PRJNA534016_P_NODE_16212_length_246_cov_0.849711_g16122_i0 PRJNA534016 16212 246 0.849711 2.09028906 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 156 1.65e-33   NTclustered gi|166038151|emb|CU349819.1| 100861 g16122 i0 78.723 31.7682926829268 235 48 95 2 13 246 796 563 Aphanomyces euteiches cDNA blastn 7815 156 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17084931 17084931 PRJNA534016_P_NODE_16334_length_245_cov_1.267442_g16244_i0 PRJNA534016 16334 245 1.267442 3.1052329 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 169 2.1e-37   NTclustered gi|166035576|emb|CU354455.1| 100861 g16244 i0 88.489 34.4979591836735 139 16 57 0 107 245 842 704 Aphanomyces euteiches cDNA blastn 8452 169 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
18359047 18359047 PRJNA534016_P_NODE_2635_length_503_cov_2.023256_g2545_i0 PRJNA534016 2635 503 2.023256 10.17697768 Achlya ambisexualis 4768 SAR_Eukaryotes SAR_Eukaryotes 348 5.6e-91   NTclustered gi|22086549|gb|AF402100.1| 4768 g2545 i0 80.042 69.272365805169 476 90 94 5 19 491 1424 951 Achlya ambisexualis isolate JS854 heat shock protein Hsp90 mRNA, complete cds blastn 34844 348 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya ambisexualis

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