RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJNA326068" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 8 ✖

tax_clade 1

bioproject 1

  • PRJNA326068 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
2940049 2940049 PRJNA326068_P_NODE_16643_length_202_cov_5.075145_g15680_i0 PRJNA326068 16643 202 5.075145 10.2517929 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 368 1.54e-97   NTclustered gi|698793876|ref|XR_717098.1| 112090 g15680 i0 99.507 100.272277227723 203 0 100 1 1 202 1864 1662 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 20255 368 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
4216707 4216707 PRJNA326068_P_NODE_13224_length_247_cov_8.715596_g12261_i0 PRJNA326068 13224 247 8.715596 21.52752212 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 309 1.2e-79   NTclustered gi|813199067|ref|XR_001099866.1| 695850 g12261 i0 89.754 71.825910931174107 244 21 98 4 6 247 1447 1688 Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA blastn 17741 309 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
10593130 10593130 PRJNA326068_P_NODE_19409_length_159_cov_1.292308_g18446_i0 PRJNA326068 19409 159 1.292308 2.05476972 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 191 2.67e-44   NTclustered gi|673029967|ref|XM_008870723.1| 157072 g18446 i0 88.535 2.9622641509434 157 18 99 0 3 159 891 735 Aphanomyces invadans ribosomal protein S2 mRNA blastn 471 191 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
10593161 10593161 PRJNA326068_P_NODE_8629_length_352_cov_94.439628_g7679_i0 PRJNA326068 8629 352 94.439628 332.42749056 Aphanomyces brasiliensis 2525538 SAR_Eukaryotes SAR_Eukaryotes 514 3.53e-141   NTclustered gi|2098511708|gb|OK235679.1| 2525538 g7679 i0 92.997 101.568181818182 357 17 99 6 2 352 929 575 Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence blastn 35752 514 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces brasiliensis
14418295 14418295 PRJNA326068_P_NODE_6812_length_413_cov_16.408854_g5891_i0 PRJNA326068 6812 413 16.408854 67.76856702 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 763 0   NTclustered gi|1578815424|gb|MK546601.1| 1982524 g5891 i0 100 99.9370460048426 413 0 100 0 1 413 163 575 Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence blastn 41274 763 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.
16966778 16966778 PRJNA326068_P_NODE_17454_length_191_cov_2.055556_g16491_i0 PRJNA326068 17454 191 2.055556 3.92611196 Plectospira myriandra 100863 SAR_Eukaryotes SAR_Eukaryotes 111 2.67e-20   NTclustered gi|59859759|gb|AY729874.1| 100863 g16491 i0 79.87 34.2879581151832 154 29 80 2 34 186 264 112 Plectospira myriandra elongation factor 1 alpha gene, partial cds blastn 6549 111 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Plectospira Plectospira myriandra
16966798 16966798 PRJNA326068_P_NODE_4394_length_527_cov_5.204819_g3615_i0 PRJNA326068 4394 527 5.204819 27.42939613 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 281 6.06e-71   NTclustered gi|698807229|ref|XM_009838342.1| 112090 g3615 i0 80.533 64.1897533206831 375 65 70 4 31 398 68 441 Aphanomyces astaci polyubiquitin mRNA blastn 33828 281 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
18241055 18241055 PRJNA326068_P_NODE_17135_length_196_cov_5.413174_g16172_i0 PRJNA326068 17135 196 5.413174 10.60982104 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 329 6.99e-86   NTclustered gi|363498776|gb|JN662487.1| 120398 g16172 i0 96.552 103.974489795918 203 0 100 1 1 196 63 265 Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 20379 329 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus

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