RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA168635 · 6 ✖

analysis 1

  • diamond · 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
27989984 27989984 PRJNA168635_P_NODE_19785_length_183_cov_1.544776_g19369_i0 PRJNA168635 19785 183 1.544776 2.82694008 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 58.5 4.33e-8   NR OQR94528.1 74557 g19369 i0 42 0.819672131147541 50 29 82 0 8 157 406 455 OQR94528.1 Major Facilitator Superfamily (MFS) [Thraustotheca clavata] diamond 150 58.5 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
29694564 29694564 PRJNA168635_P_NODE_30410_length_163_cov_3.552632_g29994_i0 PRJNA168635 30410 163 3.552632 5.79079016 [Pythium] brassicae (nom. inval.) 1485010 SAR_Eukaryotes SAR_Eukaryotes 63.9 3.85e-10   NR TYZ65744.1 1485010 g29994 i0 58 2.76073619631902 50 21 92 0 151 2 189 238 TYZ65744.1 hypothetical protein PybrP1_003093 [[Pythium] brassicae (nom. inval.)] diamond 450 63.9 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Globisporangium [Pythium] brassicae (nom. inval.)
30168515 30168515 PRJNA168635_P_NODE_31272_length_163_cov_0.912281_g30856_i0 PRJNA168635 31272 163 0.912281 1.48701803 Saprolegnia parasitica CBS 223.65 695850 SAR_Eukaryotes SAR_Eukaryotes 78.6 1.51e-15   NR XP_012209072.1 695850 g30856 i0 67.9 4.87730061349693 53 15 97.5 1 159 1 153 203 XP_012209072.1 hypothetical protein SPRG_21424 [Saprolegnia parasitica CBS 223.65] diamond 795 78.6 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
30218030 30218030 PRJNA168635_P_NODE_14032_length_215_cov_11.138554_g13616_i0 PRJNA168635 14032 215 11.138554 23.9478911 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00144   NR KAF0721512.1 100861 g13616 i0 83.3 2.83255813953488 24 4 33.5 0 3 74 110 133 KAF0721512.1 hypothetical protein Ae201684_019106 [Aphanomyces euteiches] diamond 609 45.4 0.993392070484582 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
31608734 31608734 PRJNA168635_P_NODE_21556_length_177_cov_4.132812_g21140_i0 PRJNA168635 21556 177 4.132812 7.31507724 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 45.8 0.00126   NR KUF91881.1 4792 g21140 i0 51.9 13.728813559322 54 26 91.5 0 164 3 1239 1292 KUF91881.1 hypothetical protein AM588_10007143 [Phytophthora nicotianae] diamond 2430 45.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
31685634 31685634 PRJNA168635_P_NODE_35097_length_152_cov_5.864078_g34681_i0 PRJNA168635 35097 152 5.864078 8.91339856 Phytophthora megakarya 4795 SAR_Eukaryotes SAR_Eukaryotes 46.6 4.75e-5   NR OWY94452.1 4795 g34681 i0 57.9 0.75 38 15 73 1 132 22 1 38 OWY94452.1 hypothetical protein PHMEG_00035810 [Phytophthora megakarya] diamond 114 46.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya

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