RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "blastn", bioproject = "PRJNA681822" 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

  • PRJNA681822 · 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
1931972 1931972 PRJNA681822_P_NODE_451482_length_244_cov_0.900585_g449992_i0 PRJNA681822 451482 244 0.900585 2.1974274 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 239 1.57e-58   NTclustered gi|695416746|ref|XM_009528626.1| 67593 g449992 i0 86.854 80.0655737704918 213 28 87 0 31 243 936 724 Phytophthora sojae hypothetical protein mRNA blastn 19536 239 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
12135079 12135079 PRJNA681822_P_NODE_432070_length_246_cov_0.890173_g430581_i0 PRJNA681822 432070 246 0.890173 2.18982558 Albugo candida 65357 SAR_Eukaryotes SAR_Eukaryotes 446 8.719999999999999e-121   NTclustered gi|67090782|gb|DQ007474.1| 65357 g430581 i0 99.194 101.09756097561 248 0 100 1 1 246 270 23 Albugo candida isolate AR330 large subunit ribosomal RNA gene, partial sequence blastn 24870 446 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo candida
13924184 13924184 PRJNA681822_P_NODE_225791_length_293_cov_2.140909_g224302_i0 PRJNA681822 225791 293 2.140909 6.27286337 root 1 Root_unresolved Root_unresolved 531 2.86e-146   NTclustered gi|166044655|emb|CU367564.1| 100861 g224302 i0 99.317 28.4334470989761 293 2 100 0 1 293 716 424 Aphanomyces euteiches cDNA blastn 8331 531 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
19778579 19778579 PRJNA681822_P_NODE_127536_length_361_cov_0.979167_g126049_i0 PRJNA681822 127536 361 0.979167 3.53479287 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 250 1.13e-61   NTclustered gi|698822976|ref|XM_009846215.1| 112090 g126049 i0 82.746 58.8808864265928 284 46 78 3 1 283 246 527 Aphanomyces astaci 40S ribosomal protein S13 mRNA blastn 21256 250 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
19778814 19778814 PRJNA681822_P_NODE_144096_length_346_cov_1.523810_g142608_i0 PRJNA681822 144096 346 1.52381 5.2723826 Pythium monospermum 92964 SAR_Eukaryotes SAR_Eukaryotes 612 1.1999999999999996e-170   NTclustered gi|33520250|gb|AY273995.1| 92964 g142608 i0 98.555 98.9219653179191 346 5 100 0 1 346 418 73 Pythium monospermum large subunit ribosomal RNA gene, partial sequence blastn 34227 612 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium monospermum
20297255 20297255 PRJNA681822_P_NODE_44556_length_558_cov_3.581443_g43106_i0 PRJNA681822 44556 558 3.581443 19.98445194 root 1 Root_unresolved Root_unresolved 920 0   NTclustered gi|166046685|emb|CU367795.1| 100861 g43106 i0 96.416 99.8763440860215 558 20 100 0 1 558 29 586 Aphanomyces euteiches cDNA blastn 55731 926 0.993520518358531 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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