RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB81327" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB81327 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
1414753 1414753 PRJEB81327_P_NODE_61442_length_243_cov_0.905882_g60834_i0 PRJEB81327 61442 243 0.905882 2.20129326 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 141 4.54e-29   NTclustered gi|2795059860|ref|XM_067943008.1| 4785 g60834 i0 77.917 0.987654320987654 240 44 98 7 1 237 234 1 Phytophthora cinnamomi 40S ribosomal protein S3a (IUM83_18029), partial mRNA blastn 240 141 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
6099963 6099963 PRJEB81327_P_NODE_19265_length_310_cov_3.814346_g18657_i0 PRJEB81327 19265 310 3.814346 11.8244726 root 1 Root_unresolved Root_unresolved 278 4.39e-70   NTclustered gi|166046494|emb|CU367611.1| 100861 g18657 i0 100 89.8806451612903 150 0 48 0 161 310 514 365 Aphanomyces euteiches cDNA blastn 27863 278 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
9924935 9924935 PRJEB81327_P_NODE_28528_length_281_cov_1.461538_g27920_i0 PRJEB81327 28528 281 1.461538 4.10692178 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 420 6.16e-113   NTclustered gi|2440150|emb|X75631.1| 4788 g27920 i0 93.594 83.0249110320285 281 18 100 0 1 281 3623 3343 P.megasperma gene for 28S ribosomal RNA blastn 23330 420 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megasperma
15442413 15442413 PRJEB81327_P_NODE_40853_length_260_cov_1.224599_g40245_i0 PRJEB81327 40853 260 1.224599 3.1839574 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.024   NTclustered gi|673042026|ref|XM_008876752.1| 157072 g40245 i0 100 0.107692307692308 28 0 11 0 71 98 993 966 Aphanomyces invadans hypothetical protein mRNA blastn 28 52.8 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
16716451 16716451 PRJEB81327_P_NODE_28514_length_281_cov_1.480769_g27906_i0 PRJEB81327 28514 281 1.480769 4.16096089 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 520 5.909999999999999e-143   NTclustered gi|166044648|emb|CU367557.1| 100861 g27906 i0 100 7.95729537366548 281 0 100 0 1 281 100 380 Aphanomyces euteiches cDNA blastn 2236 520 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
17991789 17991789 PRJEB81327_P_NODE_68755_length_224_cov_7.059603_g68147_i0 PRJEB81327 68755 224 7.059603 15.81351072 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 409 1.03e-109   NTclustered gi|166046495|emb|CU367612.1| 100861 g68147 i0 99.554 2 224 1 100 0 1 224 211 434 Aphanomyces euteiches cDNA blastn 448 409 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
23092045 23092045 PRJEB81327_P_NODE_59439_length_244_cov_0.900585_g58831_i0 PRJEB81327 59439 244 0.900585 2.1974274 Plasmopara sphagneticolae 1564265 SAR_Eukaryotes SAR_Eukaryotes 424 4.05e-114   NTclustered gi|1938231006|gb|MW298155.1| 1564265 g58831 i0 97.951 100.241803278689 244 5 100 0 1 244 424 667 Plasmopara sphagneticolae isolate 2-LSU large subunit ribosomal RNA gene, partial sequence. blastn 24459 424 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara sphagneticolae

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